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ę.

Lista integracji z przyciskiem Dodaj integrację

Wybierz Facebook Ads z listy dostępnych integracji.

Katalog integracji zawężony do Facebook Ads

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

Pole Nazwa źródła danych wypełnione przykładową nazwą 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.

Przycisk Autoryzuj obok pola Wybierz autoryzację Facebook

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ć.

Otwarta lista Wybierz konta z przykładowymi kontami reklamowymi Facebooka

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>.

Pole Wybierz konta z dwoma wybranymi przykładowymi kontami reklamowymi

Opcjonalnie kliknij Pokaż ustawienia zaawansowane:

  • Okna atrybucji akcji — okna atrybucji, dla których pobierane są konwersje: 1d_click, 1d_view, 7d_click, 7d_view i default (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 do reach_custom_timespan.
  • Tabele do pobrania — wszystkie tabele są wybrane; usuń te, których nie potrzebujesz.

Ustawienia zaawansowane z polami Okna atrybucji akcji, Własny zakres (zasięg), Liczba dni własnego zakresu (zasięg) i Tabele do pobrania

Kliknij Dalej.

Wypełnione ustawienia źródła danych z przyciskiem Dalej

Dane historyczne i harmonogram

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

Pole Dane historyczne wypełnione wartością 365 dni

Harmonogram synchronizacji danych zostanie utworzony automatycznie. Więcej informacji na ten temat znajdziesz tutaj.

Kliknij Utwórz, aby zakończyć konfigurację.

Ustawienia pobierania danych z przyciskiem Utwórz

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 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
Schemat danych tabeli 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
Schemat danych tabeli 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
Schemat danych tabeli 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
Schemat danych tabeli 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
Schemat danych tabeli 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
Schemat danych tabeli 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
Schemat danych tabeli 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
Schemat danych tabeli fb_reach_account_level
Field NameModeType
dateNULLABLEDATE
account_idNULLABLESTRING
account_nameNULLABLESTRING
reachNULLABLEINTEGER
reach_7dNULLABLEINTEGER
reach_14dNULLABLEINTEGER
reach_28dNULLABLEINTEGER
reach_customNULLABLEINTEGER
reach_custom_timespanNULLABLEINTEGER
Schemat danych tabeli 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
Schemat danych tabeli 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
Schemat danych tabeli 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