• Stop being a LURKER - join our dealer community and get involved. Sign up and start a conversation.

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

Mark A Hoffman

Peel'm off the Ceiling
Nov 10, 2015
36
35
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.