Digital campaign incremental contribution
Evaluate a campaign using incremental orders, coupons, and contribution.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Ek sipariş
- 163.56
- Kuponsuz katkı (TL)
- 24,615.56
- Kampanya net katkı (TL)
- -7,140.06
Who can use it, and for what?
Marketing and restaurant managers
Evaluate a campaign using incremental orders, coupons, and contribution.
A worked example from the workbook
The first sample row in the baseline has the following results. Ek sipariş 162, Kuponsuz katkı (TL) 26.244, Kampanya net katkı (TL) -5.276, Reklam katkı getirisi -%27,48. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Ek sipariş | 163.56 |
| Kuponsuz katkı (TL) | 24,615.56 |
| Kampanya net katkı (TL) | -7,140.06 |
| Reklam katkı getirisi | -32.65% |
How do you start with your own data?
- Start with Kılavuz (Guide). Replace the 16 fictional entries in the yellow cells on Veri (Data). Use an Excel date, a unique record ID and a branch or category. There are 64 ready-to-use input rows.
- Choose a comparable day or branch. Enter basket value before merchant coupon. Check that costs cover all promoted orders.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Baz sipariş çarpanı”. The sample settings are 1 / 0,9 / 1,12. Changing the scenario preserves source records.
- Panel shows the three cases and the group breakdown for the selected case. On Hesap (Calculations), check input flags and row-level decisions. To rename a group, use the same name on Settings and Data.
Workbook input fields
Labels appear in Turkish in the workbook.
- Kampanyalı sipariş
- Karşılaştırma siparişi
- Ortalama net sepet (TL)
- Ürün gideri (TL/sipariş)
- Kupon (TL/sipariş)
- Reklam (TL)
- Kargo desteği (TL/sipariş)
Sample assumptions
- Baz sipariş çarpanı
- 1