Hard
CTE
Pro Challenge

Marketplace Buyer Repeat Rate

For each buyer's first completed marketplace order month, classify whether the buyer placed another completed order within 60 days after that first order. Cancelled and refunded orders do not qualify. Report cohort_month, first_time_buyers, repeat_buyers and repeat_rate. Return columns: cohort_month, first_time_buyers, repeat_buyers, repeat_rate.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

For each buyer's first completed marketplace order month, classify whether the buyer placed another completed order within 60 days after that first order. Cancelled and refunded orders do not qualify. Report cohort_month, first_time_buyers, repeat_buyers and repeat_rate. Return columns: cohort_month, first_time_buyers, repeat_buyers, repeat_rate.

Difficulty
Advanced
SQL concept
CTE