The spreadsheet always starts well. Someone makes columns for name, spend, last contact and notes, and for a while it's great. Then a chatter skips an update on a busy night, the spend column drifts away from Fanvue, and people stop trusting it. Once nobody trusts it, nobody fills it in.
The fault is in the job you gave it. A spreadsheet needs a person to copy facts out of your chats, and money, purchases and last messages change all day. Anything copied by hand is wrong by the next sale.
So split the work. What the system already knows stays in the system. People only add what a system can't work out.
The table you don't type
The Fans page in EmpireChat has every fan in one table. Search it, sort it, filter by status, money spent, how long he's been quiet, tag, or AI on or off. Nobody has to enter a spend figure. That takes care of most of what your spreadsheet was for. Three things are left for people.
Tags: what you'd filter on
A tag is a short label you'd use to pull a group of guys. If you'd never say "show me everyone who...", it shouldn't be a tag. Good ones tend to fall into three groups:
- Who looks after him. "owner-handled", "sam".
- What he cares about. "football", "gym", "wants customs".
- What you're trying. "xmas-message", so you can find those guys again later.
Write the tag list down and keep it short. "football", "Football" and "footy" are three tags for one idea, and a filter on one of them misses the other two. Give the list one owner. If a tag hasn't been used in a month, drop it.
Notes: what the next person needs to read
A note holds what only a human knows: promises, context, warnings. Notes are for your team and aren't sent to fans. What he told her in chat is already in his profile, so don't copy his job or his dog in there.
A real one from our chats: we've seen a fan told he wouldn't have to pay, then get a paid offer later. One line in his notes tells whoever's on next what was promised, and nobody has to scroll back through months of chat to find it.
Notes worth writing look like this. All made up, but the same shape as the real thing:
- "Promised him the beach set free. Not sent yet."
- "Unhappy with last PPV, we said sorry Tuesday. Go easy for a bit."
- "Owner handles customs for this guy."
"Good guy" and "buys a lot" tell nobody anything. The table already shows what he spends. And write every note as if a new hire will read it, because one will. These are people who pay you, so keep it respectful and keep it to what helps the next chat.
Saved lists: questions you ask every week
If you keep asking the same question, save it. Any filter can become a list that keeps itself up to date. A guy joins when he matches and drops off when he doesn't, and nobody has to move him. Three to begin with: whales, guys who've spent $50+ and been quiet for 14 days, and guys who've never bought.
A list is also something you can act on. You can message a saved list through Fanvue's mass messages, which no spreadsheet tab ever did for anyone.
Reminders cover the last gap. "Ask about his trip on Friday" goes on that one fan, and due ones show at the top of the Fans page. In a spreadsheet that's a cell nobody looks at on Friday.
Keep the CSV, lose the habit
You don't have to give up Excel. CSV export is there for your own sums or for your accountant. Just treat the file as a snapshot. Export it, use it, bin it. The day someone starts editing the export and calling it the real list, you're back where you started.
Why this survives staff changes
Chatter turnover is commonly reported at 2-3 months. A sheet on someone's laptop, or a system that lives in his head, leaves with him. Tags, notes and reminders sit on the fan. With team logins, each person gets access to the pages he needs, and the record stays put when he goes.
How to start
- Start with your top 20 fans. Give each one a note with the one thing the next person must know.
- Agree a short tag list before anyone starts tagging.
- Save three lists and look at them on the same day each week.
- Add one shift rule: if you promised a guy something, it goes in his notes before you log off.
- Move over what only your old sheet knows, like promises and context. Leave the numbers behind.