I'm planning Q4 and have room for one cleanup project before the new year. Picking just one forced me to decide what actually has to come first, so here's where I landed.

Most teams start with duplicates because the count is easy to watch go down. But deciding which record wins a merge depends on your owner and stage rules. If you dedup first, you end up with tidier bad data.

The order I'd use, based on how much each one breaks downstream:

1. Stage definitions. If "qualified" means something different to marketing, sales and your CEO, then the forecast, the routing and every report are reading the same broken field. Next year's targets get set off that forecast, and you're the one defending the number in January.
2. Ownership. Records owned by reps who left, or by nobody. This is common after a merger. Those leads sit there and nobody gets alerted.
3. One source of truth per field. If two systems both write to lifecycle stage, they'll keep overwriting each other no matter how often you clean.
4. Duplicates. By now you have rules for which record wins.

A quick way to find your starting point: if your VP of Sales keeps a spreadsheet next to the CRM, look for the column that doesn't exist in the CRM. That's usually #1 or #3.

The team I take on will probably be one that merged or migrated in the last year or two, since all four break at once there. If that's you, comment what happened and what the side spreadsheet tracks, and I'll tell you which one I'd fix first. Same offer for anyone else reading.

I do RevOps and CRM cleanup work for a living. Mostly HubSpot builds, untangling duplicate/messy data, and keeping Clay and HubSpot in sync. I've got a bit of slack this week and I learn more from real broken setups than anything else, so figured I'd trade.

→ Drop a comment with whatever's annoying you most about your CRM.

→ Tell me what your setup looks like and what's going wrong, and I'll reply with how I'd actually approach it.

specific, not "book a call."

First handful of comments I'll go deep on and happy to take it to DMs if it's got sensitive data...

See you in comments

Hey all, Quick one

I'm Mansoor, focused on CRM & RevOps and I'm looking for work right now. Open to full-time, contract, fractional, or subcontracting for agencies or companies with overflow. Remote, available EST.

What I do: I build and clean up the CRM side of the GTM stack. Pipeline and deal stages that reps actually follow. Clean data so the reporting means something. I'm currently in the CRM & RevOps cohort here, going deep on the strategy side, not just the button-clicking.

My stack: HubSpot, Salesforce, and Attio on the CRM side. Clay, enrichment, and TAM builds for data. Claude Code and n8n for automation and custom builds. Comfortable wiring these together into one system.

Good fit if CRM is a mess, or you're planning to implement one and want it done right the first time.

If you're hiring, know someone who is, or have overflow, DM me or make an intro. Happy to do a free teardown of your CRM/pipeline first so you can see how I think before you commit to anything.

DM and I'll share my portfolio.