Google BigQuery and SQL with Google Analytics 4

Learn BigQuery and SQL for Marketers and Marketing Analytics with Google Analytics 4

Learn BigQuery and SQL for Marketers and Marketing Analytics with Google Analytics 4

What you’ll learn

  • Become a technical marketer who is savvy in both digital marketing and data analysis.
  • Write advanced queries.
  • Use BigQuery data in Google Data Studio.

Course Content

  • Introduction –> 5 lectures • 23min.
  • SQL Basics for BigQuery –> 6 lectures • 41min.

Google BigQuery and SQL with Google Analytics 4

Requirements

  • Basic Understanding of marketing.
  • Basic Understanding of Google Analytics 4.

Learn BigQuery and SQL for Marketers and Marketing Analytics with Google Analytics 4

This course is designed specifically for Marketers and Marketing Analytics. If you are using Google Analytics 4 then this is a must-have course for you. Google Analytics 4 now sends data directly to BigQuery. Many of the reports use used to get in Google Analytics are no longer there and you have to rely on BigQuery and Google Data Studio to build this report.

This course will teach you

  • What is BigQuery
  • What free and paid options you have
  • How you can integrate Google Analytics 4 with bigQuery
  • BigQuery + Google Analytics 4 (GA4) data structure
  • Writing SQL to pick the right data
  • Unnesting BigQuery data
  • BigQuery + Data Studio overview