Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Into the Great Unknown - MozCon

Noah Learner
August 02, 2022
Marketing & SEO
6
490

Into the Great Unknown - MozCon

In this deck that I delivered at MozCon on July 11, 2022 I took the audience on a three pronged deep dive into topic clustering, innovation work at https://branch.tools / SEO toolbuilding and how to get ahead working in digital.

I shared all kinds of free SEO tools that I built, as well as a cool observablehq tool to look at the output of a set of topic clusters that I built with a combination of Google Trends, Google Sheets, DataForSEO, Semrush API and Google Cloud Functions.

Noah Learner

August 02, 2022
Tweet

More Decks by Noah Learner

See All by Noah Learner
Complete GSC Data The New Table Stakes in SEO - LocalU - 4-7-21
thekraken
3
46
Game-Changing Ways to Use the Google Search Console API - MozCon 2021
thekraken
4
59
Google Search Console API + Google Data Studio: Big Data + Laser Focused Context for the Win - Whitespark Local Search Summit 2021
thekraken
0
48
Real Business 💩 - Analysis with Google Data Studio
thekraken
0
83
Into the Great Unknown - SearchLove
thekraken
1
54

Other Decks in Marketing & SEO

See All in Marketing & SEO
¡Adiós a las Historias de Horror SEO! 
Aprende a Establecer un Framework de Calidad SEO #SEOPlus22
aleyda
0
400
How to Develop Successful SEO Reports #SEOKomm
aleyda
5
2.6k
DevRel/Japan Conference 2022 マーケ_DevRel_セッション資料
hideki_ojima
1
100
NewsPics利用ユーザーインタビューサマリー
sairu_inc
0
2.1k
20230311_DevRel/Japan CONFERENCE 2023
odasho
0
820
Study Case : AI Copywriting vs. Human Copywriting
yakiseo
0
440
Randomized Controlled Trial
takumikato
0
330
Avoid SEO Horror Stories with Monitoring! - BrightonSEO April 2023
diije
PRO
0
210
Las Historias de Horror SEO Más Comunes en Webs de E-commerce y Cómo Evitarlas- #EcommerceTourPalma
aleyda
0
120
地方テック企業もDevRel頑張ってみた
furukawayasuto
0
970
SEOloger naživo 2023: Anna Schumacher Lokální SEO, ROPO efekt a proč mít Google Business Profile
pavelungr
0
110
Serverless SEO / Edge SEO - SEO-DAY 2021 Cologne
bastiangrimm
PRO
0
150

Featured

See All Featured
A designer walks into a library…
pauljervisheath
199
17k
In The Pink: A Labor of Love
frogandcode
133
21k
Product Roadmaps are Hard
iamctodd
39
8.2k
How STYLIGHT went responsive
nonsquared
89
4.3k
Building an army of robots
kneath
300
41k
Testing 201, or: Great Expectations
jmmastey
26
5.9k
The Power of CSS Pseudo Elements
geoffreycrofte
54
4.5k
How GitHub Uses GitHub to Build GitHub
holman
466
280k
How New CSS Is Changing Everything About Graphic Design on the Web
jensimmons
214
12k
Fontdeck: Realign not Redesign
paulrobertlloyd
74
4.5k
Fireside Chat
paigeccino
18
2.1k
Producing Creativity
orderedlist
PRO
335
38k

Transcript

  1. noahlearner #MozCon branch.tools

    View Slide

  2. noahlearner #MozCon branch.tools
    You gotta earn it.

    View Slide

  3. noahlearner #MozCon branch.tools
    GSC


    (inside out)

    View Slide

  4. noahlearner #MozCon branch.tools
    We’d only solved


    some of the problems.

    View Slide

  5. noahlearner #MozCon branch.tools
    GSC


    (inside out)
    ???


    (Outside in)

    View Slide

  6. noahlearner #MozCon branch.tools
    Building content


    is hard.

    View Slide

  7. noahlearner #MozCon branch.tools
    Especially when
    there’s no data.

    View Slide

  8. noahlearner #MozCon branch.tools
    Topics keyword
    Vs

    View Slide

  9. noahlearner #MozCon branch.tools
    a topic = a subject.
    It’s the thing you’re
    writing about.

    View Slide

  10. noahlearner #MozCon branch.tools
    a keyword = an
    important word used
    while talking about a
    subject.

    View Slide

  11. noahlearner #MozCon branch.tools
    Keyword Research
    isn’t the answer.

    View Slide

  12. noahlearner #MozCon branch.tools
    Resources


    https://bit.ly/MozCon2022

    View Slide

  13. noahlearner #MozCon branch.tools
    Here’s our process.

    View Slide

  14. noahlearner #MozCon branch.tools
    1. 2. 3. 4.
    Client
    Goals
    Gather
    Data
    Analyze
    Data
    Choose
    Topics

    View Slide

  15. noahlearner #MozCon branch.tools
    Who is your ideal
    customer?

    View Slide

  16. noahlearner #MozCon branch.tools
    What services do
    you offer?

    View Slide

  17. noahlearner #MozCon branch.tools
    What is most
    profitable?

    View Slide

  18. noahlearner #MozCon branch.tools
    What is a


    conversion worth?

    View Slide

  19. noahlearner #MozCon branch.tools
    How do you make
    money?

    View Slide

  20. noahlearner #MozCon branch.tools
    When do you make
    your money?

    View Slide

  21. noahlearner #MozCon branch.tools
    Where do you make
    your money?

    View Slide

  22. noahlearner #MozCon branch.tools
    What questions are
    tied to conversions?

    View Slide

  23. noahlearner #MozCon branch.tools
    What is your


    sales process?

    View Slide

  24. noahlearner #MozCon branch.tools
    How can


    content support


    the sales process?

    View Slide

  25. noahlearner #MozCon branch.tools
    1. 2. 3. 4.
    Client
    Goals
    Gather
    Data
    Analyze


    Data
    Create
    Topics

    View Slide

  26. noahlearner #MozCon branch.tools
    We don’t know what
    Google knows,


    we only know what
    they show us!

    View Slide

  27. noahlearner #MozCon branch.tools
    Google shows us
    relationships in a few
    places.

    View Slide

  28. noahlearner #MozCon branch.tools
    Knowledge Graph
    Search API, the SERPs,
    autocomplete, KWP
    data & Google Trends.

    View Slide

  29. noahlearner #MozCon branch.tools

    View Slide

  30. noahlearner #MozCon branch.tools

    View Slide

  31. noahlearner #MozCon branch.tools

    View Slide

  32. noahlearner #MozCon branch.tools

    View Slide

  33. noahlearner #MozCon branch.tools
    Wikipedia

    View Slide

  34. noahlearner #MozCon branch.tools
    Wikipedia makes up
    over 67% of the sources
    for tracked Knowledge
    Panels.


    - Kalicube Pro.

    View Slide

  35. noahlearner #MozCon branch.tools

    View Slide

  36. noahlearner #MozCon branch.tools

    View Slide

  37. noahlearner #MozCon branch.tools
    Related Topics!

    View Slide

  38. noahlearner #MozCon branch.tools
    SERPs

    View Slide

  39. noahlearner #MozCon branch.tools
    Get Related
    searches


    +




    People also ask

    View Slide

  40. noahlearner #MozCon branch.tools
    Autocomplete

    View Slide

  41. noahlearner #MozCon branch.tools
    What is it?

    View Slide

  42. noahlearner #MozCon branch.tools

    View Slide

  43. noahlearner #MozCon branch.tools

    View Slide

  44. noahlearner #MozCon branch.tools
    Google Trends

    View Slide

  45. noahlearner #MozCon branch.tools
    1. Enter query


    View Slide

  46. noahlearner #MozCon branch.tools
    1. Enter query


    2. Edit geo region to state.


    View Slide

  47. noahlearner #MozCon branch.tools
    1. Enter query


    2. Edit geo region to state.


    3. Download Related topics +
    Related queries CSVs


    View Slide

  48. noahlearner #MozCon branch.tools
    1. Enter query


    2. Edit geo region to state.


    3. Download Related topics +
    Related queries CSVs


    4. Add the terms to our
    Google Sheet.

    View Slide

  49. noahlearner #MozCon branch.tools
    That would never scale

    View Slide

  50. noahlearner #MozCon branch.tools
    You can get the data
    with APIs.

    View Slide

  51. noahlearner #MozCon branch.tools

    View Slide

  52. noahlearner #MozCon branch.tools
    Related Queries


    from Google Trends.

    View Slide

  53. noahlearner #MozCon branch.tools
    Steps


    - Get Data

    View Slide

  54. noahlearner #MozCon branch.tools
    Steps


    - Get data


    - Remove irrelevant terms

    View Slide

  55. noahlearner #MozCon branch.tools
    Steps


    - Get data


    - Remove irrelevant terms


    - Enrich with keyword metrics (via API)

    View Slide

  56. noahlearner #MozCon branch.tools
    Steps


    - Get data


    - Remove irrelevant terms


    - Enrich with keyword metrics (via API)


    - Get More Data

    View Slide

  57. noahlearner #MozCon branch.tools
    Human curation


    at each step


    is key.

    View Slide

  58. noahlearner #MozCon branch.tools
    Bicycle

    View Slide

  59. noahlearner #MozCon branch.tools
    22


    Search Terms

    View Slide

  60. noahlearner #MozCon branch.tools
    After 2 cycles it’s getting
    useful.

    View Slide

  61. noahlearner #MozCon branch.tools
    139


    Search Terms

    View Slide

  62. noahlearner #MozCon branch.tools
    974


    Search Terms

    View Slide

  63. noahlearner #MozCon branch.tools
    Within 15 minutes you can
    build something
    extraordinary.

    View Slide

  64. noahlearner #MozCon branch.tools
    4K+


    Terms

    View Slide

  65. noahlearner #MozCon branch.tools
    Pump your brakes.

    View Slide

  66. noahlearner #MozCon branch.tools
    4k search terms


    =


    messy messy data viz.

    View Slide

  67. noahlearner #MozCon branch.tools
    1. 2. 3. 4.
    Client
    Goals
    Gather
    Data
    Analyze


    Data
    Create
    Topics

    View Slide

  68. noahlearner #MozCon branch.tools
    Force Directed Tree


    STILL NOT THERE!

    View Slide

  69. noahlearner #MozCon branch.tools
    Circle Packing


    CLOSER

    View Slide

  70. noahlearner #MozCon branch.tools
    Sunburst

    View Slide

  71. noahlearner #MozCon branch.tools
    Could this help get
    buy in?

    View Slide

  72. noahlearner #MozCon branch.tools
    Most SEOs would


    probably prefer this.

    View Slide

  73. noahlearner #MozCon branch.tools

    View Slide

  74. noahlearner #MozCon branch.tools
    Clustering Methods

    View Slide

  75. noahlearner #MozCon branch.tools
    Manually works,


    but = many hours
    poring over
    spreadsheets.

    View Slide

  76. noahlearner #MozCon branch.tools
    Google Keyword
    Planner

    View Slide

  77. noahlearner #MozCon branch.tools
    A great idea


    from Nico Brooks

    View Slide

  78. noahlearner #MozCon branch.tools
    1. Enter query


    View Slide

  79. noahlearner #MozCon branch.tools
    1. Enter query


    2. Look at data


    View Slide

  80. noahlearner #MozCon branch.tools
    1. Enter query


    2. Look at data


    3. Add keyword ideas
    as ad groups


    View Slide

  81. noahlearner #MozCon branch.tools
    1. Enter query


    2. Look at data


    3. Add keyword ideas
    as ad groups


    4. Download campaign


    View Slide

  82. noahlearner #MozCon branch.tools
    1. Enter query


    2. Look at data


    3. Add keyword ideas
    as ad groups


    4. Download campaign


    5. Use it to guide SEO
    topics.

    View Slide

  83. noahlearner #MozCon branch.tools
    SERP Similarity


    The current tooling
    gold standard.

    View Slide

  84. noahlearner #MozCon branch.tools
    Use machine learning to
    compare search results to
    cluster search terms into
    groups or clusters.

    View Slide

  85. noahlearner #MozCon branch.tools
    Engineering Challenges
    ARE SIGNIFICANT.

    View Slide

  86. noahlearner #MozCon branch.tools
    Lee Foot’s Colab

    View Slide

  87. noahlearner #MozCon branch.tools
    Feed it your CSV +


    it outputs them


    into useful clusters.

    View Slide

  88. noahlearner #MozCon branch.tools
    Elias Dabbas


    @eliasdabbas
    creator of advertoolz library

    View Slide

  89. noahlearner #MozCon branch.tools
    Using Regular expressions,


    we can build a pretty useful
    customized classifier.

    View Slide

  90. noahlearner #MozCon branch.tools

    View Slide

  91. noahlearner #MozCon branch.tools
    Find your way to
    explore the data
    that works for you!

    View Slide

  92. noahlearner #MozCon branch.tools
    For me, easy analysis =


    Google Data Studio

    View Slide

  93. noahlearner #MozCon branch.tools

    View Slide

  94. noahlearner #MozCon branch.tools
    Clusters


    + their
    queries

    View Slide

  95. noahlearner #MozCon branch.tools
    Intent


    (via API)

    View Slide

  96. noahlearner #MozCon branch.tools
    Sub-Intent


    (via custom classifier)

    View Slide

  97. noahlearner #MozCon branch.tools
    GSC
    Trends

    View Slide

  98. noahlearner #MozCon branch.tools
    Compare your
    search terms to GSC


    to find content gaps

    View Slide

  99. noahlearner #MozCon branch.tools
    GSC
    Trends

    View Slide

  100. noahlearner #MozCon branch.tools
    This
    analysis
    was a
    piece of
    cake in
    count.co

    View Slide

  101. noahlearner #MozCon branch.tools
    GSC
    Trends

    View Slide

  102. noahlearner #MozCon branch.tools

    View Slide

  103. noahlearner #MozCon branch.tools
    thanks to @jroakes for the framing.
    Position


    Bucketing


    (via GSC)

    View Slide

  104. noahlearner #MozCon branch.tools
    1. 2. 3. 4.
    Client
    Goals
    Gather
    Data
    Analyze


    Data
    Create
    Topics

    View Slide

  105. noahlearner #MozCon branch.tools
    Target topics that:


    - align to client goals

    View Slide

  106. noahlearner #MozCon branch.tools
    Target topics that:


    - align to client goals


    - have high search volume

    View Slide

  107. noahlearner #MozCon branch.tools
    Target topics that:


    - align to client goals


    - have high search volume


    - have conversion intent


    View Slide

  108. noahlearner #MozCon branch.tools
    Target topics that:


    - align to client goals


    - have high search volume


    - have conversion intent


    - and we can rank for.

    View Slide

  109. noahlearner #MozCon branch.tools
    Target topics that:


    - align to client goals


    - have high search volume


    - have conversion intent


    - and we can rank for.

    View Slide

  110. noahlearner #MozCon branch.tools
    Build internal links to
    match the related
    queries we found in
    Trends.

    View Slide

  111. noahlearner #MozCon branch.tools
    What’s Next?

    View Slide

  112. noahlearner #MozCon branch.tools
    Build content briefs

    View Slide

  113. noahlearner #MozCon branch.tools
    Publish content

    View Slide

  114. noahlearner #MozCon branch.tools
    Use GSC data


    to optimize

    View Slide

  115. noahlearner #MozCon branch.tools
    You gotta earn it.

    View Slide

  116. noahlearner #MozCon branch.tools
    You gotta earn it.

    View Slide

  117. noahlearner #MozCon branch.tools
    Resources


    https://bit.ly/MozCon2022

    View Slide

  118. noahlearner #MozCon branch.tools
    Stay in touch!
    [email protected]
    linkedin.com/in/noahlearner/
    @noahlearner
    @thekraken

    View Slide