Many common analytics reports are looking for one or two dimensions trended by date, usually month or week. With the Google Analytics API, the year, month and week dimensions are independant values. This article shows how to concatenate them and pivot the resulting column.
For this example, we’ll show the visitor type trend by month. Start [...]

Google Analytics uses a line chart across most of their pages, showing the trend of traffic over time. I guess the idea is that you can visually see trends from week to week, month to month, but that has never worked for me. The weekly bump and weekend dips make the chart busy and confusing. [...]

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

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.

By using Nextanalytics for Excel to load and pivot your data, you gain immediate access to information you can use. You don’t have to struggle with changing field formats, building transformation formulas or struggling with Excel’s complicated pivot tables.