Offline Conversions Not Importing? How to Fix Google Ads

1. Introduction

Some sales close away from your website — a phone deal, a showroom visit, a signed quotation. Offline conversion import sends those back to Google Ads and matches each one to the click that started it. It is the bridge between your CRM and your ad account.

When that bridge holds, Google sees which keywords and audiences produce real customers, not just enquiries. When it breaks, you are back to optimising on form-fills — paying for leads that never buy. The good news: offline conversions not importing is one of the most fixable problems in the platform, because every failure leaves a clear trace.

2. Are Your Offline Conversions Really Not Importing?

Quick Answer: Your offline conversions are not importing when uploaded rows never appear as conversions. The offline diagnostics page shows errors or “no recent conversions”, the imported count sits far below what you uploaded, and your offline conversion column stays near zero. First rule out plain conversion tracking not working, then look at the import itself.

Before you rebuild anything, confirm the problem is the import — not the tracking underneath it. The clearest place to look is the offline data diagnostics page, which lists exactly what Google received and what it rejected. Check the signals below against a healthy account.

If most rows sit in the right-hand column, your import is the problem and there is real work to do. Google’s own guide to fixing discrepancies and errors in offline conversion imports is the fastest way to read the exact error behind the gap.

2. Why Offline Conversions Fail to Import

Quick Answer: Offline conversions fail to import for a few repeatable reasons. The GCLID expired past the 90-day window, the date or time-zone format is wrong, the conversion action was never set up as an import type, or the upload simply never ran. Each one throws its own error, and each has a direct fix.

Google is not being difficult. The upload has to match a real click to a real sale, and it rejects any row it cannot line up cleanly. These are the causes we see most often when a Malaysian account arrives with offline conversions not importing:

• The GCLID expired. The Google Click ID is only kept for a limited window — Google’s guidance on offline conversion imports notes clicks older than 90 days will not import. A slow sales cycle or a monthly upload misses the window.
• Wrong date, time, or time-zone format. An incorrectly formatted or missing time zone in the conversion-time column is one of the most common upload errors of all.
• The conversion action is set up wrong. If the action is not created as an “import” type — or is not set to count — rows upload but never become conversions.
• The upload never runs. A one-off manual upload that nobody repeats means new sales stop flowing after the first file.
• The GCLID was never captured. If your lead form does not store the click ID in the first place, there is nothing to match later.

An import failure is almost never a Google fault — it is a row that does not match. Fix the match, and the sales appear.

3. Where Offline Import Failures Actually Come From

Quick Answer: Across accounts we clean up, most offline import failures cluster in a few places — expired GCLIDs from slow upload cycles, time-zone and date formatting errors, and conversion actions set up wrong. Knowing the split tells you what to fix first, and it is rarely the thing people blame.

Not all failures are equal. Before rebuilding the whole pipeline, know where the rows actually drop. The breakdown below reflects the typical pattern we find when auditing accounts where offline conversions are not importing — it shows why upload timing and formatting come first, ahead of a full CRM rebuild.

The lesson is simple: more than half the lost rows come from timing and formatting, not from a broken system. If the missing sales are also making your account look like sales dropped suddenly, this is often the hidden reason why.

4. How to Fix Offline Conversions Not Importing, Step by Step

Quick Answer: Fix it in order. Read the diagnostics error, confirm the conversion action is an import type, correct your GCLID capture and 90-day upload window, standardise the date and time-zone columns, then automate the upload so it runs daily. The early steps clear the most failed rows.

Do not rebuild your CRM integration blindly. Work through the causes in order, so each fix builds on the last:

How to fix offline conversions not importing

Seven steps, worked top to bottom, to get your real sales flowing back into Google Ads.

1. Read the offline diagnostics error. Open the offline data diagnostics page and note the exact message. Google’s help on fixing import discrepancies and errors maps each message to its cause.
2. Confirm the conversion action is an import type. Check the action exists, is set to “Import” (from clicks or from a CRM), and is set to count — not paused or marked secondary by mistake.
3. Fix GCLID capture and the upload window. Make sure the click ID is stored on the lead form, and upload well within 90 days. For long sales cycles, consider enhanced conversions for leads, which matches on hashed customer data instead.
4. Standardise date, time, and time zone. Use the exact format Google expects and include a valid time zone on every conversion-time value. This clears the single most common upload error.
5. Check currency and column headers. Match column names to Google’s template and use a valid currency code (MYR) so value-based rows are not rejected.
6. Automate the upload. Schedule the file or connect the CRM through the API or a connector so uploads run daily, not whenever someone remembers.
7. Re-upload and verify. Push the corrected file, then check the diagnostics and reports after 24–48 hours to confirm rows now import.

Once real sales import cleanly, Smart Bidding finally has something worth optimising toward — and it stops chasing cheap leads that never close.

5. Import Requirements That Keep Conversions Flowing

Quick Answer: Five requirements keep offline conversions importing cleanly — a captured GCLID, an upload inside the 90-day window, an import-type conversion action, a correct date and time-zone format, and a scheduled upload. Each fixes a different failure, so meet them together, not one at a time.

Once the account is fixed, these requirements keep it fixed — each closes a specific way rows drop out. Google’s guidelines for importing offline conversions spell out the field-level detail; the table matches each fix to the error it clears.

Met together, these requirements keep your true sales flowing back to Google — which is what lets bidding reach real buyers instead of the wrong audience.

6. What Fixing Offline Import Is Worth

Quick Answer: Fixing offline import does not cost more — it makes the same budget smarter. Once real sales feed back to Google, Smart Bidding optimises toward buyers, so cost per real sale falls sharply even though spend stays flat. The gain comes from better signal, not from spending more.

The real prize is what the same budget delivers once Google can see actual sales. Hold spend at RM4,000 a month and watch cost per real sale drop as imports move from broken to clean. The path below mirrors the turnaround we see when an account moves from form-fill signals to full offline import. It is the same shift that lifts a campaign that is short of conversions to optimise on.

Moving from form-fill signals to clean offline import roughly halves the cost per real sale at the same spend — because Google is finally bidding toward customers, not clickers.

7. Mistakes That Keep Offline Conversions From Importing

Quick Answer: A few habits keep offline conversions from importing: uploading too late, never checking the diagnostics page, formatting the time column by hand each month, and treating the upload as a one-off. Each leaves rows unmatched and sales invisible to Google.

These are the patterns we see most when an account stays stuck with offline conversions not importing. Avoid them and the fixes above hold far longer:

• Uploading too late. A monthly upload routinely misses the 90-day GCLID window for slow-closing deals, so the oldest — often biggest — sales never import.
• Never opening diagnostics. The offline data diagnostics page names the exact error. Skip it and you are guessing at what to fix.
• Hand-formatting the time column. Manual date and time-zone edits each cycle reintroduce the same formatting error every time.
• Treating upload as one-off. A single import at setup, never repeated, means new sales stop flowing the moment the first file is done.
• Ignoring the reports check. Assuming an upload worked without confirming in reports hides silent failures for weeks. This can mimic conversion tracking not working when the real fault is the import.

8. Conclusion

Offline conversions not importing is a data problem, and data problems are fixable. Google only rejects rows it cannot match, so the fix starts with reading the diagnostics error, then correcting what you upload: the conversion action, the GCLID, the date and time-zone format, and the schedule.

Do that in order and your real sales quietly start flowing back into the account — cleaner signal, a lower cost per real sale, and bidding aimed at buyers instead of form-fillers. If you would rather have the whole pipeline set up and monitored for you, our team handles it through managed Google Ads. Our Google Ads agency rebuilds offline conversion tracking for Malaysian businesses every week.

9. Frequently Asked Questions

1. How do I know if my offline conversions are not importing?

Open the offline data diagnostics page in your conversion settings. If it shows errors or “no recent conversions”, the uploaded row count is far higher than the imported count, and your offline conversion column sits near zero, your offline conversions are not importing. A large gap between what you uploaded and what Google accepted is the clearest single sign.

2. Why did my offline conversions suddenly stop importing?

The most common reason is timing — clicks older than 90 days no longer match, so a slow upload cycle quietly drops your biggest deals. Other sudden causes are a changed date or time-zone format, a conversion action that was edited or paused, or a broken CRM connection. Check the diagnostics page first; it names the exact error behind the stop.

3. Does the 90-day GCLID window really block imports?

Yes. Google keeps the Google Click ID for a limited window, and conversions uploaded more than 90 days after the click will not import. If your sales cycle runs long, upload more frequently so deals land inside the window, or switch to enhanced conversions for leads, which matches on hashed customer data instead of the click ID.

4. What formatting errors stop offline conversions from importing?

The biggest one is an incorrect or missing time zone in the conversion-time column — it is among the most common upload errors of all. Wrong date formats, mismatched column headers, and an invalid currency code (use MYR) also cause rows to be rejected. Match Google’s template exactly and include a valid time zone on every row.

5. Should I fix offline imports myself or get an agency?

If the diagnostics error is a simple format or window fix, you can often correct it yourself using Google’s help pages. If imports keep failing, the CRM connection is unstable, or Smart Bidding has run blind for weeks, an agency can rebuild and automate the pipeline so it stays clean. A blind account usually costs far more than the fix.