Facebook Ads

Last updated on Jun 09, 2023

Facebook Ads allows marketers to retrieve statistics about their ads, ad sets, and campaigns running on Facebook.

Hevo uses the Facebook Marketing API to replicate your Facebook Ads data into the desired Destination database or data warehouses for scalable analysis. For this, you must authorize Hevo to access data from your Facebook Ads account.

You can also ingest data from your Instagram Ads account using the Facebook Ads connector. Instagram Ads follows the same schema as the Facebook Ads connector and offers the same data replication settings.

For creating Pipelines using this Source, Hevo provides you a fully managed BigQuery data warehouse as a possible Destination. This option remains available till the time you set up your first BigQuery Destination irrespective of any other Destinations that you may have. With the managed warehouse, you are only charged the cost that Hevo incurs for your project in Google BigQuery. The invoice is generated at the end of each month and payment is recovered as per the payment instrument you have set up. You can now create your Pipeline and directly start analyzing your Source data. Read Hevo Managed Google BigQuery.

Source Considerations

  • Facebook Ads allows fetching data up to the past three years. Hence, you can change the offset using the Change Position action only within the past three years; beyond this, the API fails.


  • This integration does not support replicating data for reviews and pages. Hevo has a separate integration for Facebook Page Insights that can be used to fetch page and post insights.

See Also

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Mar-23-2023 2.10 Updated section, Configuring Facebook Ads as a Source and Custom Reports to reflect the latest UI.
Sep-05-2022 NA Updated section, Data Replication to reorganize the content for better understanding and coherence.
Aug-24-2022 NA Updated the Configuring Facebook Ads as a Source section to reflect the latest UI changes.
Jun-21-2022 1.91 Updated the Configuring Facebook Ads as a Source and Custom Reports sections to reflect the UI changes.
May-10-2022 NA Updated the historical data sync information for predefined reports in the Data Replication section.
Apr-25-2022 1.87 Updated the note in the Schema and Primary Keys section to state that the Destination schema is derived from the Source data for Pipelines with JDBC Destinations.
Apr-21-2022 NA Added a note in the page overview about the option to replicate Instagram Ads data using the Facebook Ads connector.
Mar-21-2022 NA Reorganized the section, Custom Reports for better understanding and coherence.
Oct-25-2021 NA Added the Pipeline frequency information in the Data Replication section.
Sep-20-2021 1.72 Added a Source Consideration whereby users can change the offset to ingest data only up to the past three years.
Sep-09-2021 1.71 Updated the section, Data Model to reflect the correct field names for the Ads Insights Platform and Device object.
Jul-22-2021 NA Updated the Data Model to include the primary key information.
May-19-2021 1.63 - Updated the content to reflect the latest UI and functionality.
- Added the section, Custom Reports.

Tell us what went wrong