Posts Tagged ‘salesforce’

Jun 28

salesforce google analytics integrationYou have several tools and channels: Paid Campaigns (Google Adwords), Google Analytics and Salesforce.  All are robust and tell you different details about the behavior of your leads/prospects.  Google Analytics has an overall view about your visitors (qualified and unqualified leads), while Salesforce has detail about each individual lead.

Until now, these views are looked at separately.  Wouldn’t it be powerful to be able to combine them into one comprehensive full 360 view of your leads?  To be able to find out where they went, how they converted, then optimize for that conversion to get more leads???

The only code for Salesforce integration that existed used to be for Google AdWords.   Even that has since been retired as of May 1, 2013 (read more about it here).

In this post, we hope to provide code that integrates Salesforce and Google Analytics, which not only replaces the Adwords integration, but will work with any of your marketing channels and campaigns.

Why Integrate Salesforce with Google Analytics?

Google Analytics has very rich reporting capabilities for conversion tracking. For example, you can define a goal by simply identifying a unique URL of the thank you page for any form on your website. And if one doesn’t exist, you can even “fake it” by creating virtual pageviews or events. This will allow you to analyze the number of conversions you receive, where they came from, and other user behaviors about visitors who convert.

Salesforce is “the name” in sales funnel reporting. Each time a lead submits information through forms on your website, through integration with Salesforce (or through manual entry from your sales representatives) other information about the leads can be entered and tracked.

But both tools alone might have missing pieces. In Google Analytics, how many of my conversions are spam or unqualified leads? In Salesforce, what information or pages were my leads looking at that got them to convert? Are search engines a primary source of converting traffic? Etc.

Google Analytics and Salesforce each have a place in helping analyze how to improve your sales funnels and the quality and quantity of your leads. Combining the two can really give you powerful insights to act upon.

In this post, we’ll show you how to pass Google Analytics information to Salesforce, then cover advanced integrations, such as passing unique keys that will allow you to tie visitors between Google Analytics and Salesforce. From there, you can get “first touch” campaign information.

Implementation (The Code)

The code below will allow you to improve your reporting by passing the traffic source information into Salesforce every time a form is submitted.

  1. Setup the following 5 fields in Salesforce:
    • Medium
    • Source
    • Campaign
    • Content
    • Term

    Here’s sample code (“xxxxxxx” represents the database id/api name of the custom field, depending on your salesforce mapping):

    <input type="hidden" name="txt_medium" id="xxxxxxx" value="" />
    <input type="hidden" name="txt_source" id="xxxxxxx" value="" />
    <input type="hidden" name="txt_campaign_name" id="xxxxxxx" value="" />
    <input type="hidden" name="txt_term" id="xxxxxxx" value="" />
    <input type="hidden" name="txt_content" id="xxxxxxx" value="" />
  2. Update all forms to contain the same 5 fields created in step 1 (they should be hidden so they aren’t shown to the user).
  3. Values for the hidden fields can be read from the GA cookie __utmz. The code below will parse out the campaign variables from the GA cookies and make them available in 5 variables.
  4. Logic should be put in place within the form to pass the values of the hidden fields to their corresponding fields within Salesforce when the form is submitted.
  5. Place the following code on every page on your website that has a Salesforce form before the closing </body> tag.
<script type="text/javascript">
var z = _uGC(document.cookie, '__utmz=', ';');
var source = _uGC(z, 'utmcsr=', '|');
var medium = _uGC(z, 'utmcmd=', '|');
var term = _uGC(z, 'utmctr=', '|');
var content = _uGC(z, 'utmcct=', '|');
var campaign = _uGC(z, 'utmccn=', '|');
var gclid = _uGC(z, 'utmgclid=', '|');
if (gclid !="-") {
 source = 'google';
 medium = 'cpc';

var csegment = _uGC(document.cookie, '__utmv=', ';');
if (csegment != '-') {
 var csegmentex = /[1-9]*?\.(.*)/;
 csegment = csegment.match(csegmentex);
 csegment = csegment[1];

} else {
 csegment = '';

function _uGC(l,n,s)
if (!l || l=="" || !n || n=="" || !s || s=="") return "-";
var i,i2,i3,c="-";
if (i > -1) {
i2=l.indexOf(s,i); if (i2 < 0){ i2=l.length; }
return c;

document.getElementById("txt_medium").value =medium; /* Campaign_Medium */
document.getElementById("txt_source").value =source; /* Campaign_Source */
document.getElementById("txt_campaign_name").value =campaign; /* Campaign_CampaignName */
document.getElementById("txt_term").value =term; /* Campaign_Term */
document.getElementById("txt_content").value =content; /* Campaign_Content */


After implementing this code you can test one of the forms on your site and this is what you should see in Salesforce:

Salesforce Google Analytics Fields


Congratulations! You are now pulling reports in Salesforce and accurately determine what traffic sources are resulting in opportunities, qualified leads, and customers.  Now you have a more accurate understanding of the true ROI of your marketing activities.

(Keep in mind that when testing to clear your cache, cause any previous cookies or tags associated with your site will reflect in the form submission.)

The following is a report we have helped many of our customers work towards, which is mapping their Salesforce lead/customer data to their advertising spend.  This report shows the ROI and cost per qualified lead for each of their marketing channels.

salesforce google analytics marketing dashboard

A Note About Autotagging/AdWords

If you are trying to analyze the impact of your AdWords campaigns, you may notice that in Salesforce all of the Keywords, Content, and Campaign information is missing. This will happen if you have AdWords set to use autotagging. If this is the case, the default implementation provided above will not be able to pass anything more detailed, because the AdWords information is hidden in the GCLID, which is not decoded until later in Google Analytics.

If this information is important you have two options:

  • You can disable autotagging and use manual tagging
  • You can customize our code to accept customer parameters, which you can append to all of your destination URLS.

Advanced Implementations

Qualified Lead Behavior in Google Analytics
Marketers, get ready to have your mind blown! The number one question every business has is, “How can we get more business?” One of the keys to answering this question is to understand the common traits of your buyers. “How did we close you?” so we can do more of that.

With this integration, by associating a unique identifier with visitors in Google Analytics and passing that info to Salesforce, you can easily filter for this unique identifier (if you have goals set up) by using their built-in advanced segment of converting visits. What does that mean? That’s right, you’ll be able to see what your qualified leads did on your site!

But if your conversion is a form submission or contact email for example, what you cannot do though is create a segment of only your qualified leads or actual customers, as it will likely be filled with spam leads and non-qualified leads. We can solve this with a bit of code.

Our friend Justin Cutroni details in his blog post here how to store the unique ID that Google Analytics generates into a custom variable.  By reading the __utma cookie, we can extract this ID and send it to Google Analytics and also send this key into Salesforce. By placing this code on all Salesforce form pages on your site and passing it into both Google Analytics and Salesforce we will now have a key between the two systems to tie visitors together!

Now, in Salesforce you can create reports of qualified leads, customers, or any other customer grouping and extract these unique ID’s, then take these unique ID’s and create advanced segments for each of these groupings like so:

salesforce leads field custom variable

google analytics advanced segment custom variables

First Touch Attribution
Almost every Google Analytics report (except for Multichannel Funnels) is built on a last touch attribution model. Meaning, when you create reports or segments for converting elements, only the last traffic source is being tied to it. This is the same for our Salesforce / Google Analytics implementation that is provided above.

If you need insight on first touch campaigns and marketing channels, with some minor modifications, you can pass this along. Conceptually, this works best when you pass and store this information from the Google Analytics cookies into your database. Every time, that user re-authenticates and fills out a form, you can read this information from your backend and pass it into Salesforce using hidden fields.

Conclusion: 360 Customer View

The integrations mentioned above allow you to get closer to a 360 view of all of your customers and leads. By passing your visitors campaign and marketing channel information from Google Analytics into Salesforce, you will be able to report on the ROI and Cost Per Qualified Lead, which are two metrics every lead oriented business should have. By using the advanced implementations you can pass more information into Salesforce and create segments of your visitors based on information that is learned from them in Salesforce.

We have done many custom implementations of Salesforce and Google Analytics and with marrying both systems to other data sources.  The true power in it is architecting a solution that meets your needs. Feel free to contact me at: if you have any questions or would like help working out a solution for your environment.

May 22

Introducing Google Big Query

Cloud Computing
With Google BigQuery publicly available, all businesses can combine large data sets with amazing speed and do analytics in the cloud.

What Kinds of Questions Can You Answer With Google BigQuery?

Let’s say you are the marketing manager of a large B2C business that is driving traffic to your site through many channels including paid search, affiliates, email, and some offline campaigns as well. You really want to tie the campaign cost data all the way to your qualified leads, opportunities, and sales data, which typically resides in a CRM system, such as SalesForce, SugarCRM, or the like.

But why stop there? You also want to throw in your web analytics data and get engagement metrics in the mix. Last but not least, you’ve done your homework and implemented an integration strategy to tie all this data together (e.g. using a primary key).

You want to produce a very actionable report that shows:

  • Campaign cost data
  • Web analytics data
  • CRM data
  • A super actionable metric cost per qualified lead, broken down by campaign!
Cost per Qualified Lead Calculation with Google BigQuery

Report Analysis

In the above report, the cost per qualified lead for the Software Demo campaign in Google Adwords was just a little bit over $30, and you can start trending and optimizing accordingly. Run experiments and gather user feedback to bring that cost down!

Other Useful Features

  • Metrics like cost per qualified lead can be recalculated with amazing speed as often as the data is refreshed.
  • Results like this can be saved as a table, allowing you to build up layers of useful reports and then combine them to build even more useful reports.
  • Reports can be downloaded in CSV format for integration with Excel, PowerPoint, or whatever presentation and integration tools your business might use.
  • Unsampled reports from large data sets in Google Analytics Premium are the perfect kind of data set to upload to Google BigQuery.

Technical Details about Google BigQuery

  • Google BigQuery is a tool which allows businesses to gain insights from large data sets without any initial hardware purchases or software investments.
  • The BigQuery service is an online analytical processing (OLAP) system designed for terabyte-scale datasets.
  • The service supports SQL-like queries against those massive datasets.
  • BigQuery is surprisingly developer friendly, as it supports the straight forward REST (REpresentational State Transfer) Web service for pushing data to Google’s cloud and then querying it.
  • Google BigQuery can be accessed through a web tool or programmatically through the REST interface.
  • The web tool might be useful in visually identifying relationship and building queries, while the REST interface lets your developers get at the data in the most efficient way.

What Are the Possibilities?

Contact E-Nor for more information on how we can help you leverage Google BigQuery to answer business questions and improve your bottom line.

Feb 25

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;
<form action="
encoding=UTF-8" method="POST">

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

<input type=hidden name="retURL"

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

ii – Add the Salesforce Tracking Code to the Website

Typescript,Computer Graphic,Text,Single Word,Article,Newspaper Headline,Information Medium,Newspaper,Printed Media,Print Media,The Media,Folded,Report,Business,Finance,Banking,Document,Paper,Printing Out,Printout,Print

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="">
<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