Syntha Lab RU

Promo calendar

One row per promotion: dates, channel, category, mechanic, discount depth, baseline sales, expected uplift and the supplier funding share.

Layouts for documents 12 columns 3 example rows

Download CSV ↓

What the template is for

Planning promotions by week and estimating incremental units before launch.

What one row is
one row = a promotion

Columns

ColumnCodeTypeRequiredValidation rule
Promotion codepromoTextyesunique in the file
NamenameTextyesnot empty
StartstartDateyesdate YYYY-MM-DD
EndendDateyesdate YYYY-MM-DD, not before the start
ChannelchannelList valueyesown-retail, wholesale, marketplace or ecom
CategorycategoryList valueyesa value from the category reference
MechanicmechanicList valueyesdiscount, bundle, gift or coupon
Discount depth, %depthNumberyesfrom 0 to 100
Baseline sales, units per daybaseNumberyesa number not below 0
Expected uplift, %upliftNumberyesa number not below 0
Funded by the supplier, % of the discountcofundNumberyesfrom 0 to 100
Incremental unitsincrIntegeryescalculated: baseline × promotion days × uplift ÷ 100

Example rows

Promotion codeNameStartEndChannelCategoryMechanicDiscount depth, %Baseline sales, units per dayExpected uplift, %Funded by the supplier, % of the discountIncremental units
PR01Winter sale2027-02-102027-02-23own-retailouterweardiscount20140450882
PR02Spring bundle2027-03-052027-03-14ecomknitwearbundle15903025270
PR03Platform day2027-03-182027-03-20marketplaceshoescoupon1060555099

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

Documents that need this data

Download CSV ↓ Open interactively →