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
Highlighted for the segment chosen on the left. 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.
October subscription note
Subscribers · in 17 days
Nothing written yet
The slot is in the calendar; the coffee for October is not decided until the buying trip settles.