How to Setup Facebook Ads Integration

This integration will allow you to connect with Facebook Ads and start collecting your Ad campaign data. It is a matter of minutes to send your Ads data to feed your BI, your data warehouse, or your custom analytics stack.

Here are the steps involved:

  1. Connecting Facebook Ads
  2. Set the Replication Frequency
  3. Load your Facebook Ads data into your data warehouse
  4. Facebook Ads expected Data Model and schema

Getting Started – Setup Facebook Ads integration at Blendo

1. To add this integration, go to Blendo dashboard. Click “Add a Source”

Setup Facebook Ads integration

2. You will be prompted to connect to your Facebook Ads account through your Facebook User account.

Setup Facebook Ads integration

3. If you agree, click OK.

4. You will be prompted to allow Blendo to access your Facebook Adverts stats.

Setup Facebook Ads integration

5. If you agree, click OK.

6. In the next page, you will need to choose your FB page that you need your data from. At the drop down, select the page you need to get your ads data

Setup Facebook Ads integration

Set the Historical data sync

Select the starting date for the historical data sync of your Facebook Ads integration. Data which are newer than this date will be replicated to your data warehouse.

7. At the Historical Data drop down, select the time frame of the historical ads data to get.
Setup Facebook Ads integration - Set the Historical data sync

Set the Attribution window

8. At the Attribution Window drop down, select the attribution window of your ads data.

Setup Facebook Ads integration - Set the Attribution window

Click Validate & Save.

9. Then you will return back to the home dashboard. Click on your new FB Ads data source.

Setup Facebook Ads integration

Set the Replication Frequency

10. If you want to change the replication schedule go to the Schedule section and click on Reschedule.

Setup Facebook Ads integration - Import Reschedule

11. In the next pop-up select one of the options available and click Apply.
Setup Facebook Ads integration - Import Reschedule

<id=”load”>Load your Facebook Ads data into your data warehouse

Here is how to start loading your Facebook Ads data into your data warehouse:

Load facebook ads data into data warehouse

Expected Facebook Ads Data

Getting your Facebook Ads data is one thing. What about these data though? Let’s see:

  1. How Blendo syncs Facebook Ads data
  2. The tables with Facebook Ads data that we create in your destination data warehouse

How Blendo syncs Facebook Ads data

Historical Data

When Blendo first connects to Facebook Ads Data source, will pull all your historical data.

Sync Schedule

Blendo syncs Facebook Ads data based on the schedule and frequency you choose. The default setting is every 1 hour but is configurable from inside the app.

Replication Process

Whenever Blendo pulls data from Facebook, it fetches data for the last three days on a daily granularity. So, each entry in a table contains the values for a specific date. This information is stored in the columns date_start and date_end where in the case of data coming from data, always contain the same value.
Additionally, the data that is synced by Blendo for Facebook Ads, is appended to your database. So, no updates are happening and you might have duplicate values. For this reason, if you are looking for the latest value for a specific row, you should use the blendo_imported_at column and keep the row that contains the largest value.

What Facebook Ads data do I have available?

Bellow are some of the tables with Facebook Ads data that we create in your target data warehouse.

Expected Facebook Ads Data Model & Schema Information

Facebook Ads Data Model & Schema

Account Insights

Table Name: account_insights

This table contains insights, aggregated for the whole account.

These insights include information like: Total Impressions, Reach, CPP, CPC, CPM

Campaigns

Table Name: campaigns

This table holds information information about your campaigns.

Columns of this table include: name, objective, account_id, status.

AdSets

Table Name: adsets

This tables has information about your Ad Sets.

Columns of this table include: bid_amount, updated_time, campaign_id, daily_budget, lifetime_budget, pacing_type.

Ads

Table Name: ads

This table has information about your Ads.

Columns of this table include: bid_type, adset.id, campaign.id, account_id, bid_amount, tracking_specs.post.wall.

Ad Insights

Table Name: ad_insights

A table that contains insights about your Ads.

Columns of this table include: impressions, reach, adset_name, spend, clicks, campaign_id, account_name.

Ad_Country

Table Name: ad_country

A table that contains Ad Insights aggregated per country

Ad_Age_Gender

Table Name: ad_age_gender

A table that contains the above Ad Insights aggregated per Age and Gender.

Ad_Placement_Device

Table Name: ad_placement_device

A table that contains the above Ad Insights aggregated per device and placement

Account_Insights_Actions & Account_Insights_Unique_Actions

Table Name: account_insights_actions & account_insights_unique_actions

A table that contains insights about the user actions aggregated for the whole account.

Most important information is the action type and its value. For the case of the Account_Insights_Unique_Actions table, only unique actions are counted.

Insights_Unique_actions

Table Name: insights_unique_actions

A table that contains insights about the user actions for each of the Ads that have been created on Facebook.

Most important information is the action type and its value.

Expected Facebook Ads Data Model & Schema Information

Facebook Ads Data Model & Schema

Questions? Contact us!

in Connecting SaaS Data Sources