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

In modern SEO, you ride the long tail.  You create lots of domain specific content so the search engines find you.  You create variations of some base concepts, using lots of different keyword combinations. Believe it or not, after a year of doing this, it’s not hard to be at a thousand pages. And you will [...]

The latest thinking in SEO is to invest in content.  It’s far more achievable to be a leader in a narrow well defined domain of expertise than to compete for broad topics. As such, successful companies are investing in content on their site. This blog article focuses on how to monitor and audit what you’ve already written.
Also, [...]

How can you take the data being supplied by Google Analytics and add more dimensions and hierarchy?  This article provides a practical step by step explanation how to do that.
Many web sites have more than one content contributor so it’s useful to be able to evaluate the popularity of that author. Or, content can be [...]

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