Integracja Google Analytics 4 z BigQuery

Kopiuje eksport Google Analytics 4 z BigQuery do Twojego datasetu WitCloud i dodaje tabele sesji i atrybucji, dzięki czemu źródła ruchu są przypisane do sesji i konwersji.

Aktualizacja

Wprowadzenie

Integracja Google Analytics 4 BigQuery rozwiązuje najczęstsze problemy z pracą na danych GA4 w BigQuery, takie jak przypisanie źródeł ruchu do sesji i do konwersji.

Odczytuje surowe zdarzenia, które Google Analytics 4 eksportuje do BigQuery, i buduje tabele sesji oraz atrybucji dla trzech modeli: Google Analytics 4, Universal Analytics Cross-Device i Universal Analytics Device. Zapisuje też zdarzenia konwersji zdefiniowane w Twojej usłudze GA4.

WitCloud nie zmienia Twojego eksportu GA4. Dane są kopiowane do Twojego datasetu WitCloud i tam wzbogacane. Nazwa każdej tabeli kończy się identyfikatorem konektora, na przykład ga4_sessions_<collect ID>.

Przewodnik konfiguracji

Integracja czyta eksport GA4 do BigQuery, więc musi być on wcześniej włączony. Robisz to w Google Analytics (w interfejsie Google, nie WitCloud): w GA4 wejdź w Administracja → Połączenia z BigQuery. Obejrzyj poradnik na YouTube Lokalizacja eksportu do BigQuery musi być taka sama jak lokalizacja Twojego projektu WitCloud. Na przykład jeśli Twój projekt WitCloud jest w europe-central2, ustaw eksport GA4 na europe-central2. Przy innej lokalizacji (na przykład EU) integracja nie będzie działać prawidłowo, a krok Podsumowanie pokaże Niezgodna lokalizacja.

Aby połączyć dane kampanii Google Ads z Google Analytics 4, najpierw skonfiguruj integrację Google Ads. WitCloud połączy ją wtedy z Twoimi usługami GA4 automatycznie.

Konfiguracja modułu

Wejdź w Integracje w menu i kliknij Dodaj integrację.

Lista integracji z przyciskiem Dodaj integrację

Z listy integracji wybierz Google Analytics 4 BigQuery.

Katalog integracji zawężony do Google Analytics 4 BigQuery

Wpisz Nazwa źródła danych, na przykład Analytics 4 PL. W jednym przejściu możesz wybrać kilka usług GA4, więc to jest nazwa bazowa: każda usługa staje się osobnym konektorem, nazwanym od nazwy bazowej z dopisaną nazwą usługi (Analytics 4 PL - Demo Store PL).

Pole Nazwa źródła danych wypełnione przykładową nazwą Analytics 4 PL

Następnie na tym samym ekranie ustaw opcje atrybucji:

Ustawienia źródła danych z polami Limit czasu kampanii, Atrybucja – rozkład czasowy (dni), Czy masz wdrożony User ID? i Atrybucja – według pozycji

  • Limit czasu kampanii — przez ile dni kampania lub źródło ruchu pozostaje przypisane do użytkownika przy atrybucji sesji i konwersji. Domyślnie 30, maksymalnie 90. Dłuższy limit oznacza więcej danych przetwarzanych w BigQuery przy każdym uruchomieniu.
  • Atrybucja – rozkład czasowy (dni) — ustawienie modelu rozkładu czasowego, który daje większy udział źródłom ruchu bliższym konwersji. Wartość to okres połowicznego zaniku w dniach: źródło traci połowę swojego udziału za każdą taką liczbę dni przed konwersją. Domyślnie 7, maksymalnie 7. Przy 7 interakcja na 8 dni przed konwersją dostaje połowę udziału interakcji na 1 dzień przed nią.
  • Czy masz wdrożony User ID? — włącz, jeśli wysyłasz User ID do GA4. Integracja wypełnia wtedy także tabelę ga4_users_deduplication. Gdy opcja jest wyłączona, ta tabela jest tworzona pusta.
  • Atrybucja – według pozycji — ustawienie modelu według pozycji. Przeciągnij dwa uchwyty, aby podzielić wartość konwersji między Pierwsza interakcja, Pośrednie interakcje i Ostatnia interakcja. Domyślnie 40% dla pierwszej interakcji, 40% dla ostatniej i 20% dzielone między źródła pośrednie.

Kliknij Dalej.

Autoryzacja

Kliknij Autoryzuj obok pola Wybierz autoryzację Analytics. Jeśli Google Analytics było już autoryzowane w WitCloud, wybierz tę autoryzację z listy. Aby ją później zmienić, kliknij Autoryzuj ponownie.

Krok Ustawienia Analytics z przyciskiem Autoryzuj obok pola Wybierz autoryzację Analytics

Otworzy się okno Google (należy do Google, nie do WitCloud). Zaloguj się i zaakceptuj uprawnienia. WitCloud prosi o dostęp tylko do odczytu do danych Google Analytics (analytics.readonly) oraz o podstawowy profil Google. Użyj konta, które widzi usługi GA4, które chcesz połączyć.

Same dane w BigQuery są odczytywane kontem usługi WitCloud, a nie Twoim kontem Google. Zobacz krok Podsumowanie poniżej.

Wybierz konto w polu Wybierz konto.

Otwarta lista Wybierz konto z przykładowym kontem Demo Company

W polu Wybierz usługi wybierz jedną lub kilka usług GA4.

Otwarta lista Wybierz usługi z trzema przykładowymi usługami GA4

Pole Wybierz usługi z dwiema wybranymi przykładowymi usługami i przyciskiem Dalej

Kliknij Dalej. WitCloud sprawdzi teraz każdą wybraną usługę.

Podsumowanie: eksport do BigQuery i Google Ads

Nie wybierasz projektu, datasetu ani tabeli BigQuery. Dla każdej usługi WitCloud znajduje eksport do BigQuery powiązany z nią w GA4 (dataset analytics_<property ID>) i pokazuje wynik w kroku Podsumowanie:

  • Usługa — zielona kropka, gdy eksport do BigQuery działa, czerwona, gdy nie działa.
  • BigQuery — Połączono z projektem i datasetem albo powód, dla którego to nie działa.
  • Google Ads — Połączono z nazwą Twojego konektora Google Ads, Nieskonfigurowane, gdy usługa jest powiązana z kontem Google Ads, które nie ma jeszcze konektora Google Ads w WitCloud, albo Niepowiązane, gdy w GA4 do usługi nie jest powiązane żadne konto Google Ads.

Krok Podsumowanie z jedną przykładową usługą połączoną z BigQuery i Google Ads oraz jedną z komunikatem Brak dostępu

Przycisk Kontynuuj jest aktywny, gdy każda usługa ma działający eksport do BigQuery i żadne konto Google Ads nie zostało bez konektora. Popraw wiersze z problemem i kliknij ikonę odświeżania w nagłówku kolumny Google Ads (Odśwież status), aby sprawdzić ponownie. Usługę możesz usunąć z listy małym krzyżykiem na końcu jej wiersza, o ile zostaje przynajmniej jedna.

KomunikatCo oznacza i co zrobić
Brak dostępuWitCloud nie może odczytać datasetu analytics_<property ID>. Udostępnij go kontu usługi WitCloud z uprawnieniami BigQuery Admin. Krok pokazuje to konto z przyciskiem Skopiuj konto usługi. Jest to potrzebne, gdy eksport GA4 jest w innym projekcie Google Cloud niż Twój projekt WitCloud.
Eksport wyłączonyEksport jest skonfigurowany, ale wyłączony. Włącz go w GA4 w Administracja → Połączenia z BigQuery (interfejs Google).
Brak skonfigurowanego eksportu do BigQuery w GA4Usługa nie ma połączenia z BigQuery. Skonfiguruj je w GA4 w Administracja → Połączenia z BigQuery (interfejs Google).
Niezgodna lokalizacjaEksport jest w innej lokalizacji niż Twój projekt WitCloud. Obie muszą być w tym samym regionie.
Nie udało się połączyć / Nie udało się sprawdzićSprawdzanie nie zostało zakończone. Kliknij ikonę odświeżania, aby spróbować ponownie.

Gdy usługa pokazuje Nieskonfigurowane, kliknij ten napis, aby otworzyć integrację Google Ads. Po utworzeniu konektora Google Ads wrócisz do tego kreatora z zachowanymi ustawieniami.

Gdy wszystkie wiersze są zielone, kliknij Kontynuuj.

Krok Podsumowanie po odświeżeniu, z obiema przykładowymi usługami połączonymi z BigQuery i aktywnym przyciskiem Kontynuuj

Dane historyczne i harmonogram

W polu Dane historyczne wpisz liczbę dni historii do pobrania, maksymalnie 365. Ta sama liczba obowiązuje dla każdej wybranej usługi. Dni sprzed włączenia eksportu GA4 do BigQuery nie mają danych i są pomijane.

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

Harmonogram synchronizacji danych tworzy się automatycznie. Więcej informacji znajdziesz tutaj.

Kliknij Utwórz.

Ustawienia pobierania danych z przyciskiem Utwórz

Gotowe! Po jednym konektorze na każdą wybraną usługę pobiera teraz historię, a potem codziennie synchronizuje się z BigQuery. Dzień jest przetwarzany, gdy eksport GA4 za ten dzień ma dane.

Zmiana konektora

Otwórz konektor z listy Integracje, aby zmienić jego ustawienia. Widok edycji ma te same kroki Ustawienia konektora i Ustawienia Analytics oraz jeszcze jeden, Ustawienia BigQuery, w którym możesz wskazać inny eksport:

  • Projekt Google Cloud — wybierz projekt połączony z WitCloud albo Własny identyfikator projektu i wpisz identyfikator projektu z eksportem GA4. Kliknij Projekty, aby odświeżyć listę, albo Zbiory, aby wczytać datasety własnego projektu. Dataset z innego projektu musi być udostępniony kontu usługi WitCloud (widok pokazuje je z Skopiuj konto usługi) z uprawnieniami BigQuery Admin.
  • Zbiór danych BigQuery — na liście są tylko datasety z analytics_ w nazwie. Jeśli żaden się nie pojawi, widok pokaże Nie znaleziono zbioru z eksportem GA4: skonfiguruj eksport GA4 do BigQuery i wybierz tę samą lokalizację co w projekcie WitCloud.
  • Tabela BigQuery — tabela zdarzeń GA4 (events_YYYYMMDD).

Jeśli wybrany dataset jest w innej lokalizacji niż Twój projekt WitCloud, widok pokaże Niezgodne lokalizacje: konektor nie będzie działać prawidłowo.

Widok edycji ma też pole Połącz konta Google Ads, w którym wybierasz konektory Google Ads, których kampanie są powiązane z usługą.

Schemat danych

Każdy konektor tworzy poniższe tabele w Twoim datasecie WitCloud (nazwa tabeli kończy się identyfikatorem konektora, na przykład ga4_events_<collect ID>).

Schemat danych tabeli ga4_attribution
Field NameModeType
dateNULLABLEDATE
journey_idNULLABLESTRING
conversion_timeNULLABLETIMESTAMP
session_path_timeNULLABLETIMESTAMP
session_idNULLABLESTRING
event_dateNULLABLESTRING
attribution_timespanNULLABLESTRING
conversion_time_microsNULLABLEINTEGER
session_path_time_microsNULLABLEINTEGER
user_pseudo_idNULLABLESTRING
event_nameNULLABLESTRING
event_valueNULLABLEFLOAT
session_path_traffic_sourceNULLABLERECORD
session_path_traffic_source.sourceNULLABLESTRING
session_path_traffic_source.mediumNULLABLESTRING
session_path_traffic_source.campaignNULLABLESTRING
session_path_traffic_source.campaign_idNULLABLESTRING
session_path_traffic_source.gclidNULLABLESTRING
session_path_days_from_conversionNULLABLEINTEGER
path_lengthNULLABLEINTEGER
path_length_daysNULLABLEINTEGER
path_step_number_reverseNULLABLEINTEGER
path_step_numberNULLABLEINTEGER
attribution_scoreNULLABLERECORD
attribution_score.first_clickNULLABLEINTEGER
attribution_score.last_clickNULLABLEINTEGER
attribution_score.linearNULLABLEFLOAT
attribution_score.position_basedNULLABLEFLOAT
attribution_score.timedecayNULLABLEFLOAT
attribution_directNULLABLESTRING
ecommerceNULLABLERECORD
ecommerce.event_timestamp_utcNULLABLETIMESTAMP
ecommerce.transaction_idNULLABLESTRING
ecommerce.currencyNULLABLESTRING
ecommerce.couponNULLABLESTRING
ecommerce.total_item_quantityNULLABLEINTEGER
ecommerce.purchase_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.purchase_revenue_in_usdNULLABLEFLOAT
ecommerce.purchase_revenueNULLABLEFLOAT
ecommerce.refund_value_in_property_currencyNULLABLEFLOAT
ecommerce.refund_value_in_usdNULLABLEFLOAT
ecommerce.refund_valueNULLABLEFLOAT
ecommerce.shipping_value_in_property_currencyNULLABLEFLOAT
ecommerce.shipping_value_in_usdNULLABLEFLOAT
ecommerce.shipping_valueNULLABLEFLOAT
ecommerce.tax_value_in_property_currencyNULLABLEFLOAT
ecommerce.tax_value_in_usdNULLABLEFLOAT
ecommerce.tax_valueNULLABLEFLOAT
ecommerce.unique_itemsNULLABLEINTEGER
ecommerce.transaction_duplicate_nrNULLABLEINTEGER
ecommerce.itemsREPEATEDRECORD
ecommerce.items.item_idNULLABLESTRING
ecommerce.items.item_nameNULLABLESTRING
ecommerce.items.item_brandNULLABLESTRING
ecommerce.items.item_variantNULLABLESTRING
ecommerce.items.item_categoryNULLABLESTRING
ecommerce.items.item_category2NULLABLESTRING
ecommerce.items.item_category3NULLABLESTRING
ecommerce.items.item_category4NULLABLESTRING
ecommerce.items.item_category5NULLABLESTRING
ecommerce.items.price_in_property_currencyNULLABLEFLOAT
ecommerce.items.price_in_usdNULLABLEFLOAT
ecommerce.items.priceNULLABLEFLOAT
ecommerce.items.quantityNULLABLEINTEGER
ecommerce.items.item_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_revenue_in_usdNULLABLEFLOAT
ecommerce.items.item_revenueNULLABLEFLOAT
ecommerce.items.item_refund_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_refund_in_usdNULLABLEFLOAT
ecommerce.items.item_refundNULLABLEFLOAT
ecommerce.items.couponNULLABLESTRING
ecommerce.items.affiliationNULLABLESTRING
ecommerce.items.item_paramsREPEATEDRECORD
ecommerce.items.item_params.keyNULLABLESTRING
ecommerce.items.item_params.valueNULLABLERECORD
ecommerce.items.item_params.value.string_valueNULLABLESTRING
ecommerce.items.item_params.value.int_valueNULLABLEINTEGER
ecommerce.items.item_params.value.float_valueNULLABLEFLOAT
ecommerce.items.item_params.value.double_valueNULLABLEFLOAT
google_ads_click_infoNULLABLERECORD
google_ads_click_info.external_customer_idNULLABLESTRING
google_ads_click_info.account_descriptive_nameNULLABLESTRING
google_ads_click_info.campaign_idNULLABLESTRING
google_ads_click_info.campaign_nameNULLABLESTRING
google_ads_click_info.ad_group_idNULLABLESTRING
google_ads_click_info.ad_group_nameNULLABLESTRING
google_ads_click_info.creative_idNULLABLESTRING
google_ads_click_info.criteria_idNULLABLESTRING
google_ads_click_info.gclidNULLABLESTRING
google_ads_click_info.user_list_idNULLABLESTRING
google_ads_click_info.ad_network_type1NULLABLESTRING
google_ads_click_info.ad_network_type2NULLABLESTRING
google_ads_click_info.criteria_parametersNULLABLESTRING
google_ads_click_info.keyword_match_typeNULLABLESTRING
google_ads_click_info.pageNULLABLEINTEGER
google_ads_click_info.slotNULLABLESTRING
google_ads_click_info.deviceNULLABLESTRING
google_ads_click_info.currencyNULLABLESTRING
Schemat danych tabeli ga4_attribution_ua_cross_device
Field NameModeType
dateNULLABLEDATE
journey_idNULLABLESTRING
conversion_timeNULLABLETIMESTAMP
session_path_timeNULLABLETIMESTAMP
session_idNULLABLESTRING
event_dateNULLABLESTRING
attribution_timespanNULLABLESTRING
conversion_time_microsNULLABLEINTEGER
session_path_time_microsNULLABLEINTEGER
user_pseudo_idNULLABLESTRING
event_nameNULLABLESTRING
event_valueNULLABLEFLOAT
session_path_traffic_sourceNULLABLERECORD
session_path_traffic_source.sourceNULLABLESTRING
session_path_traffic_source.mediumNULLABLESTRING
session_path_traffic_source.campaignNULLABLESTRING
session_path_traffic_source.campaign_idNULLABLESTRING
session_path_traffic_source.gclidNULLABLESTRING
session_path_days_from_conversionNULLABLEINTEGER
path_lengthNULLABLEINTEGER
path_length_daysNULLABLEINTEGER
path_step_number_reverseNULLABLEINTEGER
path_step_numberNULLABLEINTEGER
attribution_scoreNULLABLERECORD
attribution_score.first_clickNULLABLEINTEGER
attribution_score.last_clickNULLABLEINTEGER
attribution_score.linearNULLABLEFLOAT
attribution_score.position_basedNULLABLEFLOAT
attribution_score.timedecayNULLABLEFLOAT
attribution_directNULLABLESTRING
ecommerceNULLABLERECORD
ecommerce.event_timestamp_utcNULLABLETIMESTAMP
ecommerce.transaction_idNULLABLESTRING
ecommerce.currencyNULLABLESTRING
ecommerce.couponNULLABLESTRING
ecommerce.total_item_quantityNULLABLEINTEGER
ecommerce.purchase_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.purchase_revenue_in_usdNULLABLEFLOAT
ecommerce.purchase_revenueNULLABLEFLOAT
ecommerce.refund_value_in_property_currencyNULLABLEFLOAT
ecommerce.refund_value_in_usdNULLABLEFLOAT
ecommerce.refund_valueNULLABLEFLOAT
ecommerce.shipping_value_in_property_currencyNULLABLEFLOAT
ecommerce.shipping_value_in_usdNULLABLEFLOAT
ecommerce.shipping_valueNULLABLEFLOAT
ecommerce.tax_value_in_property_currencyNULLABLEFLOAT
ecommerce.tax_value_in_usdNULLABLEFLOAT
ecommerce.tax_valueNULLABLEFLOAT
ecommerce.unique_itemsNULLABLEINTEGER
ecommerce.transaction_duplicate_nrNULLABLEINTEGER
ecommerce.itemsREPEATEDRECORD
ecommerce.items.item_idNULLABLESTRING
ecommerce.items.item_nameNULLABLESTRING
ecommerce.items.item_brandNULLABLESTRING
ecommerce.items.item_variantNULLABLESTRING
ecommerce.items.item_categoryNULLABLESTRING
ecommerce.items.item_category2NULLABLESTRING
ecommerce.items.item_category3NULLABLESTRING
ecommerce.items.item_category4NULLABLESTRING
ecommerce.items.item_category5NULLABLESTRING
ecommerce.items.price_in_property_currencyNULLABLEFLOAT
ecommerce.items.price_in_usdNULLABLEFLOAT
ecommerce.items.priceNULLABLEFLOAT
ecommerce.items.quantityNULLABLEINTEGER
ecommerce.items.item_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_revenue_in_usdNULLABLEFLOAT
ecommerce.items.item_revenueNULLABLEFLOAT
ecommerce.items.item_refund_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_refund_in_usdNULLABLEFLOAT
ecommerce.items.item_refundNULLABLEFLOAT
ecommerce.items.couponNULLABLESTRING
ecommerce.items.affiliationNULLABLESTRING
ecommerce.items.item_paramsREPEATEDRECORD
ecommerce.items.item_params.keyNULLABLESTRING
ecommerce.items.item_params.valueNULLABLERECORD
ecommerce.items.item_params.value.string_valueNULLABLESTRING
ecommerce.items.item_params.value.int_valueNULLABLEINTEGER
ecommerce.items.item_params.value.float_valueNULLABLEFLOAT
ecommerce.items.item_params.value.double_valueNULLABLEFLOAT
google_ads_click_infoNULLABLERECORD
google_ads_click_info.external_customer_idNULLABLESTRING
google_ads_click_info.account_descriptive_nameNULLABLESTRING
google_ads_click_info.campaign_idNULLABLESTRING
google_ads_click_info.campaign_nameNULLABLESTRING
google_ads_click_info.ad_group_idNULLABLESTRING
google_ads_click_info.ad_group_nameNULLABLESTRING
google_ads_click_info.creative_idNULLABLESTRING
google_ads_click_info.criteria_idNULLABLESTRING
google_ads_click_info.gclidNULLABLESTRING
google_ads_click_info.user_list_idNULLABLESTRING
google_ads_click_info.ad_network_type1NULLABLESTRING
google_ads_click_info.ad_network_type2NULLABLESTRING
google_ads_click_info.criteria_parametersNULLABLESTRING
google_ads_click_info.keyword_match_typeNULLABLESTRING
google_ads_click_info.pageNULLABLEINTEGER
google_ads_click_info.slotNULLABLESTRING
google_ads_click_info.deviceNULLABLESTRING
google_ads_click_info.currencyNULLABLESTRING
Schemat danych tabeli ga4_attribution_ua_device
Field NameModeType
dateNULLABLEDATE
journey_idNULLABLESTRING
conversion_timeNULLABLETIMESTAMP
session_path_timeNULLABLETIMESTAMP
session_idNULLABLESTRING
event_dateNULLABLESTRING
attribution_timespanNULLABLESTRING
conversion_time_microsNULLABLEINTEGER
session_path_time_microsNULLABLEINTEGER
user_pseudo_idNULLABLESTRING
event_nameNULLABLESTRING
event_valueNULLABLEFLOAT
session_path_traffic_sourceNULLABLERECORD
session_path_traffic_source.sourceNULLABLESTRING
session_path_traffic_source.mediumNULLABLESTRING
session_path_traffic_source.campaignNULLABLESTRING
session_path_traffic_source.campaign_idNULLABLESTRING
session_path_traffic_source.gclidNULLABLESTRING
session_path_days_from_conversionNULLABLEINTEGER
path_lengthNULLABLEINTEGER
path_length_daysNULLABLEINTEGER
path_step_number_reverseNULLABLEINTEGER
path_step_numberNULLABLEINTEGER
attribution_scoreNULLABLERECORD
attribution_score.first_clickNULLABLEINTEGER
attribution_score.last_clickNULLABLEINTEGER
attribution_score.linearNULLABLEFLOAT
attribution_score.position_basedNULLABLEFLOAT
attribution_score.timedecayNULLABLEFLOAT
attribution_directNULLABLESTRING
ecommerceNULLABLERECORD
ecommerce.event_timestamp_utcNULLABLETIMESTAMP
ecommerce.transaction_idNULLABLESTRING
ecommerce.currencyNULLABLESTRING
ecommerce.couponNULLABLESTRING
ecommerce.total_item_quantityNULLABLEINTEGER
ecommerce.purchase_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.purchase_revenue_in_usdNULLABLEFLOAT
ecommerce.purchase_revenueNULLABLEFLOAT
ecommerce.refund_value_in_property_currencyNULLABLEFLOAT
ecommerce.refund_value_in_usdNULLABLEFLOAT
ecommerce.refund_valueNULLABLEFLOAT
ecommerce.shipping_value_in_property_currencyNULLABLEFLOAT
ecommerce.shipping_value_in_usdNULLABLEFLOAT
ecommerce.shipping_valueNULLABLEFLOAT
ecommerce.tax_value_in_property_currencyNULLABLEFLOAT
ecommerce.tax_value_in_usdNULLABLEFLOAT
ecommerce.tax_valueNULLABLEFLOAT
ecommerce.unique_itemsNULLABLEINTEGER
ecommerce.transaction_duplicate_nrNULLABLEINTEGER
ecommerce.itemsREPEATEDRECORD
ecommerce.items.item_idNULLABLESTRING
ecommerce.items.item_nameNULLABLESTRING
ecommerce.items.item_brandNULLABLESTRING
ecommerce.items.item_variantNULLABLESTRING
ecommerce.items.item_categoryNULLABLESTRING
ecommerce.items.item_category2NULLABLESTRING
ecommerce.items.item_category3NULLABLESTRING
ecommerce.items.item_category4NULLABLESTRING
ecommerce.items.item_category5NULLABLESTRING
ecommerce.items.price_in_property_currencyNULLABLEFLOAT
ecommerce.items.price_in_usdNULLABLEFLOAT
ecommerce.items.priceNULLABLEFLOAT
ecommerce.items.quantityNULLABLEINTEGER
ecommerce.items.item_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_revenue_in_usdNULLABLEFLOAT
ecommerce.items.item_revenueNULLABLEFLOAT
ecommerce.items.item_refund_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_refund_in_usdNULLABLEFLOAT
ecommerce.items.item_refundNULLABLEFLOAT
ecommerce.items.couponNULLABLESTRING
ecommerce.items.affiliationNULLABLESTRING
ecommerce.items.item_paramsREPEATEDRECORD
ecommerce.items.item_params.keyNULLABLESTRING
ecommerce.items.item_params.valueNULLABLERECORD
ecommerce.items.item_params.value.string_valueNULLABLESTRING
ecommerce.items.item_params.value.int_valueNULLABLEINTEGER
ecommerce.items.item_params.value.float_valueNULLABLEFLOAT
ecommerce.items.item_params.value.double_valueNULLABLEFLOAT
google_ads_click_infoNULLABLERECORD
google_ads_click_info.external_customer_idNULLABLESTRING
google_ads_click_info.account_descriptive_nameNULLABLESTRING
google_ads_click_info.campaign_idNULLABLESTRING
google_ads_click_info.campaign_nameNULLABLESTRING
google_ads_click_info.ad_group_idNULLABLESTRING
google_ads_click_info.ad_group_nameNULLABLESTRING
google_ads_click_info.creative_idNULLABLESTRING
google_ads_click_info.criteria_idNULLABLESTRING
google_ads_click_info.gclidNULLABLESTRING
google_ads_click_info.user_list_idNULLABLESTRING
google_ads_click_info.ad_network_type1NULLABLESTRING
google_ads_click_info.ad_network_type2NULLABLESTRING
google_ads_click_info.criteria_parametersNULLABLESTRING
google_ads_click_info.keyword_match_typeNULLABLESTRING
google_ads_click_info.pageNULLABLEINTEGER
google_ads_click_info.slotNULLABLESTRING
google_ads_click_info.deviceNULLABLESTRING
google_ads_click_info.currencyNULLABLESTRING
Schemat danych tabeli ga4_conversion_events
Field NameModeType
countingMethodNULLABLESTRING
deletableNULLABLEBOOLEAN
nameNULLABLESTRING
customNULLABLEBOOLEAN
eventNameNULLABLESTRING
streamIdNULLABLEINTEGER
createTimeNULLABLETIMESTAMP
propertyIdNULLABLEINTEGER
Schemat danych tabeli ga4_events
Field NameModeType
event_dateNULLABLESTRING
user_pseudo_idNULLABLESTRING
user_idNULLABLESTRING
group_idNULLABLESTRING
event_nameNULLABLESTRING
event_timestampNULLABLEINTEGER
event_paramsREPEATEDRECORD
event_params.keyNULLABLESTRING
event_params.valueNULLABLERECORD
event_params.value.string_valueNULLABLESTRING
event_params.value.int_valueNULLABLEINTEGER
event_params.value.float_valueNULLABLEFLOAT
event_params.value.double_valueNULLABLEFLOAT
app_infoNULLABLERECORD
app_info.idNULLABLESTRING
app_info.versionNULLABLESTRING
app_info.install_storeNULLABLESTRING
app_info.firebase_app_idNULLABLESTRING
app_info.install_sourceNULLABLESTRING
deviceNULLABLERECORD
device.categoryNULLABLESTRING
device.mobile_brand_nameNULLABLESTRING
device.mobile_model_nameNULLABLESTRING
device.mobile_marketing_nameNULLABLESTRING
device.mobile_os_hardware_modelNULLABLESTRING
device.operating_systemNULLABLESTRING
device.operating_system_versionNULLABLESTRING
device.vendor_idNULLABLESTRING
device.advertising_idNULLABLESTRING
device.languageNULLABLESTRING
device.is_limited_ad_trackingNULLABLESTRING
device.time_zone_offset_secondsNULLABLEINTEGER
device.browserNULLABLESTRING
device.browser_versionNULLABLESTRING
device.web_infoNULLABLERECORD
device.web_info.browserNULLABLESTRING
device.web_info.browser_versionNULLABLESTRING
device.web_info.hostnameNULLABLESTRING
ecommerceNULLABLERECORD
ecommerce.total_item_quantityNULLABLEINTEGER
ecommerce.purchase_revenue_in_usdNULLABLEFLOAT
ecommerce.purchase_revenueNULLABLEFLOAT
ecommerce.refund_value_in_usdNULLABLEFLOAT
ecommerce.refund_valueNULLABLEFLOAT
ecommerce.shipping_value_in_usdNULLABLEFLOAT
ecommerce.shipping_valueNULLABLEFLOAT
ecommerce.tax_value_in_usdNULLABLEFLOAT
ecommerce.tax_valueNULLABLEFLOAT
ecommerce.unique_itemsNULLABLEINTEGER
ecommerce.transaction_idNULLABLESTRING
itemsREPEATEDRECORD
items.item_idNULLABLESTRING
items.item_nameNULLABLESTRING
items.item_brandNULLABLESTRING
items.item_variantNULLABLESTRING
items.item_categoryNULLABLESTRING
items.item_category2NULLABLESTRING
items.item_category3NULLABLESTRING
items.item_category4NULLABLESTRING
items.item_category5NULLABLESTRING
items.price_in_usdNULLABLEFLOAT
items.priceNULLABLEFLOAT
items.quantityNULLABLEINTEGER
items.item_revenue_in_usdNULLABLEFLOAT
items.item_revenueNULLABLEFLOAT
items.item_refund_in_usdNULLABLEFLOAT
items.item_refundNULLABLEFLOAT
items.couponNULLABLESTRING
items.affiliationNULLABLESTRING
items.location_idNULLABLESTRING
items.item_list_idNULLABLESTRING
items.item_list_nameNULLABLESTRING
items.item_list_indexNULLABLESTRING
items.promotion_idNULLABLESTRING
items.promotion_nameNULLABLESTRING
items.creative_nameNULLABLESTRING
items.creative_slotNULLABLESTRING
items.item_paramsREPEATEDRECORD
items.item_params.keyNULLABLESTRING
items.item_params.valueNULLABLERECORD
items.item_params.value.string_valueNULLABLESTRING
items.item_params.value.int_valueNULLABLEINTEGER
items.item_params.value.float_valueNULLABLEFLOAT
items.item_params.value.double_valueNULLABLEFLOAT
event_bundle_sequence_idNULLABLEINTEGER
event_dimensionsNULLABLERECORD
event_dimensions.hostnameNULLABLESTRING
event_previous_timestampNULLABLEINTEGER
event_server_timestamp_offsetNULLABLEINTEGER
event_value_in_usdNULLABLEFLOAT
geoNULLABLERECORD
geo.continentNULLABLESTRING
geo.countryNULLABLESTRING
geo.regionNULLABLESTRING
geo.cityNULLABLESTRING
geo.sub_continentNULLABLESTRING
geo.metroNULLABLESTRING
platformNULLABLESTRING
privacy_infoNULLABLERECORD
privacy_info.analytics_storageNULLABLESTRING
privacy_info.ads_storageNULLABLESTRING
privacy_info.uses_transient_tokenNULLABLESTRING
stream_idNULLABLESTRING
traffic_sourceNULLABLERECORD
traffic_source.nameNULLABLESTRING
traffic_source.mediumNULLABLESTRING
traffic_source.sourceNULLABLESTRING
user_first_touch_timestampNULLABLEINTEGER
user_ltvNULLABLERECORD
user_ltv.revenueNULLABLEFLOAT
user_ltv.currencyNULLABLESTRING
user_propertiesREPEATEDRECORD
user_properties.keyNULLABLESTRING
user_properties.valueNULLABLERECORD
user_properties.value.string_valueNULLABLESTRING
user_properties.value.int_valueNULLABLEINTEGER
user_properties.value.float_valueNULLABLEFLOAT
user_properties.value.double_valueNULLABLEFLOAT
user_properties.value.set_timestamp_microsNULLABLEINTEGER
wit_session_ga4NULLABLERECORD
wit_session_ga4.session_idNULLABLESTRING
wit_session_ga4.session_id_groupNULLABLESTRING
wit_session_ga4.traffic_sourceNULLABLERECORD
wit_session_ga4.traffic_source.sourceNULLABLESTRING
wit_session_ga4.traffic_source.mediumNULLABLESTRING
wit_session_ga4.traffic_source.campaignNULLABLESTRING
wit_session_ga4.traffic_source.termNULLABLESTRING
wit_session_ga4.traffic_source.contentNULLABLESTRING
wit_session_ga4.traffic_source.campaign_idNULLABLESTRING
wit_session_ga4.traffic_source.gclidNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_infoNULLABLERECORD
wit_session_ga4.traffic_source.google_ads_click_info.external_customer_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.account_descriptive_nameNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.campaign_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.campaign_nameNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_group_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_group_nameNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.creative_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.criteria_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.gclidNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.user_list_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type1NULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type2NULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.criteria_parametersNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.keyword_match_typeNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.pageNULLABLEINTEGER
wit_session_ga4.traffic_source.google_ads_click_info.slotNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.deviceNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.currencyNULLABLESTRING
wit_session_ga4.attribution_detailsNULLABLESTRING
wit_session_ua_cross_deviceNULLABLERECORD
wit_session_ua_cross_device.session_idNULLABLESTRING
wit_session_ua_cross_device.session_id_groupNULLABLESTRING
wit_session_ua_cross_device.traffic_sourceNULLABLERECORD
wit_session_ua_cross_device.traffic_source.sourceNULLABLESTRING
wit_session_ua_cross_device.traffic_source.mediumNULLABLESTRING
wit_session_ua_cross_device.traffic_source.campaignNULLABLESTRING
wit_session_ua_cross_device.traffic_source.termNULLABLESTRING
wit_session_ua_cross_device.traffic_source.contentNULLABLESTRING
wit_session_ua_cross_device.traffic_source.campaign_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.gclidNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_infoNULLABLERECORD
wit_session_ua_cross_device.traffic_source.google_ads_click_info.external_customer_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.account_descriptive_nameNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_nameNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_nameNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.creative_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.gclidNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.user_list_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type1NULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type2NULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_parametersNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.keyword_match_typeNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.pageNULLABLEINTEGER
wit_session_ua_cross_device.traffic_source.google_ads_click_info.slotNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.deviceNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.currencyNULLABLESTRING
wit_session_ua_cross_device.attribution_detailsNULLABLESTRING
wit_session_ua_deviceNULLABLERECORD
wit_session_ua_device.session_idNULLABLESTRING
wit_session_ua_device.session_id_groupNULLABLESTRING
wit_session_ua_device.traffic_sourceNULLABLERECORD
wit_session_ua_device.traffic_source.sourceNULLABLESTRING
wit_session_ua_device.traffic_source.mediumNULLABLESTRING
wit_session_ua_device.traffic_source.campaignNULLABLESTRING
wit_session_ua_device.traffic_source.termNULLABLESTRING
wit_session_ua_device.traffic_source.contentNULLABLESTRING
wit_session_ua_device.traffic_source.campaign_idNULLABLESTRING
wit_session_ua_device.traffic_source.gclidNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_infoNULLABLERECORD
wit_session_ua_device.traffic_source.google_ads_click_info.external_customer_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.account_descriptive_nameNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.campaign_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.campaign_nameNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_nameNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.creative_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.criteria_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.gclidNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.user_list_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type1NULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type2NULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.criteria_parametersNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.keyword_match_typeNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.pageNULLABLEINTEGER
wit_session_ua_device.traffic_source.google_ads_click_info.slotNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.deviceNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.currencyNULLABLESTRING
wit_session_ua_device.attribution_detailsNULLABLESTRING
attribution_timespanNULLABLESTRING
is_active_userNULLABLEBOOLEAN
Schemat danych tabeli ga4_sessions
Field NameModeType
dateNULLABLEDATE
session_idNULLABLESTRING
user_pseudo_idNULLABLESTRING
session_start_timeNULLABLEINTEGER
landing_pageNULLABLESTRING
totalsNULLABLERECORD
totals.eventNULLABLEINTEGER
totals.page_viewNULLABLEINTEGER
totals.unique_page_viewNULLABLEINTEGER
totals.screen_viewNULLABLEINTEGER
totals.unique_screen_viewNULLABLEINTEGER
totals.engagementNULLABLEINTEGER
totals.engagement_time_secondsNULLABLEFLOAT
totals.visit_durationNULLABLEINTEGER
totals.first_visitNULLABLEINTEGER
totals.view_itemNULLABLEINTEGER
totals.add_to_cartNULLABLEINTEGER
totals.begin_checkoutNULLABLEINTEGER
totals.add_shipping_infoNULLABLEINTEGER
totals.add_payment_infoNULLABLEINTEGER
totals.purchaseNULLABLEINTEGER
totals.purchase_revenue_in_property_currencyNULLABLEFLOAT
totals.shipping_value_in_property_currencyNULLABLEFLOAT
totals.tax_value_in_property_currencyNULLABLEFLOAT
totals.refund_value_in_property_currencyNULLABLEFLOAT
totals.event_countNULLABLESTRING
totals.event_valueNULLABLESTRING
stream_idNULLABLESTRING
platformNULLABLESTRING
acq_traffic_sourceNULLABLERECORD
acq_traffic_source.nameNULLABLESTRING
acq_traffic_source.mediumNULLABLESTRING
acq_traffic_source.sourceNULLABLESTRING
wit_session_ga4NULLABLERECORD
wit_session_ga4.session_idNULLABLESTRING
wit_session_ga4.session_id_groupNULLABLESTRING
wit_session_ga4.traffic_sourceNULLABLERECORD
wit_session_ga4.traffic_source.sourceNULLABLESTRING
wit_session_ga4.traffic_source.mediumNULLABLESTRING
wit_session_ga4.traffic_source.campaignNULLABLESTRING
wit_session_ga4.traffic_source.termNULLABLESTRING
wit_session_ga4.traffic_source.contentNULLABLESTRING
wit_session_ga4.traffic_source.campaign_idNULLABLESTRING
wit_session_ga4.traffic_source.gclidNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_infoNULLABLERECORD
wit_session_ga4.traffic_source.google_ads_click_info.external_customer_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.account_descriptive_nameNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.campaign_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.campaign_nameNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_group_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_group_nameNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.creative_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.criteria_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.gclidNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.user_list_idNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type1NULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type2NULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.criteria_parametersNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.keyword_match_typeNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.pageNULLABLEINTEGER
wit_session_ga4.traffic_source.google_ads_click_info.slotNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.deviceNULLABLESTRING
wit_session_ga4.traffic_source.google_ads_click_info.currencyNULLABLESTRING
wit_session_ga4.attribution_detailsNULLABLESTRING
deviceNULLABLERECORD
device.categoryNULLABLESTRING
device.mobile_brand_nameNULLABLESTRING
device.mobile_model_nameNULLABLESTRING
device.mobile_marketing_nameNULLABLESTRING
device.mobile_os_hardware_modelNULLABLESTRING
device.operating_systemNULLABLESTRING
device.operating_system_versionNULLABLESTRING
device.vendor_idNULLABLESTRING
device.advertising_idNULLABLESTRING
device.languageNULLABLESTRING
device.is_limited_ad_trackingNULLABLESTRING
device.time_zone_offset_secondsNULLABLEINTEGER
device.browserNULLABLESTRING
device.browser_versionNULLABLESTRING
device.web_infoNULLABLERECORD
device.web_info.browserNULLABLESTRING
device.web_info.browser_versionNULLABLESTRING
device.web_info.hostnameNULLABLESTRING
geoNULLABLERECORD
geo.continentNULLABLESTRING
geo.countryNULLABLESTRING
geo.regionNULLABLESTRING
geo.cityNULLABLESTRING
geo.sub_continentNULLABLESTRING
geo.metroNULLABLESTRING
app_infoNULLABLERECORD
app_info.idNULLABLESTRING
app_info.versionNULLABLESTRING
app_info.install_storeNULLABLESTRING
app_info.firebase_app_idNULLABLESTRING
app_info.install_sourceNULLABLESTRING
ecommerceREPEATEDRECORD
ecommerce.event_timestamp_utcNULLABLETIMESTAMP
ecommerce.transaction_idNULLABLESTRING
ecommerce.currencyNULLABLESTRING
ecommerce.couponNULLABLESTRING
ecommerce.total_item_quantityNULLABLEINTEGER
ecommerce.purchase_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.purchase_revenue_in_usdNULLABLEFLOAT
ecommerce.purchase_revenueNULLABLEFLOAT
ecommerce.refund_value_in_property_currencyNULLABLEFLOAT
ecommerce.refund_value_in_usdNULLABLEFLOAT
ecommerce.refund_valueNULLABLEFLOAT
ecommerce.shipping_value_in_property_currencyNULLABLEFLOAT
ecommerce.shipping_value_in_usdNULLABLEFLOAT
ecommerce.shipping_valueNULLABLEFLOAT
ecommerce.tax_value_in_property_currencyNULLABLEFLOAT
ecommerce.tax_value_in_usdNULLABLEFLOAT
ecommerce.tax_valueNULLABLEFLOAT
ecommerce.unique_itemsNULLABLEINTEGER
ecommerce.transaction_duplicate_nrNULLABLEINTEGER
ecommerce.itemsREPEATEDRECORD
ecommerce.items.item_idNULLABLESTRING
ecommerce.items.item_nameNULLABLESTRING
ecommerce.items.item_brandNULLABLESTRING
ecommerce.items.item_variantNULLABLESTRING
ecommerce.items.item_categoryNULLABLESTRING
ecommerce.items.item_category2NULLABLESTRING
ecommerce.items.item_category3NULLABLESTRING
ecommerce.items.item_category4NULLABLESTRING
ecommerce.items.item_category5NULLABLESTRING
ecommerce.items.price_in_property_currencyNULLABLEFLOAT
ecommerce.items.price_in_usdNULLABLEFLOAT
ecommerce.items.priceNULLABLEFLOAT
ecommerce.items.quantityNULLABLEINTEGER
ecommerce.items.item_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_revenue_in_usdNULLABLEFLOAT
ecommerce.items.item_revenueNULLABLEFLOAT
ecommerce.items.item_refund_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_refund_in_usdNULLABLEFLOAT
ecommerce.items.item_refundNULLABLEFLOAT
ecommerce.items.couponNULLABLESTRING
ecommerce.items.affiliationNULLABLESTRING
ecommerce.items.item_paramsREPEATEDRECORD
ecommerce.items.item_params.keyNULLABLESTRING
ecommerce.items.item_params.valueNULLABLERECORD
ecommerce.items.item_params.value.string_valueNULLABLESTRING
ecommerce.items.item_params.value.int_valueNULLABLEINTEGER
ecommerce.items.item_params.value.float_valueNULLABLEFLOAT
ecommerce.items.item_params.value.double_valueNULLABLEFLOAT
is_true_directNULLABLEBOOLEAN
Schemat danych tabeli ga4_sessions_ua_cross_device
Field NameModeType
dateNULLABLEDATE
session_idNULLABLESTRING
user_pseudo_idNULLABLESTRING
session_start_timeNULLABLEINTEGER
landing_pageNULLABLESTRING
totalsNULLABLERECORD
totals.eventNULLABLEINTEGER
totals.page_viewNULLABLEINTEGER
totals.unique_page_viewNULLABLEINTEGER
totals.screen_viewNULLABLEINTEGER
totals.unique_screen_viewNULLABLEINTEGER
totals.engagementNULLABLEINTEGER
totals.engagement_time_secondsNULLABLEFLOAT
totals.visit_durationNULLABLEINTEGER
totals.first_visitNULLABLEINTEGER
totals.view_itemNULLABLEINTEGER
totals.add_to_cartNULLABLEINTEGER
totals.begin_checkoutNULLABLEINTEGER
totals.add_shipping_infoNULLABLEINTEGER
totals.add_payment_infoNULLABLEINTEGER
totals.purchaseNULLABLEINTEGER
totals.purchase_revenue_in_property_currencyNULLABLEFLOAT
totals.shipping_value_in_property_currencyNULLABLEFLOAT
totals.tax_value_in_property_currencyNULLABLEFLOAT
totals.refund_value_in_property_currencyNULLABLEFLOAT
totals.event_countNULLABLESTRING
totals.event_valueNULLABLESTRING
stream_idNULLABLESTRING
platformNULLABLESTRING
acq_traffic_sourceNULLABLERECORD
acq_traffic_source.nameNULLABLESTRING
acq_traffic_source.mediumNULLABLESTRING
acq_traffic_source.sourceNULLABLESTRING
wit_session_ua_cross_deviceNULLABLERECORD
wit_session_ua_cross_device.session_idNULLABLESTRING
wit_session_ua_cross_device.session_id_groupNULLABLESTRING
wit_session_ua_cross_device.traffic_sourceNULLABLERECORD
wit_session_ua_cross_device.traffic_source.sourceNULLABLESTRING
wit_session_ua_cross_device.traffic_source.mediumNULLABLESTRING
wit_session_ua_cross_device.traffic_source.campaignNULLABLESTRING
wit_session_ua_cross_device.traffic_source.termNULLABLESTRING
wit_session_ua_cross_device.traffic_source.contentNULLABLESTRING
wit_session_ua_cross_device.traffic_source.campaign_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.gclidNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_infoNULLABLERECORD
wit_session_ua_cross_device.traffic_source.google_ads_click_info.external_customer_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.account_descriptive_nameNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_nameNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_nameNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.creative_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.gclidNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.user_list_idNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type1NULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type2NULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_parametersNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.keyword_match_typeNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.pageNULLABLEINTEGER
wit_session_ua_cross_device.traffic_source.google_ads_click_info.slotNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.deviceNULLABLESTRING
wit_session_ua_cross_device.traffic_source.google_ads_click_info.currencyNULLABLESTRING
wit_session_ua_cross_device.attribution_detailsNULLABLESTRING
deviceNULLABLERECORD
device.categoryNULLABLESTRING
device.mobile_brand_nameNULLABLESTRING
device.mobile_model_nameNULLABLESTRING
device.mobile_marketing_nameNULLABLESTRING
device.mobile_os_hardware_modelNULLABLESTRING
device.operating_systemNULLABLESTRING
device.operating_system_versionNULLABLESTRING
device.vendor_idNULLABLESTRING
device.advertising_idNULLABLESTRING
device.languageNULLABLESTRING
device.is_limited_ad_trackingNULLABLESTRING
device.time_zone_offset_secondsNULLABLEINTEGER
device.browserNULLABLESTRING
device.browser_versionNULLABLESTRING
device.web_infoNULLABLERECORD
device.web_info.browserNULLABLESTRING
device.web_info.browser_versionNULLABLESTRING
device.web_info.hostnameNULLABLESTRING
geoNULLABLERECORD
geo.continentNULLABLESTRING
geo.countryNULLABLESTRING
geo.regionNULLABLESTRING
geo.cityNULLABLESTRING
geo.sub_continentNULLABLESTRING
geo.metroNULLABLESTRING
app_infoNULLABLERECORD
app_info.idNULLABLESTRING
app_info.versionNULLABLESTRING
app_info.install_storeNULLABLESTRING
app_info.firebase_app_idNULLABLESTRING
app_info.install_sourceNULLABLESTRING
ecommerceREPEATEDRECORD
ecommerce.event_timestamp_utcNULLABLETIMESTAMP
ecommerce.transaction_idNULLABLESTRING
ecommerce.currencyNULLABLESTRING
ecommerce.couponNULLABLESTRING
ecommerce.total_item_quantityNULLABLEINTEGER
ecommerce.purchase_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.purchase_revenue_in_usdNULLABLEFLOAT
ecommerce.purchase_revenueNULLABLEFLOAT
ecommerce.refund_value_in_property_currencyNULLABLEFLOAT
ecommerce.refund_value_in_usdNULLABLEFLOAT
ecommerce.refund_valueNULLABLEFLOAT
ecommerce.shipping_value_in_property_currencyNULLABLEFLOAT
ecommerce.shipping_value_in_usdNULLABLEFLOAT
ecommerce.shipping_valueNULLABLEFLOAT
ecommerce.tax_value_in_property_currencyNULLABLEFLOAT
ecommerce.tax_value_in_usdNULLABLEFLOAT
ecommerce.tax_valueNULLABLEFLOAT
ecommerce.unique_itemsNULLABLEINTEGER
ecommerce.transaction_duplicate_nrNULLABLEINTEGER
ecommerce.itemsREPEATEDRECORD
ecommerce.items.item_idNULLABLESTRING
ecommerce.items.item_nameNULLABLESTRING
ecommerce.items.item_brandNULLABLESTRING
ecommerce.items.item_variantNULLABLESTRING
ecommerce.items.item_categoryNULLABLESTRING
ecommerce.items.item_category2NULLABLESTRING
ecommerce.items.item_category3NULLABLESTRING
ecommerce.items.item_category4NULLABLESTRING
ecommerce.items.item_category5NULLABLESTRING
ecommerce.items.price_in_property_currencyNULLABLEFLOAT
ecommerce.items.price_in_usdNULLABLEFLOAT
ecommerce.items.priceNULLABLEFLOAT
ecommerce.items.quantityNULLABLEINTEGER
ecommerce.items.item_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_revenue_in_usdNULLABLEFLOAT
ecommerce.items.item_revenueNULLABLEFLOAT
ecommerce.items.item_refund_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_refund_in_usdNULLABLEFLOAT
ecommerce.items.item_refundNULLABLEFLOAT
ecommerce.items.couponNULLABLESTRING
ecommerce.items.affiliationNULLABLESTRING
ecommerce.items.item_paramsREPEATEDRECORD
ecommerce.items.item_params.keyNULLABLESTRING
ecommerce.items.item_params.valueNULLABLERECORD
ecommerce.items.item_params.value.string_valueNULLABLESTRING
ecommerce.items.item_params.value.int_valueNULLABLEINTEGER
ecommerce.items.item_params.value.float_valueNULLABLEFLOAT
ecommerce.items.item_params.value.double_valueNULLABLEFLOAT
is_true_directNULLABLEBOOLEAN
Schemat danych tabeli ga4_sessions_ua_device
Field NameModeType
dateNULLABLEDATE
session_idNULLABLESTRING
user_pseudo_idNULLABLESTRING
session_start_timeNULLABLEINTEGER
landing_pageNULLABLESTRING
totalsNULLABLERECORD
totals.eventNULLABLEINTEGER
totals.page_viewNULLABLEINTEGER
totals.unique_page_viewNULLABLEINTEGER
totals.screen_viewNULLABLEINTEGER
totals.unique_screen_viewNULLABLEINTEGER
totals.engagementNULLABLEINTEGER
totals.engagement_time_secondsNULLABLEFLOAT
totals.visit_durationNULLABLEINTEGER
totals.first_visitNULLABLEINTEGER
totals.view_itemNULLABLEINTEGER
totals.add_to_cartNULLABLEINTEGER
totals.begin_checkoutNULLABLEINTEGER
totals.add_shipping_infoNULLABLEINTEGER
totals.add_payment_infoNULLABLEINTEGER
totals.purchaseNULLABLEINTEGER
totals.purchase_revenue_in_property_currencyNULLABLEFLOAT
totals.shipping_value_in_property_currencyNULLABLEFLOAT
totals.tax_value_in_property_currencyNULLABLEFLOAT
totals.refund_value_in_property_currencyNULLABLEFLOAT
totals.event_countNULLABLESTRING
totals.event_valueNULLABLESTRING
stream_idNULLABLESTRING
platformNULLABLESTRING
acq_traffic_sourceNULLABLERECORD
acq_traffic_source.nameNULLABLESTRING
acq_traffic_source.mediumNULLABLESTRING
acq_traffic_source.sourceNULLABLESTRING
wit_session_ua_deviceNULLABLERECORD
wit_session_ua_device.session_idNULLABLESTRING
wit_session_ua_device.session_id_groupNULLABLESTRING
wit_session_ua_device.traffic_sourceNULLABLERECORD
wit_session_ua_device.traffic_source.sourceNULLABLESTRING
wit_session_ua_device.traffic_source.mediumNULLABLESTRING
wit_session_ua_device.traffic_source.campaignNULLABLESTRING
wit_session_ua_device.traffic_source.termNULLABLESTRING
wit_session_ua_device.traffic_source.contentNULLABLESTRING
wit_session_ua_device.traffic_source.campaign_idNULLABLESTRING
wit_session_ua_device.traffic_source.gclidNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_infoNULLABLERECORD
wit_session_ua_device.traffic_source.google_ads_click_info.external_customer_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.account_descriptive_nameNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.campaign_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.campaign_nameNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_nameNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.creative_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.criteria_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.gclidNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.user_list_idNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type1NULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type2NULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.criteria_parametersNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.keyword_match_typeNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.pageNULLABLEINTEGER
wit_session_ua_device.traffic_source.google_ads_click_info.slotNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.deviceNULLABLESTRING
wit_session_ua_device.traffic_source.google_ads_click_info.currencyNULLABLESTRING
wit_session_ua_device.attribution_detailsNULLABLESTRING
deviceNULLABLERECORD
device.categoryNULLABLESTRING
device.mobile_brand_nameNULLABLESTRING
device.mobile_model_nameNULLABLESTRING
device.mobile_marketing_nameNULLABLESTRING
device.mobile_os_hardware_modelNULLABLESTRING
device.operating_systemNULLABLESTRING
device.operating_system_versionNULLABLESTRING
device.vendor_idNULLABLESTRING
device.advertising_idNULLABLESTRING
device.languageNULLABLESTRING
device.is_limited_ad_trackingNULLABLESTRING
device.time_zone_offset_secondsNULLABLEINTEGER
device.browserNULLABLESTRING
device.browser_versionNULLABLESTRING
device.web_infoNULLABLERECORD
device.web_info.browserNULLABLESTRING
device.web_info.browser_versionNULLABLESTRING
device.web_info.hostnameNULLABLESTRING
geoNULLABLERECORD
geo.continentNULLABLESTRING
geo.countryNULLABLESTRING
geo.regionNULLABLESTRING
geo.cityNULLABLESTRING
geo.sub_continentNULLABLESTRING
geo.metroNULLABLESTRING
app_infoNULLABLERECORD
app_info.idNULLABLESTRING
app_info.versionNULLABLESTRING
app_info.install_storeNULLABLESTRING
app_info.firebase_app_idNULLABLESTRING
app_info.install_sourceNULLABLESTRING
ecommerceREPEATEDRECORD
ecommerce.event_timestamp_utcNULLABLETIMESTAMP
ecommerce.transaction_idNULLABLESTRING
ecommerce.currencyNULLABLESTRING
ecommerce.couponNULLABLESTRING
ecommerce.total_item_quantityNULLABLEINTEGER
ecommerce.purchase_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.purchase_revenue_in_usdNULLABLEFLOAT
ecommerce.purchase_revenueNULLABLEFLOAT
ecommerce.refund_value_in_property_currencyNULLABLEFLOAT
ecommerce.refund_value_in_usdNULLABLEFLOAT
ecommerce.refund_valueNULLABLEFLOAT
ecommerce.shipping_value_in_property_currencyNULLABLEFLOAT
ecommerce.shipping_value_in_usdNULLABLEFLOAT
ecommerce.shipping_valueNULLABLEFLOAT
ecommerce.tax_value_in_property_currencyNULLABLEFLOAT
ecommerce.tax_value_in_usdNULLABLEFLOAT
ecommerce.tax_valueNULLABLEFLOAT
ecommerce.unique_itemsNULLABLEINTEGER
ecommerce.transaction_duplicate_nrNULLABLEINTEGER
ecommerce.itemsREPEATEDRECORD
ecommerce.items.item_idNULLABLESTRING
ecommerce.items.item_nameNULLABLESTRING
ecommerce.items.item_brandNULLABLESTRING
ecommerce.items.item_variantNULLABLESTRING
ecommerce.items.item_categoryNULLABLESTRING
ecommerce.items.item_category2NULLABLESTRING
ecommerce.items.item_category3NULLABLESTRING
ecommerce.items.item_category4NULLABLESTRING
ecommerce.items.item_category5NULLABLESTRING
ecommerce.items.price_in_property_currencyNULLABLEFLOAT
ecommerce.items.price_in_usdNULLABLEFLOAT
ecommerce.items.priceNULLABLEFLOAT
ecommerce.items.quantityNULLABLEINTEGER
ecommerce.items.item_revenue_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_revenue_in_usdNULLABLEFLOAT
ecommerce.items.item_revenueNULLABLEFLOAT
ecommerce.items.item_refund_in_property_currencyNULLABLEFLOAT
ecommerce.items.item_refund_in_usdNULLABLEFLOAT
ecommerce.items.item_refundNULLABLEFLOAT
ecommerce.items.couponNULLABLESTRING
ecommerce.items.affiliationNULLABLESTRING
ecommerce.items.item_paramsREPEATEDRECORD
ecommerce.items.item_params.keyNULLABLESTRING
ecommerce.items.item_params.valueNULLABLERECORD
ecommerce.items.item_params.value.string_valueNULLABLESTRING
ecommerce.items.item_params.value.int_valueNULLABLEINTEGER
ecommerce.items.item_params.value.float_valueNULLABLEFLOAT
ecommerce.items.item_params.value.double_valueNULLABLEFLOAT
is_true_directNULLABLEBOOLEAN
Schemat danych tabeli ga4_users_deduplication
Field NameModeType
nodeNULLABLESTRING
group_idNULLABLEINTEGER