ExcelFlux
← Restaurant and café

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.

MeasureSample 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?

  1. 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.
  2. Choose a comparable day or branch. Enter basket value before merchant coupon. Check that costs cover all promoted orders.
  3. 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.
  4. 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