Slide 2. was an article by my friend Dan Leibson that got me excited to embark on this journey of discovery.

Slide 3. Explorer is a tool we’ve built for exploring GSC data at scale.

Slide 8.

Slide 30.

Slide 31. 

Slide 36. 

Slide 79. is a step by step workflow for getting Keyword Planner data into a usable format.

Slide 45. Difference between Autosuggest and Google Trends from Google’s own documentation.

Slide 47. Google Trends is a killer resource for seeing Search data over time.

Slide 54. DataForSEO – Google Trends API, pytrends, and Node.js Google Trends API are three popular ways to work with Google Trends data.

Slide 70-75. ObservableHQ. I experimented heavily with this platform and think it’s a great tool to use to build different visualizations of your data. Each of the different visualizations mentioned gives a different way to see the data. Pick what works for you!

Slide 87

Onboarding Questions to ask

  • What services do you offer?
  • What is most profitable?
  • What is a conversion worth?
  • When do you make your money?
  • Where do you make your money?
  • What is your sales process?
  • What questions from potential customers drive decision?
  • How can content support the sales process?

Wikipedia Workflow

  1. Go to Wikipedia and search for the service.
  2. Link clump Chrome Extension
    1. Grab anchor link text.
  3. paste results to our sheet.

Noah’s Google Trends Sunburst Output

Play with this tool. I think you’ll find it’s a total hoot. Use it to see relationships.

Don’t use it to see parent / child relationships.

The Knowledgegraph tool

Lee Foot’s Colab Workflow

  1. Edit the output CSV name
  2. Click Runtime > Run All
  3. Upload your CSV when prompted
  4. Your CSV will Download into your machine

Content Gaps Workflow (using Count)

I experimented heavily with Count and found it to be super useful and easy to use for folks who have even the smallest amount of SQL knowledge.

Screen Shot 2022 06 09 at 10.34.07 AM


Select all of your GSC data in Step 1 followed by Select all of your Trends data in Step 2.

Screen Shot 2022 06 09 at 10.37.15 AM


Select all of the Trends Data Except for the GSC data in Step 3.

Joining our “Gap” data back up with its enriched data gives us great visibility into how useful it would be to write about a specific topic.

Photo Credits

phil botha a0TJ3hy UD8 unsplash


Photo by Phil Botha.

nasa qhBZHz J1FI unsplash


Photo Courtesy of NASA

jeremy perkins ls PiEVCGuc unsplash


Photo courtesy of Jeremy Perkins