Skip to main content

Get started

GA4BigQuery is a digital platform on how to query Google Analytics 4 (GA4) data in BigQuery.

My goal is to provide valuable content to data analysts, online marketers and engineers, who seek guidance on how to query the GA4 BigQuery export data set.

My name is Johan van de Werken. I am a freelance data analyst & analtyics engineer and have a decade of hands-on experience in marketing, web & data analytics. I thrive best at the sweet spot between data, business & tech.

Together with Simo Ahava I have created a popular video course, focusing on learning SQL in the context of Google BigQuery and Google Analytics 4.

Currently I'm working on GA4Dataform.com, a solution that offers a faster and more efficient way to utilize your GA4 data in BigQuery. Tap within minutes into pre-built SQL models designed by industry experts, enabling you to start at a level of sophistication that usually takes years to achieve.

Don't feel like using GA4Dataform or learning SQL yourself? Generate out of the box queries at GA4SQL.com.

πŸ’‘
I can’t think of a better teacher to learn BigQuery from than Johan van de Werken. As a daily user of his site I can attest to his expertise of Google Analytics data in BigQuery and his willingness to help others learn.
- Jim Gianoglio, founder @ Cauzle Analytics