Tracking offline conversions

Sometimes, a click on an AdWords ad doesn't lead directly to an online sale, but instead starts a customer down a path that ultimately leads to a sale in the offline world, such as at your office or over the phone. By importing offline conversions, you can measure what happens in the offline world after a click on one of your ads.


Importing offline conversion events gives you a more comprehensive look at which keywords and targeting criteria (for example, geography or time of day) drive the most cost-effective conversions. This data can help you target and optimize your campaigns for increased profit.

If you attract leads or buyers online, or both, you might want to record a conversion in the following cases:

  • When you close a sale offline (for example, over the phone or in person)
  • 30 days after the online sale so you can exclude transactions that resulted in a return
  • Only if the sale was made to a new customer
  • Only if it is a customer's 2nd purchase
  • When you close a sale online but are unable to use our standard Javascript-based conversion tracking solution

Here's a quick overview of the feature.

How it works

AdWords provides you with a unique ID, called a "GCLID," for every click that comes to your website from an AdWords ad. To track offline conversions, you'll save that ID along with whatever lead information you collect from the person who clicked your ad.

Later, when that person "converts" in the offline world, by signing a contract, for example, you give that GCLID back to AdWords along with a few details about the type of conversion it was and when it happened. Then AdWords records this conversion along with your other conversion tracking data.


You design, build, and sell custom boardroom tables. You use AdWords to drive prospective customers to your website, where they then can submit their contact information and request a sales call. If a lead results from a click on an AdWords ad, the lead's contact information will also include a GCLID.

Once a week, your salespeople review that week's sales and send you the prospects (and associated GCLIDs) that converted into customers, along with the date and time of each sale. You then compile that data into a five-column spreadsheet and upload it into your AdWords account. Within a few hours you'll be able to see which keywords and queries are contributing not just to new lead submissions, but, more importantly, to actual sales.

This new data saves you time and makes it easier to maximize your investment in AdWords.


To import offline conversions for your business, you'll want to make sure the following applies to you:

  • You've enabled auto-tagging. This lets you import offline conversions.
    Steps to enable auto-tagging
    1. In your AdWords account, open the settings menu and select Account settings from the drop-down menu. Preferences Tab
    2. Under "Account preferences," in the "Tracking" section, look for an "Auto-tagging" setting. It will either say "Yes" or "No."
      • If it says "Yes," auto-tagging is already enabled, and you can skip steps 3 and 4.
      • If it says "No," click Edit next to "Auto-tagging" and continue to step 3.
    3. Check the box next to "Destination URL Auto-tagging."
    4. Click Save changes.

    You'll also be able to enable auto-tagging when you create a new offline conversion action for import. (We'll explain how to do this in a bit.)

  • You can make code changes to all of your web pages. This lets you capture the GCLID parameter that's appended to the URL that people click through from one of your ads.
  • You can store each GCLID with the corresponding prospect's information that's gathered on your website. You'd want to be able to do this, for example, in your lead tracking system.
  • You have a click-to-conversion cycle that is less than 90 days. Conversions uploaded more than 90 days after the associated last click will not be imported by AdWords and will therefore not show up in your conversion statistics.

Set up imports for offline conversion tracking

There are two parts to setting up imports for offline conversion tracking. Click the links below to see steps for each one.

Step 1: Create one or more import conversion actions

You'll need to create a new conversion action for each kind of offline conversion you'd like to measure, such as "lead qualified" or a "deal won." You can measure as many offline conversion actions as you want.

Here's how to create a new offline conversion action:
  1. Sign in to your AdWords account.
  2. Click the Tools tab, and select Conversions from the drop-down menu.
  3. Click the + Conversion button.
  4. Select the "Import" option.
  5. Enter a name for the conversion action you're creating. (It's important that you remember the exact name and spelling because you'll need to enter this name later, when you upload your offline conversion information.) Click Done.
  6. Click Value. Select whether each conversion has the same value, varying values (for example, purchases of products with different prices), or select "Don't assign a value" if you'd prefer not to count one. If you choose varying values, you'll need to follow these instructions to track transaction-specific values. Click Done.
  7. Click Count. Select whether to count every or one conversion per ad click. "Every" is best for sales; "one" is best for leads. Click Done.
  8. Click Conversion window. Select a conversion window (how long after an ad click and ad impression you want to track conversions) for this conversion action. The window can be as short as one week or as long as 90 days. Click Done.
  9. Click Category. Select the category that best applies to your conversion. If you're tracking newsletter signups, you'll pick "Sign-up." For purchases, you'll pick "Purchase/Sale." If your conversion doesn't fall into a listed category, select "Other." Your choice here is used simply to segment your conversion reports. You can always change it later. Click Done.
  10. (Advanced) Click Include in "Conversions." Opting into this setting—selected by default—will include data for this conversion action in your “Conversions” reporting column. If you uncheck this setting, data will still be included in the “All conversions” column.

    Data in the “Conversions” column is used by automated bid strategies like Target return on ad spend, Enhanced cost-per-click, or Target CPA. So, if you use an automated bid strategy to optimize for conversions, and you don’t want to include this particular conversion action in your bid strategy, you can uncheck this setting. Otherwise, leave it checked. Click Done.
  11. Click Save and continue.
  12. On the next screen, you'll see a link to this Help Center article, which explains how to prepare your data and import your conversions.
  13. Click Done.

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.

How to upload conversions for multiple accounts from a single file

To do this, all of the relevant accounts need to be linked from a shared manager (MCC) account. This manager account is where you will upload your files. We'll then import any conversions that originated from its accounts.

Keep in mind: If you upload a conversion for an account that isn't linked from your manager account, you will get a "not authorized to upload" error.

  • If you use cross-account conversion tracking: You'll need to create your import conversion actions at the manager account level and follow instructions to make sure all managed accounts use the manager as the "conversion account."
  • If you don't use cross-account conversion tracking: You'll need to create your import conversion actions in each individual account. Keep in mind: if you're tracking the same conversion (for example, "lead qualified") across multiple accounts, it's critical that you use the exact same spelling and capitalization for each conversion name in each of your accounts.
  • If you haven't used AdWords conversion tracking before and all of the accounts under your manager account belong to the same business: You'll want to use cross-account conversion tracking. It can help simplify tracking your conversions and your Attribution reports.


Step 2: Enable your website and lead tracking system

Keep in mind: Be sure to complete step 1—create one or more conversion actions—before starting this step. Otherwise, you won't be able to import your early conversions. Also, this code sometimes requires small changes, depending on your website's current design. Consult with your webmaster or IT team when completing this step.

  1. Update the code on each of your web pages to capture and store the GCLID in a cookie.

    Here's sample JavaScript code you can use on each web page to store the GCLID in a cookie named "gclid."

    <script type="text/javascript">
    function setCookie(name, value, days){
        var date = new Date();
        date.setTime(date.getTime() + (days*24*60*60*1000)); 
        var expires = "; expires=" + date.toGMTString();
        document.cookie = name + "=" + value + expires + ";path=/";
    function getParam(p){
        var match = RegExp('[?&]' + p + '=([^&]*)').exec(;
        return match && decodeURIComponent(match[1].replace(/\+/g, ' '));
    var gclid = getParam('gclid');
        var gclsrc = getParam('gclsrc');
        if(!gclsrc || gclsrc.indexOf('aw') !== -1){
    	    setCookie('gclid', gclid, 90);

    It's a good idea to insert this code at the bottom of every web page, immediately before the closing </body> tag. This way, you don't have to add it every time you create new ads with new landing pages, or worry about losing GCLIDs if you change landing pages for existing ads. Even better, consider adding this code to your webpage template so that all your new pages will automatically have the code and be able to capture GCLIDs.

  2. Modify your site's prospect lead information submission page—usually, a lead submission form—to read the GCLID from the cookie and pass it along to your lead management system, along with the lead's contact information.

    You can retrieve the GCLID value via your choice of client- or server-side languages. Once retrieved, it's a good idea to pass the GCLID through your lead submission form as a hidden field element.

    Here's an example form with a hidden field for collecting the GCLID. You should insert the highlighted <input> tag in between your <form> tags.:

       <form action="" name="myForm"> 		
             Name: <input type="text" name="name"> 		
             <input type="hidden" id="gclid_field" name="gclid_field" value=""> 	 	
             <input type="submit" value="Submit Form" name="btnSubmit"> 	

    Here's example JavaScript code you can use to retrieve the GCLID value from the cookie and update the value of the hidden form element. It's important that you insert this code after the GCLID collection code we provided you in the previous step (Step 2.1) and before the closing </body> tag.

      function readCookie(name) { 
      var n = name + "="; 
      var cookie = document.cookie.split(';'); 
      for(var i=0;i < cookie.length;i++) {      
          var c = cookie[i];      
          while (c.charAt(0)==' '){c = c.substring(1,c.length);}      
          if (c.indexOf(n) == 0){return c.substring(n.length,c.length);} 
      return null; 
      window.onload = function() {      
          document.getElementById('gclid_field').value = 

    This example assumes that you have a hidden field called 'gclid_field' in your form. If your field has a different name (for instance, if you have to use the name your CRM system created for you), then simply replace 'gclid_field' with that name.

  3. Modify your backend customer data management system so it can store the GCLID along with the prospect's information. For example, if you're using a lead management system, add a custom field to your lead object so this ID can be stored and retrieved easily and reliably.

    Marketo, Mongoose Metrics and SugarCRM have published integration guides for their customers, which are available in their online help centers. You can also read our FAQ on Importing AdWords conversions from


If you have a Google Tag Manager account, you can use it to implement your GCLID collection JavaScript by following these steps:

  1. Log into your Google Tag Manager account at
  2. Under Accounts, click the name of the account with the container you use for your AdWords tags.
  3. Under Containers, click the name of the container you want to use.
  4. Click the New button, then select Tag from the drop-down menu.
  5. Enter a name in the "Tag Name" field (you might want to use something like "AdWords Click ID Collection for Conversion Import.")
  6. Under "Tag Type," select "Custom HTML Tag" from the drop-down menu.
  7. Copy the JavaScript from step 2.1 above and paste it into the "HTML" field.
  8. Under "Firing Rules," click the +Add button. Check the box next to "All pages" and click Save.
  9. Click Save.
  10. Click the Create Version button.
  11. Click the Publish button.

Import your conversions into AdWords

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 our API. If you'd like to transmit the data to the AdWords API, then you can skip the steps below and instead read this help article from our API Developer's Guide.

When you're ready to import your conversions, follow these two steps:

Step 1: Prepare your data for import
  1. 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.
  2. 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.
    Use one of the following formats to enter the time zone:
    • 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.
  3. 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
    • 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"
Imported conversions can't be removed once they are imported, so be sure that the data you enter is accurate.
Step 2: Importing 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.)
  1. In AdWords, click the Tools tab, and select Conversions. If you're using a manager account, navigate to the upload page by clicking Conversions.
  2. Click the Upload button.
  3. Click Browse to locate the template you've filled out and saved with your offline conversions information.
  4. Click the Upload button.
  5. A yellow box will appear reminding you that uploading the report will immediately update your account. (Keep in mind, there's no "undo" option after this point.
  6. Click Yes, I understand to start adding new conversions to your account.

More about imports

Click the sections below to learn more about tracking your offline 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.

Uploading multiple conversions for the same click

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.

Viewing the status of your upload

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
  • Successful
  • Failures

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.

What to do if there are errors


  1. Download the results file from the "Download results" link.
  2. Scan the new "Errors" column to find all the rows that are marked with an error.
  3. 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).
Sometimes there might be a problem that prevents the entire file from processing. If this happens, you'll find the error message in the first row (if it's a .csv or .tsv file) or in a new "General Errors" worksheet (if its an Excel file).


Viewing your imported conversions in AdWords

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.

See how performance varies by conversion action

You can add the "Conversions" column to your report. Just click the "Columns" button, select "Modify columns" and then "Conversions" from the menu. Then apply the "Conversion action name" segment by clicking the "Segment" button, selecting "Conversions" from the dropdown menu, and then choosing "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.

Using bid automation with offline conversions

You can use AdWords bid strategies to optimize for offline conversions. If you do, it's a good idea to do the following:


If you track both online conversions (for example, leads) and offline conversions (for example, final sale) using ROAS, you can assign different values to different conversion actions (for example, the value of a lead is $10, and that of a sale is $500). This gives AdWords more insight into your sales funnel. And the more insight AdWords has into your sales funnel, the better it can optimize your bids for you

If you decide to use bid automation, it's a good idea to import offline conversion data frequently (daily is best), and also wait a full lead-to-conversion cycle (for example, one week, one month, etc.) from when you start importing conversions to when you enable the Target ROAS strategy.

  • Import offline conversion data frequently (daily is best)
  • Begin uploading conversions and then wait a full cycle before you turn on bid automation
  • If you're tracking a combination of online and offline conversions, try the target ROAS bid strategy. With target ROAS, you can better optimize for online and offline conversions by assigning different values to different conversion actions, such as leads and offline sales.

Related links

Was this article helpful?
What's In Store

Get Google's guide to driving store sales through AdWords. Learn how to enhance and target your online ads to drive offline sales, and then how to optimize them for success. View the guide now.