Open any neglected freelance CRM and you’ll find the same thing: 12 “active” deals, 7 of which haven’t had any activity in 45 days. A pipeline total of $85,000 that’s actually $15,000 in real closeable revenue. Next steps marked “follow up soon” with no date, from three months ago. Three duplicate entries for the same contact with different email addresses.
This is what a dirty CRM looks like, and it’s worse than having no CRM at all. A dirty CRM provides false confidence. You look at $85,000 in pipeline and feel secure, so you don’t do outreach. Six weeks later, half those deals have gone cold and you’re scrambling for new work. The pipeline number was lying to you, and you let it.
The 15-minute Friday hygiene routine prevents this. Not dramatically, not all at once, just one week at a time, keeping the CRM an accurate picture instead of an aspirational one.
What a dirty CRM costs you
Before the hygiene routine, it’s worth understanding what the problem actually costs.
Bad capacity planning: You think you have $60,000 in near-term pipeline. You turn down a new client because you’re “almost full.” In reality, 70% of that pipeline is stale. You end up with two slow months because you assumed work was coming that wasn’t.
Missed follow-ups: A deal is sitting in “Proposal Sent” from 6 weeks ago. You forgot to follow up. The prospect went with someone else. The CRM shows it as “Active.” You’ll discover the miss in the monthly pipeline review, too late to do anything about it.
False revenue forecasting: Your end-of-month revenue projection is based on CRM pipeline. If that pipeline is inflated by ghost deals, your forecast is wrong. You make financial decisions (tool purchases, contractor spend, personal draws) based on revenue that won’t materialize.
Decision fatigue and trust erosion: When you know your CRM is inaccurate, you stop trusting it for decisions. You default to gut feel. Gut feel in business decisions is less accurate than imperfect data, and far less accurate than clean data.
The cost of CRM hygiene: 15 minutes per week. The cost of CRM neglect: measurable in missed revenue and bad decisions.
The 15-minute Friday routine, step by step
Do this every Friday before you close the admin block.
Step 1: Review open deals, close-lost anything inactive (5 minutes)
Open your CRM to the pipeline view. Look at every deal in any active stage (Active, Proposal Sent, Negotiating, etc.). For each deal:
- When was the last activity? (Email sent, call held, message received)
- If 30+ days of no activity after you’ve sent follow-ups: move to “Lost” or “Stalled”
The 30-day rule is a bright line, not a judgment call. 30 days of no response after multiple follow-ups means the prospect has effectively made a decision. You can always reopen the deal if they re-engage. But your pipeline should not carry deals that have gone cold.
The exception: deals where you’re waiting on a defined response date (“they said they’d decide by July 1”) can stay in Active until that date passes.
Step 2: Update next steps on every active deal (5 minutes)
Every deal in an active stage should have a specific next step with a specific date.
Not: “Follow up” Yes: “Send Day 7 follow-up email, May 8”
Not: “Talk to client about scope” Yes: “Discovery call Thursday May 7 at 2pm”
Go through every active deal. If a next step is overdue (the date has passed and you haven’t done it): do it now or reschedule to a specific future date. If a deal has no next step: add one. A deal with no next step is a deal you’ve unconsciously decided to ignore.
Step 3: Remove duplicates (3 minutes)
Look for the same contact entered twice, usually happens when a prospect emails from a different address or you add them from a different source. Merge the duplicate entries, keeping the one with more information.
Also check for dead contact info: email addresses that bounced, phone numbers that are no longer valid. Mark these or update with correct info.
Step 4: Add missing information (2 minutes)
For any active deals missing basic contact info, email, company, LinkedIn URL, spend 2 minutes filling in what you can. A contact with only a first name and no email address is a deal you can’t actually follow up on.
This step also catches deals where you know the contact has changed roles or companies. Update the record with current information.
Within 3 months of consistent Friday hygiene, the average solo CRM goes from 40% fictional pipeline to 90%+ accurate pipeline. The revenue surprises, both the “I thought I had more work coming” kind and the “why is my pipeline so thin?” kind, essentially stop happening.
The compounding cost of skipping it
Here’s what happens to a CRM that isn’t maintained weekly:
Week 1 of neglect: A few deals should be moved to Lost but aren’t. Pipeline is 10% inflated.
Month 1: 8-10 ghost deals have accumulated. Pipeline is 25-30% inflated. Two or three follow-ups that should have been sent weren’t.
Month 3: The pipeline looks like $70,000 but real closeable pipeline is $40,000. Multiple missed follow-ups have cost deals. You’re spending 20 minutes opening the CRM and closing it without updating anything because the task feels overwhelming.
Month 6: The CRM is essentially unused. You run the business from memory and a sticky note. You’re back to the pipeline uncertainty you were trying to solve when you set up the CRM.
15 minutes per week prevents this entire arc.
The signal: what clean pipeline data tells you
A well-maintained CRM gives you three signals that change how you make business decisions:
Pipeline velocity: How fast do deals move from first contact to close? If you track this consistently, you’ll know that your average deal takes 18 days from proposal to signed contract, so when you’re 20 days out from needing new revenue, you know to have the right deals in the proposal stage now.
Loss patterns: Why are you losing deals? If you mark lost deals with a loss reason (price, competitor, timing, went cold, no decision), after 20-30 lost deals you’ll see the pattern. Most solos discover they’re losing on a consistent theme, usually price or slow follow-up, that’s fixable once it’s visible.
Seasonal patterns: After 12 months of clean CRM data, you’ll see which months produce the most new leads, which have the highest close rates, and which are consistently slow. This lets you plan sales activity proactively, ramp outreach in slow months before the slowness hits revenue.
CRM hygiene for different tools
Notion CRM: Create a “Pipeline” database with properties: Contact Name, Company, Stage, Last Activity Date, Next Step, Next Step Date, Deal Value, Source, Notes. Filter by Stage to see active deals. Sort by Last Activity Date to find the stale ones. 15 minutes in this view covers everything.
HubSpot Free: Use the Deals board view. Filter to “Active” stages. Click each deal and update “Next step” and “Close date.” Use the activity log to check when you last had contact. HubSpot’s “Close Date” field will flag overdue deals automatically, use it.
Pipedrive: The “Rotting deals” feature automatically flags deals that haven’t been updated based on your configured threshold. Set it to 14 days. Every Friday, open the Rotting Deals filter and process everything there first.
When the CRM is beyond weekly maintenance
If you’re reading this and your CRM is already a disaster, 80 deals, most of them stale, no clear pipeline picture, don’t try to fix it in 15 minutes. Schedule a 2-hour cleanup session once:
- Export all deals to a spreadsheet
- Go through each one and decide: Active (real chance of closing in 90 days), Lost (gone cold or definitively no), Future (possible but not now)
- Delete or archive everything marked Lost and Future
- For everything marked Active: add a real next step with a real date
- Import the clean data back into the CRM
After the cleanup session, the 15-minute Friday routine maintains it. Don’t try to maintain a system that needs a full cleanup first, fix it once, then maintain it weekly.
Ready to send stronger proposals?
Build, send, and track proposals in one place so follow-up is easier.
Start your free trial →
