Introduction Google Big Query
What You Learn?
◾ Google Cloud Console and BigQuery UI.
◾ BigQuery data structure.
◾ BigQuery SQL dialects.
◾ GA schema overview.
◾ Dealing with nested and repeated fields.
◾ Understanding hit types and how records correspond to GA data.
◾ Replicating basic GA session metrics including users, sessions, pageviews, bounce rate, etc.
◾ Using BQ’s SQL features to query date ranges.
◾ Unnesting hit-level and product-level data and calculating metrics such as landing pages, time on page, and more.
◾ Using custom dimensions and custom metrics.
◾ Limitations of GA’s standard metrics and examples of alternative calculations.
◾ Best practices for structuring queries for readability.
◾ Importing and exporting data.
◾ Scheduling and automation.
◾ Integrations with other Google data sources (Firebase, Google Ads, Campaign Manager, YouTube, and others).
◾ Connecting data visualization tools including Data Studio.