Visualize E-commerce User Flows with a Sankey Chart in Looker Studio

📊 Turn Raw Data into Insights with a Sankey Chart! 🔥 In this video, I'll show you how to transform raw e-commerce event data into a clear & interactive Sankey chart using Looker Studio! 🚀 You'll learn: ✅ How to prepare your data for visualization ✅ How to track user flows (conversions, page views, checkout & more!) ✅ How to make sense of your data and uncover valuable insights 💡 🔗 Query to Prepare Data: 👉 https://github.com/msjoelin/tutorials/blob/main/sankey_dataprep.sql 📊 Looker Studio Dashboard: 👉 https://lookerstudio.google.com/s/mDbzPKKm_0U 🔔 Don't forget to like & subscribe for more data tips! 🚀 ----------------------------------------------------------------- 00:00 Intro — visualizing user flows with Sankey charts 01:48 The data — Google's public e-commerce dataset 02:50 What the final data structure needs to look like 03:32 Step 1: Extract the 3 columns we need 04:28 Step 2: Add LEAD function for source & destination 06:00 Step 3: Handle events happening at different steps 09:00 Step 4: Aggregate into source → destination format 10:36 Step 5: Filter out events after purchase 13:22 Step 6: Consolidate purchase events into one 15:03 Plug the data into Looker Studio 15:55 Build the Sankey chart 16:27 Reading & interpreting the chart #SankeyChart #LookerStudio #BigQuery #GoogleAnalytics #DataVisualization #EcommerceAnalytics #ProductAnalytics #DataAnalytics #SQL #CustomerJourney