Revenue above the hold-out
₺92,807
The period's orders per person written to, less the hold-out group's own, priced at the period's basket. 775 people were held back and placed 6 orders between them, which is enough to set a rate against. Nothing went out in the comparison window, so there is no movement to show.
Orders above the hold-out
132
189 orders came from everybody who received something this period; this is the part the hold-out group did not also produce.
People written to
7,132
7,563 messages in total. The most anybody received in a week was 2, against a cap of 2.
Permission, net
+731
759 given, 28 withdrawn.
The week, in short
Computed- 4 sends reached 7,132 people and the period came out ₺92,807 ahead of the hold-out group: 0.026 orders per person written to against 0.008 among the 775 people who were sent nothing. 775 people were held back and placed 6 orders between them, which is enough to set a rate against.
- Guatemala is back is allocated most of it — ₺45,768 of the figure above, from 1,605 people. Allocated, not measured: the measurement is the line above, and this is its share by orders.
- What comes off the roaster is the one to argue about: 39 orders from 4,301 people, the thinnest return on the sheet. Without a group that was sent nothing, that sentence could not be written at all — it would read as a number of orders and a decision to do it again.
- Permission moved +731: 759 gave it, 28 took it back, 61 per cent of them after What comes off the roaster.
- 17,051 people changed state, 3,926 of them into lapsing. That number is the department's actual workload and it does not appear on any send.
What went out
Order store| Date | Send | Reached | Orders | Allocated | Left the list |
|---|---|---|---|---|---|
| 28 Aug | BREW10 reminderSMSRegulars | 509 | 21 | ₺10,51115 orders | 2 |
| 25 Aug | BREW10E-mailLapsing | 1,148 | 36 | ₺17,49725 orders | 7 |
| 21 Aug | What comes off the roasterE-mailOn the list, never ordered | 4,301 | 39 | ₺19,03127 orders | 17 |
| 17 Aug | Guatemala is backE-mailRegulars | 1,605 | 93 | ₺45,76865 orders | 2 |
| 1 Aug – 31 Aug | 7,563 | 189 | ₺92,807132 orders | 28 |
The last column is allocated, not measured. The measurement is one comparison over the whole period — 0.026 orders per person written to against 0.008 among the 775 people in the hold-out group — and the total is that figure, split between the sends by their own orders. Orders count only where the order arrived within seven days of a message.
How the list moved since 1 Aug
Customer list| Where they were | Subscribers | First order | Regulars | Ordered recently | Lapsing | Gone quiet | Never ordered | Moved |
|---|---|---|---|---|---|---|---|---|
| New to the list | — | 2,678 | — | 790 | — | — | 139 | 3,607 |
| Subscribers | — | — | 21 | 8 | 22 | 21 | — | 72 |
| First order | — | — | 2 | 1,958 | — | — | — | 1,960 |
| Regulars | — | — | — | 605 | 253 | — | — | 858 |
| Ordered recently | — | — | 372 | — | 3,651 | — | — | 4,023 |
| Lapsing | — | — | 834 | 324 | — | 3,325 | — | 4,483 |
| Gone quiet | — | — | 997 | 1,014 | — | — | — | 2,011 |
| Never ordered | — | — | — | 37 | — | — | — | 37 |
| Moved | 0 | 2,678 | 2,226 | 4,736 | 3,926 | 3,346 | 139 | 17,051 |
17,051 people changed state in the period. That is the work nobody schedules: it happens whether or not anything goes out, and it is the reason a segment in this module is a rule rather than a number somebody saved.
Cut by state rather than by the twelve segments: a person can be in four segments at once, and a matrix of overlapping sets adds up to more people than the shop has. People who stayed where they were are left out — they are most of the list, and printing them would make every move on this table invisible. Where an order fell inside the period, the earlier one is spread evenly between the first order and the last; it is the only estimate on this sheet.
Permission
Consent record- Gave it
- 759
- Took it back
- 28
- Net
- +731
Given is dated on the consent record. Withdrawn is counted off the sends themselves — an unsubscribe click or a replied STOP — so it can be traced back to the message that caused it.
What this sheet is counting
Order storeSample data. Every figure on this sheet is counted from the shop's own order book and its own consent record; nothing here is a provider's estimate. Revenue is credited only when the order arrived within seven days of a message, and only above what the hold-out group produced over the same period; what a single row carries is its share of that one measurement.