Plan
List rebuilt 03:12 · 55,400 people, 18,598 we may write to
Everything this department does is on one screen: the cuts of the list, the weeks the sends are booked into, and the message that is about to go out. The figures beside a segment are not stored anywhere — the rule is run over the list each time the page is drawn.
Segments
People, and how many we may write to.
- Subscribers778631 writable
subscription running
- Regulars3,2151,773 writable
3 orders or more · ordered in the last 60 days
- First order, last 30 days2,678566 writable
exactly one order · ordered in the last 30 days
- Lapsing3,0841,293 writable
2 orders or more · last order between 90 and 180 days ago
- Gone quiet, over six months29,6827,306 writable
no order in 181 days
- Top spenders1,3331,093 writable
spent ₺9,000 or more · ordered in the last 120 days
- Bought the kit, not the coffee9,0322,848 writable
has bought equipment · no single origin beans in 90 days · no blends in 90 days
- Cold brew, last summer6,5041,865 writable
has bought cold brew · no order in 120 days
- Cancelled the subscription166139 writable
cancelled the subscription in the last 120 days
- On the list, never ordered4,8414,769 writable
never ordered · gave permission for e-mail
- Marketplace only34,6001,097 writable
has ordered on a marketplace · never ordered on the web store
- Birthday this month792328 writable
birthday in September · has ordered at least once
The weeks
Two behind, this one, three ahead. Every send that exists is on it.
15
20
5
6
7
8
9
10
11
Wed 2 Sep
Wed 9 Sep
Fri 11 Sep
Today · Mon 14 Sep
Wed 16 Sep
Thu 17 Sep
Fri 18 Sep
Sat 19 Sep
Tue 22 Sep
Thu 24 Sep
Thu 1 Oct
A red dot is a send the gate is currently holding; the hour is when it goes, and the figure beside it is how many people it will actually reach.
Waiting on you
Written, not approved. Nothing in this list can leave the building on its own.
- Kenya AA early accessSMSTop spenders · 284 peoplein 6 hourswaiting 18 h 14 m
- Your grinder has been quietE-mailheld by the gateBought the kit, not the coffee · 2,561 people · The message says ₺390; the record has Ethiopia Yirgacheffe 250 g at ₺420in 2 dayswaiting 1 d 23 h
- Autumn roast · the quiet onesSMSheld by the gateGone quiet, over six months · 1,960 people · 5,880 messages (3 × 1,960 people) against 2,000 a day — split it across 3 days, or shorten it to one part and send 2,000 of them todayin 4 dayswaiting 16 h 49 m
- Still grinding? · second runE-mailGone quiet, over six months · 6,574 peoplein 5 dayswaiting 1 h 54 m
- Kenya AA is backE-mailRegulars · 1,605 peoplein 8 dayswaiting 1 h 19 m
Sample data. The reach ladder, the checks under the message and the SMS arithmetic are real: the same functions run on the server and on every keystroke in the editor.
The message
The preview is the editor. Every check under it runs on what is in the box.
Kenya AA early access
To Top spenders · spent ₺9,000 or more · ordered in the last 120 days
Mon 14 Sep, 16:30
HARBORLANE
to +90 5** *** ** 13
UCS-2 · 143 of 201 units
3 parts × 284 = ₺307
“—”, “₺” are outside the GSM alphabet, so a part holds 70 characters instead of 160.
Who gets it
- In the segment1,333
- −No mobile number−455
- −Never gave permission−481
- −Took permission back−48
- −Number no longer works−9
- May be written to340
- −In the hold-out group−24
- −Already had 2 this week−1
- −In another send today−31
- Will receive it284
968 of the people who fell out could be recovered by the shop — by asking for permission again, by collecting a detail it never asked for, or by not sending something else to them first. The rest could not.
Before it can go
Worth knowingDoes not stop it
- Stays in the SMS alphabet· “—”, “₺” are outside the GSM alphabet, so every part is 70 characters instead of 160
- Message length and what it costs· 143 units · 3 parts × 284 people = ₺307
Clear
- A way to stop hearing from us· The message says how to stop
- Nothing left unfilled· No variables in this one
- No health or diet claims
- Links are tagged and short· No link in this one
- Fits through the provider in a day· 852 of the 2,000 this account may send in a day
- Outside quiet hours· Scheduled for 16:30
Does not apply here
- Products exist in the record· This message does not name a product
- Prices match the record· No product named beside the figure
- Enough stock behind it· Nothing in this message to run out of
- Subject line survives a phone· An SMS has no subject
- Not written in capitals· Judged on the e-mail side
Approving asks for a sentence. It goes on the record beside the send and is what somebody reads a week later.
Sixty bags and a list that would clear them in a morning. An SMS is worth it here and nowhere else — which is exactly the sum the desk wants seen before anybody presses send.