Write a SQL query to analyze Peloton interactive showroom performance by location, including revenue, conversion rate, and week-over-week trends.
Use the provided showroom, visit, and order data. Include every showroom for every week between the earliest and latest visit week, including weeks with no visits or orders.
Output
- One row per showroom and week, ordered by showroom name and week.
- Columns:
showroom_name, week_start, visit_count, completed_order_count, revenue, conversion_rate, and revenue_wow_change.
- Conversion rate is completed orders divided by visits. The first week per showroom should have a NULL week-over-week change.
