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
At no time, does the NEXT software use your data without you under control.
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.
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.
The default date range is “1” “Month” “Rolling Periods.”
“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.
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.
“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.
Depending on where you are in the world, the lag can be up to three calendar days (usually the Pacific Rim).
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.
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.
Getting Facebook Page Insights with NEXT
NEXT can provide you with detailed data about your Fan Pages.
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.
Facebook App Insights
You can also gather information about applications.
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.
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.