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 [...]
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, [...]
There are lots of tools out there that fetch Google Analytics data into Excel. With those other packages, you are left with repetitive monkey work, moving data around and fixing formulas.
Your bosses and clients aren’t even aware of that problem, you hate it, it’s not using your analytic skills, and you’re stuck doing it every [...]
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 [...]
A customer had a scorecard that had to be distributed for both Excel 2003 and Excel 2007.
It used Pivot Tables to lay out the data for a chart. When using Excel 2007 Save-As to create a Excel 2003 version, there’s a bug which resulted in an un-readable Pivot Table in Excel 2003! Thus, the Excel [...]
Question:
What are Next Analytics limits for queries? How many accounts or profiles can be used? How many rows of data can it get?
Answer:
Next Analytics imposes no limits to what you can do with the Google Analytics API. You can use as many accounts and profiles as you have access to. You can make as many [...]
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 [...]