Skip to content

Why ad platform conversions never match the client’s CRM

Example product scene: a roof replacement won at $18,400, matched by Lead ID to a Paid search lead

Ad platform conversions and CRM leads rarely match. The ad account says 52 conversions last month, the client’s CRM shows 41 new leads from the same ads, and both numbers are right, because the two systems count different things on different dates.

The platform counts actions; the CRM counts people

A conversion is an action the ad platform recorded: a form submitted, a call that lasted long enough, sometimes a button press. A CRM record is a person or enquiry the client’s team can contact. One person can create two conversions, and one conversion can be a bot that never becomes a record.

Start by checking which conversion actions the account counts as primary: only primary actions appear in the Conversions column. A page view or click action set as primary by mistake inflates the platform’s number on its own.

The two systems date the same lead differently

Google Ads reports a conversion on the date of the ad click by default, not the date the form was sent. A click on the 30th that turns into an enquiry on the 2nd counts in the earlier month in the standard columns. The “by conv. time” columns date each conversion when it happened, and those line up far better with a CRM.

Time zones add a second shift. The ad account reports in its own time zone and the CRM may use another, so an enquiry sent just before midnight can land on different days. In Attrival, lead reports group leads by their UTC submission time, while advertising reports follow each ad account’s time zone.

Credit is split, and every platform claims its share

With data-driven attribution, Google Ads can give part of one conversion to several clicks, so the column can show fractions. Each ad platform also credits conversions it influenced by its own rules. Add the platforms’ totals together and you can get more conversions than the client has leads.

The CRM does the opposite: one record, one source, usually whatever was captured when the lead arrived.

Duplicates, spam and tests never reach the CRM

  • Someone who fills in the form twice is two conversions, and one CRM record once the duplicate is merged.
  • Spam and test submissions are counted by the platform and deleted or ignored in the CRM.
  • A phone call and a form from the same person can both be counted as conversions.

Some leads never arrive, and some arrive without a source

If the connection between the form and the CRM fails, the platform still counts the conversion while the CRM never sees the person. The reverse also happens: the lead arrives, but its campaign details were dropped on the way, so it sits in the CRM as “direct” or with no source at all.

Both problems can be fixed, and both are worth finding before the review. Our guide to passing UTM parameters into the CRM covers the second one.

How to reconcile one month

  1. Pick one month and one ad account, and use the conversion-time columns or a conversion export with dates.
  2. Export the CRM’s new leads for the same dates, converted to the ad account’s time zone.
  3. Match them one by one with an ID carried from the form, and fall back to email or phone only where no ID exists.
  4. Put every unmatched item in a named bucket: duplicate, spam or test, outside the dates, not delivered or missing a source.
  5. Fix what is broken, such as delivery or source capture, and write down the rest as explained differences.
Example reconciliation for one month (illustrative data)
LineCount
Conversions in the ad account52
Duplicate submissions from the same person−5
Spam and test submissions−3
Clicked this month, enquired next month−2
Clicked last month, enquired this month+1
Counted as a conversion, never delivered to the CRM−2
New CRM leads from this account41

Only one line here needs action: the two undelivered leads are real people the client never saw. The rest is the normal difference between two systems, and once it is written down nobody needs to argue about it again.

What to show the client

Make leads from the CRM the headline of the client report, because those are people the client can call. Keep platform conversions in the advertising section under their own label, and never add the two together.

When each lead carries an ID from intake into the CRM, the matching step disappears. That is how Attrival matches outcomes to the campaign that produced the lead, and why its report reads the leads rather than the platform’s conversion count. For the other date questions clients ask, see how to read a client report.

More on numbers that disagree.

Report the leads the client can actually call.