Skip to main content


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 marketeers 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 8+ years 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 Or pick my brain in a 60-minute data chat.

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