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 an independent data analyst 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.

Don't feel like learning SQL yourself? Generate out of the box queries at

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