GA4 Funnel and Channel Analysis with a Looker Studio Ecommerce Dashboard
I built this in GA4 and Looker Studio using Google's public Merchandise Store dataset to sharpen how I read ecommerce funnels. In GA4 Explorations I set up a free-form table that breaks out sessions, key events and revenue by default channel group, plus a five-step funnel from session start to view item, add to cart, begin checkout and purchase. That shows where shoppers drop off and which channels actually bring in buyers. In Looker Studio I connected the GA4 property and built a dashboard with scorecards for users, sessions, key events and revenue, a sessions trend over time, a channel table and a date range control, so anyone can check performance without opening GA4. The numbers belong to Google's sample store, not a client. The point is the setup: how I structure explorations, define funnel steps and turn raw analytics into a view a marketing team can use every week.