Revenue above the hold-out
₺103,212
The period's orders per person written to, less the hold-out group's own, priced at the period's basket. 847 people were held back and placed 11 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
148
243 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,565
9,210 messages in total. The most anybody received in a week was 2, against a cap of 2.
Permission, net
+775
812 given, 37 withdrawn.
The week, in short
Computed- 7 sends reached 7,565 people and the period came out ₺103,212 ahead of the hold-out group: 0.032 orders per person written to against 0.012 among the 847 people who were sent nothing. 847 people were held back and placed 11 orders between them, which is enough to set a rate against.
- Guatemala is back is allocated most of it — ₺39,588 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 +775: 812 gave it, 37 took it back, 46 per cent of them after What comes off the roaster.
- 12,494 people changed state, 2,577 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 |
|---|---|---|---|---|---|
| 11 Sep | Still grinding?E-mailLapsing | 1,148 | 25 | ₺10,74115 orders | 7 |
| 9 Sep | Brewing guideE-mailFirst order, last 30 days | 374 | 27 | ₺11,29316 orders | 1 |
| 2 Sep | Was it too much, or the wrong coffee?E-mailCancelled the subscription | 125 | 2 | ₺9041 orders | 1 |
| 28 Aug | BREW10 reminderSMSRegulars | 509 | 21 | ₺9,09113 orders | 2 |
| 25 Aug | BREW10E-mailLapsing | 1,148 | 36 | ₺15,13422 orders | 7 |
| 21 Aug | What comes off the roasterE-mailOn the list, never ordered | 4,301 | 39 | ₺16,46224 orders | 17 |
| 17 Aug | Guatemala is backE-mailRegulars | 1,605 | 93 | ₺39,58857 orders | 2 |
| 17 Aug – 13 Sep | 9,210 | 243 | ₺103,212148 orders | 37 |
The last column is allocated, not measured. The measurement is one comparison over the whole period — 0.032 orders per person written to against 0.012 among the 847 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 17 Aug
Customer list| Where they were | Subscribers | First order | Regulars | Ordered recently | Lapsing | Gone quiet | Never ordered | Moved |
|---|---|---|---|---|---|---|---|---|
| New to the list | — | 2,441 | — | — | — | — | 83 | 2,524 |
| Subscribers | — | — | 15 | 4 | 14 | 12 | — | 45 |
| First order | — | — | — | 1,779 | — | — | — | 1,779 |
| Regulars | — | — | — | 579 | — | — | — | 579 |
| Ordered recently | — | — | 241 | — | 2,563 | — | — | 2,804 |
| Lapsing | — | — | 739 | 222 | — | 2,160 | — | 3,121 |
| Gone quiet | — | — | 815 | 774 | — | — | — | 1,589 |
| Never ordered | — | 53 | — | — | — | — | — | 53 |
| Moved | 0 | 2,494 | 1,810 | 3,358 | 2,577 | 2,172 | 83 | 12,494 |
12,494 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
- 812
- Took it back
- 37
- Net
- +775
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.