Offline Conversions Template Builder for Google Ads

How to use the offline conversions template builder for Google Ads

This tool fills in the Google Ads offline conversions template for you. It reads the export from your CRM or spreadsheet and writes the click-conversion file described on Google's import conversions from ad clicks help page: the Parameters row, Google's documented header names, and one conversion per row.

1. Export your sales or qualified leads with each lead's saved GCLID and conversion date. A value and the click date help too.
2. Drop the file in. CSV and Excel files both work. The tool finds the GCLID, date and amount columns by their names, including HubSpot's Google ad click id and Salesforce's GCLID__c.
3. Set the time zone and date format. Pick the time zone your CRM uses. If your dates look like 03/04/2026, tell the tool whether the day or the month comes first.
4. Type the conversion name. It must match your conversion action in Google Ads exactly. Skip this if your file already has a conversion name column.
5. Read the problems, then download. Rows Google would reject are left out with the reason. Clicks under 6 hours old go into an “upload later” file.

Google Ads offline conversion CSV example

A finished file looks like this. The first line sets the time zone; the second holds Google's headers. A filled-in Google template works as input too: its own Parameters line is used to read the times.

Parameters:TimeZone=America/New_York
Google Click ID,Conversion Name,Conversion Time,Conversion Value,Conversion Currency
Cj0KCQjw…BwE,Qualified lead,2026-10-14 14:30:00-0400,1250,USD

How to upload click conversions in Google Ads

1. Check your conversion action. In Goals › Conversions › Summary, the action's source must be Import from clicks. If you just created it, wait 4–6 hours before the first upload; Google says early uploads can take two days to show.
2. Open the uploader. Go to Goals › Conversions › Uploads and click the plus button. Choose Upload a file as the source and pick the CSV you downloaded here.
3. Preview, then apply. Use Preview for Google's own check, then Apply file. Upload to the account that owns the conversion action (the manager account with cross-account tracking).
4. Download Google's results. Use Download errors on the upload for a result per row, and fix those rows in your CRM so they don't come back.
5. Report by conversion time. Imported conversions are dated by the click, so compare with your CRM using the Conversions (by conv. time) column.

Common Google Ads offline conversion import errors

“This click is too old for its conversion to be imported” (older than 90 days)

Google keeps a GCLID for 90 days, and some actions have a shorter window. Upload weekly, or import an earlier funnel step, such as a qualified lead.

“Conversion date precedes click date”

The time in the file is earlier than the click — usually a time zone mix-up, or a date-only CRM field read as midnight. Pick the right time zone above; date-only rows get the end of the day (or the current time, if dated today).

“Click too recent”

The click happened less than 6 hours ago. Nothing is wrong with the row: upload the “upload later” file after 6 hours.

“We cannot find this conversion name in the target account”

The name has a typo, different capital letters or an extra space, or the file went to the wrong account. The results chart lists every name in your file, so variants stand out.

“No Google Ads conversion types were defined when this GCLID's click occurred”

The conversion action was created after the click. Create the Import from clicks action before the clicks you plan to upload.

Google Ads conversion time format: the patterns Google accepts

These are the patterns listed on Google's help page for click-conversion files. “+z” means a plus or minus sign and a 4-digit GMT offset; “zzzz” means a time zone name.