Resources

L3 Analytics Resources

The team at L3 Analytics have developed various resources to aid in their work.  We are pleased to offer these as freely available although ask that credit is attributed back to L3 Analytics.  The tools that have been developed are listed below with links through to blog posts describing their usage.  All tools can be downloaded via the relevant buttons on this page.

Excel Performance Dashboards

These templates are designed so anyone can set up their own Performance dashboards.  They allow for up to 12 metrics and 6 segments with data compared against a reference number and trended over time.  Dashboards can be produced to display Daily, Weekly or Monthly Performance with various options to compare the data against.  The set-up and updating of this dashboard are both automated.

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

Download Free Dashboard Templates

If you need a more customised dashboard for your organisation’s needs, please contact us and we would be happy to provide you a quote:

Get a Quote for Customised Dashboards

Campaign URL Builders

L3 Analytics has created Excel tools for generating campaign URLs for Google Analytics and Adobe (Omniture) SiteCatalyst.  These simplify the process of generate the URLs, enforce a strong naming convention for easier analysis of performance and, for SiteCatalyst, generate the SAINT file for upload.  The tools can be used with any and all marketing channels from Paid Search to Social Media to Offline Marketing.  Instructions are included within each Excel file with more details available on the relevant blog post.

Google Analytics Campaign URL Builder

L3 Analytics blog post introducing the GA Campaign URL Builder

Download Google Analytics Campaign URL Builder

Download Google Analytics Social Media URL Builder

Download Google Analytics Paid Search URL Builder

SiteCatalyst Campaign URL Builder

L3 Analytics blog post introducing the SiteCatalyst Campaign URL Builder

 

URL Query Parameter List Builder

This tool is used to create a list of URL query parameters to be excluded from a Google Analytics account.  Simply export a list of relevant page names, copy into the tool and run the macro – the list of URL Query Parameters is automatically generated.  Read this post for details on the benefits of and how to use the URL Query Parameter List Builder.