Integration of Facebook Ads with BigQuery

Learn how to connect Facebook Ads to Google BigQuery using WitCloud and automatically fetch campaign, click, cost, conversion and reach data.

Updated

Introduction

This module integrates with the Facebook Marketing API (Meta), enabling you to collect daily performance data of your ad accounts — campaigns, ad sets, ads, creatives, video, product (catalog) ads and reach — and store it in Google Cloud BigQuery. Gain deeper insights into your data and optimize the performance of your marketing efforts.

Configuration guide

Follow the steps below to connect Facebook Ads with BigQuery. Once the setup is complete, your ad data will be automatically transferred to your BigQuery project.

Authorize with a Facebook user who has access to the ad accounts you want to collect — WitCloud lists the ad accounts that user can access.

Module setup

Go to Integrations in the menu and click Add integration.

Integrations list with the Add integration button

Select Facebook Ads from the list of available integrations.

Integration catalog filtered to Facebook Ads

Enter the Collect name, e.g. Facebook Ads PL.

Collect name field filled in with the example name Facebook Ads PL

Authorization

If you have already authorized Facebook in this project, pick the existing authorization from the Select Facebook authorization drop-down and skip this step.

Click Authorize.

Authorize button next to the Select Facebook authorization field

A Facebook window opens. Log in and confirm the access WitCloud asks for: managing ads for the ad accounts you have access to, and your public profile. After you confirm, the new authorization is selected in the Select Facebook authorization field.

Ad accounts and advanced settings

Open Select accounts and choose the ad accounts you want to collect.

Select accounts drop-down open with example Facebook ad accounts

You can select several ad accounts at once — WitCloud creates a separate data collect for each one, named <Collect name> - <account name>.

Select accounts field with two example ad accounts selected

Optionally, click Show advanced settings:

  • Action Attribution Windows — the attribution windows conversions are collected for: 1d_click, 1d_view, 7d_click, 7d_view and default (selected by default). The values for each window are stored in the matching fields of the action records, e.g. actions.click_7d.
  • Custom range enabled (reach) — reach is collected for 1, 7, 14 and 28 days by default; switch this on to add one range of your own.
  • Custom range days (reach) — the length of that range in days, at most 90. It is stored in reach_custom, with the number of days in reach_custom_timespan.
  • Tables to collect — all tables are selected; remove the ones you do not need.

Advanced settings with Action Attribution Windows, Custom range enabled (reach), Custom range days (reach) and Tables to collect

Click Next.

Collect settings filled in with the Next button

Historical data and scheduling

In Historical Data, enter the number of days of past data to fetch — at most 365.

Historical Data field filled in with 365 days

A data synchronization schedule will be created automatically. More information on this topic can be found here.

Click Create to complete the configuration.

Data collection settings with the Create button

Done! Your Facebook Ads data will now be synchronized with BigQuery, providing you with detailed insights into the performance of your ad campaigns.

Data schema

Each ad account gets its own set of tables: the table name ends with the ad account ID, e.g. fb_ads_act_123456789. Each run collects one day; the ad, ad set, campaign, video and product tables are partitioned by date_start, the creative and reach tables by the day of the run. Conversion and event data is stored in the actions field.

Expand the tables below to view the full data schema collected from Facebook Ads.

Data schema for fb_ads
Field NameModeType
account_idNULLABLESTRING
account_nameNULLABLESTRING
account_currencyNULLABLESTRING
ad_idNULLABLESTRING
ad_nameNULLABLESTRING
adset_idNULLABLESTRING
adset_nameNULLABLESTRING
buying_typeNULLABLESTRING
campaign_idNULLABLESTRING
campaign_nameNULLABLESTRING
attribution_settingNULLABLESTRING
canvas_avg_view_percentNULLABLEFLOAT
canvas_avg_view_timeNULLABLEFLOAT
clicksNULLABLEINTEGER
impressionsNULLABLEINTEGER
date_startNULLABLEDATE
date_stopNULLABLEDATE
inline_post_engagementNULLABLEINTEGER
inline_link_clicksNULLABLEINTEGER
mobile_app_purchase_roasREPEATEDRECORD
mobile_app_purchase_roas.action_typeNULLABLESTRING
mobile_app_purchase_roas.valueNULLABLEFLOAT
mobile_app_purchase_roas.click_1dNULLABLEFLOAT
mobile_app_purchase_roas.click_7dNULLABLEFLOAT
mobile_app_purchase_roas.click_28dNULLABLEFLOAT
mobile_app_purchase_roas.view_1dNULLABLEFLOAT
mobile_app_purchase_roas.view_7dNULLABLEFLOAT
mobile_app_purchase_roas.view_28dNULLABLEFLOAT
objectiveNULLABLESTRING
place_page_nameNULLABLESTRING
spendNULLABLEFLOAT
reachNULLABLEFLOAT
unique_clicksNULLABLEINTEGER
unique_inline_link_clicksNULLABLEINTEGER
publisher_platformNULLABLESTRING
device_platformNULLABLESTRING
platform_positionNULLABLESTRING
actionsREPEATEDRECORD
actions.action_typeNULLABLESTRING
actions.valueNULLABLEFLOAT
actions.click_1dNULLABLEFLOAT
actions.click_7dNULLABLEFLOAT
actions.click_28dNULLABLEFLOAT
actions.view_1dNULLABLEFLOAT
actions.view_7dNULLABLEFLOAT
actions.view_28dNULLABLEFLOAT
unique_actionsREPEATEDRECORD
unique_actions.action_typeNULLABLESTRING
unique_actions.valueNULLABLEFLOAT
unique_actions.click_1dNULLABLEFLOAT
unique_actions.click_7dNULLABLEFLOAT
unique_actions.click_28dNULLABLEFLOAT
unique_actions.view_1dNULLABLEFLOAT
unique_actions.view_7dNULLABLEFLOAT
unique_actions.view_28dNULLABLEFLOAT
action_valuesREPEATEDRECORD
action_values.action_typeNULLABLESTRING
action_values.valueNULLABLEFLOAT
action_values.click_1dNULLABLEFLOAT
action_values.click_7dNULLABLEFLOAT
action_values.click_28dNULLABLEFLOAT
action_values.view_1dNULLABLEFLOAT
action_values.view_7dNULLABLEFLOAT
action_values.view_28dNULLABLEFLOAT
outbound_clicksREPEATEDRECORD
outbound_clicks.action_typeNULLABLESTRING
outbound_clicks.valueNULLABLEFLOAT
outbound_clicks.click_1dNULLABLEFLOAT
outbound_clicks.click_7dNULLABLEFLOAT
outbound_clicks.click_28dNULLABLEFLOAT
outbound_clicks.view_1dNULLABLEFLOAT
outbound_clicks.view_7dNULLABLEFLOAT
outbound_clicks.view_28dNULLABLEFLOAT
unique_outbound_clicksREPEATEDRECORD
unique_outbound_clicks.action_typeNULLABLESTRING
unique_outbound_clicks.valueNULLABLEFLOAT
unique_outbound_clicks.click_1dNULLABLEFLOAT
unique_outbound_clicks.click_7dNULLABLEFLOAT
unique_outbound_clicks.click_28dNULLABLEFLOAT
unique_outbound_clicks.view_1dNULLABLEFLOAT
unique_outbound_clicks.view_7dNULLABLEFLOAT
unique_outbound_clicks.view_28dNULLABLEFLOAT
website_purchase_roasREPEATEDRECORD
website_purchase_roas.action_typeNULLABLESTRING
website_purchase_roas.valueNULLABLEFLOAT
website_purchase_roas.click_1dNULLABLEFLOAT
website_purchase_roas.click_7dNULLABLEFLOAT
website_purchase_roas.click_28dNULLABLEFLOAT
website_purchase_roas.view_1dNULLABLEFLOAT
website_purchase_roas.view_7dNULLABLEFLOAT
website_purchase_roas.view_28dNULLABLEFLOAT
conversionsREPEATEDRECORD
conversions.action_typeNULLABLESTRING
conversions.valueNULLABLEFLOAT
conversions.click_1dNULLABLEFLOAT
conversions.click_7dNULLABLEFLOAT
conversions.click_28dNULLABLEFLOAT
conversions.view_1dNULLABLEFLOAT
conversions.view_7dNULLABLEFLOAT
conversions.view_28dNULLABLEFLOAT
Data schema for fb_adcreatives
Field NameModeType
dateNULLABLEDATE
account_idNULLABLESTRING
ad_idNULLABLESTRING
ad_nameNULLABLESTRING
adset_idNULLABLESTRING
campaign_idNULLABLESTRING
ad_statusNULLABLESTRING
ad_effective_statusNULLABLESTRING
ad_updated_timeNULLABLETIMESTAMP
creative_urlNULLABLESTRING
creative_idNULLABLESTRING
creative_nameNULLABLESTRING
creative_statusNULLABLESTRING
object_typeNULLABLESTRING
object_story_idNULLABLESTRING
effective_object_story_idNULLABLESTRING
call_to_action_typeNULLABLESTRING
destination_urlNULLABLESTRING
url_tagsNULLABLESTRING
final_urlNULLABLESTRING
utm_sourceNULLABLESTRING
utm_mediumNULLABLESTRING
utm_campaignNULLABLESTRING
utm_contentNULLABLESTRING
utm_termNULLABLESTRING
link_urlNULLABLESTRING
link_destination_display_urlNULLABLESTRING
template_urlNULLABLESTRING
image_urlNULLABLESTRING
thumbnail_urlNULLABLESTRING
video_idNULLABLESTRING
post_permalink_urlNULLABLESTRING
instagram_permalink_urlNULLABLESTRING
effective_instagram_media_idNULLABLESTRING
asset_feed_link_urlsREPEATEDRECORD
asset_feed_link_urls.website_urlNULLABLESTRING
asset_feed_link_urls.display_urlNULLABLESTRING
Data schema for fb_adsets
Field NameModeType
account_idNULLABLESTRING
account_nameNULLABLESTRING
account_currencyNULLABLESTRING
ad_idNULLABLESTRING
ad_nameNULLABLESTRING
adset_idNULLABLESTRING
adset_nameNULLABLESTRING
buying_typeNULLABLESTRING
campaign_idNULLABLESTRING
campaign_nameNULLABLESTRING
attribution_settingNULLABLESTRING
canvas_avg_view_percentNULLABLEFLOAT
canvas_avg_view_timeNULLABLEFLOAT
clicksNULLABLEINTEGER
impressionsNULLABLEINTEGER
date_startNULLABLEDATE
date_stopNULLABLEDATE
inline_post_engagementNULLABLEINTEGER
inline_link_clicksNULLABLEINTEGER
mobile_app_purchase_roasREPEATEDRECORD
mobile_app_purchase_roas.action_typeNULLABLESTRING
mobile_app_purchase_roas.valueNULLABLEFLOAT
mobile_app_purchase_roas.click_1dNULLABLEFLOAT
mobile_app_purchase_roas.click_7dNULLABLEFLOAT
mobile_app_purchase_roas.click_28dNULLABLEFLOAT
mobile_app_purchase_roas.view_1dNULLABLEFLOAT
mobile_app_purchase_roas.view_7dNULLABLEFLOAT
mobile_app_purchase_roas.view_28dNULLABLEFLOAT
objectiveNULLABLESTRING
place_page_nameNULLABLESTRING
spendNULLABLEFLOAT
reachNULLABLEFLOAT
unique_clicksNULLABLEINTEGER
unique_inline_link_clicksNULLABLEINTEGER
publisher_platformNULLABLESTRING
device_platformNULLABLESTRING
platform_positionNULLABLESTRING
actionsREPEATEDRECORD
actions.action_typeNULLABLESTRING
actions.valueNULLABLEFLOAT
actions.click_1dNULLABLEFLOAT
actions.click_7dNULLABLEFLOAT
actions.click_28dNULLABLEFLOAT
actions.view_1dNULLABLEFLOAT
actions.view_7dNULLABLEFLOAT
actions.view_28dNULLABLEFLOAT
unique_actionsREPEATEDRECORD
unique_actions.action_typeNULLABLESTRING
unique_actions.valueNULLABLEFLOAT
unique_actions.click_1dNULLABLEFLOAT
unique_actions.click_7dNULLABLEFLOAT
unique_actions.click_28dNULLABLEFLOAT
unique_actions.view_1dNULLABLEFLOAT
unique_actions.view_7dNULLABLEFLOAT
unique_actions.view_28dNULLABLEFLOAT
action_valuesREPEATEDRECORD
action_values.action_typeNULLABLESTRING
action_values.valueNULLABLEFLOAT
action_values.click_1dNULLABLEFLOAT
action_values.click_7dNULLABLEFLOAT
action_values.click_28dNULLABLEFLOAT
action_values.view_1dNULLABLEFLOAT
action_values.view_7dNULLABLEFLOAT
action_values.view_28dNULLABLEFLOAT
outbound_clicksREPEATEDRECORD
outbound_clicks.action_typeNULLABLESTRING
outbound_clicks.valueNULLABLEFLOAT
outbound_clicks.click_1dNULLABLEFLOAT
outbound_clicks.click_7dNULLABLEFLOAT
outbound_clicks.click_28dNULLABLEFLOAT
outbound_clicks.view_1dNULLABLEFLOAT
outbound_clicks.view_7dNULLABLEFLOAT
outbound_clicks.view_28dNULLABLEFLOAT
unique_outbound_clicksREPEATEDRECORD
unique_outbound_clicks.action_typeNULLABLESTRING
unique_outbound_clicks.valueNULLABLEFLOAT
unique_outbound_clicks.click_1dNULLABLEFLOAT
unique_outbound_clicks.click_7dNULLABLEFLOAT
unique_outbound_clicks.click_28dNULLABLEFLOAT
unique_outbound_clicks.view_1dNULLABLEFLOAT
unique_outbound_clicks.view_7dNULLABLEFLOAT
unique_outbound_clicks.view_28dNULLABLEFLOAT
website_purchase_roasREPEATEDRECORD
website_purchase_roas.action_typeNULLABLESTRING
website_purchase_roas.valueNULLABLEFLOAT
website_purchase_roas.click_1dNULLABLEFLOAT
website_purchase_roas.click_7dNULLABLEFLOAT
website_purchase_roas.click_28dNULLABLEFLOAT
website_purchase_roas.view_1dNULLABLEFLOAT
website_purchase_roas.view_7dNULLABLEFLOAT
website_purchase_roas.view_28dNULLABLEFLOAT
conversionsREPEATEDRECORD
conversions.action_typeNULLABLESTRING
conversions.valueNULLABLEFLOAT
conversions.click_1dNULLABLEFLOAT
conversions.click_7dNULLABLEFLOAT
conversions.click_28dNULLABLEFLOAT
conversions.view_1dNULLABLEFLOAT
conversions.view_7dNULLABLEFLOAT
conversions.view_28dNULLABLEFLOAT
Data schema for fb_campaigns
Field NameModeType
account_idNULLABLESTRING
account_nameNULLABLESTRING
account_currencyNULLABLESTRING
ad_idNULLABLESTRING
ad_nameNULLABLESTRING
adset_idNULLABLESTRING
adset_nameNULLABLESTRING
buying_typeNULLABLESTRING
campaign_idNULLABLESTRING
campaign_nameNULLABLESTRING
attribution_settingNULLABLESTRING
canvas_avg_view_percentNULLABLEFLOAT
canvas_avg_view_timeNULLABLEFLOAT
clicksNULLABLEINTEGER
impressionsNULLABLEINTEGER
date_startNULLABLEDATE
date_stopNULLABLEDATE
inline_post_engagementNULLABLEINTEGER
inline_link_clicksNULLABLEINTEGER
mobile_app_purchase_roasREPEATEDRECORD
mobile_app_purchase_roas.action_typeNULLABLESTRING
mobile_app_purchase_roas.valueNULLABLEFLOAT
mobile_app_purchase_roas.click_1dNULLABLEFLOAT
mobile_app_purchase_roas.click_7dNULLABLEFLOAT
mobile_app_purchase_roas.click_28dNULLABLEFLOAT
mobile_app_purchase_roas.view_1dNULLABLEFLOAT
mobile_app_purchase_roas.view_7dNULLABLEFLOAT
mobile_app_purchase_roas.view_28dNULLABLEFLOAT
objectiveNULLABLESTRING
place_page_nameNULLABLESTRING
spendNULLABLEFLOAT
reachNULLABLEFLOAT
unique_clicksNULLABLEINTEGER
unique_inline_link_clicksNULLABLEINTEGER
publisher_platformNULLABLESTRING
device_platformNULLABLESTRING
platform_positionNULLABLESTRING
actionsREPEATEDRECORD
actions.action_typeNULLABLESTRING
actions.valueNULLABLEFLOAT
actions.click_1dNULLABLEFLOAT
actions.click_7dNULLABLEFLOAT
actions.click_28dNULLABLEFLOAT
actions.view_1dNULLABLEFLOAT
actions.view_7dNULLABLEFLOAT
actions.view_28dNULLABLEFLOAT
unique_actionsREPEATEDRECORD
unique_actions.action_typeNULLABLESTRING
unique_actions.valueNULLABLEFLOAT
unique_actions.click_1dNULLABLEFLOAT
unique_actions.click_7dNULLABLEFLOAT
unique_actions.click_28dNULLABLEFLOAT
unique_actions.view_1dNULLABLEFLOAT
unique_actions.view_7dNULLABLEFLOAT
unique_actions.view_28dNULLABLEFLOAT
action_valuesREPEATEDRECORD
action_values.action_typeNULLABLESTRING
action_values.valueNULLABLEFLOAT
action_values.click_1dNULLABLEFLOAT
action_values.click_7dNULLABLEFLOAT
action_values.click_28dNULLABLEFLOAT
action_values.view_1dNULLABLEFLOAT
action_values.view_7dNULLABLEFLOAT
action_values.view_28dNULLABLEFLOAT
outbound_clicksREPEATEDRECORD
outbound_clicks.action_typeNULLABLESTRING
outbound_clicks.valueNULLABLEFLOAT
outbound_clicks.click_1dNULLABLEFLOAT
outbound_clicks.click_7dNULLABLEFLOAT
outbound_clicks.click_28dNULLABLEFLOAT
outbound_clicks.view_1dNULLABLEFLOAT
outbound_clicks.view_7dNULLABLEFLOAT
outbound_clicks.view_28dNULLABLEFLOAT
unique_outbound_clicksREPEATEDRECORD
unique_outbound_clicks.action_typeNULLABLESTRING
unique_outbound_clicks.valueNULLABLEFLOAT
unique_outbound_clicks.click_1dNULLABLEFLOAT
unique_outbound_clicks.click_7dNULLABLEFLOAT
unique_outbound_clicks.click_28dNULLABLEFLOAT
unique_outbound_clicks.view_1dNULLABLEFLOAT
unique_outbound_clicks.view_7dNULLABLEFLOAT
unique_outbound_clicks.view_28dNULLABLEFLOAT
website_purchase_roasREPEATEDRECORD
website_purchase_roas.action_typeNULLABLESTRING
website_purchase_roas.valueNULLABLEFLOAT
website_purchase_roas.click_1dNULLABLEFLOAT
website_purchase_roas.click_7dNULLABLEFLOAT
website_purchase_roas.click_28dNULLABLEFLOAT
website_purchase_roas.view_1dNULLABLEFLOAT
website_purchase_roas.view_7dNULLABLEFLOAT
website_purchase_roas.view_28dNULLABLEFLOAT
conversionsREPEATEDRECORD
conversions.action_typeNULLABLESTRING
conversions.valueNULLABLEFLOAT
conversions.click_1dNULLABLEFLOAT
conversions.click_7dNULLABLEFLOAT
conversions.click_28dNULLABLEFLOAT
conversions.view_1dNULLABLEFLOAT
conversions.view_7dNULLABLEFLOAT
conversions.view_28dNULLABLEFLOAT
Data schema for fb_video
Field NameModeType
account_idNULLABLESTRING
account_nameNULLABLESTRING
ad_idNULLABLESTRING
ad_nameNULLABLESTRING
adset_idNULLABLESTRING
adset_nameNULLABLESTRING
campaign_idNULLABLESTRING
campaign_nameNULLABLESTRING
attribution_settingNULLABLESTRING
video_30_sec_watched_actionsREPEATEDRECORD
video_30_sec_watched_actions.action_typeNULLABLESTRING
video_30_sec_watched_actions.valueNULLABLEFLOAT
video_30_sec_watched_actions.click_1dNULLABLEFLOAT
video_30_sec_watched_actions.click_7dNULLABLEFLOAT
video_30_sec_watched_actions.click_28dNULLABLEFLOAT
video_30_sec_watched_actions.view_1dNULLABLEFLOAT
video_30_sec_watched_actions.view_7dNULLABLEFLOAT
video_30_sec_watched_actions.view_28dNULLABLEFLOAT
video_avg_time_watched_actionsREPEATEDRECORD
video_avg_time_watched_actions.action_typeNULLABLESTRING
video_avg_time_watched_actions.valueNULLABLEFLOAT
video_avg_time_watched_actions.click_1dNULLABLEFLOAT
video_avg_time_watched_actions.click_7dNULLABLEFLOAT
video_avg_time_watched_actions.click_28dNULLABLEFLOAT
video_avg_time_watched_actions.view_1dNULLABLEFLOAT
video_avg_time_watched_actions.view_7dNULLABLEFLOAT
video_avg_time_watched_actions.view_28dNULLABLEFLOAT
video_p100_watched_actionsREPEATEDRECORD
video_p100_watched_actions.action_typeNULLABLESTRING
video_p100_watched_actions.valueNULLABLEFLOAT
video_p100_watched_actions.click_1dNULLABLEFLOAT
video_p100_watched_actions.click_7dNULLABLEFLOAT
video_p100_watched_actions.click_28dNULLABLEFLOAT
video_p100_watched_actions.view_1dNULLABLEFLOAT
video_p100_watched_actions.view_7dNULLABLEFLOAT
video_p100_watched_actions.view_28dNULLABLEFLOAT
video_p25_watched_actionsREPEATEDRECORD
video_p25_watched_actions.action_typeNULLABLESTRING
video_p25_watched_actions.valueNULLABLEFLOAT
video_p25_watched_actions.click_1dNULLABLEFLOAT
video_p25_watched_actions.click_7dNULLABLEFLOAT
video_p25_watched_actions.click_28dNULLABLEFLOAT
video_p25_watched_actions.view_1dNULLABLEFLOAT
video_p25_watched_actions.view_7dNULLABLEFLOAT
video_p25_watched_actions.view_28dNULLABLEFLOAT
video_p50_watched_actionsREPEATEDRECORD
video_p50_watched_actions.action_typeNULLABLESTRING
video_p50_watched_actions.valueNULLABLEFLOAT
video_p50_watched_actions.click_1dNULLABLEFLOAT
video_p50_watched_actions.click_7dNULLABLEFLOAT
video_p50_watched_actions.click_28dNULLABLEFLOAT
video_p50_watched_actions.view_1dNULLABLEFLOAT
video_p50_watched_actions.view_7dNULLABLEFLOAT
video_p50_watched_actions.view_28dNULLABLEFLOAT
video_p75_watched_actionsREPEATEDRECORD
video_p75_watched_actions.action_typeNULLABLESTRING
video_p75_watched_actions.valueNULLABLEFLOAT
video_p75_watched_actions.click_1dNULLABLEFLOAT
video_p75_watched_actions.click_7dNULLABLEFLOAT
video_p75_watched_actions.click_28dNULLABLEFLOAT
video_p75_watched_actions.view_1dNULLABLEFLOAT
video_p75_watched_actions.view_7dNULLABLEFLOAT
video_p75_watched_actions.view_28dNULLABLEFLOAT
video_p95_watched_actionsREPEATEDRECORD
video_p95_watched_actions.action_typeNULLABLESTRING
video_p95_watched_actions.valueNULLABLEFLOAT
video_p95_watched_actions.click_1dNULLABLEFLOAT
video_p95_watched_actions.click_7dNULLABLEFLOAT
video_p95_watched_actions.click_28dNULLABLEFLOAT
video_p95_watched_actions.view_1dNULLABLEFLOAT
video_p95_watched_actions.view_7dNULLABLEFLOAT
video_p95_watched_actions.view_28dNULLABLEFLOAT
video_play_actionsREPEATEDRECORD
video_play_actions.action_typeNULLABLESTRING
video_play_actions.valueNULLABLEFLOAT
video_play_actions.click_1dNULLABLEFLOAT
video_play_actions.click_7dNULLABLEFLOAT
video_play_actions.click_28dNULLABLEFLOAT
video_play_actions.view_1dNULLABLEFLOAT
video_play_actions.view_7dNULLABLEFLOAT
video_play_actions.view_28dNULLABLEFLOAT
video_continuous_2_sec_watched_actionsREPEATEDRECORD
video_continuous_2_sec_watched_actions.action_typeNULLABLESTRING
video_continuous_2_sec_watched_actions.valueNULLABLEFLOAT
video_continuous_2_sec_watched_actions.click_1dNULLABLEFLOAT
video_continuous_2_sec_watched_actions.click_7dNULLABLEFLOAT
video_continuous_2_sec_watched_actions.click_28dNULLABLEFLOAT
video_continuous_2_sec_watched_actions.view_1dNULLABLEFLOAT
video_continuous_2_sec_watched_actions.view_7dNULLABLEFLOAT
video_continuous_2_sec_watched_actions.view_28dNULLABLEFLOAT
video_15_sec_watched_actionsREPEATEDRECORD
video_15_sec_watched_actions.action_typeNULLABLESTRING
video_15_sec_watched_actions.valueNULLABLEFLOAT
video_15_sec_watched_actions.click_1dNULLABLEFLOAT
video_15_sec_watched_actions.click_7dNULLABLEFLOAT
video_15_sec_watched_actions.click_28dNULLABLEFLOAT
video_15_sec_watched_actions.view_1dNULLABLEFLOAT
video_15_sec_watched_actions.view_7dNULLABLEFLOAT
video_15_sec_watched_actions.view_28dNULLABLEFLOAT
video_thruplay_watched_actionsREPEATEDRECORD
video_thruplay_watched_actions.action_typeNULLABLESTRING
video_thruplay_watched_actions.valueNULLABLEFLOAT
video_thruplay_watched_actions.click_1dNULLABLEFLOAT
video_thruplay_watched_actions.click_7dNULLABLEFLOAT
video_thruplay_watched_actions.click_28dNULLABLEFLOAT
video_thruplay_watched_actions.view_1dNULLABLEFLOAT
video_thruplay_watched_actions.view_7dNULLABLEFLOAT
video_thruplay_watched_actions.view_28dNULLABLEFLOAT
date_startNULLABLEDATE
date_stopNULLABLEDATE
publisher_platformNULLABLESTRING
device_platformNULLABLESTRING
platform_positionNULLABLESTRING
Data schema for fb_products
Field NameModeType
account_idNULLABLESTRING
account_nameNULLABLESTRING
account_currencyNULLABLESTRING
ad_idNULLABLESTRING
ad_nameNULLABLESTRING
adset_idNULLABLESTRING
adset_nameNULLABLESTRING
buying_typeNULLABLESTRING
campaign_idNULLABLESTRING
campaign_nameNULLABLESTRING
attribution_settingNULLABLESTRING
product_idNULLABLESTRING
clicksNULLABLEINTEGER
impressionsNULLABLEINTEGER
date_startNULLABLEDATE
date_stopNULLABLEDATE
inline_post_engagementNULLABLEINTEGER
inline_link_clicksNULLABLEINTEGER
objectiveNULLABLESTRING
spendNULLABLEFLOAT
outbound_clicksREPEATEDRECORD
outbound_clicks.action_typeNULLABLESTRING
outbound_clicks.valueNULLABLEFLOAT
outbound_clicks.inlineNULLABLEFLOAT
actionsREPEATEDRECORD
actions.action_typeNULLABLESTRING
actions.valueNULLABLEFLOAT
actions.click_1dNULLABLEFLOAT
actions.click_7dNULLABLEFLOAT
actions.click_28dNULLABLEFLOAT
actions.view_1dNULLABLEFLOAT
actions.view_7dNULLABLEFLOAT
actions.view_28dNULLABLEFLOAT
unique_actionsREPEATEDRECORD
unique_actions.action_typeNULLABLESTRING
unique_actions.valueNULLABLEFLOAT
unique_actions.click_1dNULLABLEFLOAT
unique_actions.click_7dNULLABLEFLOAT
unique_actions.click_28dNULLABLEFLOAT
unique_actions.view_1dNULLABLEFLOAT
unique_actions.view_7dNULLABLEFLOAT
unique_actions.view_28dNULLABLEFLOAT
action_valuesREPEATEDRECORD
action_values.action_typeNULLABLESTRING
action_values.valueNULLABLEFLOAT
action_values.click_1dNULLABLEFLOAT
action_values.click_7dNULLABLEFLOAT
action_values.click_28dNULLABLEFLOAT
action_values.view_1dNULLABLEFLOAT
action_values.view_7dNULLABLEFLOAT
action_values.view_28dNULLABLEFLOAT
Data schema for fb_product_actions
Field NameModeType
date_startNULLABLEDATE
campaign_idNULLABLESTRING
product_idNULLABLESTRING
actionsREPEATEDRECORD
actions.action_typeNULLABLESTRING
actions.valueNULLABLEFLOAT
actions.click_1dNULLABLEFLOAT
actions.click_7dNULLABLEFLOAT
actions.click_28dNULLABLEFLOAT
actions.view_1dNULLABLEFLOAT
actions.view_7dNULLABLEFLOAT
actions.view_28dNULLABLEFLOAT
Data schema for fb_product_action_values
Field NameModeType
date_startNULLABLEDATE
campaign_idNULLABLESTRING
product_idNULLABLESTRING
action_valuesREPEATEDRECORD
action_values.action_typeNULLABLESTRING
action_values.valueNULLABLEFLOAT
action_values.click_1dNULLABLEFLOAT
action_values.click_7dNULLABLEFLOAT
action_values.click_28dNULLABLEFLOAT
action_values.view_1dNULLABLEFLOAT
action_values.view_7dNULLABLEFLOAT
action_values.view_28dNULLABLEFLOAT
Data schema for fb_reach_account_level
Field NameModeType
dateNULLABLEDATE
account_idNULLABLESTRING
account_nameNULLABLESTRING
reachNULLABLEINTEGER
reach_7dNULLABLEINTEGER
reach_14dNULLABLEINTEGER
reach_28dNULLABLEINTEGER
reach_customNULLABLEINTEGER
reach_custom_timespanNULLABLEINTEGER
Data schema for fb_reach_campaign_level
Field NameModeType
dateNULLABLEDATE
account_idNULLABLESTRING
account_nameNULLABLESTRING
campaign_idNULLABLESTRING
campaign_nameNULLABLESTRING
reachNULLABLEINTEGER
reach_7dNULLABLEINTEGER
reach_14dNULLABLEINTEGER
reach_28dNULLABLEINTEGER
reach_customNULLABLEINTEGER
reach_custom_timespanNULLABLEINTEGER
Data schema for fb_reach_adset_level
Field NameModeType
dateNULLABLEDATE
account_idNULLABLESTRING
account_nameNULLABLESTRING
adset_idNULLABLESTRING
adset_nameNULLABLESTRING
campaign_idNULLABLESTRING
campaign_nameNULLABLESTRING
reachNULLABLEINTEGER
reach_7dNULLABLEINTEGER
reach_14dNULLABLEINTEGER
reach_28dNULLABLEINTEGER
reach_customNULLABLEINTEGER
reach_custom_timespanNULLABLEINTEGER
Data schema for fb_reach_ad_level
Field NameModeType
dateNULLABLEDATE
account_idNULLABLESTRING
account_nameNULLABLESTRING
ad_idNULLABLESTRING
ad_nameNULLABLESTRING
adset_idNULLABLESTRING
adset_nameNULLABLESTRING
campaign_idNULLABLESTRING
campaign_nameNULLABLESTRING
reachNULLABLEINTEGER
reach_7dNULLABLEINTEGER
reach_14dNULLABLEINTEGER
reach_28dNULLABLEINTEGER
reach_customNULLABLEINTEGER
reach_custom_timespanNULLABLEINTEGER