Facebook Ads

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

Hevo uses 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.

Note: For Pipelines created with this Source, Hevo provides you a fully-managed BigQuery data warehouse Destination if you do not already have one set up. 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.

  • All the ad blocking softwares are paused.
    Note: Facebook 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

To configure Facebook Ads as a Source in Hevo:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipeline 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. 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

    1. Pipeline Name: A unique name for your Pipeline.

    2. Ads Accounts: Facebook Ads account(s) from where you want to replicate the data.

      Note: One Facebook account can contain multiple Facebook Ads account.

    3. Attribution Window: You can specify either one or both of the following:
      • View Impressions: The number of days between a person viewing your ad and taking an action.
      • Click related metrics: The number of days between a person clicking your ad and taking an action.
    4. Ads Action Report Time: The reported time of an action by a Facebook user. You can select either of the following:
      • Impression: The time your ad was watched.
      • Conversion: The time when an action was taken after watching your ad.

      For example, A person sees an ad on Jan 1st but converts on Jan 2nd.
      Then, the Ads Action Report Time for an Impression would be Jan 1st, while that for a Conversion would be Jan 2nd.

  8. Click TEST & CONTINUE.

Data Replication

Historical Data: If you select 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 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.

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.

Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination:

Facebook ER Diagram

Data Model

Hevo uses the following data model to ingest data from your Facebook Ads account:

Object Description
Ads Contains information about the ads in your Facebook Ads account.
Ads Insights Contains detailed statistics for each campaign, set, ad combination per day.
Ads Insights Age and Gender Contains detailed statistics for each campaign, set, ad combination per day, sorted by age and gender.
Ads Insights Country Contains detailed statistics for each campaign, set, ad combination per day, sorted by country.
Ads Insights Region Contains detailed statistics for each campaign, set, ad combination per day, sorted by region.
Ads Insights DMA Contains detailed statistics for each campaign, set, ad combination per day, sorted by DMA.
Ads Insights Platform and Device Contains detailed statistics for each campaign, set, ad combination per day, sorted by platform, and device.
Ad Creative. Defines the creative fields of one or more ads.
Ad Sets 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 Represent the objective for an advertiser. For example, to drive page post engagement.

Limitations

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

Last updated on 21 Dec 2020