New video! From first click to repeat purchase - reporting for eCommerce that actually makes sense

Hey folks, I just dropped a new video on the channel.

If you’re running an online store and tired of stitching together ten tools and five spreadsheets just to figure out what’s actually working — this one’s for you.

In the video, I walk you through a fully connected reporting system we built for eCommerce:

- Built on BigQuery + Looker Studio

- Pulls data from GA4, Google Ads, Meta Ads, and WooCommerce

- Everything’s automated — no more CSV downloads or pivot table therapy

Here’s what you’ll see:

1. Two powerful data views: events (clicks, add-to-carts, purchases) and cohorts (what users do after their first visit)

2. Revenue and conversion insights by channel, device, region

3. Funnel drop-offs, long-term value, and repeat purchases

And yes — real-world example sare included.

If you’re in eCommerce — especially with high-ticket or research-heavy products — this setup gives you the full picture. No more guessing, no more “it depends.”

If you work with GA4 to BigQuery exports, be sure to check out my SQL cheat sheet.