A Google Analytics Keyword Tag Cloud in Excel

I have seen tag clouds used all over the web to visualize what keywords are the most  popular, and thought it would be a good additional to the Next Analytics dashboard collection.  Tag clouds can easily be applied to situations where you want to see what people are looking for or talking about — anywhere [...]

Monthly Metrics – Measuring your Keywords

Jim Gianoglio over at LunaMetrics posted an interesting blog yesterday, suggesting that there is value in tracking the number of keywords referencing your site over time. He laid out an interesting argument that it is supposed to give you a good indication of how well you fair on search indexing and whether there are issues [...]

A What’s Changed Report for Google Analytics

With all the online reports provided by Google Analytics, the one that seems to be missing, years after it was pointed out, is the What’s Changed Report. Way back in 2007, Avinash Kaushik wrote in his blog (Occam’s Razor) and his book (Web Analytics, An Hour a Day) about the wonderful value of [...]

Top Analytics Reports for Bloggers

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 [...]

Traffic Sources Overview Report

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 [...]