Guides
Field notes from real revenue data work
How to clean up your CRM, keep your pipeline honest, and build revenue data your team actually trusts. Written from client engagements, not theory.
CRM Cleanup
Can AI Clean Up Your CRM? Yes — If You Never Let It Write Unsupervised
AI is genuinely good at the reading half of CRM cleanup and genuinely dangerous at the writing half. The plan/approve architecture that makes AI cleanup safe, and the six demands to make of any vendor before granting write access.
Read the guide →How to Evaluate an AI Agent Before Giving It CRM Write Access
Demos prove nothing. The evaluation method that does: grade final database state against planted ground truth, count safety violations separately from completion, run every task k times and report pass^k, and test on the API hazards that break real agents.
Read the guide →The CRM Audit Checklist: 27 Checks We Run Before Touching Any Client CRM
A field-tested CRM audit checklist covering duplicates, ownership, pipeline integrity, field completeness, process conformance, and integration drift — with the thresholds we actually use.
Read the guide →CRM Cleanup Tools: An Honest Map of the Category (2026)
The CRM data hygiene tool landscape sorted by what each tool actually does — capture-side vs correction-side, GUI vs CLI, automatic vs approval-gated — and how to pick for your stack.
Read the guide →CRM Data Hygiene: 12 Best Practices That Keep Your Data Clean
Twelve CRM data hygiene practices we run weekly on client systems: validation at entry, scheduled rule-based audits, reviewed corrections, and a single named owner.
Read the guide →CRM Data Quality Metrics: What to Measure and What to Ignore
The five CRM data quality metrics worth tracking — completeness, uniqueness, freshness, validity, and consistency — with formulas, starting thresholds, and why a single blended health score is a trap.
Read the guide →How to Find and Merge Duplicate CRM Records (Without Losing Data)
How we deduplicate client CRMs: identity keys that actually work, exact-match-first detection, constrained fuzzy matching, survivorship rules for safe merges, and the create-gate that prevents duplicates from coming back.
Read the guide →How to Clean Up Your CRM: A Step-by-Step Process That Actually Sticks
The five-step CRM cleanup process we run on client CRMs: snapshot, rule-based audit, reviewed fixes, root-cause repair, and continuous drift detection.
Read the guide →Sales Pipeline Hygiene: How to Keep Your Pipeline Honest Without Nagging Reps
A weekly pipeline hygiene system: the four checks that catch dishonest pipeline, why nagging reps fails, and how to use call evidence to keep next steps current automatically.
Read the guide →Salesforce Data Cleanup: A Practical Playbook for RevOps
A field-tested Salesforce data cleanup playbook: snapshot exports, audit reports for stale and ownerless records, duplicate and matching rules, validation-rule prevention, and safe mass updates with Data Loader.
Read the guide →How to Clean Up HubSpot: Contacts, Companies, and Deals
A HubSpot-specific cleanup walkthrough: snapshot exports, filtered audit views, the native duplicate tool's real limits, marketing-contact billing, record-source provenance, and archive vs. delete.
Read the guide →Why Sales Reps Don't Update the CRM (and What Actually Fixes It)
Reps not updating the CRM is an economics problem, not an attitude problem. The four real causes of low CRM adoption, why nagging and required fields fail, and the fixes that stick.
Read the guide →Industries
CRM Cleanup for Fintech: 7 Data Problems Generic Hygiene Misses
Fintech CRMs break in ways generic cleanup ignores — ledger-to-CRM revenue drift, ungoverned KYC data, enrichment-driven duplicates, and multi-entity ARR modeled as flat deals. Here are the seven problems and how to fix each one with rules and evidence.
Read the guide →CRM Cleanup for Healthcare & Health Tech: 7 Data Problems to Fix
Healthcare and health-tech CRMs break on long sales cycles, collapsed hospital-system hierarchies, unmodeled referral networks, and PHI leaking into free-text fields. Here are the seven data problems specific to the vertical and how to fix each with rules, evidence, and approval-gated changes.
Read the guide →CRM Cleanup for Insurance: 7 Data Problems in Carriers, Brokers & Agencies
Insurance CRMs break on policies modeled as one-shot deals, flat broker and producer hierarchies, stale licensing data, book-of-business duplication, and renewals that fall out of the pipeline. Here are the seven data problems specific to insurance and how to fix each with rules and evidence.
Read the guide →Marketing Spend & ROI
How to Calculate CAC by Channel (and the Mistakes That Make It Fiction)
Channel CAC is fully-loaded spend per channel divided by new customers sourced from that channel — a trivial formula with two fragile inputs. How to build both sides honestly with the two-table method.
Read the guide →How to Track Marketing Spend Across Channels (Without a Warehouse)
The exports-plus-ledger method we use to track marketing spend by channel: monthly CSV exports normalized to one format, a recurring-cost ledger for tools and events, and stable row identity so restated platform numbers stay visible.
Read the guide →UTM Tracking Best Practices: A Naming Convention That Survives Contact With Your Team
UTM tracking best practices we enforce on client systems: lowercase values, a closed source/medium vocabulary, a written campaign pattern, links generated from one shared builder, and a monthly drift audit.
Read the guide →Ready to build your GTM data foundation?
Book a 30-minute call. We'll map your current stack, identify the gaps, and outline what Stage 3+ looks like for your team.