Automatically Track Fan Counts of Competitors’ Facebook Pages

Refresh this spreadsheet as often as you like, daily, weekly, or monthly and track how a competitors or organization “of-interest” popularity is trending.
Get it here.
Each time it runs, it adds a new data column to a data worksheet which can be used as a dashboard.  It also creates a file on your computer which can [...]

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

Facebook Excel lets users experiment with FQL and Facebook Insights

The secret sauce of Facebook Excel is FQL
Facebook Query Language, FQL, lets you send queries to the Facebook data servers. And Next Analytics lets you send FQL queries and get the results into Excel.
Next Analytics’ Facebook Excel provides a very convenient environment to analyze Facebook and Facebook Insights.
If you have Next Analytics, it is a [...]

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

Facebook Excel shows how to build a 30 day trend of multiple pages

Many businesses and consultants manage more than one Fan Page.
For example, if you own a group of restaurants, each one might have its own page, and you want to compare the activities and performance of their Facebook marketing efforts.
What’s important is that Next Analytics let’s you get any Facebook Insights metric, for a set of [...]

Getting Facebook Insights Data into Excel

Now that Next Analytics supports the Facebook API, it’s possible to build Excel dashboards and reports that automatically refresh with your Facebook fan page activity and fan demographic information. As with all programming interfaces, the Facebook API takes a little getting used to, so in this article, I will walk you through a quick introduction [...]