Facebook Ads

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.

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.


Prerequisites

  • An active Facebook account from which data is to be ingested.

  • Access to Facebook Ads console and related statistics.

    Note: Facebook’s authentication system uses pop-ups that may encounter issues if ad blockers are not disabled during the setup. Read Authorization.


Configuring Facebook Ads as a Source

Perform the following steps to configure Facebook Ads as the Source in your Pipeline:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipelines List View.

  3. In the Select Source Type page, select Facebook Ads.

  4. In the Configure your Facebook Ads Account page, click ADD FACEBOOK ACCOUNT.

    Add account

  5. Log in to your Facebook account.

    Login to Facebook

  6. Click Done to authorize Hevo to access your Facebook Ads and related statistics.

    Allow access

  7. In the Configure your Facebook Ads Source page, specify the following:

    Configure source

    • Pipeline Name: A unique name for your Pipeline, not exceeding 255 characters.

    • Select Ad accounts: The Facebook Ads account(s) from where you want to replicate the data. One Facebook account can contain multiple Facebook Ads account.

    • Report Type: Select one of the following report types to ingest data from your Facebook Ads reports.

      • Predefined Reports: Hevo automatically selects all the reports and their respective fields and columns for ingestion.

      • Custom Reports: Hevo allows you to manually select the aggregation, breakdown, and fields for the Facebook Ads reports that you want to replicate. To know how to configure custom reports, read Custom Reports.

    • Historical Sync Duration: The duration for which the past data must be ingested. Default: 1 Year.

    • Advanced Settings

      • Ads Action Report Time: The reported time of an action by a Facebook user. You can select either of the following:

        • Impression: The time at which your ad was watched.

        • Conversion: The time when an action was taken after watching your ad.

        • Mixed.

      • Attribution Windows: You can specify either one or both of the following:

        • Click Attribution Window: The number of days between a person clicking your ad and taking an action such as install, subscribe.

        • View Attribution Window: The number of days between a person viewing your ad and taking an action such as install, subscribe.

  8. Click TEST & CONTINUE.

  9. Proceed to configuring the data ingestion and setting up the Destination.


Custom Reports

With custom reports, you can manually select the aggregation, breakdown, and fields for the Facebook Ads reports that you want to replicate.

To configure custom reports, specify the following Custom Report Settings:

  • Aggregation Level: The primary level of aggregation for the reports, such as Ad ID, Account ID. Default: Ad ID.

  • Aggregation Time: The time interval between consecutive aggregations of the reports. Default: 1 Day.

  • Breakdowns: The filters for narrowing the results of your retrieved reports by a specific category such as Date, Age Group, Region.

  • Fields: The fields or metrics that you want to include in the report such as Ad name, Campaign ID.


Data Replication

For predefeined reports

  • Historical Data: If you specify the Historical Load Date while creating the Pipeline, Hevo ingests all the ads data associated with the Facebook account and loads it into your Destination. If you select All-time Data within Historical Load Date, Hevo fetches all the data created since 1st January 2010 for your account till the current date. The Historical data is fetched from 1st January 2019 by default.

  • Incremental Data: Once the historical load is complete, all new and updated records are synchronized with your Destination.

  • Data Refresh: Hevo creates a replication job for Facebook Ads reports. It also creates a data refresher job per report type to fetch the attributing results of an older date. By default, 30 days old data is fetched once per day.

For custom reports

  • Historical Data: If you specify the Historical Load Date while creating the Pipeline, Hevo ingests all the ads data associated with the Facebook account and loads it into your Destination. By default, the data for the past 1 year is configured.

  • Incremental Data: Once the historical load is complete, all new and updated records are synchronized with your Destination.

  • Data Refresh: Hevo resyncs the data of the past 30 days.


Schema and Primary Keys

Hevo uses the following schema to upload the predefined reports data in the Destination:

Note: The schema for custom reports is derived dynamically based on the settings you provide.


Data Model

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline for predefined reports:

Note: For custom reports, the data model is derived dynamically based on the custom report settings you provide.

Object Primary Key Description
Ads - ad_id Contains information about the ads in your Facebook Ads account.
Ads Insights - ad_id
- date_start
- date_stop
Contains detailed statistics for each campaign, set, ad combination per day.
Ads Insights Age and Gender - account_id
- ad_id
- age
- date_start
- date_stop
- gender
Contains detailed statistics for each campaign, set, ad combination per day, sorted by age and gender.
Ads Insights Country - account_id
- ad_id
- date_start
- date_stop
- country
Contains detailed statistics for each campaign, set, ad combination per day, sorted by country.
Ads Insights Region - account_id
- ad_id
- date_start
- date_stop
- region
Contains detailed statistics for each campaign, set, ad combination per day, sorted by region.
Ads Insights DMA - ad_id
- date_start
- date_stop
- dma
Contains detailed statistics for each campaign, set, ad combination per day, sorted by DMA.
Ads Insights Platform and Device - ad_id
- date_start
- date_stop
- device
- platform
Contains detailed statistics for each campaign, set, ad combination per day, sorted by platform, and device.
Ad Creative - id
- creative_id
Defines the creative fields of one or more ads.
Ad Sets - id Is a group of ads that share the same daily or lifetime budget, schedule, bid type, bid info, and targeting data. Ad sets enable you to group ads according to criteria, and you can retrieve the ad-related statistics that apply to a set.
Campaigns - id Represent the objective for an advertiser. For example, to drive page post engagement.

Limitations

  • 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.

Revision History

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

Date Release Description of Change
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.
Last updated on 26 Jul 2021