Hi there,
First, a warm welcome to the 323 new subscribers who joined since the last newsletter.
In this issue:
- 7 new articles on GA4BigQuery
- ELT tool announces free plan
- Join the conversation
- Just released: the GA4 bible
- Relevant blog posts from the community
New articles on GA4BigQuery
Since the last newsletter I've added 7 new articles:
- How to filter events in your GA4 BigQuery export to avoid exceeding daily 1 million event limit
- How to explore GA4 event data with the sample ecommerce data set in BigQuery
- How to query streaming GA4 export data and combine it with historical data in BigQuery
- How to join your CRM and GA4 event data in BigQuery
- How to fix the major GA4 BigQuery export misattribution bug where paid search events and sessions are mistaken for organic or direct traffic
- Why the landing page report in GA4 sucks and how to fix it in BigQuery (GA3 style)
- How to create a GA4 user retention cohort table in BigQuery (and visualise it in Looker Studio)
Fivetran announces free plan
One of the biggest players in the marketing ELT (Extract, Load & Transform) world just announced a free plan, starting February 1st, 2023. This could be a great opportunity for you to start pushing data from other (marketing) sources to BigQuery.
Using their connectors you will be able to query (and join) data from sources like Google Ads, Search Console, Facebook, Salesforce, Shopify, etc.
What's the catch here? Well, the free plan has a limit on 500k MAR (monthly active rows). Just like the billing model in BigQuery, the Fivetran pricing is based on the amount of data you process (consumption based).
Switching to a freemium model could benefit Fivetran in the long run, as free users are already active in their ecosystem and more likely to upgrade to a premium plan when they add more data (sources).
I'm curious how competitors like Airbyte, Supermetrics, Funnel and Stitch will react.
Join the conversation
As you might have seen while browsing on GA4BigQuery: I added a comment feature. From now on all subscribers can comment on articles. The comments are only visible when you are logged in.
This is the best place to share questions, suggestions, feedback, experiences related to the content on the platform. Feel free to drop a line!
Just released: the GA4 bible
If you're working with GA4 data (and don't consider yourself a cloud guru) this book is written for you. It's a great read about GA4's analytics model, including data architecture and strategy, as well as tips on how to handle data ingestion, storage, and modeling. It also includes common data activation use cases.
The book, simply called Learning Google Analytics, is written by Mark Edmondson, a Google developer expert for both Google Analytics and Google Cloud. It breaks down GA4's capabilities and its cloud integrations in a clear and easy-to-understand manner. Edmondson is also the creator of googleAnalyticsR (a library for working with Google Analytics data in the programming language R).
Relevant blog posts from the community
- How do I access the individual timestamp of a GA4 event?
- From Google Analytics to Piwik Pro? A real client case
- Google Cloud setup checklist
- BigQuery and GA4: how to redact parameters in code
- Combine Data from Different Sources in BigQuery: GA4 and Shopify
- How to Extract Dates from a GA4 table in BigQuery (beginner level)
- The technical marketing guide
That's it for now. Thanks for reading and happy querying!
Best regards,
Johan
