Why CRMs and marketing platforms disagree
Small teams commonly run a CRM (Salesforce or HubSpot) alongside a marketing system (Marketo or Pardot) and expect them to mirror each other. Differences show up because nobody agreed which system owns which field, values are mapped differently, or syncs run at different times.
Other frequent causes are human edits in the receiving system, overlapping two-way syncs that race each other, and missing provenance fields that would say where a value came from. Time-lag and duplicate contacts make the symptom worse: the same person can look like two different leads.
Short fixes that actually work
Pick ownership by field, not by record: agree that marketing owns engagement metrics and subscription preferences, while sales owns opportunity stage and deal values. For example, set HubSpot (or Pardot) as canonical for opt-ins, and Salesforce for closed-won dates — then enforce that in your syncs.
Add two simple technical guards: a small provenance field (sync_source) and a last-updated timestamp (last_synced_at or last_marketing_update). When a sync sees a newer timestamp from the canonical system it overwrites; otherwise it leaves the receiver alone. That rule stops most accidental overwrites and racing updates.
A small-team checklist to get agreement
- Decide canonical owners per field and write them in one shared doc (who updates, who reviews).
- Standardise value maps for lifecycle/status fields (example: "MQL" in Marketo = "Marketing Qualified" in Salesforce) and store the map in a single place.
- Add two provenance fields: sync_source and last_updated, visible to both teams and included in sync payloads.
- Prefer one-way syncs for fields with a single owner; only allow two-way syncs where you have clear merge rules and tests.
- Put a few canary records into production to catch mis-syncs in minutes, not days.
- Build a simple monitor: a nightly diff report of 5–10 key fields and a one-line rollback plan.
- If you want a short field-mapping workshop and a template to run these steps, Optira can help run it with your team.