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.

Select Facebook Ads from the list of available integrations.

Enter the Collect name, e.g. 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.

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.

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

Optionally, click Show advanced settings:
- Action Attribution Windows — the attribution windows conversions are collected for:
1d_click,1d_view,7d_click,7d_viewanddefault(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 inreach_custom_timespan. - Tables to collect — all tables are selected; remove the ones you do not need.

Click Next.

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

A data synchronization schedule will be created automatically. More information on this topic can be found here.
Click Create to complete the configuration.

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 Name | Mode | Type |
|---|---|---|
| account_id | NULLABLE | STRING |
| account_name | NULLABLE | STRING |
| account_currency | NULLABLE | STRING |
| ad_id | NULLABLE | STRING |
| ad_name | NULLABLE | STRING |
| adset_id | NULLABLE | STRING |
| adset_name | NULLABLE | STRING |
| buying_type | NULLABLE | STRING |
| campaign_id | NULLABLE | STRING |
| campaign_name | NULLABLE | STRING |
| attribution_setting | NULLABLE | STRING |
| canvas_avg_view_percent | NULLABLE | FLOAT |
| canvas_avg_view_time | NULLABLE | FLOAT |
| clicks | NULLABLE | INTEGER |
| impressions | NULLABLE | INTEGER |
| date_start | NULLABLE | DATE |
| date_stop | NULLABLE | DATE |
| inline_post_engagement | NULLABLE | INTEGER |
| inline_link_clicks | NULLABLE | INTEGER |
| mobile_app_purchase_roas | REPEATED | RECORD |
| mobile_app_purchase_roas.action_type | NULLABLE | STRING |
| mobile_app_purchase_roas.value | NULLABLE | FLOAT |
| mobile_app_purchase_roas.click_1d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.click_7d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.click_28d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.view_1d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.view_7d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.view_28d | NULLABLE | FLOAT |
| objective | NULLABLE | STRING |
| place_page_name | NULLABLE | STRING |
| spend | NULLABLE | FLOAT |
| reach | NULLABLE | FLOAT |
| unique_clicks | NULLABLE | INTEGER |
| unique_inline_link_clicks | NULLABLE | INTEGER |
| publisher_platform | NULLABLE | STRING |
| device_platform | NULLABLE | STRING |
| platform_position | NULLABLE | STRING |
| actions | REPEATED | RECORD |
| actions.action_type | NULLABLE | STRING |
| actions.value | NULLABLE | FLOAT |
| actions.click_1d | NULLABLE | FLOAT |
| actions.click_7d | NULLABLE | FLOAT |
| actions.click_28d | NULLABLE | FLOAT |
| actions.view_1d | NULLABLE | FLOAT |
| actions.view_7d | NULLABLE | FLOAT |
| actions.view_28d | NULLABLE | FLOAT |
| unique_actions | REPEATED | RECORD |
| unique_actions.action_type | NULLABLE | STRING |
| unique_actions.value | NULLABLE | FLOAT |
| unique_actions.click_1d | NULLABLE | FLOAT |
| unique_actions.click_7d | NULLABLE | FLOAT |
| unique_actions.click_28d | NULLABLE | FLOAT |
| unique_actions.view_1d | NULLABLE | FLOAT |
| unique_actions.view_7d | NULLABLE | FLOAT |
| unique_actions.view_28d | NULLABLE | FLOAT |
| action_values | REPEATED | RECORD |
| action_values.action_type | NULLABLE | STRING |
| action_values.value | NULLABLE | FLOAT |
| action_values.click_1d | NULLABLE | FLOAT |
| action_values.click_7d | NULLABLE | FLOAT |
| action_values.click_28d | NULLABLE | FLOAT |
| action_values.view_1d | NULLABLE | FLOAT |
| action_values.view_7d | NULLABLE | FLOAT |
| action_values.view_28d | NULLABLE | FLOAT |
| outbound_clicks | REPEATED | RECORD |
| outbound_clicks.action_type | NULLABLE | STRING |
| outbound_clicks.value | NULLABLE | FLOAT |
| outbound_clicks.click_1d | NULLABLE | FLOAT |
| outbound_clicks.click_7d | NULLABLE | FLOAT |
| outbound_clicks.click_28d | NULLABLE | FLOAT |
| outbound_clicks.view_1d | NULLABLE | FLOAT |
| outbound_clicks.view_7d | NULLABLE | FLOAT |
| outbound_clicks.view_28d | NULLABLE | FLOAT |
| unique_outbound_clicks | REPEATED | RECORD |
| unique_outbound_clicks.action_type | NULLABLE | STRING |
| unique_outbound_clicks.value | NULLABLE | FLOAT |
| unique_outbound_clicks.click_1d | NULLABLE | FLOAT |
| unique_outbound_clicks.click_7d | NULLABLE | FLOAT |
| unique_outbound_clicks.click_28d | NULLABLE | FLOAT |
| unique_outbound_clicks.view_1d | NULLABLE | FLOAT |
| unique_outbound_clicks.view_7d | NULLABLE | FLOAT |
| unique_outbound_clicks.view_28d | NULLABLE | FLOAT |
| website_purchase_roas | REPEATED | RECORD |
| website_purchase_roas.action_type | NULLABLE | STRING |
| website_purchase_roas.value | NULLABLE | FLOAT |
| website_purchase_roas.click_1d | NULLABLE | FLOAT |
| website_purchase_roas.click_7d | NULLABLE | FLOAT |
| website_purchase_roas.click_28d | NULLABLE | FLOAT |
| website_purchase_roas.view_1d | NULLABLE | FLOAT |
| website_purchase_roas.view_7d | NULLABLE | FLOAT |
| website_purchase_roas.view_28d | NULLABLE | FLOAT |
| conversions | REPEATED | RECORD |
| conversions.action_type | NULLABLE | STRING |
| conversions.value | NULLABLE | FLOAT |
| conversions.click_1d | NULLABLE | FLOAT |
| conversions.click_7d | NULLABLE | FLOAT |
| conversions.click_28d | NULLABLE | FLOAT |
| conversions.view_1d | NULLABLE | FLOAT |
| conversions.view_7d | NULLABLE | FLOAT |
| conversions.view_28d | NULLABLE | FLOAT |
Data schema for fb_adcreatives
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| account_id | NULLABLE | STRING |
| ad_id | NULLABLE | STRING |
| ad_name | NULLABLE | STRING |
| adset_id | NULLABLE | STRING |
| campaign_id | NULLABLE | STRING |
| ad_status | NULLABLE | STRING |
| ad_effective_status | NULLABLE | STRING |
| ad_updated_time | NULLABLE | TIMESTAMP |
| creative_url | NULLABLE | STRING |
| creative_id | NULLABLE | STRING |
| creative_name | NULLABLE | STRING |
| creative_status | NULLABLE | STRING |
| object_type | NULLABLE | STRING |
| object_story_id | NULLABLE | STRING |
| effective_object_story_id | NULLABLE | STRING |
| call_to_action_type | NULLABLE | STRING |
| destination_url | NULLABLE | STRING |
| url_tags | NULLABLE | STRING |
| final_url | NULLABLE | STRING |
| utm_source | NULLABLE | STRING |
| utm_medium | NULLABLE | STRING |
| utm_campaign | NULLABLE | STRING |
| utm_content | NULLABLE | STRING |
| utm_term | NULLABLE | STRING |
| link_url | NULLABLE | STRING |
| link_destination_display_url | NULLABLE | STRING |
| template_url | NULLABLE | STRING |
| image_url | NULLABLE | STRING |
| thumbnail_url | NULLABLE | STRING |
| video_id | NULLABLE | STRING |
| post_permalink_url | NULLABLE | STRING |
| instagram_permalink_url | NULLABLE | STRING |
| effective_instagram_media_id | NULLABLE | STRING |
| asset_feed_link_urls | REPEATED | RECORD |
| asset_feed_link_urls.website_url | NULLABLE | STRING |
| asset_feed_link_urls.display_url | NULLABLE | STRING |
Data schema for fb_adsets
| Field Name | Mode | Type |
|---|---|---|
| account_id | NULLABLE | STRING |
| account_name | NULLABLE | STRING |
| account_currency | NULLABLE | STRING |
| ad_id | NULLABLE | STRING |
| ad_name | NULLABLE | STRING |
| adset_id | NULLABLE | STRING |
| adset_name | NULLABLE | STRING |
| buying_type | NULLABLE | STRING |
| campaign_id | NULLABLE | STRING |
| campaign_name | NULLABLE | STRING |
| attribution_setting | NULLABLE | STRING |
| canvas_avg_view_percent | NULLABLE | FLOAT |
| canvas_avg_view_time | NULLABLE | FLOAT |
| clicks | NULLABLE | INTEGER |
| impressions | NULLABLE | INTEGER |
| date_start | NULLABLE | DATE |
| date_stop | NULLABLE | DATE |
| inline_post_engagement | NULLABLE | INTEGER |
| inline_link_clicks | NULLABLE | INTEGER |
| mobile_app_purchase_roas | REPEATED | RECORD |
| mobile_app_purchase_roas.action_type | NULLABLE | STRING |
| mobile_app_purchase_roas.value | NULLABLE | FLOAT |
| mobile_app_purchase_roas.click_1d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.click_7d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.click_28d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.view_1d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.view_7d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.view_28d | NULLABLE | FLOAT |
| objective | NULLABLE | STRING |
| place_page_name | NULLABLE | STRING |
| spend | NULLABLE | FLOAT |
| reach | NULLABLE | FLOAT |
| unique_clicks | NULLABLE | INTEGER |
| unique_inline_link_clicks | NULLABLE | INTEGER |
| publisher_platform | NULLABLE | STRING |
| device_platform | NULLABLE | STRING |
| platform_position | NULLABLE | STRING |
| actions | REPEATED | RECORD |
| actions.action_type | NULLABLE | STRING |
| actions.value | NULLABLE | FLOAT |
| actions.click_1d | NULLABLE | FLOAT |
| actions.click_7d | NULLABLE | FLOAT |
| actions.click_28d | NULLABLE | FLOAT |
| actions.view_1d | NULLABLE | FLOAT |
| actions.view_7d | NULLABLE | FLOAT |
| actions.view_28d | NULLABLE | FLOAT |
| unique_actions | REPEATED | RECORD |
| unique_actions.action_type | NULLABLE | STRING |
| unique_actions.value | NULLABLE | FLOAT |
| unique_actions.click_1d | NULLABLE | FLOAT |
| unique_actions.click_7d | NULLABLE | FLOAT |
| unique_actions.click_28d | NULLABLE | FLOAT |
| unique_actions.view_1d | NULLABLE | FLOAT |
| unique_actions.view_7d | NULLABLE | FLOAT |
| unique_actions.view_28d | NULLABLE | FLOAT |
| action_values | REPEATED | RECORD |
| action_values.action_type | NULLABLE | STRING |
| action_values.value | NULLABLE | FLOAT |
| action_values.click_1d | NULLABLE | FLOAT |
| action_values.click_7d | NULLABLE | FLOAT |
| action_values.click_28d | NULLABLE | FLOAT |
| action_values.view_1d | NULLABLE | FLOAT |
| action_values.view_7d | NULLABLE | FLOAT |
| action_values.view_28d | NULLABLE | FLOAT |
| outbound_clicks | REPEATED | RECORD |
| outbound_clicks.action_type | NULLABLE | STRING |
| outbound_clicks.value | NULLABLE | FLOAT |
| outbound_clicks.click_1d | NULLABLE | FLOAT |
| outbound_clicks.click_7d | NULLABLE | FLOAT |
| outbound_clicks.click_28d | NULLABLE | FLOAT |
| outbound_clicks.view_1d | NULLABLE | FLOAT |
| outbound_clicks.view_7d | NULLABLE | FLOAT |
| outbound_clicks.view_28d | NULLABLE | FLOAT |
| unique_outbound_clicks | REPEATED | RECORD |
| unique_outbound_clicks.action_type | NULLABLE | STRING |
| unique_outbound_clicks.value | NULLABLE | FLOAT |
| unique_outbound_clicks.click_1d | NULLABLE | FLOAT |
| unique_outbound_clicks.click_7d | NULLABLE | FLOAT |
| unique_outbound_clicks.click_28d | NULLABLE | FLOAT |
| unique_outbound_clicks.view_1d | NULLABLE | FLOAT |
| unique_outbound_clicks.view_7d | NULLABLE | FLOAT |
| unique_outbound_clicks.view_28d | NULLABLE | FLOAT |
| website_purchase_roas | REPEATED | RECORD |
| website_purchase_roas.action_type | NULLABLE | STRING |
| website_purchase_roas.value | NULLABLE | FLOAT |
| website_purchase_roas.click_1d | NULLABLE | FLOAT |
| website_purchase_roas.click_7d | NULLABLE | FLOAT |
| website_purchase_roas.click_28d | NULLABLE | FLOAT |
| website_purchase_roas.view_1d | NULLABLE | FLOAT |
| website_purchase_roas.view_7d | NULLABLE | FLOAT |
| website_purchase_roas.view_28d | NULLABLE | FLOAT |
| conversions | REPEATED | RECORD |
| conversions.action_type | NULLABLE | STRING |
| conversions.value | NULLABLE | FLOAT |
| conversions.click_1d | NULLABLE | FLOAT |
| conversions.click_7d | NULLABLE | FLOAT |
| conversions.click_28d | NULLABLE | FLOAT |
| conversions.view_1d | NULLABLE | FLOAT |
| conversions.view_7d | NULLABLE | FLOAT |
| conversions.view_28d | NULLABLE | FLOAT |
Data schema for fb_campaigns
| Field Name | Mode | Type |
|---|---|---|
| account_id | NULLABLE | STRING |
| account_name | NULLABLE | STRING |
| account_currency | NULLABLE | STRING |
| ad_id | NULLABLE | STRING |
| ad_name | NULLABLE | STRING |
| adset_id | NULLABLE | STRING |
| adset_name | NULLABLE | STRING |
| buying_type | NULLABLE | STRING |
| campaign_id | NULLABLE | STRING |
| campaign_name | NULLABLE | STRING |
| attribution_setting | NULLABLE | STRING |
| canvas_avg_view_percent | NULLABLE | FLOAT |
| canvas_avg_view_time | NULLABLE | FLOAT |
| clicks | NULLABLE | INTEGER |
| impressions | NULLABLE | INTEGER |
| date_start | NULLABLE | DATE |
| date_stop | NULLABLE | DATE |
| inline_post_engagement | NULLABLE | INTEGER |
| inline_link_clicks | NULLABLE | INTEGER |
| mobile_app_purchase_roas | REPEATED | RECORD |
| mobile_app_purchase_roas.action_type | NULLABLE | STRING |
| mobile_app_purchase_roas.value | NULLABLE | FLOAT |
| mobile_app_purchase_roas.click_1d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.click_7d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.click_28d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.view_1d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.view_7d | NULLABLE | FLOAT |
| mobile_app_purchase_roas.view_28d | NULLABLE | FLOAT |
| objective | NULLABLE | STRING |
| place_page_name | NULLABLE | STRING |
| spend | NULLABLE | FLOAT |
| reach | NULLABLE | FLOAT |
| unique_clicks | NULLABLE | INTEGER |
| unique_inline_link_clicks | NULLABLE | INTEGER |
| publisher_platform | NULLABLE | STRING |
| device_platform | NULLABLE | STRING |
| platform_position | NULLABLE | STRING |
| actions | REPEATED | RECORD |
| actions.action_type | NULLABLE | STRING |
| actions.value | NULLABLE | FLOAT |
| actions.click_1d | NULLABLE | FLOAT |
| actions.click_7d | NULLABLE | FLOAT |
| actions.click_28d | NULLABLE | FLOAT |
| actions.view_1d | NULLABLE | FLOAT |
| actions.view_7d | NULLABLE | FLOAT |
| actions.view_28d | NULLABLE | FLOAT |
| unique_actions | REPEATED | RECORD |
| unique_actions.action_type | NULLABLE | STRING |
| unique_actions.value | NULLABLE | FLOAT |
| unique_actions.click_1d | NULLABLE | FLOAT |
| unique_actions.click_7d | NULLABLE | FLOAT |
| unique_actions.click_28d | NULLABLE | FLOAT |
| unique_actions.view_1d | NULLABLE | FLOAT |
| unique_actions.view_7d | NULLABLE | FLOAT |
| unique_actions.view_28d | NULLABLE | FLOAT |
| action_values | REPEATED | RECORD |
| action_values.action_type | NULLABLE | STRING |
| action_values.value | NULLABLE | FLOAT |
| action_values.click_1d | NULLABLE | FLOAT |
| action_values.click_7d | NULLABLE | FLOAT |
| action_values.click_28d | NULLABLE | FLOAT |
| action_values.view_1d | NULLABLE | FLOAT |
| action_values.view_7d | NULLABLE | FLOAT |
| action_values.view_28d | NULLABLE | FLOAT |
| outbound_clicks | REPEATED | RECORD |
| outbound_clicks.action_type | NULLABLE | STRING |
| outbound_clicks.value | NULLABLE | FLOAT |
| outbound_clicks.click_1d | NULLABLE | FLOAT |
| outbound_clicks.click_7d | NULLABLE | FLOAT |
| outbound_clicks.click_28d | NULLABLE | FLOAT |
| outbound_clicks.view_1d | NULLABLE | FLOAT |
| outbound_clicks.view_7d | NULLABLE | FLOAT |
| outbound_clicks.view_28d | NULLABLE | FLOAT |
| unique_outbound_clicks | REPEATED | RECORD |
| unique_outbound_clicks.action_type | NULLABLE | STRING |
| unique_outbound_clicks.value | NULLABLE | FLOAT |
| unique_outbound_clicks.click_1d | NULLABLE | FLOAT |
| unique_outbound_clicks.click_7d | NULLABLE | FLOAT |
| unique_outbound_clicks.click_28d | NULLABLE | FLOAT |
| unique_outbound_clicks.view_1d | NULLABLE | FLOAT |
| unique_outbound_clicks.view_7d | NULLABLE | FLOAT |
| unique_outbound_clicks.view_28d | NULLABLE | FLOAT |
| website_purchase_roas | REPEATED | RECORD |
| website_purchase_roas.action_type | NULLABLE | STRING |
| website_purchase_roas.value | NULLABLE | FLOAT |
| website_purchase_roas.click_1d | NULLABLE | FLOAT |
| website_purchase_roas.click_7d | NULLABLE | FLOAT |
| website_purchase_roas.click_28d | NULLABLE | FLOAT |
| website_purchase_roas.view_1d | NULLABLE | FLOAT |
| website_purchase_roas.view_7d | NULLABLE | FLOAT |
| website_purchase_roas.view_28d | NULLABLE | FLOAT |
| conversions | REPEATED | RECORD |
| conversions.action_type | NULLABLE | STRING |
| conversions.value | NULLABLE | FLOAT |
| conversions.click_1d | NULLABLE | FLOAT |
| conversions.click_7d | NULLABLE | FLOAT |
| conversions.click_28d | NULLABLE | FLOAT |
| conversions.view_1d | NULLABLE | FLOAT |
| conversions.view_7d | NULLABLE | FLOAT |
| conversions.view_28d | NULLABLE | FLOAT |
Data schema for fb_video
| Field Name | Mode | Type |
|---|---|---|
| account_id | NULLABLE | STRING |
| account_name | NULLABLE | STRING |
| ad_id | NULLABLE | STRING |
| ad_name | NULLABLE | STRING |
| adset_id | NULLABLE | STRING |
| adset_name | NULLABLE | STRING |
| campaign_id | NULLABLE | STRING |
| campaign_name | NULLABLE | STRING |
| attribution_setting | NULLABLE | STRING |
| video_30_sec_watched_actions | REPEATED | RECORD |
| video_30_sec_watched_actions.action_type | NULLABLE | STRING |
| video_30_sec_watched_actions.value | NULLABLE | FLOAT |
| video_30_sec_watched_actions.click_1d | NULLABLE | FLOAT |
| video_30_sec_watched_actions.click_7d | NULLABLE | FLOAT |
| video_30_sec_watched_actions.click_28d | NULLABLE | FLOAT |
| video_30_sec_watched_actions.view_1d | NULLABLE | FLOAT |
| video_30_sec_watched_actions.view_7d | NULLABLE | FLOAT |
| video_30_sec_watched_actions.view_28d | NULLABLE | FLOAT |
| video_avg_time_watched_actions | REPEATED | RECORD |
| video_avg_time_watched_actions.action_type | NULLABLE | STRING |
| video_avg_time_watched_actions.value | NULLABLE | FLOAT |
| video_avg_time_watched_actions.click_1d | NULLABLE | FLOAT |
| video_avg_time_watched_actions.click_7d | NULLABLE | FLOAT |
| video_avg_time_watched_actions.click_28d | NULLABLE | FLOAT |
| video_avg_time_watched_actions.view_1d | NULLABLE | FLOAT |
| video_avg_time_watched_actions.view_7d | NULLABLE | FLOAT |
| video_avg_time_watched_actions.view_28d | NULLABLE | FLOAT |
| video_p100_watched_actions | REPEATED | RECORD |
| video_p100_watched_actions.action_type | NULLABLE | STRING |
| video_p100_watched_actions.value | NULLABLE | FLOAT |
| video_p100_watched_actions.click_1d | NULLABLE | FLOAT |
| video_p100_watched_actions.click_7d | NULLABLE | FLOAT |
| video_p100_watched_actions.click_28d | NULLABLE | FLOAT |
| video_p100_watched_actions.view_1d | NULLABLE | FLOAT |
| video_p100_watched_actions.view_7d | NULLABLE | FLOAT |
| video_p100_watched_actions.view_28d | NULLABLE | FLOAT |
| video_p25_watched_actions | REPEATED | RECORD |
| video_p25_watched_actions.action_type | NULLABLE | STRING |
| video_p25_watched_actions.value | NULLABLE | FLOAT |
| video_p25_watched_actions.click_1d | NULLABLE | FLOAT |
| video_p25_watched_actions.click_7d | NULLABLE | FLOAT |
| video_p25_watched_actions.click_28d | NULLABLE | FLOAT |
| video_p25_watched_actions.view_1d | NULLABLE | FLOAT |
| video_p25_watched_actions.view_7d | NULLABLE | FLOAT |
| video_p25_watched_actions.view_28d | NULLABLE | FLOAT |
| video_p50_watched_actions | REPEATED | RECORD |
| video_p50_watched_actions.action_type | NULLABLE | STRING |
| video_p50_watched_actions.value | NULLABLE | FLOAT |
| video_p50_watched_actions.click_1d | NULLABLE | FLOAT |
| video_p50_watched_actions.click_7d | NULLABLE | FLOAT |
| video_p50_watched_actions.click_28d | NULLABLE | FLOAT |
| video_p50_watched_actions.view_1d | NULLABLE | FLOAT |
| video_p50_watched_actions.view_7d | NULLABLE | FLOAT |
| video_p50_watched_actions.view_28d | NULLABLE | FLOAT |
| video_p75_watched_actions | REPEATED | RECORD |
| video_p75_watched_actions.action_type | NULLABLE | STRING |
| video_p75_watched_actions.value | NULLABLE | FLOAT |
| video_p75_watched_actions.click_1d | NULLABLE | FLOAT |
| video_p75_watched_actions.click_7d | NULLABLE | FLOAT |
| video_p75_watched_actions.click_28d | NULLABLE | FLOAT |
| video_p75_watched_actions.view_1d | NULLABLE | FLOAT |
| video_p75_watched_actions.view_7d | NULLABLE | FLOAT |
| video_p75_watched_actions.view_28d | NULLABLE | FLOAT |
| video_p95_watched_actions | REPEATED | RECORD |
| video_p95_watched_actions.action_type | NULLABLE | STRING |
| video_p95_watched_actions.value | NULLABLE | FLOAT |
| video_p95_watched_actions.click_1d | NULLABLE | FLOAT |
| video_p95_watched_actions.click_7d | NULLABLE | FLOAT |
| video_p95_watched_actions.click_28d | NULLABLE | FLOAT |
| video_p95_watched_actions.view_1d | NULLABLE | FLOAT |
| video_p95_watched_actions.view_7d | NULLABLE | FLOAT |
| video_p95_watched_actions.view_28d | NULLABLE | FLOAT |
| video_play_actions | REPEATED | RECORD |
| video_play_actions.action_type | NULLABLE | STRING |
| video_play_actions.value | NULLABLE | FLOAT |
| video_play_actions.click_1d | NULLABLE | FLOAT |
| video_play_actions.click_7d | NULLABLE | FLOAT |
| video_play_actions.click_28d | NULLABLE | FLOAT |
| video_play_actions.view_1d | NULLABLE | FLOAT |
| video_play_actions.view_7d | NULLABLE | FLOAT |
| video_play_actions.view_28d | NULLABLE | FLOAT |
| video_continuous_2_sec_watched_actions | REPEATED | RECORD |
| video_continuous_2_sec_watched_actions.action_type | NULLABLE | STRING |
| video_continuous_2_sec_watched_actions.value | NULLABLE | FLOAT |
| video_continuous_2_sec_watched_actions.click_1d | NULLABLE | FLOAT |
| video_continuous_2_sec_watched_actions.click_7d | NULLABLE | FLOAT |
| video_continuous_2_sec_watched_actions.click_28d | NULLABLE | FLOAT |
| video_continuous_2_sec_watched_actions.view_1d | NULLABLE | FLOAT |
| video_continuous_2_sec_watched_actions.view_7d | NULLABLE | FLOAT |
| video_continuous_2_sec_watched_actions.view_28d | NULLABLE | FLOAT |
| video_15_sec_watched_actions | REPEATED | RECORD |
| video_15_sec_watched_actions.action_type | NULLABLE | STRING |
| video_15_sec_watched_actions.value | NULLABLE | FLOAT |
| video_15_sec_watched_actions.click_1d | NULLABLE | FLOAT |
| video_15_sec_watched_actions.click_7d | NULLABLE | FLOAT |
| video_15_sec_watched_actions.click_28d | NULLABLE | FLOAT |
| video_15_sec_watched_actions.view_1d | NULLABLE | FLOAT |
| video_15_sec_watched_actions.view_7d | NULLABLE | FLOAT |
| video_15_sec_watched_actions.view_28d | NULLABLE | FLOAT |
| video_thruplay_watched_actions | REPEATED | RECORD |
| video_thruplay_watched_actions.action_type | NULLABLE | STRING |
| video_thruplay_watched_actions.value | NULLABLE | FLOAT |
| video_thruplay_watched_actions.click_1d | NULLABLE | FLOAT |
| video_thruplay_watched_actions.click_7d | NULLABLE | FLOAT |
| video_thruplay_watched_actions.click_28d | NULLABLE | FLOAT |
| video_thruplay_watched_actions.view_1d | NULLABLE | FLOAT |
| video_thruplay_watched_actions.view_7d | NULLABLE | FLOAT |
| video_thruplay_watched_actions.view_28d | NULLABLE | FLOAT |
| date_start | NULLABLE | DATE |
| date_stop | NULLABLE | DATE |
| publisher_platform | NULLABLE | STRING |
| device_platform | NULLABLE | STRING |
| platform_position | NULLABLE | STRING |
Data schema for fb_products
| Field Name | Mode | Type |
|---|---|---|
| account_id | NULLABLE | STRING |
| account_name | NULLABLE | STRING |
| account_currency | NULLABLE | STRING |
| ad_id | NULLABLE | STRING |
| ad_name | NULLABLE | STRING |
| adset_id | NULLABLE | STRING |
| adset_name | NULLABLE | STRING |
| buying_type | NULLABLE | STRING |
| campaign_id | NULLABLE | STRING |
| campaign_name | NULLABLE | STRING |
| attribution_setting | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| clicks | NULLABLE | INTEGER |
| impressions | NULLABLE | INTEGER |
| date_start | NULLABLE | DATE |
| date_stop | NULLABLE | DATE |
| inline_post_engagement | NULLABLE | INTEGER |
| inline_link_clicks | NULLABLE | INTEGER |
| objective | NULLABLE | STRING |
| spend | NULLABLE | FLOAT |
| outbound_clicks | REPEATED | RECORD |
| outbound_clicks.action_type | NULLABLE | STRING |
| outbound_clicks.value | NULLABLE | FLOAT |
| outbound_clicks.inline | NULLABLE | FLOAT |
| actions | REPEATED | RECORD |
| actions.action_type | NULLABLE | STRING |
| actions.value | NULLABLE | FLOAT |
| actions.click_1d | NULLABLE | FLOAT |
| actions.click_7d | NULLABLE | FLOAT |
| actions.click_28d | NULLABLE | FLOAT |
| actions.view_1d | NULLABLE | FLOAT |
| actions.view_7d | NULLABLE | FLOAT |
| actions.view_28d | NULLABLE | FLOAT |
| unique_actions | REPEATED | RECORD |
| unique_actions.action_type | NULLABLE | STRING |
| unique_actions.value | NULLABLE | FLOAT |
| unique_actions.click_1d | NULLABLE | FLOAT |
| unique_actions.click_7d | NULLABLE | FLOAT |
| unique_actions.click_28d | NULLABLE | FLOAT |
| unique_actions.view_1d | NULLABLE | FLOAT |
| unique_actions.view_7d | NULLABLE | FLOAT |
| unique_actions.view_28d | NULLABLE | FLOAT |
| action_values | REPEATED | RECORD |
| action_values.action_type | NULLABLE | STRING |
| action_values.value | NULLABLE | FLOAT |
| action_values.click_1d | NULLABLE | FLOAT |
| action_values.click_7d | NULLABLE | FLOAT |
| action_values.click_28d | NULLABLE | FLOAT |
| action_values.view_1d | NULLABLE | FLOAT |
| action_values.view_7d | NULLABLE | FLOAT |
| action_values.view_28d | NULLABLE | FLOAT |
Data schema for fb_product_actions
| Field Name | Mode | Type |
|---|---|---|
| date_start | NULLABLE | DATE |
| campaign_id | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| actions | REPEATED | RECORD |
| actions.action_type | NULLABLE | STRING |
| actions.value | NULLABLE | FLOAT |
| actions.click_1d | NULLABLE | FLOAT |
| actions.click_7d | NULLABLE | FLOAT |
| actions.click_28d | NULLABLE | FLOAT |
| actions.view_1d | NULLABLE | FLOAT |
| actions.view_7d | NULLABLE | FLOAT |
| actions.view_28d | NULLABLE | FLOAT |
Data schema for fb_product_action_values
| Field Name | Mode | Type |
|---|---|---|
| date_start | NULLABLE | DATE |
| campaign_id | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| action_values | REPEATED | RECORD |
| action_values.action_type | NULLABLE | STRING |
| action_values.value | NULLABLE | FLOAT |
| action_values.click_1d | NULLABLE | FLOAT |
| action_values.click_7d | NULLABLE | FLOAT |
| action_values.click_28d | NULLABLE | FLOAT |
| action_values.view_1d | NULLABLE | FLOAT |
| action_values.view_7d | NULLABLE | FLOAT |
| action_values.view_28d | NULLABLE | FLOAT |
Data schema for fb_reach_account_level
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| account_id | NULLABLE | STRING |
| account_name | NULLABLE | STRING |
| reach | NULLABLE | INTEGER |
| reach_7d | NULLABLE | INTEGER |
| reach_14d | NULLABLE | INTEGER |
| reach_28d | NULLABLE | INTEGER |
| reach_custom | NULLABLE | INTEGER |
| reach_custom_timespan | NULLABLE | INTEGER |
Data schema for fb_reach_campaign_level
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| account_id | NULLABLE | STRING |
| account_name | NULLABLE | STRING |
| campaign_id | NULLABLE | STRING |
| campaign_name | NULLABLE | STRING |
| reach | NULLABLE | INTEGER |
| reach_7d | NULLABLE | INTEGER |
| reach_14d | NULLABLE | INTEGER |
| reach_28d | NULLABLE | INTEGER |
| reach_custom | NULLABLE | INTEGER |
| reach_custom_timespan | NULLABLE | INTEGER |
Data schema for fb_reach_adset_level
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| account_id | NULLABLE | STRING |
| account_name | NULLABLE | STRING |
| adset_id | NULLABLE | STRING |
| adset_name | NULLABLE | STRING |
| campaign_id | NULLABLE | STRING |
| campaign_name | NULLABLE | STRING |
| reach | NULLABLE | INTEGER |
| reach_7d | NULLABLE | INTEGER |
| reach_14d | NULLABLE | INTEGER |
| reach_28d | NULLABLE | INTEGER |
| reach_custom | NULLABLE | INTEGER |
| reach_custom_timespan | NULLABLE | INTEGER |
Data schema for fb_reach_ad_level
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| account_id | NULLABLE | STRING |
| account_name | NULLABLE | STRING |
| ad_id | NULLABLE | STRING |
| ad_name | NULLABLE | STRING |
| adset_id | NULLABLE | STRING |
| adset_name | NULLABLE | STRING |
| campaign_id | NULLABLE | STRING |
| campaign_name | NULLABLE | STRING |
| reach | NULLABLE | INTEGER |
| reach_7d | NULLABLE | INTEGER |
| reach_14d | NULLABLE | INTEGER |
| reach_28d | NULLABLE | INTEGER |
| reach_custom | NULLABLE | INTEGER |
| reach_custom_timespan | NULLABLE | INTEGER |
