Keeping Track of Customers Without a Spreadsheet or a Rolodex

Maybe you keep your customers in your phone contacts. Maybe in a spreadsheet, or a notebook, or an old card file. It worked for a long time. Then you hit the point where you cannot remember who you were supposed to call back, or you lost a good customer because you forgot to follow up, and now you are wondering if there is a better way.

There is, and it is not complicated. You do not have to become a tech person. You just have to understand one distinction, and then keep two simple lists.

A contact list is not a pipeline

This is the whole idea, so let me be plain about it.

A contact list is your address book. It is everyone you know: past customers, people who once asked about your work, the guy you met at the counter. It does not change much. You look someone up in it when you need their number. That is what a spreadsheet or your phone contacts is good at.

A pipeline is different. It is the short list of deals you are working right now, and it changes every day. Each one has a stage (just talking, quoted, about to close) and a next step you owe them. This is the list that actually makes you money, and it is the one a plain contact list is bad at, because a contact list has no idea who is hot, who is waiting on a quote, or who you promised to call Friday.

Trying to run your active deals out of a giant contact list is the mistake. The customer you need to call today is buried among four hundred names you will never call again.

Keep cold contacts separate from active deals

So keep them apart. Everyone you know lives in the contact list. Only the people you are actively selling to right now become deals on your pipeline. When a deal closes or dies, it moves off the active list, but the person stays in your contacts forever.

The payoff is a short, honest list of live deals you can actually work. When you open it, every name on it is someone who needs something from you, not a name from three years ago. That is the difference between a list that stresses you out and one that runs your week.

Chumley is built around this split on purpose. Your contacts are one thing, kept separate. Your live deals are cards on a visual board, one column per stage. A cold contact does not clutter up the deals you are chasing, and a name never gets lost just because the deal ended.

Import what you already have

Here is the part people worry about most, and it is the easiest. You do not retype anything. Whatever you have now, a spreadsheet, an export from your phone, an old contact program, you save it as a CSV file (every spreadsheet has “export as CSV” or “save as CSV”) and import it.

Chumley’s import walks you through matching your columns to the right fields: this column is the name, this one is the phone, this one is the email. A few clicks and everyone you know is in, with nothing typed twice. Then you pick the handful you are actively working and put them on the board as deals.

What this looks like day to day

Every morning you open the board and see your live deals and what is due. You tap a deal to call or text, and it logs itself. When you meet someone new, they go in as a contact, and if you start selling to them, they become a deal. Nothing gets lost, and you always know who needs a call this week.

It runs in any phone browser, nothing to install, and it is $14 per user a month with a 14-day free trial and no card. But the tool is secondary. The habit is the two lists: everyone you know in one place, the deals you are working in another.