
Google Ads Data Transfer Big Query without the hassle
The reasons why we built the Google Ads module. With Webinar slides, some background on our approach, and a sample dashboard.

The reasons why we built the Google Ads module. With Webinar slides, some background on our approach, and a sample dashboard.

In this post, a simple query that answers: Which search terms predict a purchase, even when that purchase happens days later in a different session?
Try to find that via the GA4 interface…

You finally got your GA4 data in BigQuery. You write your first query. And then you meet UNNEST. If you’ve worked

Cart abandonment is one of those things everyone knows is a problem and nobody fully understands. The usual dashboard tells you the rate. It doesn’t tell you why.
This query gives you the top “last 3 pages before abandoning a cart” for extra insight

Here’s an article on the ga4_transactions table, with a query that solves an actual use case: which product categories make customers loyal?

GA4Dataform 2.1.1 release notes