GA4BigQuery

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.

[GA4BigQuery @GA4BigQuery]

@pal_analytics Thanks for the insight.

[GA4BigQuery @GA4BigQuery]

New post: Which web analytics tools provide a raw event data export to BigQuery? https://t.co/6AMzmBSaXi

[GA4BigQuery @GA4BigQuery]

@pal_analytics Define 'much lower'?

[GA4BigQuery @GA4BigQuery]

Newsletter: #10 - Increased data sampling pushes GA4 users towards BigQuery https://t.co/sopNL0xCm5

[GA4BigQuery @GA4BigQuery]

@martijnvv @Google Of course most of them are not in the GA4 team, but one could assume this type of knowledge should be accessible for all Google employees somewhere inside the company, instead of having to rely on third party content providers.

[GA4BigQuery @GA4BigQuery]

Guess who's been signing up for a premium subscription on https://t.co/pmTkyl8UGt?

My audience typically consists of data professionals and marketers from agencies and brands of various sizes and reputations. (1/3)

[GA4BigQuery @GA4BigQuery]

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. https://t.co/U4mXH1nrZI (3/3)

[GA4BigQuery @GA4BigQuery]

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)

[GA4BigQuery @GA4BigQuery]

@wissi_analytics @bigquery4ga 🤯

[GA4BigQuery @GA4BigQuery]

Just sent newsletter #9 to 4,500 subscribers: https://t.co/jD11FkNyTZ

[GA4BigQuery @GA4BigQuery]

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) https://t.co/tmBI6Iy6A6

[GA4BigQuery @GA4BigQuery]

New post: GA4 BigQuery export schema change log (or how to generate your own) https://t.co/KFR1JwIcRY

[GA4BigQuery @GA4BigQuery]

New post: How to get the GA4 property id from the BigQuery export metadata and join it with your event data https://t.co/L8OZWXH6sW

[GA4BigQuery @GA4BigQuery]

New post: #7 - AI-powered SQL code assistance coming to BigQuery Studio https://t.co/mMD9oS1Zv0

[Luka Cempre @Lukaslo]

#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.

[GA4BigQuery @GA4BigQuery]

New post: How to create a GA4 item / product performance report in BigQuery https://t.co/EscasKxQZg

[GA4BigQuery @GA4BigQuery]

New post: How to set up Google 'Connected' Sheets to access GA4 BigQuery export data without learning SQL https://t.co/yj0ohAFkSD

[GA4BigQuery @GA4BigQuery]

New post: How (and why) to activate the GA4 user activity data export to BigQuery https://t.co/IcAhd4hPdQ

[Simo Ahava @SimoAhava]

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:

https://t.co/0j0wqNeyaz

[GA4BigQuery @GA4BigQuery]

New post: Why (and how) to use GA4 event_timestamp with your local time zone instead of event_date in BigQuery https://t.co/8CYDSYdO0T