Querying Facebook using ShufflePoint (preliminary)

Summary

Our current Facebook integration should be considered a functional prototype. The Facebook API doesn't really have a concept of "Timeframe" liks most datasources. The results is that currently you must query each period (e.g. Month) separately. Our hope is that Facebook adds better support for historical data. In the mean time, follow the samples below.

Setup

Grant ShufflePoint access to your Facebook account. Here is the direct link to the datasource setup page.

Finding Page IDs

You'll need to use a page ID in your query. The easiest way to find the ID is to start with your page. For example:

https://www.facebook.com/barackobama

And just change the "www." to "graph."

https://www.facebook.com/barackobama

You will find page ID as a long number on the line which begins with "id":

Running Queries

An example query is:

SELECT NoRowHeaders
METRICS fb:page_impressions ON COLUMNS
FROM "12345" 
WHERE TIMEFRAME lastMonth

You can get earlier months by using a named timeframe (lastMonth2, lastMonth3, etc.)

SELECT NoRowHeaders
METRICS fb:page_impressions ON COLUMNS
FROM "12345" 
WHERE TIMEFRAME lastMonth3

Our Facebook integration will be extended on an on-demand basis, so if there is something you would like to get from Facebook which is not listed in our metrics and dimensions sheet then please contact us.

Facebook Documentation

https://developers.facebook.com/docs/reference/fql/insights/: - Facebook Insights metrics reference
https://developers.facebook.com/docs/reference/api/: - Facebook Graph API
https://developers.facebook.com/tools/explorer/: - Graph API Explorer
https://developers.facebook.com/blog/post/573/: - Page Insights