Web Analytics

Avoid Data Dispersion with Salesforce and Google Adwords Integration

Integrating lead information from one system such as Google Adwords into a CRM like Salesforce is definitely not a new topic, especially since the Salesforce-Google Adwords integration has been announced for a while now.

I want to highlight the steps required for a seamless integration, as well as a few additional pro-active steps you want to take to keep your Google Analytics data clean. The same concept would apply to other analytics tools you might be running. As Avinash always reminds us, data accuracy is always one of the biggest challenges in web analytics.

Here are my steps:

  1. Create Adwords and Salesforce accounts.
  2. Link Google AdWords with Salesforce.
  3. Exclude SalesForce parameters from Google Analytics.
  4. Set up AdWords lead tracking.
  5. View report.

1) Create Adwords and Salesforce accounts

You need to have a Google AdWords account and a Salesforce account before you can integrate them.

2) Link Google AdWords with Salesforce

  • In Salesforce, click the Google AdWords Setup tab.

  • Enter your AdWords customer ID and login e-mail.

3) Exclude SalesForce Parameters from Google Analytics

When Salesforce performs its integration with AdWords, it appends parameters (_kk and _kt) to all destination URLs in your AdWords account. We suggest that you strip these query parameters out of URL to insure no duplicate entries in your Top Content report.

To strip the query parameters, please follow these steps:

*A note for AdWords managers. Keep in mind that when Salesforce appends the destination URLs with its _kk parameters, this is actually “editing” your AdWords ads and the stats associated with these ads will now reset, according to how Google AdWords works.

4) Set up AdWords Lead Tracking

  1. Back in SalesForce, click on the Google AdWords Setup tab.
  2. Click on the “Set up Lead Tracking” button.

i – Create a Web-to-Lead Form

  • Click on the “Create Web-to-Lead Form” button

  • Add the form to your page
<META HTTP-EQUIV="Content-type" CONTENT="text/html;
charset=UTF-8">
.
.
.
<form action="https://www.salesforce.com/servlet/servlet.WebToLead?
encoding=UTF-8" method="POST">

<input type=hidden name="oid" value="xxxxxxxxxxxxxxx">

<input type=hidden name="retURL"
value="https://www.mysite.com/thankyou.html">

<label for="first_name">First Name</label><input id="first_name"
maxlength="40" name="first_name" size="20" type="text" /><br>

<label for="last_name">Last Name</label><input id="last_name"
maxlength="80" name="last_name" size="20" type="text" /><br>

<label for="email">Email</label><input id="email" maxlength="80"
name="email" size="20" type="text" /><br>

<input type="submit" name="submit">
</form>

ii – Add the Salesforce Tracking Code to the Website

Add the following tracking code to every page of your site right before the </BODY> tag

<!-- Begin Salesforce Tracking Code -->
<SCRIPT type="text/javascript" src="https://lct.salesforce.com/sfga.js">
</SCRIPT>
<SCRIPT type="text/javascript">__sfga();</SCRIPT>
<!-- End Salesforce Tracking Code -->

iii – Test Your SalesForce installation

By clicking the “Test your Setup” you will be able to test the installation of the codes in step i and ii

5) View report

This report gives an overview of the leads submitted to SalesForce from your website

For more detailed information, click on each lead and learn more about the lead source

Allaedin Ezzedin

Allaedin Ezzedin is a Senior Director at Merkle | Cardinal Path, renowned for his dedication to melding business strategies with technological innovation, particularly in the realm of digital marketing optimization. With an unwavering commitment to enhancing the digital analytics landscape, Allaedin is at the forefront of advocating for Google Analytics as a pivotal enterprise analytics solution.

Share
Published by
Allaedin Ezzedin

Recent Posts

Optimizing user experiences with Digital Experience Analytics (DXA) platforms

As consumers become increasingly digitally savvy, and more and more brand touchpoints take place online,…

1 month ago

Enabling Value-Based Bidding with Google Tightlock

Marketers are on a constant journey to optimize the efficiency of paid search advertising. In…

2 months ago

Resolving “Unassigned” Traffic in GA4

Unassigned traffic in Google Analytics 4 (GA4) can be frustrating for data analysts to deal…

2 months ago

This website uses cookies.