A digital guide with example queries and tutorials on how to query Google Analytics 4 data in BigQuery. Free monthly newsletter. Premium tutorials and reports.
BigQuery
Joined November 2022
- Tweets64
- Following57
- Followers887
- Likes55
New post: Which web analytics tools provide a raw event data export to BigQuery? ga4bigquery.com/which-web-an…
Newsletter: #10 - Increased data sampling pushes GA4 users towards BigQuery ga4bigquery.com/blog/newslet…
Guess who's been signing up for a premium subscription on GA4BigQuery.com?
My audience typically consists of data professionals and marketers from agencies and brands of various sizes and reputations. (1/3)
But starting this week, we've welcomed several (!) @Google employees as premium subscribers. It’s an intriguing scenario that even the creators of GA4 seek external insights into handling the GA4 BigQuery data export. (2/3)
I guess this speaks volumes about our platform's impact. If you're interested in joining as well: here's a 20% discount on our premium subscription for Black Friday/Cyber Week. lnkd.in/enJTAdpM (3/3)
New post: How to fix the major GA4 BigQuery export misattribution (part 2: join 'gclid' parameter with Google Ads data transfer and get your campaign data right) ga4bigquery.com/how-to-fix-t…
New post: GA4 BigQuery export schema change log (or how to generate your own) ga4bigquery.com/ga4-bigquery…
New post: How to get the GA4 property id from the BigQuery export metadata and join it with your event data ga4bigquery.com/how-to-get-t…
New post: #7 - AI-powered SQL code assistance coming to BigQuery Studio ga4bigquery.com/newsletter-7…
GA4BigQuery retweeted
#BigQuery recently added charts to the UI. It offers a very quick and simple way to visualize data without needing to open other tools like Looker Studio. At the moment bar and line charts are available for a single dimension and multiple metrics.
New post: How to create a GA4 item / product performance report in BigQuery ga4bigquery.com/how-to-creat…
New post: How to set up Google 'Connected' Sheets to access GA4 BigQuery export data without learning SQL ga4bigquery.com/how-to-set-u…
New post: How (and why) to activate the GA4 user activity data export to BigQuery ga4bigquery.com/how-and-why-…
GA4BigQuery retweeted
User Data export is rolling out to #GoogleAnalytics4 / #BigQuery.
It includes two new tables - one for user ID data and one for client & device IDs.
Check out the schema and details here:
support.google.com/analytics… – at Espoo, Suomi
New post: Why (and how) to use GA4 event_timestamp with your local time zone instead of event_date in BigQuery ga4bigquery.com/why-and-how-…
GA4BigQuery retweeted
Such a good article by @CharlesFarina . It’s puzzling why the answer isn’t provided by #GA4 UI. Just another reason (of many) why understanding GA4 data is going to take some time…and why we need to learn BQ.
charlesfarina.com/the-traffi…
A couple of weeks ago Glenn Schmelzle invited us on his @funnelreboot podcast. We had a great conversation about #GA4 & #BigQuery and explored the sweet spot between data, business and tech. funnelreboot.com/episode-153…
New post: #6 - New fields in GA4 export & SQL query generators ga4bigquery.com/newsletter-6…
Great resource!
Querying the GA4 BigQuery export can be a real headache – even for SQL experts. With so many fields, it's not easy to figure out the logic behind each one.
That's where ga4sql.com comes in - a query builder that makes it easy to generate SQL queries.
#ga4 #bigquery