Facebook Dashboards
Excel Analytics shows your valuable metrics about Facebook Fan Pages

Excel Facebook Analytics shows number of fans who "Liked" a fan page and most-liked messages on a wall. Check your own or competitors' pages with it. Facebook contains a wealth of information that Next Analytics delivers to your spreadsheet. Get a quick count of the number of fans that have "Liked" your fan page. You also see the most-liked of the recent messages on your wall. Lets you keep on top of what your fans are saying, and what interests them! Easily adjusts to check on other fan pages so you can keep tabs on your friends and foes as well.

Requires Next Analytics for Excel version 3.0.12 or higher

facebook fan page 600

Download FacebookFanPage.xlsx, open in Microsoft Excel and then click Refresh on the Next Analytics menu. Read further instructions on the NextAnalytics_actions worksheet.

Next Analytics for Excel required to refresh data.

 
Excel Facebook Analytics: Fan Page Visitor Demographics (updated)

What do you know about visitors to your Fan Page?

The Facebook Fan Page Visitor Demographics spreadsheet provides details about visitors to your fan page:

  • Visits by gener/age category
  • Visits by country
  • People talking about your fan page

This is incredibly useful to be more effective at any of the following things which you probably do (or should be doing):

  • what to say while you're building your community
  • what contest to run,
  • what app to offer,
  • what to say in your survey,
  • what to say in your blog,
  • what news to announce, 
  • where to target your ads and what to say

Here's the report as it appears in Excel.

facebook visitor demographics 600

To see it in Excel, get the free spreadsheet here: Excel 2007/2010 or for Excel 2003.  

If you have Next Analytics, your own data shows (at the click of a button). Next Analytics for Excel v3.3.1 or higher required.

The workbook also includes a worksheet with a list of all the pages you Like and the pages you have Administrator privileges for (required for Facebook Insights reporting).

 
Excel Facebook Analytics: Fan Page activity, likes & dislikes (updated)

This report shows fan activities as they unfold which includes:

  • Reach by day
  • Running total of the Likes to date
  • Daily Likes and Unlikes for the month with a running total
  • Where those Likes came from (sources)
  • Demographics of your fans; country city and language
  • Age/Gender profile of your fans

facebook fan page insights 600

If you want to get this dashboard click the link for Excel 2007/2010 or Excel 2003. Microsoft Excel will open automatically. If you have Next Analytics for Excel, enter your Facebook fan page ID and press the Refresh button -- and your page's data will appear.

 
Facebook in Excel: Fan Page Messages and Comments

This Excel workbook shows the recent Facebook messages posted to a fan page, along with the number of Likes and the number of Comments for each message. The most recent 3 comments are also displayed, similar to how they appear in the Facebook web interface.

facebook messages and comments

Download this Excel workbook for Excel 2007/2010 or Excel 2003, refresh the worksheet and enter the page ID for the page of interest. All pages you Like will be listed with page ID's.

 
Facebook in Excel: Next Analytics First Impressions

This dashboard shows how easy it is to get lists of the pages you Like and the activity of your Facebook friends. Simply load and click the Next Analytics Refresh menu.

facebook first impressions

Download the workbook here FirstImpressions-Facebook.xls

 
Download Your Facebook Friends List to CSV

With this simple report, you can easily download your Facebook friends list into a CSV file and load it directly into Excel with a simple click. It delivers columns for the most popular information available, including the name, gender, locale, URLs for the profile picture and the profile itself, their affiliations and the total number of posts on their wall.

Friends To Csv

Download this workbook here Facebook-friends-list.xls

Note: Facebook does not allow you to export your friends email addresses, sorry.

 
Facebook Message Likes, Comments and Impressions

This Excel report shows your most recent Facebook fan page messages with the number of Likes, comments and impressions per message. All messages are listed by descending date, with the names of the authors and the titles of any attachments.

facebook message analytics

Although the Facebook API limits the number of messages that can be queried at one time, the report automatically retains older messages, appending to the list every time you refresh. Use the Next Analytics batch scheduler or command line utility to automatically keep it in sync.

Download the workbook here FacebookMessageAnalytics.xls.

 
Updated: Facebook Messages and Comments in Excel

This report pulls the latest messages posted to your fan page along with all the associated comments. It includes the names of the authors as well as the count of Likes and comments for each message.

fan page messages and comments

If you have administrator access to the fan page, the report will also show the number of impressions for each message. Download this workbook, enter the page ID for any fan page and refresh using Next Analytics.