The Files Associated With This Add-on Could Not Be Found. Please Upload Them and Try Again.

Import conversions from advertising clicks into Google Ads

Importing conversions lets you come across how your online ads affect offline sales and other valuable actions. This commodity explains how to set a file to import the conversions you receive from clicks on your ads into Google Ads.

For instructions on how to import conversions from calls, read Import phone call conversions.

Earlier you begin

Before importing conversions, brand sure you've followed all the instructions to prepare offline conversion tracking using GCLID or fix up enhanced conversions for leads.

Y'all can import your data into Google Ads by uploading or linking to a file through the Google Ads interface, or past transmitting the data through the Google Ads API (AdWords API). This article explains how to import conversions by uploading or linking to a file. If you'd like to transmit the data through the Google Ads API (AdWords API), refer to this help article from our API Developer's Guide.

Note: Starting in June 2021, you'll no longer be able to upload offline conversions from a client business relationship that has opted in to using manager business relationship-level conversion measurement. You'll receive an error message for any conversions you're uploading using your client account, and you'll need to go to the manager account and upload conversions from there. Refer to Changes to offline conversion uploads for client accounts.

Instructions

Follow the instructions below to set up and import your conversions data.

1. Prepare your data for import

Download a template based on the type of conversions you'd like to upload (download: Excel, CSV, or Google Sheets). You tin likewise download templates from the Google Ads interface:
1. Sign in to your Google Ads account.
2. Click the tools icon in the upper right corner of your account.
3. Under "Measurement", click Conversions.
4. In the card on the left, click Uploads.
5. Click the plus push .
6. Click View templates.
7. Select the correct template based on the method you're using: "Conversions from clicks (enhanced conversions for leads)" or "Conversions from clicks (using Google Click Identifier)".
Observe the following guidelines for uploading spreadsheets:
If whatsoever of the conversions yous import are within one day of the click, Google Ads may not exist able to tape them yet. Equally a all-time practise, upload an extra day's worth of data with each import. Google Ads won't count duplicate conversions, and you'll see an fault message letting you know which conversions are duplicates. Notation that previously, duplicate conversions were ignored, but did not brandish an error and so if you frequently upload duplicates, you may encounter more errors than before. To determine whether a conversion is unique, Google Ads uses the conversion activity name, time of conversion, and the relevant unique identifier associated with a conversion.

Note: If y'all're using external attribution with your conversion import, refer to Near importing externally attributed conversions beneath for the appropriate upload template and additional features.
- Be sure not to remove the column that begins with "Google Click ID" or your import will fail.
- Brand certain your information doesn't include additional columns or any personal information.
- If you lot want Google Ads to import your conversions automatically on a regular schedule (refer to Step 2: Import your conversions), you demand to use Google Sheets or link to a file over HTTPS or SFTP.
Utilize ane of the post-obit formats to enter the time zone (don't enclose the fourth dimension zone in quotes or other special characters):
- Enter your time zone ID. This method is recommended to avert errors during daylight savings time transitions. Example - Parameters:TimeZone=America/Chicago
- Enter your GMT offset by indicating + or - so the 4 digit time difference. (For instance, New York's offset is -0500, and Berlin's is +0100). If you use Greenwich Hateful Time, then but enter +0000. Example - Parameters:TimeZone=-0500
Next, add a new row for each offline conversion, filling in the columns as follows:
- If yous're importing enhanced conversions for leads:
  - E-mail or telephone number nerveless from your lead form: You must include either of the fields from your website lead form that you lot previously configured in global site tag or Google Tag Managing director. We recommend using e-mail. Larn more about setting upward enhanced conversions for leads
- If you're importing conversions from clicks using Google Click ID:
  - Google Click ID: The GCLID that led to the offline conversion. (If yous haven't already, follow the instructions to set offline conversion imports to learn how to get this.)
- Conversion Proper name: The name of the conversion action (for case, "lead qualified" or "contract signed") that you'd similar to import this conversion for. It's important that you must utilise the aforementioned spelling and capitalization that you lot did when y'all created this conversion activity in your Google Ads account.
- Conversion Time: The date and time that the conversion occurred. See the table below for a listing of acceptable engagement formats (for instance, MM/dd/yyyy HH:mm:ss). Y'all can add a fourth dimension zone to the conversion time by using one of the last 4 formats listed. Supervene upon"+z" with the GMT first by indicating + or - then the four digit fourth dimension difference (for instance, New York'south offset is -0500, and Berlin's is +0100), or replace "zzzz" with the fourth dimension zone ID from the codes and format listing.
If you're using enhanced conversions for leads with a scheduled upload, and so you must hash the telephone number and email fields using SHA256. Hashing is not required for a transmission, one-time upload with enhanced conversions for leads.

Example: You tin use the case method below to hash your data for enhanced conversions for leads using Google sheets:

Make a copy of the spreadsheet template.
In the bill of fare bar, click Extensions and select Apps Script.
Click the Triggers icon.
Select Create new trigger.
In the menu, select the "autoHash" function and set result blazon to "On edit"
Click Save.

The data you lot enter in the e-mail and telephone number fields will be automatically hashed.

Format	Examples
MM/dd/yyyy hh:mm:ss aa	"08/14/2012 5:01:54 PM"
MMM dd,yyyy hh:mm:ss aa	"Aug 14, 2012 5:01:54 PM"
MM/dd/yyyy HH:mm:ss	"08/fourteen/2012 17:01:54"
yyyy-MM-dd HH:mm:ss	"2012-08-14 13:00:00"
yyyy-MM-ddTHH:mm:ss	"2012-08-14T13:00:00"
yyyy-MM-dd HH:mm:ss+z	"2012-08-xiv 13:00:00+0500"
yyyy-MM-ddTHH:mm:ss+z	"2012-08-14T13:00:00-0100"
yyyy-MM-dd HH:mm:ss zzzz	"2012-08-xiv 13:00:00 America/Los_Angeles"
yyyy-MM-ddTHH:mm:ss zzzz	"2012-08-14T13:00:00 America/Los_Angeles"

Conversion Value: (optional field) A number representing the value that you place on the conversion. Information technology could reflect a currency value, or you can cull to enter relative values (i.e. ane-10). If y'all exit this field bare, Google Ads volition automatically apply the "conversion value" that you lot defined in Step 2.eight when you created your new offline conversion action.
Conversion Currency: (optional field) The currency in which your conversion value is provided. You'll utilize this if yous study conversion values in more than 1 currency, or have multiple accounts that are billed in different currencies. Use 3-character ISO 4217 currency codes, such as USD for The states dollars, and JPY for Japanese yen.

Externally attributed conversions

If you use your external attribution system to attribute your conversions across multiple clicks then y'all will want to apply external attribution with your conversion imports. Externally attributed conversion actions permit you to import partial conversion credits for each click.

To use external attribution with your imports, make certain you select Use external attribution when you create your conversion action in Google Ads (every bit specified in Step ane, detail xiv of these instructions). When you're prepare to upload conversions with partial credit, make certain you download our conversion import template for external attribution (download: Excel, CSV, or Google Sheets). There are also a few other things to continue in mind:

Be sure not to remove the column that begins with "Google Click ID", or your import will fail.
Brand certain your information doesn't include additional columns or any personal information.
Remember to gear up the TimeZone value in the "Parameters" row and/or in your "Conversion Time" column. Learn more about setting up your currency and time zone
You need to enter the name of the attribution model you're using to assign fractional conversion credit. For example, this could be "Linear" or "Data-driven".
If you choose to include conversion value, information technology should be the fractional value respective to the attributed conversion credit (refer to the post-obit instance below).
The amount you enter in the "Attributed Credit" cavalcade should be greater than zero and less than or equal to one.
The "Conversion Value", and "Conversion Currency" columns are both optional.

An example of how to use the conversion import template with external attribution is when you lot're tracking purchases and collecting the GCLID from each client click. It might accept 3 clicks before a client purchases a US$100 item on your website. I click might come on a Google Ads display advert, one click from another advertising network and a last click on a Google Ads search advertizing. If you lot use a linear attribution model, then your upload would look like this:

Parameters:Attribution Model = linear
Parameters:TimeZone=-0800	# Attributed credit should exist between 0 and ane #	# Optional #	# Optional #
Google Click ID	Conversion Proper name	Conversion Fourth dimension	Attributed credit	Conversion Value	Conversion Currency
googleclickid1	External Attribution Conversion action proper noun	05/01/2017 3:42:01 PM	0.33	33.33	USD
googleclickid2	External Attribution Conversion action name	05/01/2017 3:42:01 PM	0.33	33.33	USD

2. Import your conversions

To import your offline conversions to Google Ads, you'll need to upload your conversion file to the Google Ads account that manages your conversions. If you lot have cross-account conversion tracking fix upwardly, you lot should upload conversions at the manager account level. You can either upload a file in one case or create a schedule to regularly upload a file that you keep online. Follow the instructions for a onetime upload or scheduled uploads beneath, depending on how you want to import your conversions.

You can create a custom variable by using conversion tracking tags or uploading offline conversions.

Important: Later creating a new conversion activity, wait 4-six hours, earlier uploading conversions for that conversion action.

One-fourth dimension upload of your conversions

Sign in to your Google Ads account.
Click the tools icon in the upper right corner of your business relationship.
Under "Measurement", click Conversions.
In the menu on the left, click Uploads.
Click the plus button .
Click the Source driblet-down, and select the source of your file. Yous tin upload a file from your reckoner or Google Sheets, or transfer it over HTTPS or SFTP.
Based on the source y'all selected, choose from the options below:
- If you lot selected "Upload a file" or "Google Sheets", click Choose file to find and select the file that contains your offline conversion information.
- If you lot selected HTTPS or SFTP, enter the file URL and the username and password to admission the file.
  
  Note: If yous select SFTP and get a "File not institute" error, try placing a double-slash ("//") between the file path and proper noun. For example, SFTP://sftp.mysite.com/conversions // conv.csv.
Indicate if your user data is hashed or unhashed (unhashed preferred). Unhashed information volition exist hashed on your computer by Google before uploading the user information; hashed data indicates that yous have pre-formatted your file and hashed the private user information using the SHA256 algorithm, which is the industry standard for one-mode hashing.
- Note: If you utilise the "hashed" method, make sure that your first-party data isn't re-formatted before existence hashed. Your first-political party data should exactly match what was entered in the lead form when information technology was collected before being hashed.
To import a file's contents without previewing the upload results, click Employ and skip the remaining steps. To preview the upload results, click Preview. The file preview highlights the number of conversions that will be imported into your account. The preview likewise includes any errors in your file. Y'all tin can fix the errors in your file and upload information technology again, or ignore the errors.
- When the preview is ready, click Details to see some of the content from your file. The errors volition exist shown commencement.
- To run across all of your file contents, click More.
- Click Apply file. A progress bar at the bottom of the page will notify you when the conversions in your file take finished importing. Click Details in the progress bar to run into all the conversions that were imported.

You tin view files that you lot've uploaded but haven't applied, besides as files y'all've uploaded and applied. Acquire more most viewing your uploaded files

Upload your conversions on a schedule

Google Ads can automatically import your conversions on a regular schedule. Yous'll demand to create a file with your conversions in Google Sheets or shop the file online with HTTPS or SFTP. If you're using enhanced conversions for leads, you must hash the information in your file before it is uploaded. To schedule file uploads, follow these steps:

Sign in to your Google Ads business relationship.
Click the tools icon in the upper right corner of your account.
Under "Measurement", click Conversions.
In the menu on the left, click Uploads.
Click Schedules along the meridian of the page.
Click the plus button .
Click the Source drop-downwardly, and select the source of your file. You can upload a file from Google Sheets, or transfer it over HTTPS or SFTP.
Based on the source you selected, choose from the options beneath:
- If you lot selected "Google Sheets", click Cull file to detect and select the file that contains your offline conversion information.
- If y'all selected HTTPS or SFTP, enter the file URL and the username and password to admission the file.
  
  Note: If you select SFTP and get a "File non institute" error, effort placing a double-slash ("//") betwixt the file path and proper name. For example, SFTP://sftp.mysite.com/conversions // conv.csv.
Click the Frequency drop-down, and select how often you'd similar your file to be imported.
Click the Time drop-downward, and select when your file will be imported.
Click Save & preview. The preview indicates if the schedule saves successfully or if it doesn't. A schedule might not save if Google Ads tin't reach the file source due to an incorrect username or password, or if the file isn't formatted properly.
Click OK to return to the Schedules page. The Schedules folio lists all of your scheduled uploads.

Notation: If in that location's a problem with your scheduled upload, then you lot'll run into an alert in your account and receive an email. You'll demand to check your online file to fix the problem.
To change your scheduled upload, click Options under the "Actions" column and choose from the options beneath:
- Click Edit to change the settings for a scheduled upload.
- Click Break to terminate the scheduled uploads for a file.
- Click Resume if the scheduled uploads for a file were paused and you'd like to resume the scheduled uploads.
- Click Remove if y'all don't need to upload the conversions in the file anymore.
Y'all can't change the scheduled upload options if your Google Ads account has read-only access.

3. View your results and fix issues

It'due south mutual, especially when you're start setting up your conversion import procedure to have errors in your upload files. We urge every advertiser to examine the results for their uploads.

View your uploaded files

When your conversions file is uploaded, you'll run into a new entry for that file on the uploads page. Note that uploading, and applying a file could take several minutes.

Sign in to your Google Ads account.
Click the tools icon in the upper right corner of your account.
Under "Measurement", click Conversions.
In the card on the left, click Uploads.
If you have whatever files that y'all've previewed just oasis't applied, you'll see them in the "Pending actions" table. In the "Actions" cavalcade, click Apply to import the conversions in the file or Discard to remove the uploaded file.
Below the "Pending actions" table, you'll meet a list of the files you've uploaded and applied. Check the post-obit columns for more information about the files.
- The "Condition" column lets you rapidly see whether the conversions in the file were imported successfully.
- The "Results" cavalcade provides more details about the import status. If the file import failed, this column will provide a reason why it failed. This column too provides links to view the conversions that were imported and which ones weren't due to file errors.
- The "Actions" column provides the following links:
  - Download results: Download a copy of your uploaded file. This link appears when all the conversions in your file were imported successfully.
  - Download all: Download a copy of your uploaded file, including conversions that failed to import.
  - Download errors: Download a spreadsheet that lists the conversions from your file that failed to import, along with error messages.
  When y'all select whatever of the three links above, the downloaded file includes a "Results" column which confirms that a conversion was imported successfully or explains why it failed to import. These links are removed 30-60 days after your initial upload.

Fix import issues

View your uploaded files and detect the file that has the fault.
In the "Actions" column, click Download errors to download a spreadsheet that lists the conversions from your file that failed to import.
Review the error messages in the "Results" cavalcade of the spreadsheet to determine why Google Ads couldn't import your conversions.
Brand the necessary corrections to the spreadsheet, salve it, and effort uploading it again.
Sometimes in that location might be a problem that prevents the entire file from processing. If this happens, y'all'll find the mistake message in the first row (if it'south a .csv or .tsv file) or in a new "General Errors" worksheet (if it'due south an Excel file).

Common errors and resolutions in offline conversion imports

No conversion types defined

No Google Ads conversion types were defined when this GCLID'south click occurred. You lot'll need to create at least one conversion type. In order to use offline conversion tracking, an "Import from Clicks'' conversion action must be created. Read Set upwards offline conversion imports.

Hashing errors

To avoid hashing errors, utilize the following guidelines (run into sample formatting below guidelines):

Make sure there is no hash for Country or Zip columns.
Brand all characters in the electronic mail addresses lowercase and remove any actress spaces before or after the email addresses.
All electronic mail addresses should comprise an @ sign.
All electronic mail addresses should incorporate a period "." followed by a top level domain, such every bit ".com".
Email addresses shouldn't contain spaces.
E-mail addresses shouldn't contain consecutive dots [..*].
Email addresses shouldn't get-go or finish with a period.
Electronic mail addresses shouldn't contain accents (for example: è, é, ê, and ë).
You tin use accents in "Get-go Proper noun" and "Concluding Proper name" fields.
Telephone numbers should be formatted according to the international standard, E.164 format.

We cannot notice this conversion name in the target account

Confirm that the click came from the business relationship yous are uploading to. If the ad click came to an account within an MCC and y'all are uploading to the MCC business relationship, ensure that the account within the MCC has cross account conversion tracking enabled.

Conversion date precedes click engagement

The Offline Conversion cannot happen before the ad click. Add together one-2 days to your conversion time in your upload, or check that the fourth dimension zone is properly set.

This click is too old for its conversion to exist imported

We retain the GCLID for only xc days. Delight upload more frequently or if your conversion happens after 90 days, upload an offline conversion event that happens within ninety days.

We are still processing this click's information, please re-upload this conversion in 12 hours

Our organization has not processed the click yet. Recommended wait is 6 hours if you are using scheduled upload.

Guidelines for importing conversions

Time your uploads

Offline conversions uploaded more than 90 days afterward the associated terminal click won't be imported into Google Ads, and this means it won't show up in your conversion statistics.

Upload multiple conversions for the same click

The aforementioned conversion won't be imported more than one time. So, if you try to upload a conversion with the same combination of unique identifier (GCLID or pb course user-provided data), "ConversionName", date, and time, or duplicate conversion aligning, information technology volition only be counted once, and you will see an error message for any indistinguishable uploads.

If yous want to upload multiple conversions of the same type—several offline buy conversions, for example—for the same click, you can. Google Ads volition record them as separate conversions as long as they have unlike times (the unique identifiers and conversion names tin be identical), and provided you lot have your conversion counting setting set to 'every'.

It's a expert idea to re-upload whatever conversions that occurred soon before your last upload, merely in case some of them were too recent to be processed. Google Ads needs 4-half dozen hours after the ad click before a conversion can be successfully uploaded. (If you upload a conversion besides soon after the click, you'll meet an error message that says "We're still processing this click'due south information, please try again afterwards 4-6 hours.")

For example, if you upload your conversions daily, you lot'll want to make sure you lot upload all conversions from the last two days, just in case some of the conversions from two days ago weren't processed. Don't worry about double counting—Google Ads won't count the aforementioned uploaded conversion more than one time. If you upload multiple conversions for the aforementioned click you'll receive an fault for each duplicate conversion.

View your imported conversions in Google Ads

It takes virtually iii hours for your imported conversion statistics to show up in your Google Ads account. When they do, they'll appear in your conversions columns. You can acquire about the conversions columns and how to add them to your reports in Empathize your conversion tracking information. To see how performance varies past conversion activity, yous can segment the "Conversions" column past "Conversion activeness proper noun".

To validate whether your conversion imports are working, use the "All conv. (by conv. time)" column. Unlike the other conversion columns, this column reports total conversions by the date of the conversion considering your upload file records a conversion time.

Keep in heed, the longer the delay between your clicks and your conversions (online or imported conversions), the longer you volition have to wait to run into the most complete conversion metrics.

Case: If y'all want to see conversion statistics for Monday, your clicks accept three days to convert, and you upload your conversions nightly, then you'll have to wait until Friday morning before you can see Monday's authentic conversion statistics.

Configure your SFTP URL

"File not found. Delight check that your URL, name, and/or password are correct."

If yous encounter this upload error, and you've already determined that the username and password are entered correctly, then y'all nearly likely need to change your URL to clarify if the file is located in your home directory.

Every user (e.g. Jon) on an SFTP server< (e.g. ftp.example.com) has a home directory (e.chiliad. /home/Jon/). Some SFTP servers assume that the file you are requesting (e.g. upload.csv) will always reside somewhere within your home directory. In these cases, if you lot include your dwelling house directory in the URL, the FTP server will look for the file in the wrong location.

Fix upload errors

Here are a few examples of upload errors and how to solve them.

If the file is saved to your dwelling house directory (/home/Jon/)

Status	URL	Reason
Bad	`ftp.example.com/ abode/Jon/upload.csv`	This seems like the logical URL to use, just the FTP server assumes that the file is stored in your dwelling directory. So it interprets this file path to exist /home/Jon/home/Jon/
Expert	`ftp.example.com/upload.csv`	Removing the path to your home directory (/ home /Jon/) will eliminate the confusion.
Good	`ftp.example.com //home/Jon/upload.csv`	Placing a "//" between the domain and the file path tells the FTP server not to presume that the file is in your home directory.

If the file is saved to a directory within your domicile directory(/home/Jon/data/)

Status	URL	Reason
Bad	`ftp.example.com /habitation/Jon/data/upload.csv`	Again, considering the FTP server assumes that the file is stored in you lot home directory, it interprets this file path to be /home/Jon/home/Jon/information/
Good	`ftp.example.com /information/upload.csv`	Removing the path to your home directory (/ home /Jon/) will eliminate the confusion.
Expert	`ftp.example.com //home/Jon/upload.csv`	Placing a "//" between the domain and the file path tells the FTP server not to assume that the file is in your home directory.

If the file is not saved to your habitation directory (instead it in /foo/bar/)

Status	URL	Reason
Bad	`ftp.example.com / foo/bar /upload.csv`	This seems like the logical URL to employ, only the FTP server assumes that the file is stored in your home directory. So it interprets this file path to exist /home/Jon/foo/bar/
Skillful	`ftp.example.com / /foo/bar/upload.csv`	Placing a "//" betwixt the domain and the file path tells the FTP server not to assume that the file is in your domicile directory.

Using tertiary-political party integrations to import offline conversions

Y'all tin use third-party integration to automate conversion imports from your CRM systems by integrating your Google Ads account with Salesforce or Zapier.

Google Ads Conversion Import for Salesforce ® allows y'all to automatically run across when sales events that yous track in Salesforce started with a click on an ad. Information technology's the best option if y'all use Salesforce'southward Sales Deject® to track your sales data. You can learn more most the specifics for this solution in About Google Ads Conversion Import for Salesforce®.
- Instructions: Import conversions from Salesforce
Zapier offline conversion tracking lets you automate the import of your offline conversion tracking information from many different customer relationship management (CRM) systems to Google Ads. Larn more Nigh Zapier offline conversion import for Google Ads
- Instructions: Import conversions from Zapier
- A "trigger" tells Zapier when a conversion has happened and starts the upload process. Please utilize this guidance to make up one's mind which trigger is best for you based on the CRM you lot employ likewise equally where y'all track your conversions.

Note: Starting in June 2021, you'll no longer be able to upload offline conversions from a Google Ads client business relationship that has opted in to using manager account-level conversion measurement. Yous'll receive an error message for any conversions you're uploading using your client account, and you'll demand to go to the director business relationship and upload conversions from there. Refer to Changes to offline conversion uploads for client accounts.