how to Import Offiline conversion into google adwords conversion tool?

Hi,

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.

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

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.

Process to start importing your offline sale data to google adwords.

First You've enabled auto-tagging. This lets you import offline conversions.

• 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.

Paste this code before body closing body tag

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(window.location.search);
    return match && decodeURIComponent(match[1].replace(/\+/g, ' '));
}
var gclid = getParam('gclid');
if(gclid){
    var gclsrc = getParam('gclsrc');
    if(!gclsrc || gclsrc.indexOf('aw') !== -1){
     setCookie('gclid', gclid, 90);
 }
}
</script> 

In our query form we have to take one hidden input type for passing GLCID.

   <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">  
   </form>

In this third section of code, we have to place this code/script on below of 1st code. 

<script> 
  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 = 
  readCookie('gclid'); 
  } 
  </script>

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.