起点传媒

Center for Customer Insights and Digital Marketing

BigQuery, SQL & Looker Studio Workshop | CCIDM

Digital Marketing Data Warehouse & Dashboard Building

About the Workshop

This session gives you a hands-on guide to moving your marketing data out of spreadsheets and into a cloud data warehouse you own. You'll create a free Google Cloud project and load data into BigQuery three ways: the Google Analytics 4 export, a CSV upload, and the Google Ads Data Transfer Service. Using Google's public GA4 e-commerce data set, you'll write SQL step by step, from basic filters to aggregations, wildcard tables, and a join that blends GA4 purchases with offline budget data. We'll also cover how to get reliable SQL from AI by giving it your data set's schema as context. By the end, you'll turn your query into a BigQuery view and connect it to Looker Studio to build a live dashboard with scorecards, time series charts, and filter controls.

Learning Outcomes

  1. Explain why exporting raw GA4 data to a cloud data warehouse overcomes the limits of spreadsheets and the GA4 interface
  2. Create a free Google Cloud project and load data into BigQuery through the GA4 export, a CSV upload, and the Google Ads Data Transfer Service
  3. Write SQL queries in BigQuery using SELECT, FROM, WHERE, SUM, GROUP BY, and ORDER BY
  4. Combine GA4 data with offline data using a WITH statement and a LEFT JOIN
  5. Use AI to generate accurate SQL by giving it your data set's schema as context
  6. Create a BigQuery view and connect it to Looker Studio to build a dashboard with charts and filter controls

Presentation Slides:

Workshop Preparation:

Resources:

  • Google Cloud Console:
  • BigQuery:
  • Looker Studio:
  • Google Analytics 4:
  • GA4 sample e-commerce data set:
  • GoogleSQL query syntax reference:
  • BigQuery pricing: