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 run a blog, DailyBlogTips recommends the Top 5 Google Analytics Reports for Bloggers. We’ve produced a quick dashboard using Nextanalytics for Excel to give you access to all this information in one quick overview, refreshed with the click of a button. You’ll see (1) the top traffic sources that your visitors are coming [...]
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 [...]
For many reports, it is good to see the largest items in a list (top 10 web pages, top 20 keywords, etc). You are only getting part of the story if you don’t keep those items in perspective to the whole – what was the total for all the rest of the items? In this [...]
When building a dashboard for web reporting, people often want a quick summary or overview on the first sheet. In the overview, they’d like to see a few key traffic metrics as well as an indication of the trends over the period. This is easy to do with Nextanalytics and some simple Excel charting.
Using Google Analytics web analytics service to monitor your web site gives you some excellent metrics to monitor the engagement level of your site visitors. Engagement is typically measured with four distribution reports that explore your visitors’ loyalty, recency, and the duration and depth of visit profiles. Distribution reports can be very difficult to program [...]
When building a web analytics dashboard, adding interactivity is often required to make the application truly useful. In this example, you will see how we can add a web profile selector to our web dashboard with very little effort.
This is part of a series showing how easily you can build a daily web dashboard using Nextanalytics for Excel with the new Google Analytics connector. In this article, I want to show how to add a new item to an existing workbook (our Daily web dashboard). Along the way, you will see how easy [...]