Google Ads and CRM numbers don't match: which to trust?

Trust your CRM, booking system or spreadsheet for how many real leads you got and how much money came in. Use Google Ads’ numbers to compare your campaigns, keywords and ads against each other, and expect the two never to match exactly.

They count different things in different ways. Google Ads records what its tag sees and files it under the day of the click; your CRM records the people who actually got in touch and the jobs you won. The useful question isn’t “which one is right” but “is the gap steady, and can I explain it?”

Why the numbers differ

Click date, not lead date. Google says its main conversion columns are based on the time of the click, not the time of the conversion. Someone who clicks on 30 October and fills in your form on 2 November shows up in Google’s October numbers and in your CRM’s November ones. Google also warns that recent days look weak because some people who clicked haven’t converted yet, and that conversions can be reported up to 90 days after the click, depending on your conversion window.

Conversion windows. Google only counts a conversion that happens within the window you set, 30 days by default for Search. A customer who clicks, thinks about it for six weeks and then books is a lead in your CRM but not a conversion in Google Ads.

Every vs One. With Every, one person sending your form three times is three conversions. With One, it’s one per click. Your CRM sees one person. See One vs Every for which to pick.

Duplicates. A tag installed twice, or the same form tracked by the Google Ads tag and by Google Analytics with both set to primary, doubles the count. That’s covered in duplicate conversions.

View-through conversions. These are people who saw an ad without clicking and converted later. Google keeps them out of the Conversions column for most campaign types and puts them in All conversions and View-through conversions. If you compare your CRM with All conversions, you’re including people who may never have clicked.

Modelled conversions. When visitors decline cookies, Google’s tag can’t see the whole path from click to form. Google estimates the missing conversions and adds them to the Conversions column. Those are real people in your CRM, but your CRM has no way of knowing they came from an ad.

Attribution. Data-driven attribution, the default for most conversion actions, splits credit for one conversion across the ads and keywords that helped. So a single campaign can show part-conversions like 2.6. Your CRM gives the whole lead to one source, usually whatever the customer said or the last link they used.

Value. Google only knows the value your tag sends. If your site doesn’t pass a real amount, Google uses the default value you entered for every conversion. For a business that quotes jobs, that’s nearly always the case.

Time zone. Google says reports follow your account’s time zone. If your CRM runs on a different one, leads near midnight land on different days, which matters on short date ranges.

An example

Say a roofer checks October on 3 November. Google Ads shows 21 conversions worth $21,000. The CRM shows 14 new leads marked “Google”, and 3 jobs won for $27,500.

The 7-lead gap breaks down like this:

• 4 are repeat form sends. The contact form counts Every, and four people sent it twice.
• 2 people clicked in the last days of October and filled in the form on 1 and 2 November. Google files them under October; the CRM under November.
• 1 lead came from an ad, but the customer told the office a neighbour had recommended them, so it was logged as a referral.

That’s 21 minus 4 minus 2, or 15 leads in October, against 14 plus 1 in the CRM. The gap is explained, and only one part of it (the Every setting) is worth fixing.

The money is a different story. Google’s $21,000 is 21 conversions times the $1,000 default value someone typed in when setting up the action. It has nothing to do with the $27,500 actually won. For revenue, the CRM is the only number that counts.

These numbers are made up, but each cause is one Google documents.

Which one to trust for what

• For money, profit and “is advertising paying for itself”, trust your CRM, booking system or bank. Google Ads doesn’t know which leads turned into paid jobs unless you tell it.
• For comparing campaigns, keywords and ads, use Google Ads. It applies the same rules to every campaign, and it’s the only place that knows which click a lead came from. If one campaign shows twice the conversions of another for the same spend, that’s meaningful even if both numbers are a bit high.
• To tell whether tracking works, watch the gap between them. A steady gap you can explain is fine. A gap that suddenly widens or shrinks means something changed: a new tag, a rebuilt website, a cookie banner, a changed setting.

Bidding is the catch. Automated bidding learns from the conversions Google Ads records, not from your CRM, so the closer you bring them to your CRM, the better it spends.

How to line them up

Do this once a month with last month’s numbers, after the first few days of the new month have passed.

1. Pick the same dates and the same kind of date. Google’s standard columns use the click date. Your CRM probably uses the date the lead came in. Add the Conversions (by conv. time) column in Google Ads, which Google says reports conversions by when they happened and is a better match for your own systems.
2. Use Conversions, not All conversions. All conversions includes secondary actions and view-through conversions.
3. Compare like with like. Segment the report by Conversions > Conversion action and match each one to your CRM: forms with forms, calls with calls. Count only CRM leads whose source is Google Ads.
4. Check One vs Every on each lead action. If it’s Every, expect Google to be higher.
5. Check the time zone in your account settings against your CRM’s, if you compare single days or weeks.
6. Write down the gap. Google 21, CRM 14, explained. Next month, compare the gap, not just the totals.

When the gap is a real problem

Google shows far more leads than your CRM. If Google is close to double, look for a tag installed twice or two primary actions for the same form. If it’s wildly higher and uneven, check whether a page view is being counted instead of a form. Start with duplicate conversions.

Google shows far fewer, or none. Tracking may have broken, a cookie banner may be blocking the tag, or most of your leads come by phone and calls aren’t tracked. See conversion tracking not working.

The gap jumped from one month to the next with no change in how you work. Something in the setup changed. Check when the website or tags were last edited.

The free SpendCanary scan flags lead actions set to count Every and accounts recording more conversions than clicks, two of the usual causes of an inflated gap.

Bring your CRM’s numbers into Google Ads

If you want Google to bid on leads that actually became paying jobs, send those results back. Offline conversion import lets you upload sales from your CRM using the Google click ID (GCLID) that came with the original visit, and Google’s FAQ says you can upload a conversion up to 90 days after the click. If you haven’t set up offline import yet, Google recommends starting with enhanced conversions for leads: your form sends Google a hashed email address, and later you upload the leads that became customers so Google can match them. Both need some setup on your site or CRM, so ask whoever built it. If tracking isn’t in place at all, start with setting up conversion tracking.

Sources

• Google Ads Help: Understand your conversion tracking data, Find out how long it takes for your customers to convert, About conversion windows, About conversion counting options, About view-through conversions, About “All conversions”, About consent mode modeling, About attribution models, About conversion values, About your Google Ads time zone setting, About offline conversion imports, Offline conversion imports FAQs, About enhanced conversions for leads.
• The roofer example is illustrative, not a real account. The advice to track the gap month to month is our own rule of thumb.