Conversion rates
Time to first order
Conversion charts
Instruction
Great! Now we'd like to calculate the global average time from registration to first order. This is a good indicator of how long a typical customer takes to make the first purchase. Take a look:
SELECT AVG(first_order_date - registration_date) AS avg_days_to_first_order FROM customers;
All we had to do was use AVG() with an interval inside.
Exercise
Find the average time from registration to first order for each channel. Show two columns: channel_name and avg_days_to_first_order.
Stuck? Here's a hint!
Join the customers and channels tables to get channel names. Group by channel IDs and channel names.
