Promo calendar
One row per promotion: dates, channel, category, mechanic, discount depth, baseline sales, expected uplift and the supplier funding share.
What the template is for
Planning promotions by week and estimating incremental units before launch.
- What one row is
- one row = a promotion
Columns
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Promotion code | promo | Text | yes | unique in the file |
| Name | name | Text | yes | not empty |
| Start | start | Date | yes | date YYYY-MM-DD |
| End | end | Date | yes | date YYYY-MM-DD, not before the start |
| Channel | channel | List value | yes | own-retail, wholesale, marketplace or ecom |
| Category | category | List value | yes | a value from the category reference |
| Mechanic | mechanic | List value | yes | discount, bundle, gift or coupon |
| Discount depth, % | depth | Number | yes | from 0 to 100 |
| Baseline sales, units per day | base | Number | yes | a number not below 0 |
| Expected uplift, % | uplift | Number | yes | a number not below 0 |
| Funded by the supplier, % of the discount | cofund | Number | yes | from 0 to 100 |
| Incremental units | incr | Integer | yes | calculated: baseline × promotion days × uplift ÷ 100 |
Example rows
| Promotion code | Name | Start | End | Channel | Category | Mechanic | Discount depth, % | Baseline sales, units per day | Expected uplift, % | Funded by the supplier, % of the discount | Incremental units |
|---|---|---|---|---|---|---|---|---|---|---|---|
| PR01 | Winter sale | 2027-02-10 | 2027-02-23 | own-retail | outerwear | discount | 20 | 140 | 45 | 0 | 882 |
| PR02 | Spring bundle | 2027-03-05 | 2027-03-14 | ecom | knitwear | bundle | 15 | 90 | 30 | 25 | 270 |
| PR03 | Platform day | 2027-03-18 | 2027-03-20 | marketplace | shoes | coupon | 10 | 60 | 55 | 50 | 99 |
The example data is illustrative: an exercise, replace it with your own.
Note
Uplift is measured against a no-promotion baseline, not the previous week. The pull-forward effect (a dip after the promotion) needs a separate calculation; it is not in the table. The example data is illustrative: an exercise, not a norm or an industry benchmark.
How to open the file
The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.
Calculations that use these fields
- Promotion calendar and discount budget
- Promotion result: incremental profit
- Co-funding a promotion with a platform or partner: the brand’s share
- Control group: promotion effect (difference-in-differences)
- Elasticity from a past promotion
- Elasticity from a price and sales table: log-log regression with an interval
- A/B test on proportions: sample size, duration and reading the result
- First-order discount: CAC and LTV
Documents that need this data
- Promo calendar and promotion effectiveness
- Commercial terms: payment terms, retro bonuses, MDF and listing fees, SLA penalties, chargebacks
- Unit economics (CM1, CM2, CM3) with buyout
- Bayesian estimates of conversion and buyout: small samples, prior distributions, shrinkage and comparison with the frequentist approach
- Dynamic pricing: elasticity by segment, brand constraints, an optimal clearance path and the Thompson bandit
- Price elasticity of demand: how to estimate it from data without being fooled
- A/B tests for promotions and promos: hypothesis, sample, power, p-value, peeking
- Marketing launch calendar and a media plan with a budget: by channel and month, payback as a calculation
- Advertising on platforms, card SEO, bid auctions and promotions: mechanics and the metrics of ad cost share, ROAS and ROMI
- Multiple regression of sales: demand drivers, advertising and promo contribution, multicollinearity, lags and model checks