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

A very common challenge in corporate web reporting is determining the appropriate metrics for fiscal periods that differ from the calendar. This multi-part article discusses how we can use the Next Analytics Excel add-in to overcome our fiscal reporting challenges. In Part I, we looked at the simple case of reporting fiscal weeks where the [...]

A very common challenge in corporate web reporting is determining the appropriate metrics for fiscal periods that differ from the calendar. This multi-part article discusses how we can use the Next Analytics Excel add-in to overcome our fiscal reporting challenges.
Let’s start with fiscal week reporting. Most fiscal weeks start on Sunday, and if that is [...]

Question: I want to set up a YTD figure so the figures include every complete calendar month for the year (e.g. if the date today was April 2nd, I would need the figures for Jan, Feb and March only)
Answer: The simplest solution would be to make a query for the “LastCalendar 2 Months” and save [...]