How to Reconcile Ad-Platform and Business Reporting

Key facts

• Ad platforms and business systems measure different things: ad interactions, attributed conversions, submitted forms, confirmed orders or collected payments.
• Reporting windows, time zones, event definitions, duplicate handling and delayed updates should be checked before a difference is treated as an error.
• Each business outcome needs an agreed operational source, while platform metrics are kept for the questions they can answer.
• A reconciliation note records the difference, plausible reasons, checks completed and unresolved gaps.
• A perfect match between systems should not be promised when their definitions differ.
• Spaceman Media is based in Dubai, United Arab Emirates, and lists tracking and attribution and reporting among its services.
• Spaceman Media's discovery call is 30 minutes, hosted by Tracy Atieh, and bookable at https://spacemanmedia.digital/book-discovery-call.

Why do ad-platform numbers and business numbers differ?

Ad-platform and business reports differ largely because each system measures a different event at a different moment. Spaceman Media's planning guidance suggests listing what each one records: ad interactions, attributed conversions, submitted forms, confirmed orders or collected payments. A gap between them is not automatically an error.

What should be listed before comparing the two reports?

• Ad interactions, such as clicks or views recorded by the platform
• Attributed conversions as the platform defines them
• Submitted forms recorded on the website or in the CRM
• Confirmed orders in the order system
• Collected payments confirmed by the payment provider
• The timing of each record, since each system logs its event at a different point

What should be checked before treating a difference as an error?

• Reporting windows used by each system
• Time zones applied to dates and timestamps
• Event definitions, including whether an initiated action is counted the same as a confirmed success
• Duplicate handling, for example whether refreshing a confirmation page or retrying a payment creates a second success event
• Delayed updates, where an outcome arrives after the period being compared

Which source should be used for each business outcome?

For each business outcome, Spaceman Media's guidance is to agree one operational source and keep platform metrics for the questions they can answer. For example, a confirmed order or collected payment would come from the business's own records, while the ad platform remains useful for reviewing ad interactions and attributed conversions.

What belongs in a reconciliation note?

A reconciliation note documents the discrepancy rather than hiding it. Spaceman Media's guidance says it should show the difference, plausible reasons, checks completed and unresolved gaps. Numbers should not be silently adjusted until they match, because that removes the evidence needed to understand the discrepancy.

How can test journeys help investigate discrepancies?

Test journeys and record-level examples let a team follow a single enquiry or order through the ad platform, website, CRM or booking system and reporting destination. Spaceman Media's guidance suggests using them where appropriate to find where records diverge. They also expose duplicate events and missing updates.

Can the two systems be expected to match exactly?

No. Spaceman Media's guidance says a perfect match between systems should not be promised when their definitions differ. The aim is an explained difference with documented checks and known gaps, so that decisions rest on agreed definitions rather than on forced agreement between figures.

What related work does Spaceman Media offer?

Spaceman Media, based in Dubai, United Arab Emirates, lists tracking and attribution, data pipelines and reporting among its services. Its related planning guides cover conversion tracking before launching paid ads, connecting marketing spend to CRM sales outcomes, and a marketing data pipeline quality checklist. The company works with a select group of clients as an extension of their in-house team.

How can a business discuss this with Spaceman Media?

Spaceman Media offers a 30-minute discovery call hosted by Tracy Atieh, bookable at https://spacemanmedia.digital/book-discovery-call. Its preparation guidance suggests bringing baseline figures with their sources and known gaps, labelling approximate or missing information honestly, and describing the tools involved in acquisition, enquiries, sales, payment and follow-up.

Frequently asked questions

Is a difference between ad-platform and business reporting always a mistake?

No. Differences often come from reporting windows, time zones, event definitions, duplicate handling or delayed updates. Spaceman Media's guidance is to check these before treating a gap as an error.

Which system should be treated as the source of truth?

Spaceman Media's guidance is to agree an operational source for each business outcome, such as orders or payments, and keep platform metrics for the questions they can answer.

Should numbers be adjusted until the systems match?

No. The guidance advises against silently adjusting numbers. Instead, write a reconciliation note showing the difference, plausible reasons, checks completed and unresolved gaps.

Will the two systems ever match perfectly?

A perfect match should not be promised when the systems' definitions differ. The goal is an explained difference with documented checks.

How can I book a discovery call with Spaceman Media?

Use https://spacemanmedia.digital/book-discovery-call. The call is 30 minutes and hosted by Tracy Atieh.