Unlocking the Value In Your Clickstream Data

by Bal Basra

In 2017, 65% of all US retail sales involved a visit to the company’s website. And as you may have already realised, your website is one of the most important sources of data when it comes to understanding your customers’ wants, needs, and preferences. Assuming you have web analytics, this source of data gives you the opportunity to track and collect data on every single interaction a customer makes with your brand.

In-store you can track what a customer has bought or returned. On social media, you can get a view of which adverts they have seen, or which content they have browsed. But it’s only with web analytics that you can truly track every interaction, regardless if a purchase was completed.

Sure, you cannot track the mood the person was in when browsing nor what they had for breakfast. But no other channel gives you the chance to learn so much about your customers. From which pages and products someone has viewed to time spent on page and engagement with bespoke content widgets. From basket interactions to video plays and customer feedback views. It’s clickstream data capture which allows you to track every interaction with your brand.

The aforementioned clickstream audience gets us to a point where most organisations are today, leveraging their clickstream data in their chosen personalisation, DMP, and email tools. There is, however, much more that can be done with this data. You might say that you could look at a customer’s historical in-store transactions and work out what you think they might be interested in next. However, finding a segment of 100,000 people, in the last 14 days, who have viewed a certain product type without purchasing, is undeniably more powerful. I know which audience I would rather market to.

So, if 65% of all US retail sales are involving a visit to the company’s website, and if overall web share of sales typically ranges between 35% – 60%, there is no doubt about the impact your website on overall sales.

How to unlock the value in your clickstream data

How can we unlock the value of our clickstream data?

Web analytics is great. You can track demand, product interest, online sales, and even identify problem areas on your digital properties. These are just some of the critical functions your web analytics tool can do. However, such tools have their limitations.

The type of querying you can do is pretty limited, as are the types of visualisations you can create. The data science functionality, when available, is restricted to proprietary, pre-defined models. The schemas that these datasets are stored in are predefined and the type of data you can pull into these applications is generally limited to lookup data.

To really unlock the value in your clickstream data you only need to pull the data out of these applications and into a Big Data platform. When you do this, you can knock down the barriers of restrictive querying, focus in on individual customers (not cookies), and get clickstream data feeding in along with your many other data sources. Only then can you truly achieve an omni-channel view of your customer.

The 5 things to keep in mind as you attempt to unlock the value in your clickstream data are:

1. Customers buy from brands, cookies do not buy from channels. Do Big Data.

Most organisations have realised that customers expect an omni-channel experience and have started (or are about to embark on) a Big Data platform project to handle this. It is of paramount importance that the clickstream data be a part of this project. Clickstream data can be tricky to work with, as Web Analytics vendors do not always provide this data in a format that is easy to use. However, with so much data on existing customers, as well as prospects, this data source is just too valuable to ignore. When the clickstream data is accurate and made available in your Big Data Platform, in a schema that makes sense, you can achieve a true, omni-channel view of how your customer is interacting view your brand and begin to understand and model how best to serve them.

2. Data Science. Stop ignoring 90% of your data.

When querying and segmenting, web analysts tend to focus on high-value data such as purchases, cart adds, visits to key pages in the conversion funnel, etc. You might then segment this data by some key dimensions, product types, geographical properties, first-time visitors, etc. Realistically you might be able to take these key metrics and apply 5 or 6 layers of segmentation to get to something interesting, be it an audience or a metric. Even in this scenario, you have probably ignored 90% of the data you have for each visitor included in the audience. Think of all of that data your Web Analytics tool collects with each tag fire. Then multiply this by the number of tag fires each visitor generates. You have so much information on your web visitors; why ignore it? Using data science techniques, you can begin to consider the other 90% of your clickstream data and begin to find behavioural patterns. For example, just because I have viewed a certain product or service more than 3 times, or added something to my basket before abandoning, does not mean I am ripe for retargeting. Conversely, just because I have not completed these interactions does not mean I am not interested in buying the product. The truth may lie in everything else I have done on your website. Start considering the full picture and use open source libraries when doing so.

3. Reporting: It is a business-wide problem

Every business needs to produce reporting that tracks sales, revenue, and demand. Clickstream data is a vital component of this, particularly for tracking digital sales but perhaps most importantly as a measure of demand for your various products and services. If you do not have your clickstream data in your Big Data Platform you are left with the unenviable task of manually trying to combine separate reports into a single sales dashboard. Worse still, you may simply ignore the clickstream data and not report on your demand levels. But with your data consolidated in one place, not only can you easily produce high-value omni-channel business reports but you can also be more agile in answering any follow-up questions, with the required data in one place and ready to use.

4. Monetise your clickstream data – It is already costing you a small fortune.

Web Analytics tools are not cheap, and the more data you collect the more you have to pay. My previous points have examined optimal ways of storing, processing and querying your data, allowing you to learn more from the data you already have. Once you have accomplished this and created various scores and segments for your existing customers and prospects, you need to get this information into the applications you use to communicate with your customers. Connections between your Big Data Platform and your marketing tools (DMP, personalisation, customer contacts, and anything else you use), be it for online or offline customer communication, need to be established. At that point, you can automate the data flows and ensure customers are receiving a relevant, personalised and consistent experience with your brand, across the different channels that are available to them.

5. Automate everything you can

Within an Analytics function, there are a limited number of people. Typically, these people are highly skilled in one or more areas of Analytics, be it querying, data science, visualisations, or data engineering. By automating as many processes as possible, you can ensure that the resources available to you are delivering new insights and are seen as a value driver rather than a potential constraint or blocker. When it comes to clickstream data, the aim is to automate the ingestion, processing, and auditing of this data in your Big Data Platform. This frees up the data engineer to work on new data sources and ensures your analysts and data scientists have up-to-date, ready-to-use data at all times. The same then applies to getting data out of your Big Data Platform and into the applications you use to communicate with your customers. Establish these data pipelines and automate these flows. Without this, you risk becoming a blocker to the business, as the time to delivery of new outbound data sends will be very long.

So, if you’re looking to boost sales and revenue, clickstream data will be your go-to source of data to find the customers to reach out to. It should also be an essential component in your businesses data strategy. If you get this data into your Big Data Platform, in a structured and usable format, and establish the required outbound data pipes, you will be able to give your analysts the tools they need to increase data value, and your marketing team will be able to maintain true, omni-channel engagement with prospects and customers.

Looking for a better way to get your Adobe Analytics data into your big data environment? Discover what an Adobe Analytics App can do for you.

You have so much information on your web visitors; why ignore it?

Share this:
Tags:   Behavioral Data

Bal Basra

Solutions Consultant at Syntasa

Bal is a Solutions Consultant at Syntasa, assisting customers and prospects in extracting the maximum value from their big data projects. He brings tremendous knowledge of analytics products and methodologies from previous positions at Adobe and TUI.