SAVE TIME - Learning how to use the bulk export, as well as BigQuery and SQL, is time consuming and requires a lot of researches and tests. Our training curates all the essential knowledge you need to start using BigQuery and SQL for SEO analysis.

Module 1 : Why use BigQuery with the Search Console data

• Why use the built-in bulk exports and why they're not perfect
  
• Initial setup
  
• Quizz

Module 2 : You're in! First steps to data analysis

• Introduction: how to access and use your data in BigQuery
  
• GSC bulk export data types
  
• Introduction: how to build an SQL query
  
• Working with dates
  
• Aggregate your data
  
• CASE statements
  
• Subqueries
  
• Common SQL queries
  
• Queries to dig deeper
  
• Join multiple data sets together
  
• Quiz
  

Module 3 : Saving and exporting your data

• Saving queries
  
• Saving as a table
  
• Saving views
  
• Schedule queries
  
• View in Google Sheets and other export methods
• Quiz 1
  
• Making Data Portable
  
• Your sample report
  
• Quiz 2
  

Module 4 : BigQuery cost management

• Billing + warning
  
• Advices to limit costs
  
• Quizz

Module 5 : Tips & FAQs

• Checklist to not mess it up
  
• Golden Rules
  
• FAQs