GuidesGoogle Ads

How to import offline conversions into Google Ads

Capture the Google click ID on every lead, store it with the lead in your CRM, then upload the sales that follow so Google Ads can see which clicks became revenue. Create an import conversion action first, upload by file, sheet or CRM connection, and keep the upload frequent.

Updated November 16, 20266 steps5 min read

Audit my Google Ads →

$1 today. Cancel anytime before day 7.

Offline conversion import
  1. 1Turn on auto-taggingEvery click carries a GCLID.
  2. 2Capture the GCLIDSave it in a hidden form field and your CRM.
  3. 3Create the import actionGoals, Conversions, New, then Import.
  4. 4Upload the conversionsFile, scheduled sheet, or CRM connection.
  5. 5Check the diagnosticsLook for matched and unmatched rows.
  6. 6Use the data for biddingSet the offline action as primary.
On this page
  1. Why offline conversions are worth the work
  2. Capture the click ID
  3. Create the conversion action
  4. Upload by file, sheet or connection
  5. Which stages to import
  6. Verify and use the data
  7. Questions

Why offline conversions are worth the work

A form fill is not revenue. For lead-gen businesses, the clicks that become customers often look the same as the ones that waste a salesperson’s time. Importing the closed sale lets Smart Bidding optimize toward the clicks that turn into money, not just forms.

It also fixes reporting. Cost per qualified lead and cost per sale become visible in Google Ads. The Google Ads for leads guide shows how to design the funnel this feeds.

It also helps with the gap between marketing and sales. When the ad platform can see which leads became customers, you can stop arguing about lead quality from anecdotes and start comparing campaigns on closed revenue.

Capture the click ID

Turn on auto-tagging in the account settings so every click carries a GCLID in the landing page URL. Add a hidden field to your forms that fills with that value, and save it on the lead record. For calls and chats, store it when the visit is matched to the contact.

The most common failure is losing the value between the click and the CRM. Test with your own click and check that the ID arrives. The GCLID guide and the missing GCLID guide cover the traps, such as redirects that strip the parameter.

Keep the GCLID long enough. Leads can close weeks or months after the click, so store the value on the contact record and do not overwrite it on a later visit. If a person clicks several ads, decide whether you keep the first or the last, and apply the same rule every time.

If your forms are on a third-party tool, check that its embedded page keeps the click ID. Some embeds load in a frame that cannot read the parent page’s URL, so the hidden field stays empty. Test that exact form, not just the page around it.

Want this checked in your Google Ads account?

Reads campaigns, search terms, keywords and conversions. Every change waits for your approval.

Create the conversion action

In Goals, choose Conversions, then New conversion action, then Import, and select the CRM or other data sources route and track conversions from clicks. Give it a name your team will recognize, such as “Qualified lead” or “Closed sale”, set a value or a different value for each conversion, and choose a conversion window.

Use more than one stage if your sales cycle is long. A qualified-lead import arrives in days and trains bidding faster than a closed-sale import that arrives in months.

Choose the attribution model and conversion window on purpose. For a sales cycle of 60 days, a 30 day window loses real conversions. Set the window to cover most of your cycle, up to the maximum, so later closes still credit the click that started them.

Upload by file, sheet or connection

The simplest way is a file. The template needs the Google Click ID, the conversion name, the conversion time with a time zone, and optionally a value and currency. You can upload it by hand, schedule an import from Google Sheets or SFTP, or connect a CRM such as Salesforce or HubSpot.

Upload regularly, at least daily if volume allows, and do not wait until the click window is almost over. If you cannot keep the GCLID, use enhanced conversions for leads, which match on hashed email or phone instead.

Check formats before the first upload. The time must include a time zone offset and match the account’s format, and the value should be a plain number without a currency symbol. A single bad column can make the whole file fail, so test with a small batch first and read the result message.

Which stages to import

A common structure is three actions. A lead, which is the form fill, imported in real time. A qualified lead, once sales has accepted it. And a closed sale, with its revenue. Set the first as secondary, the second as primary if you need faster learning, and the third as primary once you have enough volume.

Bidding needs a minimum number of conversions to learn well. If you only close five deals a month, optimizing on closed sales alone will starve the model, so lean on the qualified-lead stage and use the sale for reporting.

Verify and use the data

Open the diagnostics for the upload and look at matched versus unmatched rows. A low match rate usually points to a missing GCLID or a conversion time outside the window. Fix the capture, not just the file.

Sprites can read the conversion actions in your Google Ads account, check that the import is healthy on a schedule, and propose fixes as approval cards you edit before anything is applied.

Add a monthly reconciliation. Count conversions in Google Ads and compare them with closed deals in the CRM that had a stored click ID. A match rate that drifts down over months usually means a form or page change broke the capture, which is far cheaper to catch early.

Questions

What is the difference between offline conversions and enhanced conversions for leads?

Offline imports match a sale to a click using the GCLID. Enhanced conversions for leads match using hashed email or phone you collected on the form. Pick the one your data can support.

How long after the click can I upload a conversion?

Only within the conversion window set on the action, which can run up to 90 days after the click. Upload as soon as the outcome is known.

Why are my uploaded conversions not matching?

Common causes are a missing or truncated GCLID, a time zone mismatch, and a conversion time earlier than the click. Check the diagnostics for the exact error.

Does importing offline conversions cost anything?

No. It is a free feature of Google Ads. The cost is the work of capturing IDs and keeping the CRM clean.

Keep going

Have Sprites do this in your Google Ads account

  • Reads campaigns, search terms, keywords and conversions
  • Drafts negatives, new ads and budget moves as cards
  • Every change waits for your approval