To understand today’s customer and performance of your marketing efforts, web analytics data has to move out of it’s silo and needs to be integrated with other data sources.
Many of you might be already be using 3rd party solutions to pull data from few sources into a dash boarding tool. That is a great start but it still does not provide you a complete view of customer journeys. For example, just because you have social media mentions on the same dashboard as your on-site analytics data does not tell you if those mentions are from your customers or somebody, who is neither a customer nor is your target customer, just blabbering in social media. But I will give you credit for thinking outside the Web Analytics tool.
To understand complete customer journey (i.e. 360 degree view of customer) and to conduct analysis that take you from marginal improvements in conversions to something that has a huge impact on the business you need much more detailed data than a web analytics report or a dash boarding tool can provide. First, you need to collect individual data for each customer in various channels then warehouse the data in one place where you join various sources via common key such as customer id, email address, phone number etc. Only then you can create and run complex cross channel queries to understand try customer behavior and campaign performance.
Many mature organization are already doing it or are working on it. If you are not then it is about time to start thinking about if you want to stay competitive.
Don’t think that just because you are using Google Analytics you can’t have this level of data because you can. You just have to push yourself and start thinking outside what your web analytics tool can provide.
How Can You Do it
Web Analytics tools already anticipated this needs so they have built a way for you to get the data out easily. You can use either of the two methods listed below to get the required data
- APIs – Many tools like Google Analytics provide data via APIs. Use those APIs to pull appropriate data into your datamart/datawarehouse.
- Data Feeds – Many tools provide data in a flat file that you can use to populate your datamart.
Here are few things to keep in mind before you start putting this data in your datamart
- Make sure your tools are configured properly to collect the data in the right format and
- Your data transformation process should be able to understand the difference between various custom variables that you have used in the data collection
- Various data sources also need proper identifiers (keys) to match them together.
This is not going to be an easy project but this is a critical step in using your web analytics data to stay competitive.
There are few 3rd companies who are already providing tools and service to help you with it. I recommend looking at iJento Datamart solution (Note: I work for iJento). You should also check out Gary Angel’s Blog. Gary has worked and written extensively on this topic.
If you have any question, I will be happy to chat. Email me.