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

Batch updates of Excel web analytics dashboards

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

Dates From Google Analytics Year-Week Numbers

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