It is surprisingly hard to get day-of-week information out of Google Analytics, and the ‘best’ scenario I have heard is to compare one week to another. That’s not much of a trend, but I guess it’s something. With Next Analytics for Excel, there is a simple way to get reports by day-of-week that lets you create [...]

In this week’s Excel dashboard, we look at website landing pages – which ones are your most effective and how different visitor groups treat them. Four major segments are shown side-by-side: direct traffic, visits from search engines, visits from referring web sites, and clicks from paid advertising. Leveraging Excel’s conditional formatting makes it easy to [...]

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

In this week’s Web Analytics TV with Avinash and Nick, Lisa C asked if it was possible to see a trend report for the top landing pages from SEO. Although Avinash agreed “I want this!”, he said this is one of those reports that is only possible through the API today. Since Next Analytics has [...]