How would you write a SQL query to compare conversion rates across customer cohorts over time at Mitel Networks?
Use the customer acquisition date to define cohorts and conversion events to measure cumulative conversion through August 2024. Account for customers with no conversion events and repeated conversion events.
cohort_month, months_since_cohort, cohort_size, converted_customers, conversion_rate, and rate_change_pp.cohort_month, then months_since_cohort.| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| signup_date | DATE | Date the customer entered the Mitel customer base |
| acquisition_channel | VARCHAR(50) | Marketing channel attributed to acquisition |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique conversion event identifier |
| customer_id | INT | Customer associated with the event |
| event_date | DATE | Date the marketing event occurred |
| event_type | VARCHAR(40) | Event classification, including converted |
| source | VARCHAR(50) | Campaign or marketing source |