Google Analytics Excel: Monitor Trend of Page Depth Above a Threshold

The trend of page depth is one of many indicators of how well you’re doing as a web site designer and content author.
Page depth is an indication that people are interested in the content on your site. The more pages they view, the more they like what they see.  Or perhaps they can’t find what they’re [...]

Learn how Next Analytics deals with large Google Analytics data

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

Google Analytics Excel: Analyze web page popularity

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

See how easy it is to add custom dimensions to Google Analytics

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

Google Analytics Fiscal Reporting in Excel – Part I

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

Facebook Like and Comment Sources

On an Inside Facebook article this week, Josh Constine reveals how Facebook has recently improved the Facebook Insights API so it now reveals if page likes or comments came from a mobile device. With full access to the Facebook API, we thought we should show you how Next Analytics can pull this new information and [...]

How to #Measure SEO Performance by @AniLopez

Thought you’d like to know about a blog by @AniLopez of @CardinalPath (formerly VKI). It’s a very helpful explanation of key items when it comes to SEO Measurement.
See the blog aricle here:  http://dynamical.biz/blog/web-analytics/measuring-seo-performance-37.html
Ani also supplies a ready-to-use dashboard for turnkey “SEO Measurement”.  Here’s one of the charts you could get:

I’m proud to mention that he used our [...]

Making a year-to-date query

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

A Google Analytics Keyword Tag Cloud in Excel

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

Twitter Friends and Followers – Comparing the Lists

One of the new Excel dashboards we released this week downloads the friends and followers of a given Twitter user, and then compares the two lists, generating a short list of friends that don’t follow and followers that aren’t friends. I have seen a number of blog articles that go into long discussions about how [...]