Using the unique capabilities of the Nextanalytics add-in for Excel 2007 (2003 version also available), we whipped up a quick dashboard that combines many of the key visitor-tracking metrics from Google Analytics all on one page, and it’s all yours, in a Microsoft Excel workbook. Use it as-is or customize to suit your distinctive needs. [...]

Third in the series (see Visitors overview, Traffic Sources overview) of Excel-versions of typical Google Analytics reports, the Content Overview report provides the detail on what web pages are the most popular. Starting with an overall trend chart showing page views totals by date, the report includes high-level counts and mini-trend-charts for both the page [...]

Have you ever wanted your Google Analytics reports in Excel, so you can share them with your boss? Maybe add a tweak or two to reflect your (or ‘Her’) unique needs? Well, now you can, and you don’t have to be an Excel whiz to do it! Start with our XLS file, and simply enter [...]

If you are looking for an Excel version of the standard Google Analytics Traffic Sources Overview, this is it, delivered using Nextanalytics for Excel. It includes the usual total visits trend and the top mediums listed on a percentage basis with micro-trends and a summary pie chart.  Across the bottom, it shows the top sources [...]

Peter O’Neill of Logan Tod posted an article outlining his requirements for an Excel plug-in for Google Analytics. After a couple of follow-up conversations with Peter, let me respond to his requirements list and show how Nextanalytics for Excel delivers the ideal solution.

When monitoring web sites, it is easy to get lost in the day to day details, and every now and then you need to step back just a bit and take a look at a larger picture. Usually longer term trends are viewed as a single line chart or page views or visits, and it [...]

There are a large number of dimensions and metrics recorded by Google Analytics, and each of them provides some unique insight into your web site visitors and their behaviour. When looking at the visitors, it helps to build a profile of where they are from, how they came to your site and what they used [...]

A sudden change in web site traffic appears and you have to explain it to your boss. Here is an example of a quick analysis using Nextanalytics for Excel with Google Analytics that not only gets to the information you need quickly, but it gives you repeatable presentation material with very little extra effort.

When you want to analyze first-time visitors to your web site, where they land first is often a key question. Maybe you had an email campaign with embedded links or you want to measure traffic from blogs that targeted special landing pages. Your challenge is to identify and report on the traffic to these special [...]

When building a trend report with Nextanalytics for Excel, you have complete control over the date format displayed. By displaying only the year or month components, the data is automatically aggregated accordingly.