noahlearner twooctobers.com
1. 2. 3. 4.
Client
Goals
Gather
Data
Analyze
Data
Choose
Topics
Slide 16
Slide 16 text
noahlearner twooctobers.com
Who is your ideal
customer?
Slide 17
Slide 17 text
noahlearner twooctobers.com
What services do
you offer?
Slide 18
Slide 18 text
noahlearner twooctobers.com
What is most
profitable?
Slide 19
Slide 19 text
noahlearner twooctobers.com
What is a
conversion worth?
Slide 20
Slide 20 text
noahlearner twooctobers.com
How do you make
money?
Slide 21
Slide 21 text
noahlearner twooctobers.com
When do you make
your money?
Slide 22
Slide 22 text
noahlearner twooctobers.com
Where do you make
your money?
Slide 23
Slide 23 text
noahlearner twooctobers.com
What questions are
tied to conversions?
Slide 24
Slide 24 text
noahlearner twooctobers.com
What is your
sales process?
Slide 25
Slide 25 text
noahlearner twooctobers.com
How can
content support
the sales process?
Slide 26
Slide 26 text
noahlearner twooctobers.com
1. 2. 3. 4.
Client
Goals
Gather
Data
Analyze
Data
Create
Topics
Slide 27
Slide 27 text
noahlearner twooctobers.com
We don’t know what
Google Knows,
we only know what
they show us!
Slide 28
Slide 28 text
noahlearner twooctobers.com
Google shows us
relationships in a few
places.
Slide 29
Slide 29 text
noahlearner twooctobers.com
Knowledgegraph
Search API, the SERPs,
autocomplete, KWP
data & Google Trends.
Slide 30
Slide 30 text
noahlearner twooctobers.com
Slide 31
Slide 31 text
noahlearner twooctobers.com
Slide 32
Slide 32 text
noahlearner twooctobers.com
Slide 33
Slide 33 text
noahlearner twooctobers.com
Slide 34
Slide 34 text
noahlearner twooctobers.com
Wikipedia
Slide 35
Slide 35 text
noahlearner twooctobers.com
Wikipedia makes up
over 67% of the sources
for tracked Knowledge
panels.
- Kalicube Pro.
Slide 36
Slide 36 text
noahlearner twooctobers.com
Slide 37
Slide 37 text
noahlearner twooctobers.com
Slide 38
Slide 38 text
noahlearner twooctobers.com
Disambiguation!
Slide 39
Slide 39 text
noahlearner twooctobers.com
Related Topics!
Slide 40
Slide 40 text
noahlearner twooctobers.com
SERPs
Slide 41
Slide 41 text
noahlearner twooctobers.com
Get Related
searches
+
People also ask
Slide 42
Slide 42 text
noahlearner twooctobers.com
Autocomplete
Slide 43
Slide 43 text
noahlearner twooctobers.com
What is it?
Slide 44
Slide 44 text
noahlearner twooctobers.com
Slide 45
Slide 45 text
noahlearner twooctobers.com
Slide 46
Slide 46 text
noahlearner twooctobers.com
Google Trends
Slide 47
Slide 47 text
noahlearner twooctobers.com
1. Enter Query
Slide 48
Slide 48 text
noahlearner twooctobers.com
1. Enter Query
2. Edit Geo region to state.
Slide 49
Slide 49 text
noahlearner twooctobers.com
1. Enter Query
2. Edit Geo region to state.
3. Download Related Topics
+ Related queries CSVs
Slide 50
Slide 50 text
noahlearner twooctobers.com
1. Enter Query
2. Edit Geo region to state.
3. Download Related Topics
+ Related queries CSVs
4. Add the terms to our
Google Sheet.
Slide 51
Slide 51 text
noahlearner twooctobers.com
That would never scale
Slide 52
Slide 52 text
noahlearner twooctobers.com
You can get the data
with APIs.
Slide 53
Slide 53 text
noahlearner twooctobers.com
Slide 54
Slide 54 text
noahlearner twooctobers.com
Related Queries
from Google Trends.
Slide 55
Slide 55 text
noahlearner twooctobers.com
Steps
- Get Data
Slide 56
Slide 56 text
noahlearner twooctobers.com
Steps
- Get Data
- Remove Irrelevant terms
Slide 57
Slide 57 text
noahlearner twooctobers.com
Steps
- Get Data
- Remove Irrelevant terms
- Enrich with Keyword Metrics (via API)
Slide 58
Slide 58 text
noahlearner twooctobers.com
Steps
- Get Data
- Remove Irrelevant terms
- Enrich with Keyword Metrics (via API)
- Get More Data
Slide 59
Slide 59 text
noahlearner twooctobers.com
Human curation
at each step
is key.
Slide 60
Slide 60 text
noahlearner twooctobers.com
Bicycle
Slide 61
Slide 61 text
noahlearner twooctobers.com
22
Search Terms
Slide 62
Slide 62 text
noahlearner twooctobers.com
after 2 cycles it’s getting
useful.
Slide 63
Slide 63 text
noahlearner twooctobers.com
139
Search Terms
Slide 64
Slide 64 text
noahlearner twooctobers.com
974
Search Terms
Slide 65
Slide 65 text
noahlearner twooctobers.com
within 15 minutes you can
build something
extraordinary.
Slide 66
Slide 66 text
noahlearner twooctobers.com
4K+
Terms
Slide 67
Slide 67 text
noahlearner twooctobers.com
Pump your brakes.
Slide 68
Slide 68 text
noahlearner twooctobers.com
4k Search terms
=
Messy Messy Data Viz.
Slide 69
Slide 69 text
noahlearner twooctobers.com
1. 2. 3. 4.
Client
Goals
Gather
Data
Analyze
Data
Create
Topics
Slide 70
Slide 70 text
noahlearner twooctobers.com
Force Directed Tree
STILL NOT THERE!
Slide 71
Slide 71 text
noahlearner twooctobers.com
Circle Packing
CLOSER
Slide 72
Slide 72 text
noahlearner twooctobers.com
Sunburst
Slide 73
Slide 73 text
noahlearner twooctobers.com
Could this help get
buy in?
Slide 74
Slide 74 text
noahlearner twooctobers.com
Most SEOs would
probably prefer this.
Slide 75
Slide 75 text
noahlearner twooctobers.com
Slide 76
Slide 76 text
noahlearner twooctobers.com
Clustering Methods
Slide 77
Slide 77 text
noahlearner twooctobers.com
Manually works,
but = many hours
poring over
spreadsheets.
Slide 78
Slide 78 text
noahlearner twooctobers.com
Google Keyword
Planner
Slide 79
Slide 79 text
noahlearner twooctobers.com
a Great Idea
from Nico Brooks
Slide 80
Slide 80 text
noahlearner twooctobers.com
1. Enter Query
Slide 81
Slide 81 text
noahlearner twooctobers.com
1. Enter Query
2. Look at data
Slide 82
Slide 82 text
noahlearner twooctobers.com
1. Enter Query
2. Look at data
3. Add keyword ideas
as ad groups
Slide 83
Slide 83 text
noahlearner twooctobers.com
1. Enter Query
2. Look at data
3. Add keyword ideas
as ad groups
4. Download Campaign
Slide 84
Slide 84 text
noahlearner twooctobers.com
1. Enter Query
2. Look at data
3. Add keyword ideas
as ad groups
4. Download Campaign
5. Use it to guide SEO
topics.
Slide 85
Slide 85 text
noahlearner twooctobers.com
SERP Similarity
The current tooling
gold standard.
Slide 86
Slide 86 text
noahlearner twooctobers.com
Compare search results to
cluster search terms into
groups or clusters.
Slide 87
Slide 87 text
noahlearner twooctobers.com
Engineering Challenges
ARE SIGNIFICANT.
Slide 88
Slide 88 text
noahlearner twooctobers.com
Lee Foot’s Colab
Slide 89
Slide 89 text
noahlearner twooctobers.com
Feed it your CSV +
it outputs them
into useful clusters.
Slide 90
Slide 90 text
noahlearner twooctobers.com
Elias Dabbas
@eliasdabbas
creator of advertoolz library
Slide 91
Slide 91 text
noahlearner twooctobers.com
Using Regular Expressions,
we can build a pretty useful
customized classifier.
Slide 92
Slide 92 text
noahlearner twooctobers.com
Slide 93
Slide 93 text
noahlearner twooctobers.com
Find your Way to
Explore the Data
that works for you!
Slide 94
Slide 94 text
noahlearner twooctobers.com
For me, easy analysis =
Google Data Studio
Slide 95
Slide 95 text
noahlearner twooctobers.com
Slide 96
Slide 96 text
noahlearner twooctobers.com
Clusters
+ their
queries