Facebook Page Insights

Dataddo Facebook Page Insights connector enables simple API data extraction without writing a single line of code.

Permissions

When authorizing access, make sure that the user has the correct permissions. To access the Page Insights data, the user has to have assigned ANALYST permission. Please check the official documentation for further details: https://www.facebook.com/help/289207354498410

Available Metrics

Dataddo can extract all the metrics provided via an official API. The full list is available here: https://developers.facebook.com/docs/graph-api/reference/insights

Limits

Facebook Insights API has a hard limit for the total number of rows that can be extracted. Dataddo supports automatic pagination, so the data extraction is in fact distributed into multiple rows.

Multi-account extraction

Dataddo Facebook Page Insights connector supports automatic extraction from all the available Facebook Pages. This feature is particularly useful when you have (e.g. being an online agency) multiple accounts and need to automatically extract the same metrics and dimensions across them.

Dates and timezone shift

Facebook Pages Insights metrics are calculated in PST timezone, this means that the values displayed in Business manager are valid for a date considering the PST timezone. The API output, however, is in UTC. Dataddo automatically compensates for this, since some of the downstream systems do not work with timezone notation. Please follow the examples of the behaviour below to choose the correct configuration.

Default behaviour:

Date in Business manager Date provided by FB API Date provided by Dataddo
2020-11-20 2020-11-21 08:00:00+0000 2020-11-20 24:00:00+0800

With "Report in PST" option turned off: 

Date in Business manager Date provided by FB API Date provided by Dataddo
2020-11-20 2020-11-21 08:00:00+0000 2020-11-21 08:00:00+0000

Correct date range setup

Fact that metrics are calculated in the PST timezone and Facebook API operates in UTC has an implication on the date range setting during the connector setup. If you set the connector to query the data for 2020-11-21, the Facebook API considers it as the value in UTC timezone, therefore the matching metrics are for 2020-11-21 08:00:00+0000, corresponding to values associated with 2020-11-20 in your Business manager.

Creating a Facebook Page Data Source

To create a Facebook Page data source, navigate to Sources at the top left of the Dataddo app.

Top Bar Marked-png-1

Then click on New Sources from the top right corner.

Source Selection Page-png-1

From the list of connectors, choose the Facebook Page connector.

search

On the next page, you will need to give Dataddo authorization to connect with your Facebook Ads account. Once you click on Authorize, you will be redirected to your account to log in.

configure account

After you log in and give Dataddo the necessary permissions to access your data, you will get redirected back to the connector. If you happen to have more Facebook accounts connected to Dataddo, you can select the one you would like to use from the drop-down menu. You will also have to select the Facebook Page.

account

Next, you can name your data source, and select the required Metrics, and Attributes.

attributes

On the snapshotting page, you will set up the destination configuration. To help you with the snapshot mapping, we make it easier for you to create a connection to the destination based on your preference.

  • Click on the option "Dashboarding App" if you want your data to connect to applications, like Google Data Studio, Power BI, or Tableau.
  • Click on the option "Data Warehouse", If you want your data to be sent to warehouse storage, like MySQL, Big Query, or PagegreSQL.
  • If you are already experienced with the snapshotting setup, you can go ahead and process without selecting the two options.

snapshotting options

Lastly, you configure your snapshotting preferences, choosing Data range (if available), Snapshotting frequency, and Snapshotting retention. 

snapshotting configuration

Now you are all set and ready. Click on See Preview to review all the selections made by you before saving the Data Source using the button in the top right corner Save source.

preview

Your new source is now created. You can click on Add source to a flow to bind the source with a flow. To create a flow, please follow our Creating a data flow guide.

Visual example

video