A familiar scene: marketing presents pipeline from the ad platforms. Sales presents pipeline from the CRM. Finance presents cash from the ledger. All three rooms are acting in good faith. The meeting still ends without a decision, because the objects are not the same.
The disagreement is the signal
When three systems disagree, the useful question is not who is wrong. It is which event each system is actually recording. An ad platform records a click and a conversion pixel. A CRM records a person a human was willing to type in. Finance records money that cleared. Those are related facts. They are not interchangeable.
Mid-sized companies get into this state by growing. Each tool was a reasonable purchase at the time. Identifiers were never designed. Campaign names were typed by whoever launched the work. Customer matching was left to memory.
What usually sits underneath
Missing keys, duplicate records, delayed pipelines, and definitions that live in someone’s head. The spreadsheet that reconciles the three views is doing architecture work that the systems refused to do.
- Lead in marketing is a form fill. Lead in sales is a qualified conversation.
- Revenue in the CRM is a closed opportunity. Revenue in finance is cash or an invoice.
- A customer in Stripe may not exist in the CRM under the same email.
A practical sequence
Write down the objects that matter: person, company, opportunity, invoice, shipment, or enrolment. For each object, name the system that is allowed to be right. Then name the keys that let the other systems attach. Only after that is a dashboard a good idea.
This is slower than buying another BI connector. It is faster than another year of arguing about last month.
What DataLift does with this
Diagnosis names the objects that disagree. Integration makes one of them authoritative. Reporting is rebuilt on that source. Success is two people producing the same number without a reconciling spreadsheet.
If your Monday file is the only place the three numbers meet, that file is the architecture. Treat it as such.