Clarvivo

Free tool by Clarvivo · no login

Validate your offline conversion upload before Google Ads rejects it

Upload a CSV to catch missing click IDs, conversion names, timezone-safe dates, duplicate identifiers and malformed values before it reaches Google Ads.

Offline conversion upload CSV

Validate a Google Ads offline conversion file before upload. We check identifiers, action names, timestamps, values and currency without sending it anywhere.

This tool answers: Will my Google Ads offline conversion file be accepted and matchable?

Enable JavaScript to run the check — the diagnosis itself is free and needs no account.

Why this happens

Offline conversion imports are how Google Ads learns which clicks became qualified leads, closed deals or in-store sales. For lead-generation businesses they are often the most important signal in the account. They are also fragile: one wrong column name, a timestamp without a timezone, or a click ID copied with a trailing space, and rows are rejected or silently fail to match.

Google Ads tells you about problems after the upload, through diagnostics that can take hours to appear and don't always say which rows failed or why. By then you've lost a day of signal, and if the upload runs on a schedule, the same broken file keeps going in.

This validator checks the file before it reaches Google Ads. It looks for the columns Google requires, the identifiers it can match, and the formats it accepts, and tells you which lines need fixing.

Next checks

These answer the questions this one tends to raise.

How this check works

So you can trust the result — and your developer can verify it.

  1. We check the required columns

    An offline conversion upload needs a conversion name (matching the action in Google Ads), a conversion time and a click identifier (gclid, gbraid or wbraid). Missing columns are reported first, with the headers we did find.

  2. We validate every row

    Each row is checked for a click identifier, a conversion name, a timestamp with a timezone, and, where present, a numeric value and a currency code. Problems are listed with their line numbers.

  3. We never send the file anywhere

    Validation happens on the file you upload. Nothing is forwarded to Google Ads, and the file isn't stored.

Common causes and fixes

Timestamps without a timezone
Google Ads needs to know when the conversion happened relative to the click. Use a format like 2026-10-05 14:30:00+00:00 or include a timezone column, and make sure it's after the click time.
Click IDs missing from CRM records
If the gclid was never captured on the form, there's nothing to upload. Capture gclid, gbraid and wbraid into hidden fields on the landing page and store them on the lead.
Conversion name doesn't match
The name in the file must match an offline conversion action in the account exactly, including capitalisation. Typos create unmatched rows.
Value or currency formatted for humans
Values like "1,200.00 USD" fail. Use a plain number in the value column and an ISO currency code in its own column.
Conversions too old
Google Ads only accepts conversions within the action's click-through window, up to 90 days after the click. Upload regularly rather than in large backfills.

Frequently asked questions

Which click identifiers does it accept?
gclid, gbraid and wbraid. gbraid and wbraid are used for iOS traffic where gclid isn't available.
Does it check whether my click IDs are valid in Google Ads?
It checks presence and format. Whether a specific click exists in your account can only be confirmed by Google Ads after upload.
Can I upload Enhanced Conversions for leads data here?
This validator focuses on click-ID based offline conversions. Hashed user data for enhanced conversions for leads follows a different template.
What does a healthy file look like?
Every row has a conversion name, a timezone-qualified time after the click, a click ID, and optionally a value with currency. The validator marks that as ready for upload.
What should I do after it passes?
Upload a small sample first and check the conversion action's diagnostics in Google Ads, then run the Offline Conversion Match-Rate Diagnoser to see what share of conversions you can match at all.

Keep offline revenue connected to the original click.

Clarvivo makes the acquisition-to-payment path observable before an upload becomes your only evidence.

Connect offline conversions to revenue

What this tool reads, and what it keeps