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

Google Search Console API + Google Data Studio: Big Data + Laser Focused Context for the Win - Whitespark Local Search Summit 2021

Google Search Console API + Google Data Studio: Big Data + Laser Focused Context for the Win - Whitespark Local Search Summit 2021

In this deck I show how to use the Google Search Console API as a smaller site to compete against Enterprise sites in Local SEO.

A lot of the features mentioned are available in https://branch.tools

Noah Learner

August 03, 2022
Tweet

More Decks by Noah Learner

Other Decks in Marketing & SEO

Transcript

  1. [email protected] @noahlearner
    no[email protected] @noahlearner #WLSS
    Google Search Console API +
    Google Data Studio:
    Big Data + Laser Focused
    Context for the Win

    View Slide

  2. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Why are we here?

    View Slide

  3. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    The
    Google Search Console (GSC)
    API Revolution

    View Slide

  4. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    The GSC API Revolution
    What is It?

    View Slide

  5. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    It’s a new way to find
    traffic growth
    opportunities.

    View Slide

  6. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    The GSC API Revolution
    Big data from the GSC API
    To provide context & Take Action.

    View Slide

  7. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    The GSC API Revolution
    Why?

    View Slide

  8. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Google Search Console
    Just isn’t good enough.

    View Slide

  9. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    1,000
    rows?

    View Slide

  10. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    1 dimension
    at a time?

    View Slide

  11. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    It’s also slow and
    tedious to work with.

    View Slide

  12. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Cloud Technology has
    evolved.

    View Slide

  13. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Making it possible to
    get & store
    search data for pennies!

    View Slide

  14. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    The Revolution is for ALL!

    View Slide

  15. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Small sites can be nimble
    + compete for the long tail
    in ways larger sites can’t.

    View Slide

  16. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    It’s Google Search
    Console Made
    Meaningful.

    View Slide

  17. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS

    View Slide

  18. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS

    View Slide

  19. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    The API delivers
    25x the data.

    View Slide

  20. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    25x the data is pretty cool,
    where’s the money?

    View Slide

  21. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    HOW MUCH IS
    HIDDEN?
    Clicks x Conv Rate x AOV

    View Slide

  22. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    7k
    Clicks x Conv Rate x AOV

    View Slide

  23. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    1%
    Clicks x Conv Rate x AOV

    View Slide

  24. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    $570
    Clicks x Conv Rate x AOV

    View Slide

  25. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    $40k
    = ~2% of revenue is hidden

    View Slide

  26. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    That is 1 of 285
    brands on the site.

    View Slide

  27. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    HIDDEN BOF TERMS
    $380k

    View Slide

  28. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    The API offers an
    astonishing amount
    of data.

    View Slide

  29. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Create UIs
    that match
    your workflows.

    View Slide

  30. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Layered filtering
    takes us from
    large data to
    actionable
    insights

    View Slide

  31. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    What are the Advantages?

    View Slide

  32. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    HOLY MOLY it’s fast.

    View Slide

  33. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    You’ll
    get more done
    in less time.

    View Slide

  34. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Segment your
    traffic with filters
    in meaningful
    ways.

    View Slide

  35. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Using GMB Queries
    To Drive ROI!

    View Slide

  36. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    GMB Filtering
    Services, entities, brands, and
    verbs associated with your GMB
    categories.

    View Slide

  37. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Combine this data with
    GA data for $$$.

    View Slide

  38. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Where do they go next?

    View Slide

  39. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Store pages
    1. GA Audience >
    Users Flow
    2. Change Category
    to Landing Page
    for a store page

    View Slide

  40. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Store pages
    1. Add content to store
    page to grow sales:
    a. Popular products
    b. Popular brands
    c. Popular
    categories

    View Slide

  41. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Position
    Bucketing
    THIS IS $$$

    View Slide

  42. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    ● Target queries by position

    View Slide

  43. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    ● Target queries by position
    ● Target low hanging fruit

    View Slide

  44. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    ● Target queries by position
    ● Target low hanging fruit
    ● Target queries just outside
    the local pack (4-15).

    View Slide

  45. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Branded
    Terms

    View Slide

  46. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    ● Are people searching more for
    my Brand?

    View Slide

  47. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    ● Are people searching more for
    my Brand?
    ● Is my site ranking for more:
    ○ Head terms?

    View Slide

  48. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    ● Are people searching more for
    my Brand?
    ● Is my site ranking for more:
    ○ Head terms?
    ○ Services?

    View Slide

  49. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    ● Are people searching more for
    my Brand?
    ● Is my site ranking for more:
    ○ Head terms?
    ○ Services?
    ○ Products?

    View Slide

  50. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS

    View Slide

  51. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Product
    Brands

    View Slide

  52. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    We saw huge
    demand for
    queries including
    “For Sale”

    View Slide

  53. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    REVENUE UP 116% over 2020

    View Slide

  54. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Putting it all together:
    TOPIC EXPLORER

    View Slide

  55. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS

    View Slide

  56. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Enter a head term
    to show relevant
    queries and URLS.

    View Slide

  57. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS

    View Slide

  58. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Click a search term
    to find a target page
    to optimize

    View Slide

  59. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS

    View Slide

  60. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    We can see:
    the page
    to optimize

    View Slide

  61. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS

    View Slide

  62. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    We can see:
    cannibalization
    issues

    View Slide

  63. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    We can see:
    internal linking
    opportunities

    View Slide

  64. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Perform
    serp analysis
    to understand
    search intent.

    View Slide

  65. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    What page types
    are in the Serps?

    View Slide

  66. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Keep your page that
    aligns with the serps.

    View Slide

  67. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    301 redirect / deoptimize
    the other pages.

    View Slide

  68. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Initial
    317K
    15K
    Step 1
    25.6K
    1.3K
    Step 2
    1
    5
    Terms
    URLs

    View Slide

  69. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    We can see
    content expansion
    opportunities

    View Slide

  70. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS

    View Slide

  71. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    FAQs anyone?

    View Slide

  72. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS

    View Slide

  73. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Take it a step further
    with conditional
    formatting.

    View Slide

  74. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS

    View Slide

  75. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS

    View Slide

  76. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Process the data in
    BigQuery for even more
    $$$.

    View Slide

  77. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Trending Queries = $$$

    View Slide

  78. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS

    View Slide

  79. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    You can then create
    change columns that
    are sortable in GDS.

    View Slide

  80. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS

    View Slide

  81. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    GIMME GIMME
    GIMME!!!

    View Slide

  82. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    How can I
    get this rolling?

    View Slide

  83. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Gathering the Data

    View Slide

  84. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    BigQuery Data Studio
    GSC API
    The System

    View Slide

  85. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Build your own or use an
    ETL tool:

    View Slide

  86. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Getting the data into BQ.
    $10 - $$$$ / month / client

    View Slide

  87. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    BigQuery costs between
    $0.02 - $0.25 / client / month

    View Slide

  88. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    DATA STUDIO
    IS
    FREE

    View Slide

  89. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    What have we
    learned?

    View Slide

  90. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    The GSC API is the
    new table stakes.

    View Slide

  91. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    The combo of
    API + BQ + GDS
    is crazy powerful.

    View Slide

  92. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    You’ll build better
    content that ranks
    and converts.

    View Slide

  93. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    Leave no data behind!

    View Slide

  94. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    USEFUL
    LINKS
    Two Octobers Explorer for Search:
    https://bit.ly/388eAPC

    View Slide

  95. [email protected] @noahlearner
    [email protected] @noahlearner #WLSS
    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