Facebook Ads

Facebook Ads Integration

Hevo lets you load your Facebook Ads Insights data using the Facebook Marketing API. Let’s walk through steps for adding Facebook Ads as a source.

Connecting Facebook Ads

Facebook Ads setup requirements

To set up Facebook Ads in Hevo, you need:

  • Access to Facebook Ads and related stats.
  • Pause all ad-blocking software currently in use. Facebook authentication system uses pop-ups that may encounter issues if ad blockers aren’t disabled during the setup. You can read more about these permissions here.

Add Facebook Ads as a source

  1. Sign in to your Hevo Data Account.
  2. Click Create Pipeline under Pipeline Tab.
  3. Click the Facebook Ads icon.
  4. You’ll be asked to authorize Hevo to access Facebook Ads via a series of steps to allow Hevo access data your public profile, Facebook Ads and related stats.
  5. After you’ve finished authorizing Hevo, you would be expected to enter the name of the source/pipeline and select the accounts you want to pull data from. Select the desired account by clicking the checkboxes. Please note, Hevo now supports polling data from multiple accounts.
  6. Select Ads Action Report Time; It determines the report time of action stats. For example, if a person saw the ad on Jan 1st but converted on Jan 2nd. If you select impression, you will see a conversion on Jan 1st and if you select conversion, you will see a conversion on Jan 2nd.
  7. Click on Test and Continue

Note:

  • Ads Reporting Level: It is default set to Ad level to help fetch granular data.
  • Fields: Hevo will poll all possible fields, a complete list of all possible fields can be found here.
  • By Default Hevo will poll all the data since 1st January 2019.
  • This integration does not currently support replicating data for reviews, pages, etc.

Facebook Ads table schemas

There are two types of data Hevo polls: Core Objects and Insights.

  • Core Objects contain information about the Ads’ Data that’s useful for analysis. These are Ad Creative, Ads, Ad Sets, Campaigns Objects.
  • Insights data contains performance data for every ad/ad set/ad campaign combination.

ads

The ads object contains info about the ads in your Facebook Ads account. Checkout Facebook Marketing API for more details.

ad sets

An ad set 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 your criteria, and you can retrieve the ad-related statistics that apply to a set.

ad creative

An ad creative object is an instance of a specific creative which is being used to define the creative field of one or more ads. Click here for more details.

campaigns

A campaign is the highest level organizational structure within an ad account and should represent a single objective for an advertiser, for example, to drive page post engagement.

ads_insights

The ads_insights table contains detailed statistics for each campaign/set/ad combination for each day.

ads_insights_age_and_gender

The ads_insights table contains detailed statistics for each campaign/set/ad combination for each day segmented by age and gender.

ads_insights_country

The ads_insights table contains detailed statistics for each campaign/set/ad combination for each day segmented by country.

ads_insights_region

The ads_insights table contains detailed statistics for each campaign/set/ad combination for each day segmented by region.

ads_insights_dma

The ads_insights table contains detailed statistics for each campaign/set/ad combination for each day segmented by dma.

ads_insights_platform_and_device

The ads_insights table contains detailed statistics for each campaign/set/ad combination for each day segmented by platform and device.

Facebook Ads data replication (Beta)

When Hevo creates a replication job for Facebook Ads insight reports, it also creates a data refresher job per report type to fetch attributing results to the ads to an older date. Hevo, by default, fetches 30 days older data once every day. Hevo will count this replication towards your events quota.