Ad spend sits in ad accounts, visits in site analytics, deals in the CRM and money in the payment system. The question is whether a row in one can be matched to a row in another.
Three names
| Word | What vendors usually mean |
|---|---|
| Integration | Connectors that move data from sources to one place |
| Hub | The same, plus one view or a place where teams pick up the data |
| Platform | Connectors and storage, often with dashboards and reports |
The words overlap, and a vendor may use all three. So ask what the product does after the data arrives.
What actually joins the data
| Between | The key | What goes wrong |
|---|---|---|
| Ad account and site | Tags in the link, click ID | Tags are missing or written in different ways |
| Site and lead | A visit ID passed with the form | Calls and messengers pass nothing |
| Lead and CRM | The lead ID, email or phone | A deal is created by hand with no link to the lead |
| CRM and payments | The deal or customer ID | Refunds and repeat payments are not tied to the deal |
Keys are half of the work. The other half is rules: one currency, one day boundary, one name for a channel, one meaning of a sale. Each person who builds a report without them gets a different number.
Three ways to do it
| Way | Who keeps the rules | It fits when |
|---|---|---|
| Spreadsheets | The person who fills them in | Few sources, a small team, a monthly report |
| Connectors, warehouse and BI | A data analyst | The company has a warehouse and someone to run it |
| A ready product | The vendor, with your settings | You need the report, and do not want to run the data work |
More in Your spreadsheet report or KO and BI or KO.
Where KO fits
KO takes the third way for marketing data. It connects ad accounts, the site and the CRM, keeps the connectors, links each lead to its visit and counts metrics by one set of formulas. The result is one report from spend to revenue.
KO is built around that report, and it does not move arbitrary company data between systems. The connector list is in Integrations.