Google Ads shows plenty of form fills. Your sales team closed a handful of deals. Nobody can say which ad brought those buyers, so Smart Bidding keeps chasing cheap leads.
Offline conversion tracking with a CRM or a Google Sheet means saving the Google Click ID (GCLID) with every lead, then sending the leads that become sales back to Google Ads. A Google Tag Manager tag saves the click ID, a hidden form field carries it into your CRM or sheet, and Google Ads Data Manager imports the sale later.
Think of a coat check. The click ID is the ticket. Lose the ticket at the door and nobody can match the coat later. I set this up for lead gen accounts as an done-for-you offline conversion tracking setup. Below is the five-step version, with the code and the screens from my guide.
Step 1: Turn on auto-tagging and check the click ID in your URL
The whole setup depends on one value in the URL. In Google Ads, open Admin, then Account settings, and make sure Auto-tagging is on. Then click one of your own ads, or use the ad preview tool, and look at the landing page address. You should see ?gclid= in it.
Some iPhone and Safari visits arrive with gbraid or wbraid instead, so save those too. Also check that no redirect strips the parameters. My free UTM redirect checker shows that in seconds.
Do this:
- Turn on Auto-tagging in Google Ads, Account settings.
- Click your own ad and confirm gclid is in the landing page URL.
- Plan to save gbraid and wbraid as well as gclid.
- Check that no redirect or form tool removes the URL parameters.
Step 2: Add a click ID capture tag in Google Tag Manager
This is the tag that makes everything else possible. It is a Custom HTML tag on All Pages. It reads gclid, gbraid, wbraid and the UTMs from the URL and keeps them in a first-party cookie for 90 days. A new ad click replaces the old values, so the last click wins.
It then fills hidden form fields named gclid, utm_source and so on. It also fills forms that load late, like pop-ups, and it never overwrites a field that already has a value. If a visitor has no click ID saved, it falls back to Google's own _gcl_aw cookie. Capture the click ID on every page, not only the landing page. Google says the same in its own guide. The full code is in my blog post, and you should read it once before you paste it.
Do this:
- In GTM, go to Tags, then New, and choose Custom HTML.
- Paste the click ID capture code and name the tag
need a banner, require ad_storage consent in the tag's Consent Settings. - Add hidden fields named gclid, gbraid, wbraid and the UTMs to your forms.
Step 3: Test the click ID in GTM Preview and in your CRM
Do not trust a tag you have not seen fire. Click Preview and open your site with a test address like ?gclid=TEST123&utm_source=google. In Tag Assistant, find the click_ids_ready event and open the Data Layer tab. You should see the click ID, the UTMs, the click time and the landing page.
Then go to another page, submit your form with a test email, and open the new contact in your CRM. The GCLID field should say TEST123. Delete the test contact afterwards so it never gets sent to Google Ads. If the field stays empty, my HubSpot offline conversion tracking guide shows how I map the hidden fields to CRM properties.
Do this:
- Click Preview and open your site with ?gclid=TEST123&utm_source=google.
- Find click_ids_ready in Tag Assistant and check the Data Layer values.
- Go to a second page without parameters, then submit the form with a test email.
- Open the contact in your CRM and confirm the GCLID field says TEST123.
- Delete the test contact.
Step 4: Store the click ID on the deal and build the offline conversions sheet
Keep the GCLID on the deal or opportunity, not only on the contact. The sale value lives on the deal, and that is what you send back. Each CRM does it a little differently, and I covered my GoHighLevel offline conversions guide with tested automation code.
Now make the sheet. One row per conversion, with these columns: Google Click ID, GBRAID, WBRAID, Conversion Name, Conversion Time, Conversion Value, Conversion Currency and Email. Write the time with a time zone, like 2026-11-06 14:30:00 America/New_York, so Google reads it right. Use one conversion name per stage, such as Qualified Lead and Closed Won. My offline conversion builder can help with the layout.
Do this:
- Add a custom GCLID field on the deal or opportunity in your CRM.
- Create the sheet with the eight columns above.
- Write every Conversion Time with a time zone.
- Give each stage its own conversion name and its own row.
- Add rows automatically when a deal changes stage, with a CRM workflow, n8n, Make or Zapier.
Step 5: Import the sheet into Google Ads and bid on real revenue
In Google Ads, go to Goals, then Summary, then Create conversion action, and choose Conversions offline. Make one action per stage. Wait 4 to 6 hours before the first import. Then connect the sheet through Google Ads Data Manager, map your columns and set it to run daily. Google now calls the old file uploads legacy and points to Data Manager.
When Closed Won has steady volume, make it a primary goal and test value-based bidding. Add the hashed email to the same rows for enhanced conversions for leads. If you have visitors from the EEA, check your banner with my Consent Mode checker first. For recovering leads lost to ad blockers, see my server-side tracking guide for lead gen.
Do this:
- Create one Conversions offline action per stage in Google Ads.
- Wait 4 to 6 hours, then connect the sheet in Google Ads Data Manager.
- Map your columns to the conversion action and set the import to daily.
- Import within 90 days of the click, because that is the window for a GCLID.
- Test value-based bidding once Closed Won has steady volume.
Quick answers
What is offline conversion tracking in Google Ads?
It means sending sales that happen after the click, like a closed deal in your CRM, back to Google Ads and matching them to the ad click with the GCLID. Smart Bidding then learns from real revenue.
Where do I store the GCLID, in the CRM or a Google Sheet?
Store it with the lead in a custom field, ideally on the deal too. The sheet is just where closed deals are listed for import. You can use a CRM, a sheet or both.
How long can I import a GCLID after the click?
Up to 90 days. After that Google cannot match the sale to the click, so import often and at least once a day if you use Smart Bidding.
Why is the GCLID field empty in my CRM?
Usually the form has no hidden field with that name, the form sits in an iframe, or a redirect removed the parameter. Test with ?gclid=TEST123 in GTM Preview to find which.
Key takeaways
- No click ID, no offline conversion. Google Ads matches a sale to an ad click by the GCLID.
- One GTM Custom HTML tag can save the click IDs for 90 days and fill your hidden form fields.
- Keep the GCLID on the deal, because the sale value lives there.
- Use one row per stage in the sheet, and write every time with a time zone.
- Import through Google Ads Data Manager on a daily schedule, then test value-based bidding.
Summary
Offline conversion tracking with a CRM or Google Sheet saves the Google Click ID with every lead and sends closed sales back to Google Ads. A Google Tag Manager Custom HTML tag stores gclid, gbraid, wbraid and UTMs for 90 days and fills hidden form fields. Test it in GTM Preview, store the click ID on the CRM deal, list each stage in a sheet, then import it through Google Ads Data Manager. It is for lead gen teams that want Smart Bidding to learn from sales.
Want the full guide with the complete code, the sheet columns and the troubleshooting list? It is here: https://mdniamul.com/offline-conversion-tracking-services/
Can your team tell which ad or keyword brought your last five closed deals?
MD Niamul
Conversion Tracking and Web Analytics Specialist, Digital Soldier Agency





Top comments (0)