This page contains links to all tools and resources referenced in the IO 2023
talk on [BigQuery export for Google Analytics](https://io.google/2023/program/8846bfe6-ffe9-4de4-9057-ea1c44441e71/).
[Video](https://www.youtube.com/watch?v=c0mqBuXPrpA)

## Tools and resources

- Explore the [BigQuery sample dataset for Google Analytics ecommerce web implementation](https://developers.google.com/analytics/bigquery/web-ecommerce-demo-dataset) to learn about the schema and the data structure.
- Try out BigQuery at no cost with the [BigQuery sandbox](https://cloud.google.com/bigquery/docs/sandbox).
- Use the [schema reference](https://support.google.com/analytics/answer/7029846) to understand what's included in your BigQuery event export data.
- Try out [sample basic queries](https://developers.google.com/analytics/bigquery/basic-queries) on the demo dataset or your own BigQuery export dataset.
- View [BigQuery pricing](https://cloud.google.com/bigquery/pricing) details.
- Review instructions for [setting up BigQuery export for your Google Analytics property](https://support.google.com/analytics/answer/9823238).
- Learn about [BigQuery cost controls](https://cloud.google.com/bigquery/docs/controlling-costs) and how to implement them.
- Use [Looker Studio](https://lookerstudio.google.com/) and other third party reporting tools to create dashboards from your Google Analytics BigQuery export data.
- Understand [why Google Analytics UI and BigQuery Export number might not match](https://developers.google.com/analytics/blog/2023/bigquery-vs-ui).
- Manage performance and cost in BigQuery:
  - [Scheduled query](https://cloud.google.com/bigquery/docs/scheduling-queries)
  - [Materialized view](https://cloud.google.com/bigquery/docs/materialized-views-intro)
  - [Partitioning](https://cloud.google.com/bigquery/docs/partitioned-tables) and [clustering](https://cloud.google.com/bigquery/docs/clustered-tables)
  - [BI Engine](https://cloud.google.com/bigquery/docs/bi-engine-intro)
- Links to collected traffic source data export and UserID-level export will be added here once these features are available.
- Join the [GA Discord Server](https://goo.gle/ga-discord) and sign up for the [developer newsletter](https://goo.gle/ga-newsletter).