More Free Excel Dashboard Templates for Web Analytics
24/04/2012 | Written by | Categories: Analytics Tools

Interactive table contains reports and 3D charts

The Excel template released in May last year for creating Performance dashboards has proven to be incredibly popular and successful.  It was downloaded over 7,000 times by the end of 2011 with people using it within small & big companies around the world.  The original blog post also hit some very high rankings in Google, around #2 for terms like excel dashboard templates.

Given this success, I have created two new Excel dashboard templates.  Many of the same features of the original template have been carried across to these new templates:

  • Automatic creation of dashboards based on the settings entered
  • Choose between a dashboard with or without segments
  • Ability to create a daily, weekly and monthly version of the dashboard
  • Define your own metrics including the number format and desired direction
  • Automatic updating of dashboard once data entered into Data Summary worksheet
  • Select the comparison period for metrics and the level for large movements in the metric
  • Any metric can be selected in a drop-down to appear in charts
  • Dashboards work in all versions of Excel except Excel ’04 for Macs

But these are new templates with new features, designed for different purposes.  I expect them to be most useful for web analytics data but some people may think of other purposes.

Ecommerce Dashboard Template

This dashboard template has been designed to be used with ecommerce websites.  The key difference from the Performance Dashboard is that the Ecommerce Dashboard contains a funnel instead of two of the data tables.  Other features include:

  • Two data tables containing up to four metrics each
  • Funnel with up to six stages containing metrics for each stage PLUS the completion rate between stages
  • Ability to select any metric or completion rate to appear in charts
  • Three versions of the dashboard containing either two charts or one chart + a commentary section

View of the Ecommerce Dashboard

Marketing Dashboard Template

This dashboard template has a very different format to the other two dashboard templates.  The main feature is a single data table that contains up to six metrics for each of a list of traffic sources – including “Other” and “Total”.  Other features include:

  • The % change against a previous period for each metric
  • Column chart allowing comparison of a KPI across all traffic sources
  • Line chart displaying trend for selected KPI for selected traffic source

Screenshot of Marketing Dashboard

Free Templates Downloads

As with the original dashboard templates, these templates are available for free download.  They are released under a Creative Commons licence meaning they are free to use but credit back to L3 Analytics must be retained.  The Performance Dashboard template has been updated to remove a few bugs and update the approach in saving data with the new version also available.

One user of the Performance Dashboard template asked if a button could be added so he could leave a contribution as a thank you for the dashboard.  Instead I request that anyone who benefits from these free templates makes a donation to charity.

Click through for more information and to download the free Excel dashboard templates.

Download Free Dashboard Templates
Finally, if you do need a dashboard customised for your organisation’s needs or if you would like a data extract built for Google Analytics or Omniture SiteCatalyst, please contact me and I would be happy to provide you with a quote.

Get a Quote for Customised Dashboards

2 responses to “More Free Excel Dashboard Templates for Web Analytics”

  1. Koen says:

    What I don’t understand is how these templates connect with Google API. You can’t provide an Google Analytics account anywhere. Am I missing something?


    • Peter O'Neill says:

      Hi Koen – simple answer is they don’t. The dashboards can be used for any purpose, most common appears for finance. I personally use Next Analytics to import GA data, linking the Data Summary worksheet to a Data Extract worksheet. If done properly (with any data source), you then press one button to extract the data and a second button to update the dashboard.

      It is just not possible to create templates that automatically integrate with GA for any metrics/segments. I am working on a side project to create online dashboards following the same template but even then, part of the cost will be to define that data extract from GA.

Leave a Reply

Your email address will not be published. Required fields are marked *

Looking to improve your digital analytics or conversion rate optimisation?
Contact us today on +44 (0)20 7148 5970

Alternatively, come visit us in London and we’ll buy the coffee!
Get in touch
Leave us a message
Use the form below to leave us a message.

Lindsey Street