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!
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.