The first thing most freelancers do when they want to manage clients in Notion: they go looking for a CRM template.
It's an understandable instinct. A CRM sounds serious. It looks like what real companies use.
The problem: a CRM is built for sales teams managing hundreds of leads. You're managing ten active clients, maybe twenty. You don't need a twelve-stage sales pipeline.
You need to know, in thirty seconds, where each client relationship stands. That's it.
What a client database actually needs to do
Before you create a single property, ask yourself one question: what does this database need to do for you day to day?
For a freelancer, a client database needs to answer three simple needs:
- Know who your active clients are right now
- Pull up contact details and context quickly
- Link through to the projects currently running for that client
Nothing else is essential at the start. If your system already does these three things cleanly, it's working.
The essential properties
Placeholder: client database with its essential properties visible.
An effective client database holds up with six to eight properties, maximum. The essentials:
- Client name: the title of the entry, always
- Status: Prospect, Active, On hold, Finished
- Client type: Company, Sole trader, Non-profit
- Main contact: name and email
- Start date: how long the relationship has existed
- Linked projects: a relation to your Projects database
Properties to avoid at the start: a priority score, a closing probability, an acquisition source, a projected budget. These can have value, but if you don't keep them updated, they create the illusion of tracking without actually tracking anything.
Start with less. Add a property only once you notice you're repeatedly looking for that piece of information.
Your client database isn't really pulling its weight?
A precise issue solved in 1 hour, or a full diagnosis if it's your whole workspace that's stopped working.
Article 3 of 8 · See all articles in this guide →