Prompt
How do I fix attribution numbers that don't match my CRM?
Latest observation
Attribution mismatches usually come from different tools using different rules, windows, or identities. The fix is to find where the logic diverges, then make the CRM and attribution source line up as closely as possible.
Common reasons numbers don’t match
-
Different attribution models
- CRM may use first-touch, last-touch, or custom rules.
- Your attribution tool may use multi-touch, position-based, or algorithmic weighting.
-
Different lookback windows
- One system may count a touchpoint if it happened within 30 days.
- Another may use 7, 60, or 90 days.
-
Identity matching issues
- The same person may appear as multiple records due to:
- multiple emails
- changed email addresses
- missing user IDs
- cross-device behavior
- The same person may appear as multiple records due to:
-
Different event definitions
- “Lead,” “MQL,” “SQL,” “Opportunity,” or “Closed Won” may not mean the same thing in both systems.
-
Timestamp or timezone differences
- Events may fall into different days/months depending on timezone or how timestamps are recorded.
-
Missing or duplicate source data
- UTMs missing from some traffic
- duplicate CRM records
- manual overrides in CRM
-
Offline and offline-to-online gaps
- Calls, events, partner referrals, or sales-sourced deals may not be fully tracked in the attribution platform.
How to fix it
1) Define one source of truth for each metric
Decide:
- Which system defines pipeline and revenue
- Which system defines marketing touchpoints
- Which system defines lead status
If CRM is the source of truth for revenue, don’t expect the attribution tool to exactly match unless both systems use the same logic.
2) Align attribution rules
Check and match:
- attribution model
- lookback window
- touchpoint inclusion/exclusion rules
- conversion definitions
3) Audit identity resolution
Make sure you have:
- a persistent user/contact ID
- proper mapping between anonymous and known users
- deduping rules in CRM
- consistent email normalization
4) Validate tracking setup
Check:
- UTM parameters on all campaigns
- form tracking
- CRM field mapping
- event firing
- referral source capture
- offline conversion imports
5) Reconcile data by a small sample
Pick 10–20 deals that are mismatched and trace them end-to-end:
- first touch
- all marketing touches
- lead creation date
- opportunity creation date
- close date
- owner/source fields in CRM
- attribution output
This usually reveals the mismatch pattern quickly.
6) Standardize lifecycle stages
Make sure stage changes happen consistently:
- lead creation
- qualification
- opportunity creation
- closed won/lost
If reps are changing stages manually, enforce definitions and required fields.
7) Create a reconciliation report
Build a report showing:
- deal ID
- CRM revenue
- attribution revenue
- difference
- lead source
- touchpoints
- owner
- dates
This helps identify systematic issues instead of chasing individual cases.
Quick checklist
- Same attribution model
- Same lookback window
- Same conversion definitions
- Same timezone
- Deduped CRM records
- Identity stitching works
- UTM tracking consistent
- Offline conversions imported
- Stage mappings verified
If you want, I can help you debug it systematically
If you share:
- your CRM
- your attribution tool
- what numbers differ
- whether the issue is leads, pipeline, or revenue
…I can give you a step-by-step reconciliation process.