Facebook Ads

Journey Analytics provides a predefined connection that enables you to upload Facebook Ad data into your project in order to integrate it with your behavioral tracking data. This enables you to measure your social media return on investment and get the most out of your social media campaigns.

Tip: We recommend adding the utm_campaign parameter to pass the Facebook Ad ID in each of your ad's URL, so you can link users' activity to the specific ads. Use Google campaign URL builder to simplify the creation of URLs with parameters. Example:http://www.mydomain.com/?utm_source=facebook&utm_medium=cpc&utm_campaign=[Ad ID]

Setup

In the integrations page, click the + icon and select Facebook Ads.
Fill in the Integration Name.
Click the Connect button.
Enter your Facebook Ads account credentials and click the Allow button. If you have already authorized Journey Analytics to your Facebook Ads account you won't be asked for the credentials again.

The first import process should take place within a few minutes. See the Last Run Status in the integrations list to monitor success or failed updates.

Data is updated twice a day (8AM & 8PM UTC) and fetches data from 3 days back to ensure data completeness. New data is appended to the tables stored in Journey Analytics .

Table Schemas

The integration fetches the following tables from all accounts associated with the user:

FaceBookAds_AdAccounts
FaceBookAds_AdSets

To add additional tables or columns to this integration, or upload Facebook Ads data to your own Google project (instead of into your Journey Analytics project), contact your customer success representative or Medallia Support.

FaceBookAds_AdAccounts


Column Name	Type
adaccountid	STRING
clicks	FLOAT
cost	FLOAT
country	STRING
date	TIMESTAMP
impressions	FLOAT
integrationname	STRING
integrationtime	TIMESTAMP
source	STRING

FaceBookAds_AdSets


Column Name	Type
account_id	FLOAT
actions	FLOAT
ad_account_id	STRING
adset_id	FLOAT
budget_remaining	FLOAT
call_to_action_clicks	FLOAT
campaign_id	FLOAT
canvas_avg_view_percent	FLOAT
canvas_avg_view_time	FLOAT
configured_status	STRING
cost_per_estimated_ad_recallers	FLOAT
cost_per_inline_link_click	FLOAT
cost_per_inline_post_engagement	FLOAT
cost_per_unique_click	FLOAT
cpm	FLOAT
cpp	FLOAT
ctr	FLOAT
daily_budget	FLOAT
effective_status	STRING
estimated_ad_recall_rate_lower_bound	FLOAT
estimated_ad_recall_rate_upper_bound	FLOAT
frequency	FLOAT
id	FLOAT
impressions	FLOAT
inline_post_engagement	FLOAT
name	STRING
reach	FLOAT
social_impressions	FLOAT
spend	FLOAT
total_action_value	FLOAT
total_actions	FLOAT
total_unique_actions	FLOAT
unique_actions	FLOAT
unique_ctr	FLOAT
unique_link_clicks_ctr	FLOAT

FaceBookAds_Campaigns


Column Name	Type
actions	FLOAT
ad_account_id	STRING
call_to_action_clicks	FLOAT
campaign_id	FLOAT
canvas_avg_view_percent	FLOAT
canvas_avg_view_time	FLOAT
configured_status	STRING
cost_per_estimated_ad_recallers	FLOAT
cost_per_inline_link_click	FLOAT
cost_per_inline_post_engagement	FLOAT
cost_per_total_action	FLOAT
cost_per_unique_click	FLOAT
cpm	FLOAT
cpp	FLOAT
ctr	FLOAT
effective_status	STRING
estimated_ad_recall_rate	FLOAT
estimated_ad_recall_rate_lower_bound	FLOAT
estimated_ad_recall_rate_upper_bound	FLOAT
frequency	FLOAT
id	FLOAT
impressions	FLOAT
inline_post_engagement	FLOAT
name	STRING
reach	FLOAT
social_impressions	FLOAT
social_reach	FLOAT
spend	FLOAT
total_action_value	FLOAT
total_actions	FLOAT
total_unique_actions	FLOAT
unique_actions	FLOAT
unique_ctr	FLOAT
unique_link_clicks_ctr	FLOAT