Google Ads Offline Conversion Import: Link CRM Sales to Ads
How to set up Google Ads offline conversion import: conversion actions, file format, Data Manager, the 2026 API change, adjustments and fixing upload errors.
Google Ads offline conversion import is a way to upload sales that close after an ad click, in your CRM, over the phone or face to face, back into Google Ads. Google Ads matches these records to the click ID and records the sale as a conversion for the campaign that drove it. Your bid strategy then learns from real business results instead of form counts.
In this post I explain how to create an offline conversion action, which import routes are valid as of 2026 and how to prepare the upload file. Then I cover choosing CRM stages, correcting cancelled sales and the most common upload errors.
How does Google Ads offline conversion import work?
Offline conversion import works by sending the click ID captured on your site back to Google Ads when the sale happens. As Google describes it, every ad click carries a unique GCLID. You store this ID with the lead details, and when the person signs a contract you give it back to Google Ads with the conversion type and time.[1]
The flow has four links. The user clicks an ad and a gclid parameter is added to the landing page URL. The form writes that value into the CRM through a hidden field. The sales team moves the lead forward and the CRM stage changes. Finally, that stage is uploaded to Google Ads together with the click ID.
The first link in the chain is capturing the click ID. I explained how GCLID moves from the landing page into the CRM in detail in the GCLID guide. This post starts at the point where the ID is already in your CRM.
Next to classic GCLID import, Google now recommends enhanced conversions for leads. This method uses user-provided data such as hashed email and phone for matching, in addition to GCLID.[1] According to Google on the same page, advertisers who uploaded first-party data alongside GCLIDs saw a median 10% increase in conversions compared with standard imports.[1] Normalising and hashing user data is a separate topic; I covered it in the enhanced conversions for leads post.
Which import method should you choose in 2026?
In 2026, the hub Google recommends for a new offline conversion setup is Google Ads Data Manager. Google labels its file import page as “legacy” and recommends uploading conversions through Data Manager.[3] The choice depends on where your data lives and how much developer capacity your team has.
Google lists three main routes: Google Ads Data Manager, the Google Ads API and third-party integrations such as Zapier.[3] On the API side, an important change happened in 2026. According to the Google Ads API documentation, since June 15, 2026 new offline conversion and enhanced conversions for leads implementations must use the Data Manager API.[5] For projects that made no uploads within a specific date range, UploadClickConversions requests return an error.[5]
Data Manager connector
- Set up from the Google Ads interface
- Sheets, SFTP, HTTPS, cloud storage and CRM connectors
- Scheduled imports without a developer
- Suits accounts with a few conversion actions
Data Manager API
- Requests are sent from your own CRM or back end
- Events can be sent in near real time
- Deduplication and adjustments with transactionId
- Suits custom-built CRMs and multi-account setups
How far back Data Manager reads depends on the source. According to Google, Google Cloud Storage, Amazon S3, HTTP, SFTP and Google Sheets sources import conversions from the last 90 days on every run.[2] For Salesforce and HubSpot, the first successful run takes the last 14 days, and later runs import the changes in between.[2] For BigQuery, Snowflake and similar data warehouses, every run reads the last 14 days.[2]
- Period read on every run for Sheets, SFTP, HTTP and cloud storage
- 90 days
- Period read on the first Salesforce and HubSpot run
- 14 days
- Wait before the first upload after a new conversion action
- 4-6 hours
For teams building their own software, the right place to start is the Data Manager API offline conversions guide. In this API, eventTimestamp is required for every event and transactionId is used for deduplication. Later events that arrive with the same transactionId are treated as adjustments to the first event. If your sales cycle is longer than 14 days, it is important to know this connector behaviour in advance. Otherwise late-closing sales may never be read.
How do you create an offline conversion action?
Short answer
How do you create an offline conversion action in Google Ads?
In Google Ads, an offline conversion action is created from the Summary page in the Goals menu. In the create conversion action step, you select offline conversions and connect a data source. Measurement is not active until a data source is connected. After saving, you need to wait 4-6 hours before uploading the first file.
- Open the Summary page in the Goals menu
- Click + Create conversion action
- Select Conversions offline
- Use Add data source to connect Data Manager, or skip it for later
- Set the conversion category, value and count settings
- Save and wait 4-6 hours before the first upload
A conversion action is the setting that defines what counts as a conversion in Google Ads. In an offline scenario, this action is the Google Ads counterpart of a stage in your CRM. Two different stages, such as “qualified lead” and “sale”, need two separate conversion actions.
Google lists the setup steps as follows: the Summary page in the Goals menu, then creating a conversion action, offline conversions and adding a data source.[2] You do not have to connect the data source right away, but according to Google the new measurement is not active until a source is connected.[2]
Mind the timing. Google recommends waiting 4-6 hours after creating a new conversion action. Uploads made during that window can take 2 days to show in reports.[2] The conversion name in the file must also match the name you created in Google Ads exactly, including capitalisation.[3]
I prefer to keep a new offline conversion action as secondary for the first weeks. A secondary action shows in reports but does not steer the bid strategy. Once I see that uploads are regular and the match rate is reasonable, I make the action primary. I covered the primary and secondary distinction in more detail in the Google Ads conversion tracking post.
How do you prepare the import file?
The import file is a table with one row per offline conversion and the headers from Google’s template. According to Google, all required headers in the template must be present and no extra columns outside the template should be added.[3] Missing or mismatched headers are one of the common causes of upload errors.[3]
| Column | Required? | What goes in it? |
|---|---|---|
| Google Click ID | Yes, for classic import | The GCLID from the click; it is case sensitive |
| Conversion Name | Yes | The exact name of the conversion action in Google Ads |
| Conversion Time | Yes | The conversion time with its time zone |
| Conversion Value | No | The value of the sale; if empty, the action’s default value is used |
| Conversion Currency | No | ISO 4217 currency code, e.g. TRY, EUR |
| Order ID | No, but recommended | The unique ID of the sale |
| Ad User Data / Ad Personalization | For consent handling | Granted or Denied |
Time zone is the field that causes the most errors. Google recommends using a time zone ID in the file’s “Parameters” row, because this avoids errors during daylight saving transitions.[3] For Turkey, this value is Europe/Istanbul. According to Google, missing or incorrect time zone information in the “Conversion Time” column is a frequent cause of upload errors.[3]
Parameters:TimeZone=Europe/Istanbul
Google Click ID,Conversion Name,Conversion Time,Conversion Value,Conversion Currency,Order ID
EAIaIQobChMI_sample_gclid,Sale_Completed,2026-11-18 14:30:00,45000,TRY,CRM-2026-0001
The values in the example are illustrative. In a real file, copy the GCLID from the raw value in the CRM; opening and saving in Excel can corrupt long IDs. Do not put a currency symbol or thousands separator in the value column. Keep the currency code and the value in separate columns.
Google also points out a few finer details in its file rules. Google Ads may not yet be able to record conversions within one day of the click, so it recommends adding an extra day of data to each upload.[3] Google Ads does not count the same conversion twice. It determines uniqueness from the conversion name, conversion time and click ID.[3] Scheduled automatic imports need a file link through Google Sheets, HTTPS or SFTP.[3]
Which CRM stages should you send to Google Ads?
You should send Google Ads the CRM stages that are closest to the business result you want the bid strategy to optimise for and that happen in sufficient volume. Sending only the final sale gives the right signal. But if sales happen only a few times a month, there may not be enough data for the bid strategy to learn.
That is why I usually build a two- or three-stage structure. The first stage is the qualified lead: an enquiry the sales team marks as a real need. The second stage is a commitment step such as an appointment, a quote or a deposit. The third stage is the closed sale. Each stage maps to a separate conversion action in Google Ads.
Value matters too. Google says the value field can carry a real currency value or a relative value such as 1-10.[3] In early stages where the sale amount is unknown, using relative values is a practical way to tell the bid strategy how services differ. I explained how I score lead quality in the patient lead quality post.
You can find the clinic-side details of the lead → consultation → procedure flow in the health tourism offline conversions post.
What do you do if a sale is cancelled or its value changes?
A cancelled sale or a sale whose value changes is updated in Google Ads by uploading a conversion adjustment. Google defines two adjustment types: RESTATE, which restates the value, and RETRACT, which withdraws the conversion from reports completely.[4] To make adjustments, you must have uploaded the conversions with an order ID in the first place.[4]
Google’s adjustment rules in short:
- New conversions and adjustments cannot be uploaded in the same file; they must be sent separately.[4]
- The adjustment time must be after the conversion time and before the upload time.[4]
- If you cannot use an order ID, you can match with the GCLID and conversion time from the original upload.[4]
- If RESTATE brings the value down to zero, the conversion is withdrawn automatically.[4]
- An incorrect adjustment cannot be changed later; it has to be re-uploaded with the correct value.[4]
This mechanism is critical in sectors with high refund and cancellation rates. For example, if a sale with a deposit is later cancelled but stays in reports, the bid strategy overvalues the searches that drove it. Linking the “cancelled” stage in the CRM to a RETRACT upload prevents that bias.
Why are uploaded offline conversions not showing?
The most common reasons uploaded offline conversions do not show are waiting times, time zone errors, conversion name mismatches and clicks that fall outside the conversion window. According to Google, it can take 24-48 hours for data to be processed and reflected in reports.[3] The first check is not to expect results before that time has passed.
The EXPIRED_EVENT error in the Google Ads API documentation means the click happened before the conversion action’s click-through conversion window.[5] If your sales cycle is longer than that window, you need to check the conversion action’s setting. Using the wrong template while enhanced conversions for leads is on also produces errors. Google says that if this feature is enabled at account level, you should use the template that includes user-provided data columns.[3]
When diagnosing a problem, tracing a single record end to end is the fastest route. Click your own ad, fill in the form with test data and check how the GCLID appears in the CRM. Then upload that record to a test conversion action and check the row result in the upload history. The first point where the ID is cut or changed is the place you need to fix.
How do you handle KVKK and consent in offline conversion data?
Offline conversion data relates to personal data, so it must be handled under KVKK (Turkey’s personal data protection law) and, depending on the target market, under GDPR. Google requires you to give users clear and comprehensive information on the sites where you collect data and to obtain consent where the law requires it.[1] This obligation also falls on the team preparing the upload file.
The file has two consent columns. “Ad User Data” carries consent for sending user data to Google for advertising purposes. “Ad Personalization” shows consent for ad personalisation.[3] The Google Ads API documentation also recommends filling the consent field and notes that otherwise conversions may not be attributable.[5] Keep these values consistent with your site’s Consent Mode v2 setup and the consent record in your CRM.
If you send user data, email and phone must be hashed with SHA-256. According to Google, this data must be pre-hashed for scheduled uploads, and normalisation steps such as converting to lowercase must happen before hashing.[3] In sensitive fields such as healthcare, never add a column containing a diagnosis, treatment name or health information to the file. It is also safer to choose a generic conversion name such as “Sale_Completed” that does not reveal the treatment.
Handling the click ID securely on the server side is also related to this topic. I explained the approach of moving personal data between the CRM and the ad platform without passing it through the browser in the server-side tracking post.
Conclusion
Google Ads offline conversion import is the most direct way to steer ad budget from form counts to real business results. The setup has three parts: moving the click ID into the CRM, creating a conversion action for each CRM stage and uploading those stages regularly in the right format. In 2026, choose Data Manager for new setups, and the Data Manager API if you have your own software.
To start, pick one CRM stage, upload it to a secondary conversion action for a few weeks and watch the matches. When the data becomes consistent, make the action primary and connect cancellations through adjustment files. You can see how I plan measurement together with campaign management on my performance marketing page, and read about my experience on the about page.
Key terms
- Offline conversion import
- Offline conversion import is a method for uploading results that happen outside the website after an ad click, such as sales or qualified leads, into Google Ads. Google Ads matches each uploaded record to the click through GCLID or user data and records it as a conversion for the campaign.
- Google Ads Data Manager
- Google Ads Data Manager is the interface where first-party data is connected to a Google Ads account and activated for conversions and audiences. It imports offline conversions on a schedule from Google Sheets, SFTP, HTTPS, cloud storage, data warehouses and CRM connectors such as HubSpot and Salesforce.
- Conversion adjustment
- Conversion adjustment is an upload that changes the value of a previously recorded conversion or withdraws it from reports completely. The RESTATE type updates the value and the RETRACT type withdraws the conversion; matching is usually done with the order ID.
- Order ID
- Order ID, also called transaction ID, is an identifier that is unique to each conversion and prevents the same sale from being counted twice. Google Ads uses this ID to find the original conversion when you later restate its value or retract it.
Frequently asked questions
What does Google Ads offline conversion import do?
Offline conversion import lets you upload results that happen after an ad click, over the phone, in store or through a sales team, back into Google Ads. Google Ads matches these records to the click and records them as conversions for the right campaign. Your bid strategy can then learn from real sales or qualified leads instead of form counts.
Is GCLID required to upload offline conversions?
In classic offline conversion import, GCLID is the main matching key and the Google Click ID column must not be removed from the file. If you use enhanced conversions for leads, hashed email and phone are also used for matching. Google recommends sending the GCLID alongside user data whenever you have it.
When do uploaded offline conversions show up?
According to Google, it can take 24-48 hours for uploaded data to be processed and reflected in reports. If you created a new conversion action, wait 4-6 hours before the first upload. Conversions uploaded during that window may take 2 days to appear in reports.
Can you still upload offline conversions with the Google Ads API?
According to Google's Google Ads API documentation, since June 15, 2026 new offline conversion and enhanced conversions for leads implementations must use the Data Manager API. UploadClickConversions requests fail for projects that made no uploads within a specific date range. Google also recommends migrating existing integrations to the Data Manager API.
How do you remove a cancelled sale from Google Ads?
A cancelled sale is withdrawn with a conversion adjustment file using the RETRACT type. For a sale whose value changed, you use the RESTATE type with the new value. Adjustments match the original conversion through its order ID and cannot be uploaded in the same file as new conversions.
Sources
- Google Ads Help: About offline conversion imports
- Google Ads Help: Set up offline conversions using Google Click ID (GCLID)
- Google Ads Help: Import conversions from ad clicks into Google Ads using files (legacy)
- Google Ads Help: How to adjust your conversions
- Google Ads API: Upload offline click conversions
The full topic: Google Ads guide ↗ · Tracking guide ↗