Compare actuals during promo windows
Compute realized lift% per promo: (actual_during - baseline) / baseline. Show promo_id and realized_lift_pct.
| Column | Type | Key |
|---|---|---|
| actual_id | INT | PK |
| sku_id | INT | FK → dim_skus |
| location_id | INT | FK → dim_locations |
| period_date | TEXT | |
| units_sold | INT | |
| revenue | REAL |
| Column | Type | Key |
|---|---|---|
| promo_id | INT | PK |
| sku_id | INT | FK → dim_skus |
| location_id | INT | FK → dim_locations |
| promo_name | TEXT | |
| promo_type | TEXT | |
| start_date | TEXT | |
| end_date | TEXT | |
| lift_pct_actual | REAL |
Each hint you reveal reduces the XP you can earn. Try the query first.
JOIN promotions to actuals on sku_id and date range.
Compute baseline as non-promo period average.
Realized lift vs baseline.