What You Should Know about Historical Data in Web Analytics

For many of us, historical data in web analytics is very important because it helps us optimize 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 should I invest my money and resources?
  • Which keywords should I bid on?
  • Who are my best customer types in terms of revenue generation?

We often time travel to get an 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.

Attribution Modelling in Google Analytics and Beyond
Attribution Modelling in Google Ads and Facebook

Get my best selling books on Attribution Modelling

  • Learn to implement attribution modelling in your organisation
  • Understand the customer purchase journey across devices
  • Determine the most effective marketing channels for investment

 Click book covers to find out more

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 month. They are not the products which sold the most in the last three months and certainly not the one sold in the last year.

This is because we live and operate in a constant change of marketing conditions, trends, buying behaviour, 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 three 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 anymore?

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 three 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 that assisted in a lot of sales through organic search during those three months?

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

The important thing to remember here is that assisted marketing channels (channels that assisted 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 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 for changes in assisted marketing channels/mediums over time

  1. You got a guest post opportunity on a big authoritative website and as a result, you got a 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 that was high in demand but short in supply.
  4. Your link bait went viral which resulted in a 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 a number of profitable keywords.
  8. You started leveraging two new marketing channels to promote your contents: Slideshare 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 anymore.
  • Your linkbait 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 the 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 assists 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 overlook the role, assisted marketing channels played in your historical data then you will attribute conversions to wrong marketing channels and lose money.

Attribution Modelling in Google Analytics and Beyond
Attribution Modelling in Google Ads and Facebook

Get my best selling books on Attribution Modelling

  • Learn to implement attribution modelling in your organisation
  • Understand the customer purchase journey across devices
  • Determine the most effective marketing channels for investment

 Click book covers to find out more

Do you want expert help in setting up/fixing GA4 and GTM?

If you are not sure whether your GA4 property is setup correctly or you want expert help migrating to GA4 then contact us. We can fix your website tracking issues.


My step-by-step blueprint for selecting the best Excel charts for data analysis and reporting (40 pages)

Get the FREE e-book on Best Excel Charts For Data Analysis And Reporting (40 Pages)

Download the FREE ebook

 

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. This way you can minimize the impact of the 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, three 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 four months, six months, or one year.

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

Comparing one year of 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 insists 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.

  1. How to valuate Display Advertising through Attribution Modelling
  2. Understanding Shopping Carts for Analytics and Conversion Optimization
  3. 6 Keys to Digital Success in Attribution Modelling
  4. Google Analytics Attribution Modeling Tutorial
  5. How to Measure and Improve the Quality of SEO Traffic through Google Analytics
  6. How to explain attribution modelling to your clients
  7. Default and Custom Attribution Models in Google Analytics
  8. Understanding Missing Touchpoints in Attribution Modelling
  9. What You Should Know about Historical Data in Web Analytics
  10. Model Comparison Report Explained in Google Analytics Attribution
  11. Data-Driven Attribution Model in Google Analytics – Tutorial
  12. Conversion Lag Report Explained in Google Analytics Attribution
  13. Selecting the Best Attribution Model for Inbound Marketing
  14. How to do ROI Analysis in Google Analytics
  15. Conversion Credit Models Guide – Google Analytics Attribution
  16. Introduction to Nonline Analytics – True Multi Channel Analytics
  17. Conversion Types Explained in Google Analytics Attribution
  18. Attribution Channels Explained in Google Analytics Attribution
  19. Differences Between Google Attribution & Multi-Channel Funnel Reports
  20. Introduction to TV Attribution in Google Analytics Attribution 360
  21. Conversion Credit Distribution for Attribution Models in Google Analytics
  22. Conversion Paths Report Explained in Google Analytics Attribution
  23. Attribution Model Comparison Tool in Google Analytics
  24. Touchpoint Analysis in Google Analytics Attribution Modelling
  25. Attributed Conversions & Attributed Revenue Explained in Google Attribution
  26. Which Attribution Model to use in Google Analytics?
  27. Google Attribution Access and User Permissions – Tutorial
  28. Conversion Path Length Report Explained in Google Analytics Attribution
  29. How to set up a data-driven attribution model in Google Analytics
  30. View-Through Conversion Tracking in Google Analytics
  31. Offline Conversion Tracking in Google Analytics – Tutorial
  32. How to Create Custom Attribution Model in Google Analytics
  33. 8 Google Analytics Conversions Segments You Must Use
  34. You are doing Google Analytics all wrong. Here is why
  35. How to Use ZMOT to Increase Conversions and Sales Exponentially
  36. Connected Properties Explained in Google Analytics Attribution
  37. Marketing Mix Modelling or Attribution Modelling. Which one is for you?
  38. How is attribution modelling helpful for ecommerce and non-ecommerce websites?
  39. Conversion Time & Interaction Time Explained in Google Analytics Attribution
  40. How to Allocate Budgets in Multi Channel Marketing
  41. How Does Attribution Work?
  42. Data-Driven Attribution Model Explorer in Google Analytics
  43. Introduction to Attribution Beta – Attribution Project in Google Analytics

My best selling books on Digital Analytics and Conversion Optimization

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 BeyondSECOND EDITION OUT NOW!
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.

Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.

About the Author

Himanshu Sharma

  • Founder, OptimizeSmart.com
  • Over 15 years of experience in digital analytics and marketing
  • Author of four best-selling books on digital analytics and conversion optimization
  • Nominated for Digital Analytics Association Awards for Excellence
  • Runs one of the most popular blogs in the world on digital analytics
  • Consultant to countless small and big businesses over the decade