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!

In just four weeks, you will:

  •  Get familiar with Google BigQuery
  • Learn how to analyze SEO data at cloud scale
  • Learn common patterns for SQL analytics in SEO
  • Get personalized support (if you sign up before June 1st)

Register before June 1st and get $25 off!

This class will normally cost $50 USD but if you register today, you’ll get 50% off the regular price with promo code EARLYWORD. No payment needed to register.

Register now for 50% off regular price!

What country do you live in?

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. 

Course overview

What you'll learn

Get a jump on the newest trend in SEO analytics! When Google launched the Search Console Bulk Export feature for BigQuery, 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.

What are you waiting for?

Sign up today and get 50% off