Integracja Facebook Ads z BigQuery
Dowiedz się, jak połączyć Facebook Ads z Google BigQuery w WitCloud i automatycznie pobierać dane o kampaniach, kliknięciach, kosztach, konwersjach i zasięgu.
Aktualizacja
Wprowadzenie
Ten moduł korzysta z Facebook Marketing API (Meta) i pozwala pobierać dzienne dane o skuteczności Twoich kont reklamowych — kampanie, zestawy reklam, reklamy, kreacje, wideo, reklamy produktowe (z katalogu) i zasięg — oraz zapisywać je w Google Cloud BigQuery. Dzięki temu lepiej zrozumiesz swoje dane i zoptymalizujesz skuteczność działań marketingowych.
Konfiguracja
Wykonaj poniższe kroki, aby połączyć Facebook Ads z BigQuery. Po zakończeniu konfiguracji dane reklamowe będą automatycznie przesyłane do Twojego projektu BigQuery.
Autoryzuj się jako użytkownik Facebooka, który ma dostęp do kont reklamowych, które chcesz pobierać — WitCloud pokazuje konta reklamowe dostępne dla tego użytkownika.
Dodanie integracji
Przejdź do Integracje w menu i kliknij Dodaj integrację.

Wybierz Facebook Ads z listy dostępnych integracji.

Wpisz Nazwa źródła danych, np. Facebook Ads PL.

Autoryzacja
Jeśli Facebook jest już autoryzowany w tym projekcie, wybierz istniejącą autoryzację z listy Wybierz autoryzację Facebook i pomiń ten krok.
Kliknij Autoryzuj.

Otworzy się okno Facebooka. Zaloguj się i potwierdź dostęp, o który prosi WitCloud: zarządzanie reklamami na kontach reklamowych, do których masz dostęp, oraz Twój profil publiczny. Po potwierdzeniu nowa autoryzacja zostanie wybrana w polu Wybierz autoryzację Facebook.
Konta reklamowe i ustawienia zaawansowane
Otwórz listę Wybierz konta i wybierz konta reklamowe, które chcesz pobierać.

Możesz wybrać kilka kont reklamowych naraz — WitCloud tworzy osobny konektor dla każdego z nich, o nazwie <Nazwa źródła danych> - <nazwa konta>.

Opcjonalnie kliknij Pokaż ustawienia zaawansowane:
- Okna atrybucji akcji — okna atrybucji, dla których pobierane są konwersje:
1d_click,1d_view,7d_click,7d_viewidefault(wybrane domyślnie). Wartości dla każdego okna trafiają do odpowiednich pól rekordów akcji, np.actions.click_7d. - Własny zakres (zasięg) — domyślnie zasięg jest pobierany dla 1, 7, 14 i 28 dni; włącz tę opcję, aby dodać jeden własny zakres.
- Liczba dni własnego zakresu (zasięg) — długość tego zakresu w dniach, maksymalnie 90. Wynik trafia do kolumny
reach_custom, a liczba dni doreach_custom_timespan. - Tabele do pobrania — wszystkie tabele są wybrane; usuń te, których nie potrzebujesz.

Kliknij Dalej.

Dane historyczne i harmonogram
W polu Dane historyczne wpisz, z ilu dni wstecz pobrać dane — maksymalnie 365.

Harmonogram synchronizacji danych zostanie utworzony automatycznie. Więcej informacji na ten temat znajdziesz tutaj.
Kliknij Utwórz, aby zakończyć konfigurację.

Gotowe! Dane z Facebook Ads będą teraz synchronizowane z BigQuery, a Ty zyskasz szczegółowy wgląd w skuteczność swoich kampanii reklamowych.
Schemat danych
Każde konto reklamowe ma własny zestaw tabel: nazwa tabeli kończy się identyfikatorem konta reklamowego, np. fb_ads_act_123456789. Każde uruchomienie pobiera jeden dzień; tabele reklam, zestawów reklam, kampanii, wideo i produktów są partycjonowane według date_start, a tabele kreacji i zasięgu według dnia uruchomienia. Dane o konwersjach i zdarzeniach są zapisywane w polu actions.
Rozwiń poniższe tabele, aby zobaczyć pełny schemat danych pobieranych z Facebook Ads.
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
