Facebook Post
  • 5 Minutes to read
  • Dark

Facebook Post

  • Dark

Article Summary

Facebook Post Insights provide information such as the number of likes, comments, and shares that a post receives, the demographic information of the users who engage with the post, the reach and engagement rate of the post, and the times and days when the post is most effective.

The insights can be used by businesses and individuals to measure the effectiveness of their social media marketing campaigns and to make data-driven decisions to improve their engagement and reach on the platform.

How to Create a Facebook Posts Data Source

  1. Under the Sources tab, click on the Create Source button and select the connector from the list.
  2. From the drop-down menu, choose your account.
    Didn't find your account?

    Click on Add new Account at the bottom of the drop-down and follow the on-screen prompts. You can also go to the Authorizers tab and click on Add New Service.

  3. Name your data source and select your metrics and attributes.
  4. [Optional] Configure your advanced settings (for more information please refer to the section on Advanced Settings). If you are unsure about how to proceed, we recommend skipping this step.
  5. Configure your snapshotting preferences. Choose your sync frequency or the exact synchronization time under Show advanced settings.
  6. Preview your data by clicking on the Test Data button in the top right corner. You can adjust the date range for a more specific time frame.
  7. Click on Save and congratulations, your new data source is ready!

Connector Overview


To access your Facebook Posts data, the account you connect to Dataddo has to have at least analyst-level permissions. For more information, please check the official Facebook documentation for further details.

It is also possible to extract your Facebook Video data through our Facebook Post connector.

Multi-Account Extraction

If you have more than one Facebook Page connected to your account, the Dataddo Facebook Post connector supports automatic Facebook posts data extraction from all available pages. For more information please see Multi-Account Extraction FAQ.


Number of Facebook Posts

Although the Facebook Insights API allows extraction of max 100 post, Dataddo supports automatic pagination which allows bypassing this limit.

However, in some cases the Facebook API will not return all 100 requested posts. Please reduce the value set in the limit parameter.

Number of Records

The Dataddo Facebook Post connector will be able to extract up to 5 000 records at a time.

Lifetime Values

Only lifetime values of the metrics are available through the Facebook Insight API. Please note that data cannot be broken down by days, it is possible to extract only the number of impressions or clicks.

You are provided with the total aggregated value of the given metric to the date and will not be provided with the daily (weekly, monthly) deltas. As such, it will not be possible to load historical data.


DateTotal Clicks
Jan 11 000
Jan 21 053

As we see the total number, this means that on Jan 2 there were 53 clicks.


To build a time series for each metric, set the snapshot-taking frequency to daily and choose to Append your snapshots.

Add the Insert date attribute in the connector configuration. This will add an additional timestamp, indicating the date to which the value of the metric is fixed.


Data Preview Unavailable

If there is no data preview after clicking on Test Data, there might be a problem with your source configuration. The most common causes are:

  • Date range: Try a smaller date range. You can load the rest of your data afterward through our manual data load function.
  • Invalid metrics, attributes, or breakdowns: You may not have any data for the selected metrics, attributes, or breakdowns.
  • Incompatible combination of metrics, attributes, or breakdowns: The combination you have selected cannot be queried together. Please refer to the service's documentation to view a full list of metrics that can be included in the same source.

Authorization Error

If your Facebook source is broken, check the extraction log to see the details of the issue.

  1. Go to Sources, click on the three dots and choose Test Extraction.
  2. If the error message is one of the following, go to Authorizers to reauthorize the service (Facebook).
    "response_status": "401 Unauthorized"
    "Www-Authenticate": "OAuth \"Facebook Platform\" \"invalid_token\" \"You cannot access the app till you log in to www.facebook.com and follow the instructions given.\""
    "response_body": "{\"error\":{\"message\":\"You cannot access the app till you log in to www.facebook.com and follow the instructions given.\",\"type\":\"OAuthException\",\"code\":190,\"error_data\":\"{\\\"checkpoint_url\\\":\\\"https:\\\\\\/\\\\\\/www.facebook.com\\\"}\",\"error_subcode\":459,\"fbtrace_id\":\"AUWZQsg7Opr7SEpp_lk9wUa\"}}"
  3. Restart the broken sources by clicking on Manual Data Load icon next to your source.
    Facebook - authorization error log 2

Unable to Find Facebook Sub Accounts

If your access rights have changed or you gained access to a new Facebook account, it is possible that your other accounts will not be immediately listed in Dataddo. To fix this, please try the following:

Completely Reauthorize the Service

  1. Go to the Authorizers tab in Dataddo and delete the Facebook authorizer.
    Deleting an Authorizer

    Please keep in mind that you will first need to delete all sources created with the authorizer. This will also affect your flows.

  2. Go to your Facebook settings and navigate to the Business integrations tab.
  3. Find Dataddo and click on Remove.
  4. Now go back to the Authorizers tab in Dataddo and authorize your Facebook account again.

Check Your Account Permissions
If the method above doesn't work, please check your Facebook account's permissions. To access insights, make sure the permissions are at least on the analyst level.

Extract Hashtags

It is not possible to extract only hashtags. There, however, is a way around it as hashtags are always part of your captions.

When choosing your metrics, make sure to include the Captions data label.

Related Articles

Now that you have successfully created a data source, see how you can connect your data to a dashboarding app or a data storage.

Sending Data to Dashboarding Apps

Sending Data to Data Storages

Other Resources

Was this article helpful?

What's Next