Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Customer Behavior Analysis in SQL

Introduction
Conversion rates
Time to first order
10. Global average time to first order
Conversion charts
Summary

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.