Slide 1

Slide 1 text

noahlearner twooctobers.com Topics

Slide 2

Slide 2 text

noahlearner twooctobers.com You gotta earn it.

Slide 3

Slide 3 text

noahlearner twooctobers.com GSC (inside out)

Slide 4

Slide 4 text

noahlearner twooctobers.com We’d only solved some of the problems.

Slide 5

Slide 5 text

noahlearner twooctobers.com GSC (inside out) ??? (Outside in)

Slide 6

Slide 6 text

noahlearner twooctobers.com Building Content is hard.

Slide 7

Slide 7 text

noahlearner twooctobers.com Especially when there’s no data.

Slide 8

Slide 8 text

noahlearner twooctobers.com Topics keyword Vs

Slide 9

Slide 9 text

noahlearner twooctobers.com a topic = a subject. It’s the thing you’re writing about.

Slide 10

Slide 10 text

noahlearner twooctobers.com a keyword = an important word used while talking about a subject.

Slide 11

Slide 11 text

noahlearner twooctobers.com Keyword Research isn’t the answer.

Slide 12

Slide 12 text

noahlearner twooctobers.com How can we do better?

Slide 13

Slide 13 text

noahlearner twooctobers.com Resources https://bit.ly/searchlove2022

Slide 14

Slide 14 text

noahlearner twooctobers.com Here’s our process.

Slide 15

Slide 15 text

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

Slide 97

Slide 97 text

noahlearner twooctobers.com Intent (via API)

Slide 98

Slide 98 text

noahlearner twooctobers.com Sub-Intent (via custom classifier)

Slide 99

Slide 99 text

noahlearner twooctobers.com GSC Trends

Slide 100

Slide 100 text

noahlearner twooctobers.com Compare your Search Terms to GSC to find Content Gaps

Slide 101

Slide 101 text

noahlearner twooctobers.com GSC Trends

Slide 102

Slide 102 text

noahlearner twooctobers.com This analysis was a piece of cake in count.co

Slide 103

Slide 103 text

noahlearner twooctobers.com GSC Trends

Slide 104

Slide 104 text

noahlearner twooctobers.com

Slide 105

Slide 105 text

noahlearner twooctobers.com thanks to @jroakes for the framing. Position Bucketing (via GSC)

Slide 106

Slide 106 text

noahlearner twooctobers.com 1. 2. 3. 4. Client Goals Gather Data Analyze Data Create Topics

Slide 107

Slide 107 text

noahlearner twooctobers.com Target topics that: - align to Client Goals

Slide 108

Slide 108 text

noahlearner twooctobers.com Target topics that: - align to Client Goals - have high search volume

Slide 109

Slide 109 text

noahlearner twooctobers.com Target topics that: - align to Client Goals - have high search volume - have conversion intent

Slide 110

Slide 110 text

noahlearner twooctobers.com Target topics that: - align to Client Goals - have high search volume - have conversion intent - and we can rank for.

Slide 111

Slide 111 text

noahlearner twooctobers.com Target topics that: - align to Client Goals - have high search volume - have conversion intent - and we can rank for.

Slide 112

Slide 112 text

noahlearner twooctobers.com Build internal links to match the related queries we found in Trends.

Slide 113

Slide 113 text

noahlearner twooctobers.com What’s Next?

Slide 114

Slide 114 text

noahlearner twooctobers.com Build Content briefs

Slide 115

Slide 115 text

noahlearner twooctobers.com Publish Content

Slide 116

Slide 116 text

noahlearner twooctobers.com Use GSC data to Optimize

Slide 117

Slide 117 text

noahlearner twooctobers.com You gotta earn it.

Slide 118

Slide 118 text

noahlearner twooctobers.com Resources https://bit.ly/searchlove2022

Slide 119

Slide 119 text

noahlearner twooctobers.com Stay in touch! [email protected] linkedin.com/in/noahlearner/ @noahlearner @thekraken