Learn SQL for SEO

with Google Search Console Data in BigQuery

Early bird registration!

Level up your analytics career

Are you an SEO, digital marketer, or analyst that wants to take your technical skills (and your career) to the next level?

This class is for you!

This video course will help you:

  •  Get familiar with Google BigQuery
  • Learn how to analyze SEO data at cloud scale
  • Learn common patterns for SQL analytics in SEO
Check out the course syllabus.
 
Course options:
Lite Course (Free): Get access to some of the course instruction via email when you sign up.
 

Full Course: Get all the course materials, code samples, configuration files, ChatGPT integration instructions and access to the Q&A community for only $50. (*Complete payment after the signup form.) The first 20 participants get free 1:1 support 

Contact me for team and agency pricing.

Sign up now and get free Premium Support!

Learn from 10+ years of analytics

I’ve spent over a decade in digital analytics and I’ve run thousands of SQL queries and spent the last segment of my career in the data warehouse industry. There’s no person better to teach a course on SQL for SEO. 

Connect on Linkedin

Course overview

What you'll learn

Get a jump on the newest trend in SEO analytics! When Google launched the BigQuery integration for Google Search Console , it became possible to analyze your website’s search data with unprecedented scale and sophistication. Take this class, and you will learn how to use BigQuery to infinitely scale your analytical impact!

BigQuery for data analysis

You’ll learn how to connect your Google Search Console data to BigQuery even if you’ve never used BigQuery before.

Analytical patterns for SEO

You’ll identify search trends, diagnose issues, and find opportunities to increase search traffic in ways you never thought possible.

SQL for web analytics

You’ll develop a tool kit of SQL patterns that you can use on any web data set that includes keywords and URLS. 

BigQuery cost control

You’ll learn the secrets to minimizing your BigQuery data storage and processing costs and stay below the Free tier.

Google Search Console data and reports

You’ll become familiar with the intricacies of how Google Search Console defines and reports search metrics.

Visualizing Search Data

You’ll learn how to connect Google Search Console data in BigQuery to Looker Data Studio to create dynamic reports.

Course Syllabus

  1. You’ll need access to a BigQuery account with at least a week’s worth of Google Search Console data loaded in.
    • If you don’t have access to GSC data in BigQuery, you have two options:
      • Setup the integration by following this tutorial
      • Follow these instructions to upload some demo data into your BigQuery instance.
  2. Optional but recommended: a basic understanding of SQL. While this course will start very basic, the course is designed for practitioners with intermediate SQL skills. 

Part 1: Introduction to Google Search Console Analytics in BigQuery

We’ll dive right into BigQuery and explore the three Google Search Console tables from the native integration. 

You’ll learn about: 

  • The three tables that the GSC integration populates in Google Search Console.
  • How Google defines dimensions and calculates the metrics in the three tables by tracing the data from the search page to BigQuery.

Part 2: Introduction to Data Warehousing

We’ll zoom way out and take a high-level look at the concept of data warehousing. 

You’ll learn about: 

  • What makes a data warehouse a data warehouse, and what makes a BigQuery uniquely suited for web analytics at a web-scale. 
  • How data is loaded into data warehouses by the process known as ETL (extraction, transformation, and loading.)

Part 3: SEO Analytics SQL

This is the most significant part of the course, with a light overview of SQL syntax, some BigQuery-specific considerations for controlling costs, and a bunch of SQL patterns for SEO data.

You’ll learn about: 

  • Best practices for keeping BigQuery costs under control when analyzing data
  • Common statistics and aggregation for SEO data
  • Advanced SQL patterns for specific use cases like performance trends, CTR curves, diagnostics, and opportunity discovery.

Part 4: Advanced Applications for Google Search Console Data

This section is all about applying the insights that you’ve gained from analyzing your search data. We’ll discuss how to communicate this information to have more impact and how to increase the visibility of your SEO efforts.

You’ll learn about: 

  • Sharing your SEO performance by visualizing it in dashboards 
  • Communicating about your learnings to create a broader impact
  • Integrating the data with other systems to automate alerts and optimizations
What are you waiting for?

Sign up today and get free 1:1 support!

Register
CONTACT
CONTACT