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 July 1st)
Register before July 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 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
- 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.
- If you don’t have access to GSC data in BigQuery, you have two options:
- 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