Write a SQL query to compare merchant conversion before and after a new capital offer flow launch, using cohort-level metrics at Parafin. Assume the launch date is 2024-07-01. Treat a merchant as converted within a period if any qualifying offer event has status converted.
cohort_month, pre-launch and post-launch offered merchant counts, converted merchant counts, conversion rates, and conversion-rate changecohort_month ascending| Column | Type | Description |
|---|---|---|
| merchant_idPK | INT | Unique merchant identifier |
| signup_date | DATE | Date the merchant joined Parafin |
| segment | VARCHAR(50) | Merchant business segment |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique capital offer event identifier |
| merchant_id | INT | Merchant associated with the offer event |
| event_date | DATE | Date of the offer event |
| flow_version | VARCHAR(20) | Capital offer flow version used |
| status | VARCHAR(20) | Outcome of the offer event |