The spreadsheet round trip: building customer segments by hand

Your customer list already knows more about your buyers than you do. It has been filling itself in since your first sale, from every purchase, every membership and every free download, with a lifetime value beside each name. The problem is that it is one long list, and the thing you want to send this week is really for about a fifth of it. You do not need a segmentation engine to fix that. You need a spreadsheet, twenty minutes, and the habit of bringing the tidy version back.

The segment you want never exists yet

Ask yourself who this week's email is for and you will describe something oddly shaped. People who bought the beginner pack but never the advanced one. People who took the free download in March and have not been back. People who paid for a call but never rebooked. None of those are a button. They are a sentence about your own business, and they change every time your offer changes.

This is the genuinely hard part, and it is worth saying plainly: no dashboard can guess a criterion you have not thought of yet. The customer list can hold the facts — who bought what, when, and how much they have spent with you in total — but the decision about which of those facts matters today is yours. Software is good at storing. You are the one who has to choose.

There is a second awkward truth, and it applies whether you send from store.fan's own email tools or from somewhere else. Whatever you build is a snapshot. Someone buys an hour after you export and they are not in your file. That is fine, as long as you treat the spreadsheet as a working copy rather than the official record. The official record keeps updating itself in your dashboard whether you look at it or not.

Guessing from memory versus reading a sorted column

Most creators do segment. They just do it in their heads, badly, while writing the email. They picture three enthusiastic buyers and write to them, then send it to everybody. The round trip replaces that with something duller and much more reliable.

The round trip, step by step

Set a timer for twenty minutes. The point of the exercise is not a perfect taxonomy. It is one labelled column you did not have this morning.

1. 1Open the customers area of your dashboard and export the full list to CSV. Do this on whatever plan you are on — the export is not held back on Free.
2. 2Open the file in whatever spreadsheet you already trust. Do not tidy the columns yet.
3. 3Sort by lifetime value, highest first, and read the top thirty names slowly. This is the only part where you will be surprised.
4. 4Add one new column and call it segment. One column, not five.
5. 5Fill it in with plain words you would actually say out loud: advanced, beginner, free-only, lapsed, calls.
6. 6Sort by your new column and check that each group holds together. If a group has two people in it, merge it into a bigger one.
7. 7Save a copy for yourself, then bring the tidied file back in through the CSV import so your dashboard and your working copy agree.
8. 8Write down, in one line per segment, the next email that segment should get. If you cannot write that line, delete the segment.

What this looks like on a list of four hundred

Picture a list of 412 people, which is a perfectly ordinary size after a year of selling. Roughly 290 of them arrived through a free lead magnet and have never paid you anything. About 90 bought one thing. Around 30 bought twice, and a dozen have a lifetime value several times the average because they kept coming back for calls. Those are plausible proportions for a small store, not a promise about yours.

Sorted that way, the email writes itself differently for each group. The 290 need the thing they downloaded to be useful again before they are asked for anything. The 90 need to know what comes next, which is usually the product they did not buy. The 30 rarely need persuading, only informing. And the dozen at the top are the people you should probably email individually, by hand, because there are only twelve of them. That last group is invisible until you sort by lifetime value, which is precisely why the sort is worth twenty minutes.

The mistake most people make

They build eleven segments in one enthusiastic afternoon and send to none of them. Segmentation feels like progress because it is tidy, and tidying is easier than writing. The rule that fixes it is blunt: a segment does not exist until it has received an email. Build two, send to both this week, and add a third only when the first two have a rhythm. If you are on a paid plan and can send from inside store.fan, that rhythm gets much easier to keep, because the list and the send button live in the same place.

None of this is clever. It is a file, a sort and a word typed into a column. But it is the difference between writing to an imaginary average reader and writing to thirty people you can describe. Do it once and you will notice how much of your list you have been ignoring, and how few of your best buyers you have ever spoken to directly.