Registration is now open for ACCELERATE 2014 in Atlanta, Georgia on September 18th. Reserve your spot today at Eventbrite — tickets are only $99 USD!

CRM Integration #1 – Passing Web Analytics Data to CRM

Published by Adam Greco on May 10, 2010 All posts from Adam Greco

(Estimated Time to Read this Post = 5 Minutes)

One of the areas of Web Analytics that I am passionate about is the integration of Web Analytics and CRM.  In the next three blog posts, I am going to share why I think this topic is important and some ideas on how to do it.

Why Integrate Web Analytics and CRM?
For those who are not experts on CRM, it stands for Customer Relationship Management and it generally involves using a tool to store all information you have about your prospects/customers.  This normally includes all contacts with customers while they were prospects, all customer service touches, what products they use and how much they pay for each.  However, the main thing to understand is that CRM systems contain pretty much all data about prospects/customers that takes place after you know who they are.  But before your customers fill out a form or call you, guess where many of them are going?  That’s right, your company’s website (and to social media sites more and more!).  Guess who knows the most about what prospects do before your company knows they are interested in you?  Your Web Analytics platform!

Last week, I presented on this topic at the eMetrics conference where I posited that the combination of Web Analytics and CRM is akin to the joining of chocolate and peanut butter in that they are both great, but even better together!  Often times, as web analysts we know a great deal about what happens on the website, but unless your website sells something or sells advertising, the true success event ($$$) often takes place off the website (especially for B2B sites).  Additionally, for all the great information we have about website visitors, most of it is anonymous – we don’t really know who they are so we can’t easily connect their website behavior to other interactions.  What if we could take all of that anonymous website behavior and somehow connect it with the known prospect/customer behavior stored in our CRM system?  Imagine if every time a prospect filled out a lead form on your website, the sales person who is routed the lead could see what that person had viewed on the website, what products they had looked at, etc…  That could lead to a much more meaningful conversation and help get things off on the right foot.  In this first post on the topic, I will cover ways in which you can improve your CRM system by passing it meaningful data from your web analytics tool.

Passing Pages Viewed
The first area I would like to cover is the concept mentioned above in which we pass data about pages viewed from your Web Analytics tool into your CRM tool.   So let’s say that you have a website visitor who navigates a bunch of pages on your website and then fills out a lead form.  At that moment, you have the opportunity to create a connection between that user’s website (cookie) ID (Omniture calls this a Visitor ID) and the ID used to record that lead form in your CRM system.  While it would take too long to go into all of the details on how to do this (Hint: read my old Transaction ID post!), at a high level, you can use API’s of both tools to tie these ID’s together.  Once you have made this connection, you can pass data bi-directionally between the two systems.  In this case, we are going to create a custom object in our CRM system that represents website traffic and import what pages this particular prospect on the website.  While this may sound hard, if you look closely, you will notice that the following screen shot is something I did between Omniture and back in 2005 so it can’t be that hard right?

In this case, your sales team would know that this person is probably interested in Weather products so they might want to prepare accordingly for their first phone call or face-to-face meeting.

Passing Website Scores
In one of his post-Summit blog posts, Ben Gaines talked about a topic called Visitor Scoring (I prefer the name Website Scoring to avoid the whole Engagement debate!).  Basically, this involves storing a unique website score for each website visitor so you can see how active they have been on the website.  For example, you can set this up so if a visitor views a Product page they get 5 “points” but if they view a product demo video, they get 8 “points” and so on.  I tend to use Participation metrics or segments in Discover to determine which pages should be rating higher than others.  If you have implemented this, one of the cool ways you can use it is to identify the current website score of a website visitor who completes a web form and pass it to your CRM system.  Let’s say that your sales team receives hundreds or thousands of new leads each day.  One way they can determine which ones they should call first might be to see how active each has been on the website.  If one prospect comes through with a website score of “10″ and another with “54″ which one would you call?  While this isn’t meant to replace a full-blown lead management system, it is another data point that can be passed from Web Analytics to CRM.

Lead Nurturing
Unfortunately, there are most likely way too many visitors for your sales team to talk to and not all of them are truly qualified.  Therefore, one of the key strengths of CRM tools is that they can nurture or re-market to prospects via e-mail and other platforms.  For example, it would be common for a company to use its CRM tool to automatically schedule an e-mail to go to all prospects who are interested in Product X and have more than 500 employees.   However, what is often missing from these types of nurturing programs is the deep insights that can come from your Web Analytics tool.  Building upon the preceding scenario, if we have a connection between a particular prospect and their Website cookie ID, as they come back to the site and click on more things, we should be pushing that information into our CRM tool and having it then decide which re-marketing information the prospect receives.  For example, if the prospect above started clicking on items related to another CME product (say Eurodollars), the sales person may not have any plans in the next week to look at this person’s record so they would never know that.  But by automating the data exchange between the Web Analytics tool and the CRM tool, specific product flags could be triggered that would result in the prospect being intelligently nurtured with little human intervention.  If you are interested in Lead Nurturing, you can also look at tools like Eloqua which partner with CRM tools to provide this type of functionality.

Passing Key Website Metrics to CRM
The last concept I will cover in this post is the passing of key website metrics to your CRM system.  Most sales organizations use conversion funnels that are not unlike what we are used to in Web Analytics.  However, their funnels normally begin with new Leads and progress through different sales stages until business is won or lost.  The one flaw in this model is that it doesn’t account for the true potential of selling opportunities that exist.  A true salesperson would say that anyone who visits their company’s website is an opportunity for a sale so the way I look at it, they should include metrics like Unique Visitors and people who View a Demo or see a Lead Form as part of their sales funnel.  I also think that getting sales to think of their funnel in a larger context helps bridge the gap between Sales and Marketing and opens the door for increased cooperation.

Therefore, one of the ways I do this is to take the traditional sales funnel and add some of our Web Analytics KPI’s to it like this:

Final Thoughts
So covers most of the topics related to passing Web Analytics data into CRM.  In the next post I will cover the flip-side and show how you can pass CRM data into your Web Analytics tool.

Categorized under General

  • Hugh Macken

    Adam, great post. I just started reading about you in Jim Sterne’s book “Social Media Metrics.” I reasly liked what you had to say. Did you ever resolve the issue of no “Twitter” referral data from 3d party clients like tweetdeck? If not let me know; I’d be happy to try and help.

    I just wanted to comment briefly on the crm integration issues you mention above. Attensity recently acquired biz360. One of the reasons: to allow the two companies to get a bit closer to providing a truly social crm. The one piece they are probably missing is web analytics similar to what omniture offers. I think those three combined with Salesforce would be one ver powerful combination indeed.

  • Adam Greco


    Still no solution to the Twitter referral issue from 3rd parties that I know of…

    I am not familiar with biz360, but they look to be in the same genre as Radian6. Right now I think that Social Media to CRM integration has trumped Web Analytics-CRM integration, but I think both have their place…

  • Jame Ervin

    This was an interesting post. It is great to be able to get a full view of your prospects online behavior, and off course the cottage industry of marketing automation has sprung up to help build those customer profiles. I think it is still hard to get a consolidated view of everything and would love to see more social media reporting in both web analytics and marketing automation platforms.


Recent Blog Posts

Registration for ACCELERATE 2014 is now open
Eric T. Peterson, Senior Partner

I am excited to announce that registration for ACCELERATE 2014 on September 18th in Atlanta, Georgia is now open. You can learn more about the event and our unique "Ten Tips in Twenty Minutes" format on our ACCELERATE mini-site, and we plan to have registration open for our Advanced Analytics Education pre-ACCELERATE training sessions in the coming weeks.

Continue reading this article ... ... more from Eric T. Peterson

Current Order Value
Adam Greco, Senior Partner

I recently had a client pose an interesting question related to their shopping cart. They wanted to know the distribution of money its visitors were bringing with them to each step of the shopping cart funnel.

Continue reading this article ... ... more from Adam Greco

A Guide to Segment Sharing in Adobe Analytics
Tim Wilson, Partner

Over the past year, I've run into situations multiple times where I wanted an Adobe Analytics segment to be available in multiple Adobe Analytics platforms. It turns out…that's not as easy as it sounds. I actually went multiple rounds with Client Care once trying to get it figured out. And, I’ve found "the answer" on more than one occasion, only to later realize that that answer was a bit misguided.

Continue reading this article ... ... more from Tim Wilson

Currencies & Exchange Rates
Adam Greco, Senior Partner

If your web analytics work covers websites or apps that span different countries, there are some important aspects of Adobe SiteCatalyst (Analytics) that you must know. In this post, I will share some of the things I have learned over the years related to currencies and exchange rates in SiteCatalyst.

Continue reading this article ... ... more from Adam Greco

Linking Authenticated Visitors Across Devices
Adam Greco, Senior Partner

In the last few years, people have become accustomed to using multiple digital devices simultaneously. While watching the recent winter Olympics, consumers might be on the Olympics website, while also using native mobile or tablet apps. As a result, some of my clients have asked me whether it is possible to link visits and paths across these devices so they can see cross-device paths and other behaviors.

Continue reading this article ... ... more from Adam Greco

The 80/20 Rule for Analytics Teams
Eric T. Peterson, Senior Partner

I had the pleasure last week of visiting with one of Web Analytics Demystified’s longest-standing and, at least from a digital analytical perspective, most successful clients. The team has grown tremendously over the years in terms of size and, more importantly, stature within the broader multi-channel business and has become one of the most productive and mature digital analytics groups that I personally am aware of across the industry.

Continue reading this article ... ... more from Eric T. Peterson

Ten Things You Should ALWAYS Do (or Not Do) in Excel
Tim Wilson, Partner

Last week I was surprised by the Twitter conversation a fairly innocuous vent-via-Twitter tweet started, with several people noting that they had no idea you could simple turn off the gridlines.

Continue reading this article ... ... more from Tim Wilson

Omni Man (and Team Demystified) Needs You!
Adam Greco, Senior Partner

As someone in the web analytics field, you probably hear how lucky you are due to the fact that there are always web analytics jobs available. When the rest of the country is looking for work and you get daily calls from recruiters, it isn’t a bad position to be in! At Web Analytics Demystified, we have more than doubled in the past year and still cannot keep up with the demand, so I am reaching out to you ...

Continue reading this article ... ... more from Adam Greco

A Useful Framework for Social Media "Engagements"
Tim Wilson, Partner

Whether you have a single toe dipped in the waters of social media analytics or are fully submerged and drowning, you’ve almost certainly grappled with "engagement." This post isn’t going to answer the question "Is engagement ROI?" ...

Continue reading this article ... ... more from Tim Wilson

It’s not about "Big Data", it’s about the "RIGHT data"
Michele Kiss, Partner

Unless you’ve been living under a rock, you have heard (and perhaps grown tired) of the buzzword "big data." But in attempts to chase the "next shiny thing", companies may focus too much on "big data" rather than the "right data."

Continue reading this article ... ... more from Michele Kiss

Eric T.








Contact Us

You can contact Web Analytics Demystified day or night via email or by reaching out to one of our Partners directly.

» Contact Information

Web Analytics Demystified, Inc.
P.O. Box 13303
Portland, OR 97213
(503) 282-2601

Useful Links