Back to guides

Offline Conversion CSV Checklist

Use this checklist before uploading an offline conversion CSV to Google Ads preview. Google Ads supports additional template formats, but this local checker only validates CSV files.

Last updated: June 6, 2026. Re-check the official Google Ads documentation before changing production import workflows.

Choose the workflow before reading the report

Click ID upload

Use GCLID, GBRAID, or WBRAID fields. Keep one click identifier per click-conversion row when the workflow requires exactly one.

Scheduled/pre-hashed user-data upload

Use pre-hashed user-provided data where required by your workflow. Plain email, phone, first name, last name, or street address values should be reviewed as blockers.

Manual unhashed review

Manual workflows may allow Google Ads to hash some plain values, but you still need valid email/phone formatting and final preview in Google Ads.

Data Manager / ECL boundary

Do not treat this local checker as a Google Ads Data Manager schema validator or an official account setup check.

CSV template items

Identifier

Every row needs a usable identifier for the chosen workflow: a valid click ID, valid email, valid phone, or complete address-style user data. Location-only fields such as country or postal code are not enough.

Conversion Name

Match the conversion action name used in Google Ads. Empty values are a high-risk upload problem.

Conversion Time

Use a parseable date and time. Include a row-level timezone or a file-level Parameters:TimeZone row when your export uses one timezone.

Value and Currency

Use numeric conversion values and ISO 4217 currency codes such as USD, EUR, GBP, SGD, or JPY.

Consent

If your workflow uses consent signals, review Ad User Data and Ad Personalization values before previewing the file.

Order ID and duplicates

Use Order ID when appropriate, then check repeated identifier + conversion name + conversion time combinations before importing.

What this local checker cannot verify

The checker reads a CSV in your browser and reports file-level risks. It does not connect to Google Ads, Data Manager, Google Ads API, your CRM, or your account. It cannot confirm conversion action ownership, click ownership, account permissions, customer data terms, Data Manager schema rules, template compatibility for every file format, import preview status, or final attribution. Always preview and validate the corrected file in the official Google Ads workflow.

Official sources used

These links support the page boundary and the local checks described here. They are not copied into the checker as a complete Google Ads validator, and the checker should not be described as official Google guidance.

Check a CSV