Google Ads

Google Ads Offline Conversion Tracking: 4 Ways to Import CRM Leads

If you run Google Ads for leads, the form fill is not the result you care about. The result is the qualified call, the booked job or the signed contract, and those happen later, inside your CRM. Google Ads never sees them unless you send them back.

That is what offline conversion tracking does: it tells Google Ads which clicks turned into real business, so Smart Bidding can find more people like your best customers instead of more people who fill in forms.

This guide covers how it works, the four ways to set it up, and the mistakes that make uploads fail.

How offline conversion tracking works

Every method follows the same three steps:

  1. Capture the click ID. When someone clicks an ad, Google adds a click identifier to the landing page URL: gclid, or on some iOS traffic gbraid / wbraid. Your site stores it and sends it with the lead into the CRM.
  2. Record the outcome in the CRM. When the lead becomes qualified or a deal closes, the CRM has the click ID, the date and time, and the value.
  3. Send the outcome back to Google Ads. You upload “this click ID converted at this time for this value” to an import conversion action. Google matches it to the original click.

If step 1 fails, nothing after it can work. That is where most setups break.

Capturing the GCLID reliably

  • Add a hidden field (for example gclid) to every lead form.
  • Fill it with JavaScript from the URL parameter, and fall back to the _gcl_aw cookie that the Google tag sets, so the ID survives when the visitor browses a few pages before converting.
  • Map the hidden field to a dedicated CRM property, not a notes field.
  • Test it: click a real ad (or add ?gclid=test123 to a URL), submit the form, and check that the CRM record shows the value.

If you use HubSpot, see HubSpot to Google Ads offline conversion tracking for the HubSpot-specific setup.

Create the import conversion action first

In Google Ads go to Goals → Conversions → New conversion action → Import, then choose CRMs, files or other data sources and Track conversions from clicks.

A few settings matter:

  • Name it after the CRM stage (for example “Qualified lead – CRM” and “Closed deal – CRM”), so reports are readable.
  • Value: use the real deal value if you have it, or a consistent estimated value per stage.
  • Primary vs secondary: only the stage you want Smart Bidding to optimise toward should be primary. If the website form conversion is also primary, every lead is counted twice.
  • Click-through window: up to 90 days. Clicks older than the window can’t be uploaded, so long sales cycles need the upload to happen per stage, not only at the final close.

After creating a new conversion action, wait a few hours before the first upload.

Method 1: Manual CSV upload

Download Google’s template from Conversions → Uploads, fill in one row per conversion and upload it.

ColumnExample
Google Click IDCj0KCQjw...
Conversion NameClosed deal – CRM (must match exactly)
Conversion Time2026-10-18 14:32:00+00:00
Conversion Value2400
Conversion CurrencyUSD

Good for: testing, low volume, or proving the idea before investing in automation. Watch out for: time zones. A conversion time without a time zone, or one earlier than the click, is rejected.

Method 2: Scheduled uploads

Instead of uploading by hand, point Google Ads at a source it reads on a schedule: a Google Sheet, or a file on HTTPS or SFTP. Your CRM or a small automation writes new rows; Google Ads fetches them daily.

Good for: small teams that already export CRM reports and want a hands-off routine. Watch out for: the sheet must keep the exact template columns, and rows should not be deleted and re-added, or conversions get duplicated.

Method 3: CRM integrations and automation tools

Several CRMs connect to Google Ads directly (for example HubSpot and Salesforce), and Google Ads’ Data Manager can connect supported tools without code. Where no native option exists, automation platforms such as Zapier or Make can watch for a stage change in the CRM and send the conversion. For the 2026 move to the Data Manager API and what else to update before 2027, see tracking changes for 2027.

Good for: near-real-time uploads without writing code. Watch out for: what actually triggers the upload. If the automation fires on every deal update, one deal can be sent many times. Trigger on the stage change itself, and send an order ID so duplicates can be rejected.

Method 4: The Google Ads API

For high volume or custom systems, a developer can upload click conversions through the Google Ads API (UploadClickConversions). This gives full control: retries, logging, per-stage values and conversion adjustments.

Good for: SaaS products, marketplaces and anyone with their own backend. Watch out for: it needs a developer token, OAuth credentials and someone to maintain the code.

The GCLID-free option: Enhanced Conversions for Leads

Click IDs get lost: forms on another domain, privacy features that strip URL parameters, leads that arrive by phone after visiting the site. Enhanced Conversions for Leads solves part of this. The website sends a hashed email (or phone number) when the form is submitted; later you upload the same hashed identifier with the offline conversion, and Google matches them.

Most setups now use both: the GCLID where it exists, and the hashed email as a fallback. If you need to check your hashing, the Customer Data Hasher normalises and hashes values the way Google expects.

Which method should you choose?

Your situationStart with
Under ~20 deals a month, testing the ideaManual CSV upload
A CRM that exports reports, no developerScheduled Google Sheets upload
HubSpot, Salesforce or another supported CRMNative integration or Data Manager
Custom backend, high volumeGoogle Ads API
Many leads arrive without a GCLIDAdd Enhanced Conversions for Leads to any of the above

Common reasons uploads fail

The upload report in Conversions → Uploads lists an error per row. The usual causes:

  • Conversion action not found: the name in the file doesn’t match the conversion action exactly.
  • Click too old: the conversion happened outside the click-through window.
  • Conversion before the click: the conversion time is in the wrong time zone.
  • Invalid click ID: the GCLID was truncated (often by a CRM field length limit) or has extra spaces.
  • Upload succeeded but nothing shows: conversions can take a few hours to appear, and they are reported on the click date, not the upload date.

You can validate a file before uploading it with the Google Ads Offline Conversion Validator.

Checklist before you rely on the data

  • Hidden GCLID field on every lead form, stored in a dedicated CRM property
  • Import conversion action created per CRM stage, with correct values
  • Only one primary conversion for the stage Smart Bidding should optimise
  • Conversion times include a time zone
  • A test conversion uploaded and visible in Google Ads
  • Enhanced Conversions for Leads enabled as a fallback

Need this set up?

Offline conversion tracking is one of the highest-impact changes for lead-generation accounts, but small mistakes (a truncated GCLID, a double-counted primary conversion) quietly undo it. If you want it done properly, see my Google Ads offline conversion tracking service or book a free tracking audit.

💼 Need CRM Offline Conversions Connected to Google Ads?

Stop letting Smart Bidding optimize for unqualified form fills. I connect HubSpot, Salesforce, GoHighLevel, and custom CRMs directly to Google Ads so your campaigns bid on actual closed-won revenue.

Direct Implementation White-Label for Agencies

Need this implemented, audited, or white-labeled?

Whether you are an eCommerce brand owner fixing signal loss or a digital marketing agency needing a senior analytics engineer under strict NDA, I deliver 24–48h SLA turnaround with 8.5+ EMQ match rates.

✓ 24–48h Emergency SLA ✓ Strict Non-Solicitation & NDA ✓ 8.5+ Event Match Quality
Jobair Mahmud

Jobair Mahmud

AI-Driven Performance Marketing & Web Analytics Consultant

Helping eCommerce brands and marketing agencies trust their ads data, scale Smart Bidding, and eliminate wasted ad spend through bulletproof server-side tracking and PPC management.