Import conversions into AdWords
Importing conversions lets you see how your online ads affect offline sales and other valuable actions. This article explains how to prepare a file to import and import your conversion data into AdWords.
Before you begin
Before importing conversions, make sure you’ve followed all the instructions to set up offline conversion tracking.
There are two ways you can import your data in to AdWords: by uploading it as a CSV or Excel file, or by transmitting the data to the AdWords API. This article explains how to import conversions by uploading a file. If you'd like to transmit the data to the AdWords API, read this help article from our API Developer's Guide.
Follow the instructions below to prepare your data for import and then import your data.
Step 1: Prepare your data for import
- Download our conversion upload template (download: Excel or CSV).
- Be sure not to remove the row that begins with "Google Click ID," or your import will fail.
- Make sure your data doesn't include additional columns or any personal information.
- Choose how to enter your time zone in the file:
- If all of your conversion times are in the same time zone, set the time zone once in the "Parameters" row.
- If your conversion times are in different time zones, add the time zone to each conversion time. See the instructions and table under “Conversion Time” in step 3 below. If you don’t enter a time zone in the “Parameters” row, delete the “Parameters” row.
- Or, you can enter a time zone in both the “Parameters” row and the “Conversion Time.” “Conversion Time” will be used first, and if any conversion is missing the time zone, the “Parameters” value will be used.
- Enter your time zone ID from this list. This method is recommended to avoid errors during daylight savings time transitions.
- Enter your GMT offset by indicating + or - and then the 4 digit time difference. (For example, New York's offset is -0500, and Berlin's is +0100). If you use Greenwich Mean Time, then simply enter +0000.
- Next, add a new row for each offline conversion, filling in the columns as follows:
- Google Click ID: the GCLID that led to the offline conversion. (If you haven’t already, follow the instructions to set up offline conversion tracking to learn how to get this.)
- Conversion Name: the name of the conversion action (for example, "lead qualified" or "contract signed"). It's important that you use the exact same spelling and capitalization that you did when you created this conversion action in your AdWords account.
- Conversion Value: (optional field) a number representing the value that you place on the conversion. It could reflect a currency value, or you could simply choose to enter relative values of 0-10 (negative numbers are not accepted). If you leave this field blank, AdWords will automatically apply the "conversion value" that you defined in Step 2.8 when you created your new offline conversion action.
- Conversion Currency: (optional field) the currency in which your conversion value is provided. You'll use this if you report conversion values in more than one currency, or have multiple accounts that are billed in different currencies.
- Conversion Time: the date and time that the conversion occurred. See the table below for a list of acceptable date formats (e.g. MM/dd/yyyy HH:mm:ss). You can add a time zone to the conversion time by using one of the last 4 formats listed. Replace “+z” with the GMT offset by indicating + or - and then the 4 digit time difference. (For example, New York's offset is -0500, and Berlin's is +0100). Or, replace "zzzz" with the time zone ID from this list.
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/14/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-14 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-14 13:00:00 America/Los_Angeles" yyyy-MM-ddTHH:mm:ss zzzz "2012-08-14T13:00:00 America/Los_Angeles"
Step 2: Import your conversions
To import your offline conversions to AdWords, you'll need to upload your conversion file into your AdWords or manager (MCC) account. (Keep in mind, imported conversions can't be removed once they're imported.)
Important: After creating a new conversion action, wait 4-6 hours before uploading conversions for that conversion action. If you upload conversions during the first 4-6 hours, it might take 2 days for those conversions to appear on your reports.
- In AdWords, click the Tools tab, and select Conversions. If you're using a manager account, navigate to the upload page by clicking Conversions.
- In the menu on the left, click Upload.
- Click Choose file to locate the template you've filled out and saved with your offline conversions information.
- Click the Upload and preview or Upload and apply button.
- If you click “Upload and preview,” you’ll see a preview screen with the estimated changes. Click Apply changes to import the conversions into your account. (Keep in mind, there's no "undo" option after this point.)
- If you click “Upload and apply,” the conversions will be imported into your account. (Keep in mind, there's no "undo" option after this point.)
Click the sections below for guidelines to follow while importing your conversions.Timing your uploads
Offline conversions uploaded more than 90 days after the associated last click won't be imported into AdWords, and this means it won't show up in your conversion statistics.
The same conversion won't be imported more than once. So, if you try to upload a conversion with the same combination of GCLID, "ConversionName," date, and time, AdWords will ignore it.
But if you want to upload multiple conversions of the same type—several offline purchase conversions, for example—for the same click, you can. AdWords will record them as separate conversions as long as they have different times (the GCLIDs and conversion names can be identical).
It's a good idea to re-upload any conversions that occurred shortly before your last upload, just in case some of them were too recent to be processed. AdWords needs 4-6 hours after the ad click before a conversion can be successfully uploaded. (If you upload a conversion too soon after the click, you'll see an error message that says "We're still processing this this click's information, please try again after 4-6 hours.")
For example, if you upload your conversions daily, you'll want to make sure you 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—AdWords won't count the same uploaded conversion more than once.
Once your file is uploaded, you'll see a new entry for that file at the top of the table. Check the "status" column to see if your job is complete.
Importing the file may take several minutes. Once it's complete, you'll see a summary in the status column with the following updates:
- Records uploaded
- Actions found
This summary will also contain a link to "Download results" which will give you a copy of your uploaded file, including any error messages. This link will be removed 30-60 days after your initial upload.
- Download the results file from the "Download results" link.
- Scan the new "Errors" column to find all the rows that are marked with an error.
- Make the necessary corrections, save the file, and then re-upload the file. It's OK to upload the whole file again, including the previous changes (since AdWords will ignore those rows that have already been imported).
It takes about 3 hours for your imported conversions statistics to show up in your AdWords account. When they do, they'll appear in your conversions columns. (You can learn about the conversions columns and how to add them to your reports in Understand your conversion tracking data.) To see how performance varies by conversion action, you can segment the “Conversions” column by “Conversion action name.”
The longer the delay between your clicks and your conversions (online or imported conversions), the longer you will have to wait to see the most complete conversion metrics.
If you want to see conversion statistics for Monday, your clicks take 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 accurate conversion statistics.