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

Game-Changing Ways to Use the Google Search Console API - MozCon 2021

Game-Changing Ways to Use the Google Search Console API - MozCon 2021

In this deck I showed off a number of ways to get the most out of the Google Search Console API by learning how to pipeline it using an ETL tool like https://jepto.com and to then visualize it with Google Data Studio.

I talk about a lot of the key benefits of this approach including:
- This approach makes data studio a super fast tool.
- You can segment and classify your data (we do this with customizable top, middle and bottom of the funnel terms at https://branch.tools).
- Position bucketing. It's super easy to segment your query data to find low hanging fruit opportunities.
- See your data segmented by URL structure
- Keyword Cannibalization
- Keyword Expansion
- Trending Queries

Noah Learner

August 03, 2022
Tweet

More Decks by Noah Learner

Other Decks in Marketing & SEO

Transcript

  1. noah@twooctobers @noahlearner
    Game-Changing Ways
    to Use the Google
    Search Console API
    Noah Learner
    Product Director, Two Octobers
    @noahlearner

    View Slide

  2. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    The Hubble
    Ultra Deep Field
    This is what
    10,000 galaxies
    looks like.

    View Slide

  3. noah@twooctobers @noahlearner
    [email protected] @noahlearner

    View Slide

  4. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    100 meters away

    View Slide

  5. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Using the API is like
    unleashing the power of
    Hubble.

    View Slide

  6. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    GSC UI

    View Slide

  7. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    GSC API

    View Slide

  8. noah@twooctobers @noahlearner
    [email protected] @noahlearner

    View Slide

  9. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    1,000
    rows?

    View Slide

  10. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    The API delivers
    25x the data.

    View Slide

  11. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    1 dimension
    at a time?

    View Slide

  12. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Google Search Console’s
    performance tab
    is painful.

    View Slide

  13. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    It’s also slow and
    tedious to work with.

    View Slide

  14. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    How’s this for context?

    View Slide

  15. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    25x the data is pretty cool,
    where’s the money?

    View Slide

  16. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    HOW MUCH IS
    HIDDEN?
    Clicks x Conv Rate x AOV

    View Slide

  17. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    7k
    Clicks x Conv Rate x AOV

    View Slide

  18. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    1%
    Clicks x Conv Rate x AOV

    View Slide

  19. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    $570
    Clicks x Conv Rate x AOV

    View Slide

  20. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    $40k
    = ~2% of revenue is hidden

    View Slide

  21. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    That is 1 of 285
    brands on the site.

    View Slide

  22. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    HIDDEN BOF TERMS
    $380k

    View Slide

  23. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    The API offers an
    astonishing amount
    of data.

    View Slide

  24. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Create UIs
    that match
    your workflows.

    View Slide

  25. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Build multiple layers
    of filters to get to
    answers. AND FAST

    View Slide

  26. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Context!

    View Slide

  27. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    GIMME GIMME
    GIMME!!!

    View Slide

  28. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    How can I
    get this rolling?

    View Slide

  29. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    BigQuery Data Studio
    GSC API
    The System

    View Slide

  30. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Gathering the Data

    View Slide

  31. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Build your own or use an
    ETL tool:

    View Slide

  32. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Getting the data into BQ.
    $10 - $$$$ / month / client

    View Slide

  33. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    BigQuery costs between
    $0.02 - $0.25 / client / month

    View Slide

  34. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    DATA STUDIO
    IS
    FREE

    View Slide

  35. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    What are the Advantages?

    View Slide

  36. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    HOLY MOLY it’s fast.

    View Slide

  37. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Segment your
    data by creating
    filters like this

    View Slide

  38. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Learn about
    calculated
    fields + case
    statements

    View Slide

  39. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    BE PATIENT.

    View Slide

  40. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Position
    Bucketing
    THIS IS $$$

    View Slide

  41. noah@twooctobers @noahlearner
    [email protected] @noahlearner

    View Slide

  42. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Branded
    Terms

    View Slide

  43. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Folder
    Structure

    View Slide

  44. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Product
    Brands

    View Slide

  45. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    We saw huge
    demand for
    queries including
    “For Sale”

    View Slide

  46. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    REVENUE UP 116% over 2020

    View Slide

  47. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Layered filtering
    takes us from
    large data to
    actionable
    insights

    View Slide

  48. noah@twooctobers @noahlearner
    [email protected] @noahlearner

    View Slide

  49. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    The
    magic

    View Slide

  50. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Enter a head term
    to show relevant
    queries and URLS.

    View Slide

  51. noah@twooctobers @noahlearner
    [email protected] @noahlearner

    View Slide

  52. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Click a search term
    to find a target page
    to optimize

    View Slide

  53. noah@twooctobers @noahlearner
    [email protected] @noahlearner

    View Slide

  54. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    We can see:
    the page
    to optimize

    View Slide

  55. noah@twooctobers @noahlearner
    [email protected] @noahlearner

    View Slide

  56. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    We can see:
    cannibalization
    issues

    View Slide

  57. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    We can see:
    internal linking
    opportunities

    View Slide

  58. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Perform serp analysis
    to understand
    search intent.

    View Slide

  59. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Keep your page that
    aligns with the intent
    you see in the serps.

    View Slide

  60. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    301 redirect / deoptimize
    the other pages.

    View Slide

  61. noah@twooctobers @noahlearner
    [email protected] @noahlearner

    View Slide

  62. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    We can see
    content expansion
    opportunities

    View Slide

  63. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Initial
    317K
    15K
    Step 1
    25.6K
    1.3K
    Step 2
    1
    5
    Terms
    URLs

    View Slide

  64. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    We can see
    low hanging fruit
    opportunities

    View Slide

  65. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Striking
    Distance

    View Slide

  66. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    FAQs anyone?
    Content expansion?

    View Slide

  67. noah@twooctobers @noahlearner
    [email protected] @noahlearner

    View Slide

  68. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Take it a step further
    with conditional
    formatting.

    View Slide

  69. noah@twooctobers @noahlearner
    [email protected] @noahlearner

    View Slide

  70. noah@twooctobers @noahlearner
    [email protected] @noahlearner

    View Slide

  71. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Process the data in
    BigQuery for even more
    $$$.

    View Slide

  72. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Trending Queries = $$$

    View Slide

  73. noah@twooctobers @noahlearner
    [email protected] @noahlearner

    View Slide

  74. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    You can then create
    change columns that
    are sortable in GDS.

    View Slide

  75. noah@twooctobers @noahlearner
    [email protected] @noahlearner

    View Slide

  76. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    What have we
    learned?

    View Slide

  77. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    The GSC API is the
    new table stakes.

    View Slide

  78. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    The combo of
    API + BQ + GDS
    is crazy powerful.

    View Slide

  79. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    You’ll build better
    content that ranks
    and converts.

    View Slide

  80. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    Leave no data behind!

    View Slide

  81. noah@twooctobers @noahlearner
    [email protected] @noahlearner
    USEFUL
    LINKS
    How to Build a Google Search Console
    Data Pipeline: http://bit.ly/gscPipeline
    Getting All Your Search Data:
    https://bit.ly/3fcGzC9
    Building Case Statements
    https://support.google.com/datastudi
    o/answer/7020724

    View Slide

  82. noah@twooctobers @noahlearner
    Game-Changing Ways
    to Use the Google
    Search Console API
    Noah Learner
    Product Director, Two Octobers
    @noahlearner

    View Slide