You've successfully subscribed to GA4BigQuery
Success! Your account is fully activated, you now have access to all content.
Success! Your billing info is updated.
Billing info update failed.

#3 - Relevant blog posts, join the conversation, GA4 bible released

#3 - Relevant blog posts, join the conversation, GA4 bible released

Join 1,800+ other professionals and receive a monthly newsletter packed with GA4 & BigQuery news, tips & tricks

Great! Check your inbox and click the link to confirm your subscription
Please enter a valid email address!
Already have an account? Sign in

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:

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

That's it for now. Thanks for reading and happy querying!

Best regards,
Johan