What You Should Know about Historical Data in Web Analytics

For many of us, historical data in web analytics is very important because it help us in optimizing our marketing campaigns and efforts.

Let’s go one year back in time:

# What are my top selling products?

# Which is the most effective marketing channel in terms of conversions?

# What are my top converting keywords?

# Who are my top competitors?

# Where I should invest my money and resources?

# Which keywords I should bid on?

# Who are my best customer types in terms of revenue generation.

We often do time travel to get answer to these burning questions.

But the problem with historical data is that it is historical. It is dated.

The insight that you get from analyzing historical data is out of date and it does not always match with the present marketing conditions. The older the data, the more it stinks.

What are my top selling products?

Let us answer this question. Your top selling products are the products which sold the most last week or at most in the last one month. They are not the products which sold the most in the last 3 months and certainly not the one sold in the last one year.

This is because we live and operate in a constant change of marketing conditions, trends, buying behavior, pricing, competition and multi channel funnels.

For example, let us assume you concluded that: “our top selling products are ‘A’, ‘B’ and ‘C’ according to our last 3 months analytics data and we should continue to invest in them”.

But what if the product ‘A’, ‘B’ and ‘C’ are now out of stock or are not sold any more?

What if the sales of these products are declining now but you continue to invest in them because they sold the most in the last 3 months?

What if the potential sales of these products are bleak because a strong competitor say ‘amazon’ has made entry into your market?

What if you no longer run that email campaign and that Facebook campaign which assisting in lot of sales through organic search during those 3 months?

There can be lot of ‘ifs ‘and ‘buts’.

The important thing to remember here is that assisting marketing channels (channels which assist in conversions) change all the time and we often overlook them and rely only on the marketing channels which directly completed the conversions.

Note: If what I am saying is not making much sense to you then I strongly suggest you to read this post first: Attribution Modelling in Google Analytics and then The Geek Guide to implementing Attribution Modelling.Both of these articles explain attribution modelling in great detail.

Possible reasons of change in assisting marketing channels/mediums over time

1. You got a guest post opportunity on a big authoritative website and as a result you got lot of exposure, signups and sales.

2. You changed your website design which dramatically improved the conversion rate of your website.

3. You sold a product which was high in demand but short in supply.

4. Your link bait went viral which resulted in lot of exposure and conversions.

5. You bid on new keywords which turned out to be very profitable because of low competition and CPC.

6. You fixed serious website architecture issues which dramatically improved the crawling and indexing of your website and eventually resulted in more conversions and sales.

7. You captured new top positions both in organic and paid search for number of profitable keywords.

8. You started leveraging two new marketing channels to promote your contents: Slidershare and Linkedin

Now the problem is

History does not repeat itself in online marketing.

It is highly unlikely that you can replicate your success rate by carrying out the aforesaid task once again in the ever changing online landscape. There is always a possibility that this month:

  • Your post may not get published on an authoritative blog.
  • There may be no changes to the website design.
  • Your top selling product may not be in short supply any more.
  • Your link bait doesn’t go viral.
  • Your profitable keywords are no longer as profitable as they used to be.
  • You may no longer have any website architecture issue to fix which can dramatically improve crawling and indexing of your website.
  • You may get new competitors who capture some of your profitable ranking positions both in organic and paid search.

There is also a possibility that this month a completely new set of marketing channels assist in your conversions.

All these hidden channels/mediums impact conversions and that is why your organic and paid search campaigns perform differently each month even if you don’t directly make any considerable changes to them. So if you optimize your marketing campaigns and overlooked the role, assisting marketing channels played in your historical data then you will attribute conversions to wrong marketing channels and loose money.

Get the FREE E-Book (52 Pages)

So what is the solution? Should you discard historical data completely?

No. Do not discard historical data but look at the most recent one. As a rule of thumb,

Rule #1: The more you segment your data, the smaller should be your time frame for historical analysis.

Rule #2: The more you look at the data in an aggregate form, the bigger should be your time frame for historical analysis. 

For example,

If you want to know your top selling products then look at most, one month old data. In this way you can minimize the impact of ever changing online landscape on your marketing and business decisions and get optimum results from your marketing campaigns.

If you want to know your top selling product categories then look at most, 3 months old data.

If you want to measure the  quarterly or annual growth of the entire business in terms of sales, leads, total visits etc then choose bigger time frames like 4 months, 6 months or 1 year. 

One year is a very long time period in online world and any period longer than that can be considered pre-historic.

Comparing one year web analytics data to the last year can be like comparing apples to oranges because so much would have changed during that time from website size, traffic, products, competitors to your target market. If your client/boss insist on using historical data with longer time intervals then educate him about the ever changing online landscape, competition and changes made to your website and campaigns.

As such, a traditional MMM model is not suitable for carrying out digital marketing mix modelling aka attribution modelling.

Other articles on Attribution Modelling in Google Analytics

  1. Touch Point Analysis in Google Analytics Attribution Modelling
  2. 8 Google Analytics Conversions Segments You Must Use
  3. Default and Custom Attribution Models in Google Analytics
  4. Attribution Model Comparison Tool in Google Analytics
  5. Which Attribution Model to use in Google Analytics?
  6. How to create Custom Attribution Model in Google Analytics

  1. How to do ROI Analysis in Google Analytics
  2. Data-Driven Attribution Model Explorer in Google Analytics
  3. Guide to Data Driven Attribution Model in Google Analytics
  4. Conversion Credit distribution for Attribution Models in Google Analytics
  5. You are doing Google Analytics all wrong. Here is why

  1. Marketing Mix Modelling or Attribution Modelling. Which one is for you?
  2. Introduction to Nonline Analytics – True Multi Channel Analytics
  3. How to set up Data driven attribution model in Google Analytics
  4. How to valuate Display Advertising through Attribution Modelling
  5. Understanding Shopping Carts for Analytics and Conversion Optimization

  1. View-through conversion tracking in Google Analytics
  2. Understanding Missing Touch Points in Attribution Modelling
  3. Guide to Offline Conversion Tracking in Google Analytics
  4. How to explain attribution modelling to your clients
  5. 6 Keys to Digital Success in Attribution Modelling

  1. How to use ZMOT to increase Conversions and Sales exponentially
  2. How to Measure and Improve the Quality of SEO Traffic through Google Analytics
  3. How to analyse and report the true value of your SEO Campaign
  4. How to allocate Budgets in Multi Channel Marketing
  5. Google Analytics Attribution Modelling – Complete Guide

  1. Google Analytics Not Provided Keywords and how to unlock and analyze them
  2. Selecting the Best Attribution Model for Inbound Marketing
  3. Introduction to TV attribution in Google Analytics Attribution 360
  4. Cross Device Reports in Google Analytics via Google Signals

Learn about the Google Analytics Usage Trends Tool

The Google Analytics usage trend is a new tool which is used to visualise trends in your Google Analytics data and to perform trend analysis.

Do you want to Learn Web Analytics in 4 Weeks?

  • Learn and Master Web Analytics, Conversion Optimization & Google Analytics from Industry Expert in 4 weeks.
  • Lifetime access to the course + Lifelong FREE course updates.
  • New study material added every few months (lifelong learning).
  • Up to date training material.
  • Most exhaustive course on Google Analytics on the internet.
  • Hundreds of Assessments to test your learning.
  • Your 24/7, 365 days a year reference source.
  • Learn at your own pace and from any place.
  • Risk Free with 30 days 100% Money Back Guarantee.

Take your Analytics knowledge to the next level. Checkout my Best Selling Books on Amazon

Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.

Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.

Attribution Modelling in Google Analytics and Beyond
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.

Himanshu Sharma

Certified web analyst and founder of OptimizeSmart.com

My name is Himanshu Sharma and I help businesses find and fix their Google Analytics and conversion issues. If you have any questions or comments please contact me.

  • Over eleven years' experience in SEO, PPC and web analytics
  • Google Analytics certified
  • Google AdWords certified
  • Nominated for Digital Analytics Association Award for Excellence
  • Bachelors degree in Internet Science
  • Founder of OptimizeSmart.com and EventEducation.com

I am also the author of three books:

error: Alert: Content is protected !!