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 [...]
Using Excel to report web analytics is fraught with challenges. This article explores how Next Analytics for Excel overcomes the 6 major obstacles.
When Google announced the release of 127 new dimensions and metrics available from the Google Analytics API on Jan.25, 2011, there was hardly a peep about the HUGE relaxation of the rules about what dimensions and metrics could be queried together. I am amazed that no one has picked up on it since then! Well, [...]
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 [...]
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 [...]
Next Analytics was already the best Excel add-in for automating your Google Analytics reporting, but with the release of version 3,1, we have included a Batch Scheduler and a Command Line Utility that take things to a whole new level of automation. And with 3.1, you can also get Facebook, Twitter, LinkedIn and even SQL [...]
When making weekly reports from the Google Analytics API, it is most efficient to download your data using Google’s year and week dimensions. This produces a row of data for each calendar week in the report, but it leaves you with a report that contains no dates — just week numbers. Most people don’t think [...]
I saw a tweet today about an old Google Analytics blog article about custom reporting, and in the comments, it seemed that everyone wanted a simple report showing the popularity of various browser versions. That is not a report you can make using Google Analytics custom reports, so it has gone unanswered…until now. Using the [...]