As noted in Occam’s Razor by Avinash Kaushik, as well as his popular books Web Analytics 2.0 and Web Analytics: An Hour a Day, the most important aspect of any web analytics initiative is getting to the actionable insights that drive strategic decisions. He says that from raw data alone, it is impossible to deduce [...]
In part 1 of this article, I introduced a new report that shows some of the powerful analytics capabilities of Nextanalytics for Excel – in this case, a full series of tables exploring the relationships between the Recency, Loyalty, Duration and Depth segmentation. This Excel-based dashboard also provides the ability to filter by any of [...]
Most of the templates and sample reports that I’ve posted simply demonstrate that Nextanalytics can produce all the same web reports you have seen elsewhere. But Nextanalytics can go so much further; we’re not just another quick and easy reporting tool – we can run with the big dogs.
In this example, we not only create [...]
As I was digging into some web traffic from Brazil, I happened to notice that the most popular screen resolution was 1024 x 768. OK, that makes sense, but it got me thinking…with all the huge resolution desktop screens, wide screen laptops and odd-shaped mobile devices, just what is the most common size/shape of display [...]
Stephane Hamel of Immeria created a sample dashboard in Excel (link) that took off virally, becoming a popular starting point for others (link) (link) to create their own solutions. I applaud his work and his creativity. In the comments to his blog, though, a number of people found the complexity daunting. I am a strong [...]
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 [...]