Getting Facebook Insights Data into Excel

Build custom dashboards in Excel to display and analyze Facebook Insights data. Since NEXT Analytics supports the Facebook API, it’s easy to analyze your Facebook fan page and more in a custom report with NEXT Analytics. Unlimited Facebook profiles, unlimited Facebook accounts. Discover trends, correlations, patterns and outliers quickly and make evidence-based decisions about your social marketing strategy. Refresh your dashboard or report with one click, or tell NEXT to refresh it automatically for you.

Building your first query will only take a few minutes—even less if you already have NEXT Analytics installed on your computer. If you don’t, not to worry. You can start a free 14-day trial.

Getting Facebook Insights Data The Old-Fashioned Way
Facebook Insights provides the analytics behind your Facebook fan pages and applications, and through the API, it offers very granular access to the fan activity and demographics. The granularity means that there are a lot of metrics and restrictions on how metrics interact, so building even a simple dashboard directly from the Facebook API can mean that you have to perform a lot of queries — a process made a lot easier by NEXT Analytics and its ability to join and compare multiple queries.

Automate the Process with NEXT Analytics
NEXT Analytics provides dozens of ready-to-use Facebook sample reports in our dashboard library. Once you install and configure NEXT software (which takes under 5 minutes), putting your own data into one of our pre-made dashboards is literally a matter of a few clicks. Plus, you can refresh your data as often as you like by clicking “Refresh Data”, or make life even easier by setting up automatic scheduled refresh.

How to Perform a Custom Facebook Insights Query with NEXT Analytics

Authenticate your Facebook account first. Open NEXT ANalytics. Within the NEXT Analytics application, click on “Facebook Insights”.
If it’s your first time, you are prompted to login and authorize the NEXT software to access your data.

At no time, does the NEXT software use your data without you under control.

NEXT lets you manage more than one Facebook Login. That’s convenient if you are a consultant, or if you manage many Fan Pages, some with different Facebook logins.

The following dialog box allows you to maintain a list of Facebook Accounts. Just click on the drop down box to see all the accounts

Depending on which account you choose, you can get Facebook Insights metrics on Posts, Pages, Domains, and Applications.

You may be asked to assign some program defaults.

Click the drop down for a list of your fan pages, applications, and/or domains, then click “Set Default”.

Clicking “Refresh Data” at this point will give you a list of friends for the user entered in the box.



Selecting a Date Range

NEXT offers a variety of date ranges for your data. Below is a brief description of each.

Click on the “Date Range” tab.

The default date range is “1” “Month” “Rolling Periods.”


The units of time that are available to you are:

And you can break them up into these groupings:

“Rolling Period” is from today back for the time unit you chose to be.

“Last Full Period” looks back in time for the most recent full unit of time that you chose. E.g. “Last Calendar Month”.

“To Date” gives you data from the start of the period to today.

“Today” and “Yesterday” are only useful for selected metrics, especially in regards to Facebook Insights which often lags by a day or two.

“Get Data To/From” allows you to select specific dates.
The next tab, “Level of Detail for Dates,” lets you choose how detailed you’d like the data in the Date Range you chose.

Using the “Sum” options is much more efficient than generating daily data manually. Your results come back MUCH faster and the numbers are still quite useful.

“Value for each day” will give you each day’s data, one number for each day.

“Sum of 7 days” will query a 7 day total as one number. This is much more efficient and faster than getting 7 individual days and adding them up.

“Sum of 28 days” will query the most recent 28 days and provide a total as one number.
Similarly, Facebook also supports getting the sum of the most recent 28 days.

“Sum of the lifetime values” is only available for some metrics. If available, Facebook will deliver the lifetime total on a particular date.

Most Facebook metrics are not provided in real-time.

Depending on where you are in the world, the lag can be up to three calendar days (usually the Pacific Rim).

The “Option” tab allows you to shift the Date Range automatically, so you don’t need to see zero results for yesterday or the day before because they haven’t been processed by Facebook servers yet.


Getting Facebook Post Insights with NEXT

The Post Insights function examines post-level data of a Facebook Fan Page you have access to as an owner, administrator, or through Facebook Insights. Rather than receiving data about your Fan Page as a whole, post-level data will provide insights to specific posts you published on that Page. In essence, you can use Post Insights to track and analyze the performance of individual posts.

Click on the “Post Insights” tab.

A list of your pages for which you have owner, administrator, or insight access appears in the top window.

Select the page you want and click “Fetch Posts”. For a busy page, this may take a few minutes. You can only analyze posts from one page at a time.

The posts for the page you selected will show up in the middle window. Select any post(s) in the middle window in order to analyze it in detail in the bottom window. You can click on more than one post at a time. Clicking on the selected post in the third window will remove that post from selection.

Once you have chosen which post(s) to analyze, click on a post and one or more of the option buttons underneath it. NEXT Software will refresh with the metrics for the selected post(s). If the option you want is already selected, then click the “Refresh Data” button.


Getting Facebook Page Insights with NEXT

NEXT can provide you with detailed data about your Fan Pages.

Under the “Page Insights” tab, a list of your pages for which you have access as owner, administrator, or through Facebook Insights will appear in the top window.

Select the fan page you would like to analyze. You can select more than one page at a time. Your selection will appear in the bottom window.

Click on the options you would like to apply to them. Choose as many options as you like. Then click “Refresh Data”.



Facebook Domain Analysis

The “Domain” tab shows the list of Domains. You can select one or more Domains.

Select the option(s) you would like to apply, and click “Refresh Data.”


Facebook App Insights

You can also gather information about applications.

Under the “Applications” tab, enter the App ID number. You can only fetch data on one App at a time.

Select the metrics you would like to use by clicking on the check boxes.

Once you have finished selecting all the metrics you want, click “Refresh Data.”



Previewing Your Data

When you have finished selecting the Facebook Insights you wish to analyze and the time frame, click on the “Refresh Data” Icon in the top right corner of the screen. A preview window showing your data will open automatically.

You can perform further analysis in the preview window by using the menu or “Analytics” drop-down.
Then click “file”  “Save Workbook and Exit”. Your data will now be in Excel, where you can perform further analysis and create custom graphs and charts.


Refresh your data within Excel as often as you like by clicking on the “Next Analytics” tab in the Excel ribbon bar and clicking “Refresh Data”