Dataddo Facebook Post Insights connector enables simple API data extraction without writing a single line of code.
When authorizing access, make sure that the user has correct permissions. To access the Post Insights data, the user has to have assigned ANALYST permission to a given Facebook Page. Please check the official documentation for further details: https://www.facebook.com/help/289207354498410
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
Lifetime values only
It is important to mention that only lifetime values of the metrics are available due to the limitations of Facebook Insights API. Therefore, you are only provided with the total aggregated value of the given metric to the date. E.g. on 1st January, the total views of the post were 1000, on 2nd January the total views of the post were 1053 and so on. You will not be provided with the daily (weekly, monthly) "deltas".
Overcoming "lifetime values only" issue with Dataddo
Set the snapshot taking frequency to "daily". This will secure that each day you will gradually build a time series for each metric. You can add the "insert date" attribute in the connector configuration that adds an additional timestamp, indicating the date to which the value of the metric is fixed.
Facebook Insights API has a hard limit of 100 posts that can be extracted. Dataddo supports automatic pagination, so more than 100 posts can be extracted.
Dataddo Facebook Post Insights connector supports automatic extraction of all the posts 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.
Creating a Facebook Post Data Source
To create a Facebook Post data source, navigate to Sources at the top left of the Dataddo app.
Then click on New Sources from the top right corner.
From the list of connectors, choose the Facebook Post connector.
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.
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.
Next, you can name your data source, and select the required Metrics, Attributes, and Max number of posts.
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 PostgreSQL.
- If you are already experienced with the snapshotting setup, you can go ahead and process without selecting the two options.
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.
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.