Calculate True CAC When Google Ads and CRM Conversion Counts Don't Match

Why Google Ads and CRM Conversion Counts Diverge

Google Ads reports 150 conversions for last month. Your CRM shows 87 actual customers. Neither number is wrong—they measure different things at different points in the funnel.

Google Ads tracks any action tagged as a conversion: form submissions, page views, add-to-cart events, or demo requests. Your CRM tracks customers who entered the system and were qualified by your sales team. The gap between the two is where most CAC miscalculations happen.

Common reasons for the gap:

• Duplicate form submissions (same person fills out the form twice)
• Bot traffic or invalid clicks that still trigger conversion pixels
• Form submissions from unqualified leads (wrong industry, budget, intent)
• Conversion pixel fires before the CRM receives the data
• Attribution window mismatch (Google counts 30-day clicks; CRM logs entry date weeks later)
• Leads that enter the CRM but are rejected by sales as unqualified

The Two-Number CAC Problem

If you divide Google Ads spend by Google Ads conversions, you get a number that doesn't reflect what your business actually acquired. A $5,000 spend with 150 Google conversions looks like $33 CAC. But if only 87 of those became real customers, your true CAC is $57—a 73% difference.

The second number is what your board, investors, and profit margin care about. Google's number is useful for bid optimization, but it's not your true cost to acquire a paying customer.

Step 1: Define "Customer" in Your CRM

Before you calculate, lock down what counts as a customer. Is it anyone who enters the CRM, or only leads marked as "qualified"? Only leads who received a demo? Only leads who received a proposal?

The safest definition: a contact in your CRM that your sales team manually qualified and moved to a sales stage (not auto-rejected or marked as spam). This filters out bot submissions and unqualified noise.

If your CRM has a "qualified lead" status or field, use that. If not, use the first sales stage (e.g., "Discovery" or "Demo Scheduled"). Avoid counting all form submissions; those are too broad and include junk.

Step 2: Pull the Right Numbers from Your CRM

Export a list of all qualified leads created during the campaign period. Include creation date, source (should show "Google Ads" or similar), and any UTM parameters captured at submission.

Count only leads where the source clearly links to Google Ads. If your CRM doesn't capture UTM source automatically, you'll need to match leads by email or phone against your Google Ads conversion list (a manual process, but necessary for accuracy).

The result is your true conversion count: the number of real, qualified leads or customers Google Ads actually generated.

Step 3: Account for Time-Zone and Attribution Delays

Google Ads records conversions in the timezone of your Google Ads account. Your CRM records submissions in its own timezone or the user's timezone. A form submitted at 11:59 PM in Google's timezone might be logged at 12:01 AM in your CRM, appearing to be the next day.

More important: some leads take hours or days to sync from your form provider (Unbounce, Marketo, Gravity Forms) to your CRM. A conversion recorded by Google on Day 1 may not appear in your CRM until Day 2 or Day 3.

Solution: Pull Google Ads conversions and CRM leads from the same date range, but add 2–3 days of buffer. If you're analyzing January 1–31, pull Google Ads data for January 1–February 2, and CRM data for January 1–February 2. This captures late-arriving syncs.

Step 4: Match Google Ads Conversions to CRM Leads

The cleanest approach: add a hidden form field that captures Google's click ID (gclid) when the form is submitted. Your form provider passes it to your CRM. You can then match Google Ads conversions to CRM leads by gclid.

If you don't have gclid captured, use secondary matching:

• Match by email address (if the same person filled out the Google form and entered the CRM)
• Match by phone number
• Match by UTM parameters (utm_source, utm_medium, utm_campaign) if your form captures them
• Count all CRM leads with source = "Google Ads" or similar tag during the same period

The first method (gclid) is most accurate. The last method (source tag) is fastest but assumes all Google Ads leads are tagged correctly in your CRM.

Step 5: Calculate True CAC

Once you have the count of qualified CRM leads from Google Ads:

True CAC = Total Google Ads Spend / Number of Qualified Leads in CRM

Example:

• Google Ads spend (January): $5,000
• Google Ads conversions reported: 150
• Qualified leads in CRM from Google Ads (January 1–Feb 2): 87
• True CAC = $5,000 / 87 = $57.47 per customer

Compare this to your customer lifetime value (LTV). If LTV is $500, your ratio is 8.7:1 (healthy). If LTV is $100, your ratio is 1.7:1 (unsustainable).

Step 6: Find and Fix the Gap

Now investigate why Google reported 150 but your CRM shows 87. The 63-lead gap is your leakage.

Export the Google Ads conversion list and the CRM qualified lead list. Cross-check by email, phone, or gclid. Leads in Google but not in CRM fell into one of these buckets:

• Never synced to CRM: Form submitted, pixel fired, but the lead never reached your CRM. Check your form provider's integration logs.
• Synced but auto-rejected: Lead entered CRM but was marked spam, duplicate, or unqualified by a rule. Review your CRM's auto-qualification logic.
• Duplicate submissions: Same person submitted twice; Google counted two conversions, CRM de-duped to one contact.
• Invalid traffic: Bot clicks or click fraud that triggered the pixel but generated no real lead.
• Wrong attribution: Lead came from organic or direct, not Google Ads, but was tagged incorrectly.

Each bucket suggests a fix. Sync failures mean checking your form integration. Auto-rejection rules mean refining your lead quality filters. Duplicates mean adding deduplication logic. Invalid traffic means tightening your conversion tracking.

When the CRM Count Exceeds Google Ads

Sometimes your CRM shows more leads than Google Ads reports. This usually means:

• Leads came from multiple sources (Google Ads, organic, direct) but were tagged as Google Ads in your CRM.
• Your conversion pixel didn't fire on all form submissions (tracking gap).
• Leads were added manually to your CRM or imported from another source.

In this case, your true CAC is lower than Google Ads alone suggests. But you've lost visibility into which leads actually came from paid search. Fix the tracking gap by ensuring your conversion pixel fires on every form submission and your CRM captures source accurately.

Reality Check: CAC Variance Is Normal

A 20–30% gap between Google Ads conversions and CRM leads is typical. Gaps above 50% signal a serious tracking or qualification issue worth investigating.

Once you've identified and fixed the gap, recalculate monthly. CAC will still vary based on bid strategy, landing page quality, and lead quality standards. But the number will now reflect what you're actually paying per customer, not per form submission.

What to Do Next

Start by auditing one month of data. Pull Google Ads conversions and CRM leads side by side. Match them by email or gclid. Count the gap. Then work backward to find where leads are leaking. This one-month audit takes a few hours but gives you the foundation for accurate CAC tracking going forward.

If you need help setting up tracking or reconciling your data, a Google Ads audit can identify gaps in your conversion setup and lead quality filters.

FAQs

People Also Ask