Cooladata 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

  1. In the integrations page, click the + icon and select Facebook Ads.
  2. Fill in the Integration Name.
  3. Click the Connect button.
  4. Enter your Facebook Ads account credentials and click the Allow button. If you have already authorized cooladata 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 Cooladata.

 

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 Cooladata project), contact your customer success representative, at: support@cooladata.com.

 

FaceBookAds_AdAccounts

Column NameType
adaccountidSTRING
clicksFLOAT
costFLOAT
countrySTRING
dateTIMESTAMP
impressionsFLOAT
integrationnameSTRING
integrationtimeTIMESTAMP
sourceSTRING

FaceBookAds_AdSets

Column NameType
account_idFLOAT
actionsFLOAT
ad_account_idSTRING
adset_idFLOAT
budget_remainingFLOAT
call_to_action_clicksFLOAT
campaign_idFLOAT
canvas_avg_view_percentFLOAT
canvas_avg_view_timeFLOAT
configured_statusSTRING
cost_per_estimated_ad_recallersFLOAT
cost_per_inline_link_clickFLOAT
cost_per_inline_post_engagementFLOAT
cost_per_unique_clickFLOAT
cpmFLOAT
cppFLOAT
ctrFLOAT
daily_budgetFLOAT
effective_statusSTRING
estimated_ad_recall_rate_lower_boundFLOAT
estimated_ad_recall_rate_upper_boundFLOAT
frequencyFLOAT
idFLOAT
impressionsFLOAT
inline_post_engagementFLOAT
nameSTRING
reachFLOAT
social_impressionsFLOAT
spendFLOAT
total_action_valueFLOAT
total_actionsFLOAT
total_unique_actionsFLOAT
unique_actionsFLOAT
unique_ctrFLOAT
unique_link_clicks_ctrFLOAT

FaceBookAds_Campaigns

Column NameType
actionsFLOAT
ad_account_idSTRING
call_to_action_clicksFLOAT
campaign_idFLOAT
canvas_avg_view_percentFLOAT
canvas_avg_view_timeFLOAT
configured_statusSTRING
cost_per_estimated_ad_recallersFLOAT
cost_per_inline_link_clickFLOAT
cost_per_inline_post_engagementFLOAT
cost_per_total_actionFLOAT
cost_per_unique_clickFLOAT
cpmFLOAT
cppFLOAT
ctrFLOAT
effective_statusSTRING
estimated_ad_recall_rateFLOAT
estimated_ad_recall_rate_lower_boundFLOAT
estimated_ad_recall_rate_upper_boundFLOAT
frequencyFLOAT
idFLOAT
impressionsFLOAT
inline_post_engagementFLOAT
nameSTRING
reachFLOAT
social_impressionsFLOAT
social_reachFLOAT
spendFLOAT
total_action_valueFLOAT
total_actionsFLOAT
total_unique_actionsFLOAT
unique_actionsFLOAT
unique_ctrFLOAT
unique_link_clicks_ctrFLOAT
Print Friendly, PDF & Email