Google Ads Offline Conversion Validator

Validate your CRM conversion export before uploading to Google Ads. Catch formatting syntax errors, invalid GCLIDs, broken timezone offsets, and missing columns before Google rejects your file.

CSV Upload / Paste

Expected header: Google Click ID, Conversion Name, Conversion Time, Conversion Value, Conversion Currency

0 rows detected
Validation Status

Ready to inspect CSV

Paste your Google Ads offline conversions CSV or click 'Load Valid Sample CSV' to verify columns, click ID integrity, and timestamp syntax.

Upload Requirements Audit

  • Required Header ColumnsAwaiting input
  • GCLID / Click ID ValidityAwaiting input
  • Timezone Offset FormatAwaiting input
  • Currency Code Format (ISO 4217)Awaiting input
INTERACTIVE DEMO Want to test how this tool works?
Save these results as a PDF report A clean, branded copy to share with your team or client.
Free PDF report

Where should we put your name on the report?

Your PDF downloads straight away. Your tool data never leaves your browser.

Jobair Mahmud, Web Analytics & Tracking Architect
Tool Creator

Jobair Mahmud

Founder & Tracking Architect

100% Top Rated
★★★★★
5.0 / 5.0

Uploads keep failing or leads lack a GCLID?

I set up offline conversion tracking end to end: GCLID capture, CRM fields, automated uploads and Enhanced Conversions for Leads.

Fix my offline conversions →

How to use the Google Ads Offline Conversion Validator

Google Ads rejects offline conversion uploads for small formatting problems: a conversion name that doesn't match, a time without a time zone, a click ID that was cut short. This validator checks your rows before you upload, so you fix errors once instead of after every failed import.

Step by step

  1. Paste a few rows from your CSV or CRM export, including the click ID, conversion name, time, value and currency.
  2. Read the check for each column: click ID, time zone format and currency code.
  3. Fix the source of any error in your CRM or export, not just the file, so future uploads pass too.
  4. Upload a small test batch in Google Ads → Goals → Conversions → Uploads and read the row-level report.

How to read your result

All checks pass

The format is right. If conversions still don't appear, check that the conversion action exists and the clicks are within its window.

Time zone fails

Add the time zone offset to every conversion time (for example +00:00). Without it, conversions can appear to happen before the click.

Click ID fails

The GCLID was truncated or changed, often by a CRM field length limit or a spreadsheet. Store it in a dedicated text field.

Common mistakes

  • Conversion name in the file not matching the conversion action exactly.
  • Uploading conversions older than the conversion action's click-through window.
  • Spreadsheets converting long click IDs or dates into a different format.

Questions

Why do uploaded conversions take time to show?

Google Ads can take a few hours to process uploads, and conversions are reported on the date of the original click, not the upload date.

What if leads arrive without a GCLID?

Enhanced Conversions for Leads can match them with a hashed email or phone number instead of the click ID.

Uploads keep failing or leads lack a GCLID?

I set up offline conversion tracking end to end: GCLID capture, CRM fields, automated uploads and Enhanced Conversions for Leads.