E-Commerce Funnel Dashboard (GA4 + BigQuery)

Created an interactive dashboard for analyzing the sales funnel of an online store, which allows marketing teams to quickly assess key metrics and analyze user behavior.
What has been implemented:
- KPI: Sessions, Orders, Purchases, Conversion Rate
- 7-step funnel - from website visit to purchase
- Segmentation by traffic source, device, language, OS, landing page
- Cleaned and standardized filters → built readable names instead of raw GA4 values
- Added the parameter “Selected Event” to change the key event and analyze conversions to it
- 5+ interactive charts, drill-downs, and time filters
What this means for the business:
- see where users drop out of the funnel
- assess the effectiveness of different traffic sources
- identify problems in UX or payment processes
- make data-driven decisions
SQL query:
https://lnkd.in/gGc3kSG2