• This thread is just the tip of the iceberg.The people ahead of the curve aren't Googling for answers — they're already in here, having the conversations you haven't found yet. DealerRefresh is free.Get the full picture →

Here are some sample BigQuery queries to pull GA4 data based on the ASC standard.

Mark A Hoffman

3rd Base Coach
Nov 10, 2015
42
40
Awards
3
First Name
Mark
With the recent push for the ASC standard for GA4, and with more people dipping their toes into the BigQuery waters, I thought it would be a good time to share some helpful queries that highlight what you can do with BigQuery and the ASC standard.

I built a simple tool that lets you enter your BigQuery project ID and dataset ID, along with a date range and it will format several different sample queries that you can cut and paste directly into your own BigQuery. (Don't worry, nobody can access your data even if they had the project ID and dataset ID. It's basically just the name of your database; they would still need to have permissions to it.)

You can try out the tool here: Dealer Insights

If you have any questions about how to leverage ASC and BigQuery, let me know. It's kinda my thing.
 
  • Like
Reactions: Anthony G.

✨ AI Highlights

Mark A Hoffman shares a tool and sample BigQuery queries designed to help automotive dealers extract GA4 data aligned with the ASC (Automotive Standards Committee) standard, making it easier for professionals new to BigQuery to analyze their data. The tool allows users to input their BigQuery credentials and date ranges to generate ready-to-use queries without exposing their data to security risks. This resource aims to democratize access to advanced analytics capabilities for dealership professionals interested in leveraging BigQuery's analytical power.

Replies Views 0 1,580 Started Last Reply