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

Z listy integracji wybierz 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).

Następnie na tym samym ekranie ustaw opcje atrybucji:

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

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.

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


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.

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.
| Komunikat | Co oznacza i co zrobić |
|---|---|
| Brak dostępu | WitCloud 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łączony | Eksport jest skonfigurowany, ale wyłączony. Włącz go w GA4 w Administracja → Połączenia z BigQuery (interfejs Google). |
| Brak skonfigurowanego eksportu do BigQuery w GA4 | Usługa nie ma połączenia z BigQuery. Skonfiguruj je w GA4 w Administracja → Połączenia z BigQuery (interfejs Google). |
| Niezgodna lokalizacja | Eksport 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.

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.

Harmonogram synchronizacji danych tworzy się automatycznie. Więcej informacji znajdziesz tutaj.
Kliknij 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 Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| journey_id | NULLABLE | STRING |
| conversion_time | NULLABLE | TIMESTAMP |
| session_path_time | NULLABLE | TIMESTAMP |
| session_id | NULLABLE | STRING |
| event_date | NULLABLE | STRING |
| attribution_timespan | NULLABLE | STRING |
| conversion_time_micros | NULLABLE | INTEGER |
| session_path_time_micros | NULLABLE | INTEGER |
| user_pseudo_id | NULLABLE | STRING |
| event_name | NULLABLE | STRING |
| event_value | NULLABLE | FLOAT |
| session_path_traffic_source | NULLABLE | RECORD |
| session_path_traffic_source.source | NULLABLE | STRING |
| session_path_traffic_source.medium | NULLABLE | STRING |
| session_path_traffic_source.campaign | NULLABLE | STRING |
| session_path_traffic_source.campaign_id | NULLABLE | STRING |
| session_path_traffic_source.gclid | NULLABLE | STRING |
| session_path_days_from_conversion | NULLABLE | INTEGER |
| path_length | NULLABLE | INTEGER |
| path_length_days | NULLABLE | INTEGER |
| path_step_number_reverse | NULLABLE | INTEGER |
| path_step_number | NULLABLE | INTEGER |
| attribution_score | NULLABLE | RECORD |
| attribution_score.first_click | NULLABLE | INTEGER |
| attribution_score.last_click | NULLABLE | INTEGER |
| attribution_score.linear | NULLABLE | FLOAT |
| attribution_score.position_based | NULLABLE | FLOAT |
| attribution_score.timedecay | NULLABLE | FLOAT |
| attribution_direct | NULLABLE | STRING |
| ecommerce | NULLABLE | RECORD |
| ecommerce.event_timestamp_utc | NULLABLE | TIMESTAMP |
| ecommerce.transaction_id | NULLABLE | STRING |
| ecommerce.currency | NULLABLE | STRING |
| ecommerce.coupon | NULLABLE | STRING |
| ecommerce.total_item_quantity | NULLABLE | INTEGER |
| ecommerce.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.purchase_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.purchase_revenue | NULLABLE | FLOAT |
| ecommerce.refund_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.refund_value_in_usd | NULLABLE | FLOAT |
| ecommerce.refund_value | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_usd | NULLABLE | FLOAT |
| ecommerce.shipping_value | NULLABLE | FLOAT |
| ecommerce.tax_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.tax_value_in_usd | NULLABLE | FLOAT |
| ecommerce.tax_value | NULLABLE | FLOAT |
| ecommerce.unique_items | NULLABLE | INTEGER |
| ecommerce.transaction_duplicate_nr | NULLABLE | INTEGER |
| ecommerce.items | REPEATED | RECORD |
| ecommerce.items.item_id | NULLABLE | STRING |
| ecommerce.items.item_name | NULLABLE | STRING |
| ecommerce.items.item_brand | NULLABLE | STRING |
| ecommerce.items.item_variant | NULLABLE | STRING |
| ecommerce.items.item_category | NULLABLE | STRING |
| ecommerce.items.item_category2 | NULLABLE | STRING |
| ecommerce.items.item_category3 | NULLABLE | STRING |
| ecommerce.items.item_category4 | NULLABLE | STRING |
| ecommerce.items.item_category5 | NULLABLE | STRING |
| ecommerce.items.price_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.price_in_usd | NULLABLE | FLOAT |
| ecommerce.items.price | NULLABLE | FLOAT |
| ecommerce.items.quantity | NULLABLE | INTEGER |
| ecommerce.items.item_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_revenue | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_refund | NULLABLE | FLOAT |
| ecommerce.items.coupon | NULLABLE | STRING |
| ecommerce.items.affiliation | NULLABLE | STRING |
| ecommerce.items.item_params | REPEATED | RECORD |
| ecommerce.items.item_params.key | NULLABLE | STRING |
| ecommerce.items.item_params.value | NULLABLE | RECORD |
| ecommerce.items.item_params.value.string_value | NULLABLE | STRING |
| ecommerce.items.item_params.value.int_value | NULLABLE | INTEGER |
| ecommerce.items.item_params.value.float_value | NULLABLE | FLOAT |
| ecommerce.items.item_params.value.double_value | NULLABLE | FLOAT |
| google_ads_click_info | NULLABLE | RECORD |
| google_ads_click_info.external_customer_id | NULLABLE | STRING |
| google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| google_ads_click_info.campaign_id | NULLABLE | STRING |
| google_ads_click_info.campaign_name | NULLABLE | STRING |
| google_ads_click_info.ad_group_id | NULLABLE | STRING |
| google_ads_click_info.ad_group_name | NULLABLE | STRING |
| google_ads_click_info.creative_id | NULLABLE | STRING |
| google_ads_click_info.criteria_id | NULLABLE | STRING |
| google_ads_click_info.gclid | NULLABLE | STRING |
| google_ads_click_info.user_list_id | NULLABLE | STRING |
| google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| google_ads_click_info.page | NULLABLE | INTEGER |
| google_ads_click_info.slot | NULLABLE | STRING |
| google_ads_click_info.device | NULLABLE | STRING |
| google_ads_click_info.currency | NULLABLE | STRING |
Schemat danych tabeli ga4_attribution_ua_cross_device
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| journey_id | NULLABLE | STRING |
| conversion_time | NULLABLE | TIMESTAMP |
| session_path_time | NULLABLE | TIMESTAMP |
| session_id | NULLABLE | STRING |
| event_date | NULLABLE | STRING |
| attribution_timespan | NULLABLE | STRING |
| conversion_time_micros | NULLABLE | INTEGER |
| session_path_time_micros | NULLABLE | INTEGER |
| user_pseudo_id | NULLABLE | STRING |
| event_name | NULLABLE | STRING |
| event_value | NULLABLE | FLOAT |
| session_path_traffic_source | NULLABLE | RECORD |
| session_path_traffic_source.source | NULLABLE | STRING |
| session_path_traffic_source.medium | NULLABLE | STRING |
| session_path_traffic_source.campaign | NULLABLE | STRING |
| session_path_traffic_source.campaign_id | NULLABLE | STRING |
| session_path_traffic_source.gclid | NULLABLE | STRING |
| session_path_days_from_conversion | NULLABLE | INTEGER |
| path_length | NULLABLE | INTEGER |
| path_length_days | NULLABLE | INTEGER |
| path_step_number_reverse | NULLABLE | INTEGER |
| path_step_number | NULLABLE | INTEGER |
| attribution_score | NULLABLE | RECORD |
| attribution_score.first_click | NULLABLE | INTEGER |
| attribution_score.last_click | NULLABLE | INTEGER |
| attribution_score.linear | NULLABLE | FLOAT |
| attribution_score.position_based | NULLABLE | FLOAT |
| attribution_score.timedecay | NULLABLE | FLOAT |
| attribution_direct | NULLABLE | STRING |
| ecommerce | NULLABLE | RECORD |
| ecommerce.event_timestamp_utc | NULLABLE | TIMESTAMP |
| ecommerce.transaction_id | NULLABLE | STRING |
| ecommerce.currency | NULLABLE | STRING |
| ecommerce.coupon | NULLABLE | STRING |
| ecommerce.total_item_quantity | NULLABLE | INTEGER |
| ecommerce.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.purchase_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.purchase_revenue | NULLABLE | FLOAT |
| ecommerce.refund_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.refund_value_in_usd | NULLABLE | FLOAT |
| ecommerce.refund_value | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_usd | NULLABLE | FLOAT |
| ecommerce.shipping_value | NULLABLE | FLOAT |
| ecommerce.tax_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.tax_value_in_usd | NULLABLE | FLOAT |
| ecommerce.tax_value | NULLABLE | FLOAT |
| ecommerce.unique_items | NULLABLE | INTEGER |
| ecommerce.transaction_duplicate_nr | NULLABLE | INTEGER |
| ecommerce.items | REPEATED | RECORD |
| ecommerce.items.item_id | NULLABLE | STRING |
| ecommerce.items.item_name | NULLABLE | STRING |
| ecommerce.items.item_brand | NULLABLE | STRING |
| ecommerce.items.item_variant | NULLABLE | STRING |
| ecommerce.items.item_category | NULLABLE | STRING |
| ecommerce.items.item_category2 | NULLABLE | STRING |
| ecommerce.items.item_category3 | NULLABLE | STRING |
| ecommerce.items.item_category4 | NULLABLE | STRING |
| ecommerce.items.item_category5 | NULLABLE | STRING |
| ecommerce.items.price_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.price_in_usd | NULLABLE | FLOAT |
| ecommerce.items.price | NULLABLE | FLOAT |
| ecommerce.items.quantity | NULLABLE | INTEGER |
| ecommerce.items.item_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_revenue | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_refund | NULLABLE | FLOAT |
| ecommerce.items.coupon | NULLABLE | STRING |
| ecommerce.items.affiliation | NULLABLE | STRING |
| ecommerce.items.item_params | REPEATED | RECORD |
| ecommerce.items.item_params.key | NULLABLE | STRING |
| ecommerce.items.item_params.value | NULLABLE | RECORD |
| ecommerce.items.item_params.value.string_value | NULLABLE | STRING |
| ecommerce.items.item_params.value.int_value | NULLABLE | INTEGER |
| ecommerce.items.item_params.value.float_value | NULLABLE | FLOAT |
| ecommerce.items.item_params.value.double_value | NULLABLE | FLOAT |
| google_ads_click_info | NULLABLE | RECORD |
| google_ads_click_info.external_customer_id | NULLABLE | STRING |
| google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| google_ads_click_info.campaign_id | NULLABLE | STRING |
| google_ads_click_info.campaign_name | NULLABLE | STRING |
| google_ads_click_info.ad_group_id | NULLABLE | STRING |
| google_ads_click_info.ad_group_name | NULLABLE | STRING |
| google_ads_click_info.creative_id | NULLABLE | STRING |
| google_ads_click_info.criteria_id | NULLABLE | STRING |
| google_ads_click_info.gclid | NULLABLE | STRING |
| google_ads_click_info.user_list_id | NULLABLE | STRING |
| google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| google_ads_click_info.page | NULLABLE | INTEGER |
| google_ads_click_info.slot | NULLABLE | STRING |
| google_ads_click_info.device | NULLABLE | STRING |
| google_ads_click_info.currency | NULLABLE | STRING |
Schemat danych tabeli ga4_attribution_ua_device
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| journey_id | NULLABLE | STRING |
| conversion_time | NULLABLE | TIMESTAMP |
| session_path_time | NULLABLE | TIMESTAMP |
| session_id | NULLABLE | STRING |
| event_date | NULLABLE | STRING |
| attribution_timespan | NULLABLE | STRING |
| conversion_time_micros | NULLABLE | INTEGER |
| session_path_time_micros | NULLABLE | INTEGER |
| user_pseudo_id | NULLABLE | STRING |
| event_name | NULLABLE | STRING |
| event_value | NULLABLE | FLOAT |
| session_path_traffic_source | NULLABLE | RECORD |
| session_path_traffic_source.source | NULLABLE | STRING |
| session_path_traffic_source.medium | NULLABLE | STRING |
| session_path_traffic_source.campaign | NULLABLE | STRING |
| session_path_traffic_source.campaign_id | NULLABLE | STRING |
| session_path_traffic_source.gclid | NULLABLE | STRING |
| session_path_days_from_conversion | NULLABLE | INTEGER |
| path_length | NULLABLE | INTEGER |
| path_length_days | NULLABLE | INTEGER |
| path_step_number_reverse | NULLABLE | INTEGER |
| path_step_number | NULLABLE | INTEGER |
| attribution_score | NULLABLE | RECORD |
| attribution_score.first_click | NULLABLE | INTEGER |
| attribution_score.last_click | NULLABLE | INTEGER |
| attribution_score.linear | NULLABLE | FLOAT |
| attribution_score.position_based | NULLABLE | FLOAT |
| attribution_score.timedecay | NULLABLE | FLOAT |
| attribution_direct | NULLABLE | STRING |
| ecommerce | NULLABLE | RECORD |
| ecommerce.event_timestamp_utc | NULLABLE | TIMESTAMP |
| ecommerce.transaction_id | NULLABLE | STRING |
| ecommerce.currency | NULLABLE | STRING |
| ecommerce.coupon | NULLABLE | STRING |
| ecommerce.total_item_quantity | NULLABLE | INTEGER |
| ecommerce.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.purchase_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.purchase_revenue | NULLABLE | FLOAT |
| ecommerce.refund_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.refund_value_in_usd | NULLABLE | FLOAT |
| ecommerce.refund_value | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_usd | NULLABLE | FLOAT |
| ecommerce.shipping_value | NULLABLE | FLOAT |
| ecommerce.tax_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.tax_value_in_usd | NULLABLE | FLOAT |
| ecommerce.tax_value | NULLABLE | FLOAT |
| ecommerce.unique_items | NULLABLE | INTEGER |
| ecommerce.transaction_duplicate_nr | NULLABLE | INTEGER |
| ecommerce.items | REPEATED | RECORD |
| ecommerce.items.item_id | NULLABLE | STRING |
| ecommerce.items.item_name | NULLABLE | STRING |
| ecommerce.items.item_brand | NULLABLE | STRING |
| ecommerce.items.item_variant | NULLABLE | STRING |
| ecommerce.items.item_category | NULLABLE | STRING |
| ecommerce.items.item_category2 | NULLABLE | STRING |
| ecommerce.items.item_category3 | NULLABLE | STRING |
| ecommerce.items.item_category4 | NULLABLE | STRING |
| ecommerce.items.item_category5 | NULLABLE | STRING |
| ecommerce.items.price_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.price_in_usd | NULLABLE | FLOAT |
| ecommerce.items.price | NULLABLE | FLOAT |
| ecommerce.items.quantity | NULLABLE | INTEGER |
| ecommerce.items.item_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_revenue | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_refund | NULLABLE | FLOAT |
| ecommerce.items.coupon | NULLABLE | STRING |
| ecommerce.items.affiliation | NULLABLE | STRING |
| ecommerce.items.item_params | REPEATED | RECORD |
| ecommerce.items.item_params.key | NULLABLE | STRING |
| ecommerce.items.item_params.value | NULLABLE | RECORD |
| ecommerce.items.item_params.value.string_value | NULLABLE | STRING |
| ecommerce.items.item_params.value.int_value | NULLABLE | INTEGER |
| ecommerce.items.item_params.value.float_value | NULLABLE | FLOAT |
| ecommerce.items.item_params.value.double_value | NULLABLE | FLOAT |
| google_ads_click_info | NULLABLE | RECORD |
| google_ads_click_info.external_customer_id | NULLABLE | STRING |
| google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| google_ads_click_info.campaign_id | NULLABLE | STRING |
| google_ads_click_info.campaign_name | NULLABLE | STRING |
| google_ads_click_info.ad_group_id | NULLABLE | STRING |
| google_ads_click_info.ad_group_name | NULLABLE | STRING |
| google_ads_click_info.creative_id | NULLABLE | STRING |
| google_ads_click_info.criteria_id | NULLABLE | STRING |
| google_ads_click_info.gclid | NULLABLE | STRING |
| google_ads_click_info.user_list_id | NULLABLE | STRING |
| google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| google_ads_click_info.page | NULLABLE | INTEGER |
| google_ads_click_info.slot | NULLABLE | STRING |
| google_ads_click_info.device | NULLABLE | STRING |
| google_ads_click_info.currency | NULLABLE | STRING |
Schemat danych tabeli ga4_conversion_events
| Field Name | Mode | Type |
|---|---|---|
| countingMethod | NULLABLE | STRING |
| deletable | NULLABLE | BOOLEAN |
| name | NULLABLE | STRING |
| custom | NULLABLE | BOOLEAN |
| eventName | NULLABLE | STRING |
| streamId | NULLABLE | INTEGER |
| createTime | NULLABLE | TIMESTAMP |
| propertyId | NULLABLE | INTEGER |
Schemat danych tabeli ga4_events
| Field Name | Mode | Type |
|---|---|---|
| event_date | NULLABLE | STRING |
| user_pseudo_id | NULLABLE | STRING |
| user_id | NULLABLE | STRING |
| group_id | NULLABLE | STRING |
| event_name | NULLABLE | STRING |
| event_timestamp | NULLABLE | INTEGER |
| event_params | REPEATED | RECORD |
| event_params.key | NULLABLE | STRING |
| event_params.value | NULLABLE | RECORD |
| event_params.value.string_value | NULLABLE | STRING |
| event_params.value.int_value | NULLABLE | INTEGER |
| event_params.value.float_value | NULLABLE | FLOAT |
| event_params.value.double_value | NULLABLE | FLOAT |
| app_info | NULLABLE | RECORD |
| app_info.id | NULLABLE | STRING |
| app_info.version | NULLABLE | STRING |
| app_info.install_store | NULLABLE | STRING |
| app_info.firebase_app_id | NULLABLE | STRING |
| app_info.install_source | NULLABLE | STRING |
| device | NULLABLE | RECORD |
| device.category | NULLABLE | STRING |
| device.mobile_brand_name | NULLABLE | STRING |
| device.mobile_model_name | NULLABLE | STRING |
| device.mobile_marketing_name | NULLABLE | STRING |
| device.mobile_os_hardware_model | NULLABLE | STRING |
| device.operating_system | NULLABLE | STRING |
| device.operating_system_version | NULLABLE | STRING |
| device.vendor_id | NULLABLE | STRING |
| device.advertising_id | NULLABLE | STRING |
| device.language | NULLABLE | STRING |
| device.is_limited_ad_tracking | NULLABLE | STRING |
| device.time_zone_offset_seconds | NULLABLE | INTEGER |
| device.browser | NULLABLE | STRING |
| device.browser_version | NULLABLE | STRING |
| device.web_info | NULLABLE | RECORD |
| device.web_info.browser | NULLABLE | STRING |
| device.web_info.browser_version | NULLABLE | STRING |
| device.web_info.hostname | NULLABLE | STRING |
| ecommerce | NULLABLE | RECORD |
| ecommerce.total_item_quantity | NULLABLE | INTEGER |
| ecommerce.purchase_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.purchase_revenue | NULLABLE | FLOAT |
| ecommerce.refund_value_in_usd | NULLABLE | FLOAT |
| ecommerce.refund_value | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_usd | NULLABLE | FLOAT |
| ecommerce.shipping_value | NULLABLE | FLOAT |
| ecommerce.tax_value_in_usd | NULLABLE | FLOAT |
| ecommerce.tax_value | NULLABLE | FLOAT |
| ecommerce.unique_items | NULLABLE | INTEGER |
| ecommerce.transaction_id | NULLABLE | STRING |
| items | REPEATED | RECORD |
| items.item_id | NULLABLE | STRING |
| items.item_name | NULLABLE | STRING |
| items.item_brand | NULLABLE | STRING |
| items.item_variant | NULLABLE | STRING |
| items.item_category | NULLABLE | STRING |
| items.item_category2 | NULLABLE | STRING |
| items.item_category3 | NULLABLE | STRING |
| items.item_category4 | NULLABLE | STRING |
| items.item_category5 | NULLABLE | STRING |
| items.price_in_usd | NULLABLE | FLOAT |
| items.price | NULLABLE | FLOAT |
| items.quantity | NULLABLE | INTEGER |
| items.item_revenue_in_usd | NULLABLE | FLOAT |
| items.item_revenue | NULLABLE | FLOAT |
| items.item_refund_in_usd | NULLABLE | FLOAT |
| items.item_refund | NULLABLE | FLOAT |
| items.coupon | NULLABLE | STRING |
| items.affiliation | NULLABLE | STRING |
| items.location_id | NULLABLE | STRING |
| items.item_list_id | NULLABLE | STRING |
| items.item_list_name | NULLABLE | STRING |
| items.item_list_index | NULLABLE | STRING |
| items.promotion_id | NULLABLE | STRING |
| items.promotion_name | NULLABLE | STRING |
| items.creative_name | NULLABLE | STRING |
| items.creative_slot | NULLABLE | STRING |
| items.item_params | REPEATED | RECORD |
| items.item_params.key | NULLABLE | STRING |
| items.item_params.value | NULLABLE | RECORD |
| items.item_params.value.string_value | NULLABLE | STRING |
| items.item_params.value.int_value | NULLABLE | INTEGER |
| items.item_params.value.float_value | NULLABLE | FLOAT |
| items.item_params.value.double_value | NULLABLE | FLOAT |
| event_bundle_sequence_id | NULLABLE | INTEGER |
| event_dimensions | NULLABLE | RECORD |
| event_dimensions.hostname | NULLABLE | STRING |
| event_previous_timestamp | NULLABLE | INTEGER |
| event_server_timestamp_offset | NULLABLE | INTEGER |
| event_value_in_usd | NULLABLE | FLOAT |
| geo | NULLABLE | RECORD |
| geo.continent | NULLABLE | STRING |
| geo.country | NULLABLE | STRING |
| geo.region | NULLABLE | STRING |
| geo.city | NULLABLE | STRING |
| geo.sub_continent | NULLABLE | STRING |
| geo.metro | NULLABLE | STRING |
| platform | NULLABLE | STRING |
| privacy_info | NULLABLE | RECORD |
| privacy_info.analytics_storage | NULLABLE | STRING |
| privacy_info.ads_storage | NULLABLE | STRING |
| privacy_info.uses_transient_token | NULLABLE | STRING |
| stream_id | NULLABLE | STRING |
| traffic_source | NULLABLE | RECORD |
| traffic_source.name | NULLABLE | STRING |
| traffic_source.medium | NULLABLE | STRING |
| traffic_source.source | NULLABLE | STRING |
| user_first_touch_timestamp | NULLABLE | INTEGER |
| user_ltv | NULLABLE | RECORD |
| user_ltv.revenue | NULLABLE | FLOAT |
| user_ltv.currency | NULLABLE | STRING |
| user_properties | REPEATED | RECORD |
| user_properties.key | NULLABLE | STRING |
| user_properties.value | NULLABLE | RECORD |
| user_properties.value.string_value | NULLABLE | STRING |
| user_properties.value.int_value | NULLABLE | INTEGER |
| user_properties.value.float_value | NULLABLE | FLOAT |
| user_properties.value.double_value | NULLABLE | FLOAT |
| user_properties.value.set_timestamp_micros | NULLABLE | INTEGER |
| wit_session_ga4 | NULLABLE | RECORD |
| wit_session_ga4.session_id | NULLABLE | STRING |
| wit_session_ga4.session_id_group | NULLABLE | STRING |
| wit_session_ga4.traffic_source | NULLABLE | RECORD |
| wit_session_ga4.traffic_source.source | NULLABLE | STRING |
| wit_session_ga4.traffic_source.medium | NULLABLE | STRING |
| wit_session_ga4.traffic_source.campaign | NULLABLE | STRING |
| wit_session_ga4.traffic_source.term | NULLABLE | STRING |
| wit_session_ga4.traffic_source.content | NULLABLE | STRING |
| wit_session_ga4.traffic_source.campaign_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.gclid | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info | NULLABLE | RECORD |
| wit_session_ga4.traffic_source.google_ads_click_info.external_customer_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.campaign_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.campaign_name | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_group_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_group_name | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.creative_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.criteria_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.gclid | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.user_list_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.page | NULLABLE | INTEGER |
| wit_session_ga4.traffic_source.google_ads_click_info.slot | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.device | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.currency | NULLABLE | STRING |
| wit_session_ga4.attribution_details | NULLABLE | STRING |
| wit_session_ua_cross_device | NULLABLE | RECORD |
| wit_session_ua_cross_device.session_id | NULLABLE | STRING |
| wit_session_ua_cross_device.session_id_group | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source | NULLABLE | RECORD |
| wit_session_ua_cross_device.traffic_source.source | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.medium | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.campaign | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.term | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.content | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.campaign_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.gclid | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info | NULLABLE | RECORD |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.external_customer_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_name | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_name | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.creative_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.gclid | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.user_list_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.page | NULLABLE | INTEGER |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.slot | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.device | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.currency | NULLABLE | STRING |
| wit_session_ua_cross_device.attribution_details | NULLABLE | STRING |
| wit_session_ua_device | NULLABLE | RECORD |
| wit_session_ua_device.session_id | NULLABLE | STRING |
| wit_session_ua_device.session_id_group | NULLABLE | STRING |
| wit_session_ua_device.traffic_source | NULLABLE | RECORD |
| wit_session_ua_device.traffic_source.source | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.medium | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.campaign | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.term | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.content | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.campaign_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.gclid | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info | NULLABLE | RECORD |
| wit_session_ua_device.traffic_source.google_ads_click_info.external_customer_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.campaign_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.campaign_name | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_name | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.creative_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.criteria_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.gclid | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.user_list_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.page | NULLABLE | INTEGER |
| wit_session_ua_device.traffic_source.google_ads_click_info.slot | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.device | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.currency | NULLABLE | STRING |
| wit_session_ua_device.attribution_details | NULLABLE | STRING |
| attribution_timespan | NULLABLE | STRING |
| is_active_user | NULLABLE | BOOLEAN |
Schemat danych tabeli ga4_sessions
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| session_id | NULLABLE | STRING |
| user_pseudo_id | NULLABLE | STRING |
| session_start_time | NULLABLE | INTEGER |
| landing_page | NULLABLE | STRING |
| totals | NULLABLE | RECORD |
| totals.event | NULLABLE | INTEGER |
| totals.page_view | NULLABLE | INTEGER |
| totals.unique_page_view | NULLABLE | INTEGER |
| totals.screen_view | NULLABLE | INTEGER |
| totals.unique_screen_view | NULLABLE | INTEGER |
| totals.engagement | NULLABLE | INTEGER |
| totals.engagement_time_seconds | NULLABLE | FLOAT |
| totals.visit_duration | NULLABLE | INTEGER |
| totals.first_visit | NULLABLE | INTEGER |
| totals.view_item | NULLABLE | INTEGER |
| totals.add_to_cart | NULLABLE | INTEGER |
| totals.begin_checkout | NULLABLE | INTEGER |
| totals.add_shipping_info | NULLABLE | INTEGER |
| totals.add_payment_info | NULLABLE | INTEGER |
| totals.purchase | NULLABLE | INTEGER |
| totals.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| totals.shipping_value_in_property_currency | NULLABLE | FLOAT |
| totals.tax_value_in_property_currency | NULLABLE | FLOAT |
| totals.refund_value_in_property_currency | NULLABLE | FLOAT |
| totals.event_count | NULLABLE | STRING |
| totals.event_value | NULLABLE | STRING |
| stream_id | NULLABLE | STRING |
| platform | NULLABLE | STRING |
| acq_traffic_source | NULLABLE | RECORD |
| acq_traffic_source.name | NULLABLE | STRING |
| acq_traffic_source.medium | NULLABLE | STRING |
| acq_traffic_source.source | NULLABLE | STRING |
| wit_session_ga4 | NULLABLE | RECORD |
| wit_session_ga4.session_id | NULLABLE | STRING |
| wit_session_ga4.session_id_group | NULLABLE | STRING |
| wit_session_ga4.traffic_source | NULLABLE | RECORD |
| wit_session_ga4.traffic_source.source | NULLABLE | STRING |
| wit_session_ga4.traffic_source.medium | NULLABLE | STRING |
| wit_session_ga4.traffic_source.campaign | NULLABLE | STRING |
| wit_session_ga4.traffic_source.term | NULLABLE | STRING |
| wit_session_ga4.traffic_source.content | NULLABLE | STRING |
| wit_session_ga4.traffic_source.campaign_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.gclid | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info | NULLABLE | RECORD |
| wit_session_ga4.traffic_source.google_ads_click_info.external_customer_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.campaign_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.campaign_name | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_group_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_group_name | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.creative_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.criteria_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.gclid | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.user_list_id | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.page | NULLABLE | INTEGER |
| wit_session_ga4.traffic_source.google_ads_click_info.slot | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.device | NULLABLE | STRING |
| wit_session_ga4.traffic_source.google_ads_click_info.currency | NULLABLE | STRING |
| wit_session_ga4.attribution_details | NULLABLE | STRING |
| device | NULLABLE | RECORD |
| device.category | NULLABLE | STRING |
| device.mobile_brand_name | NULLABLE | STRING |
| device.mobile_model_name | NULLABLE | STRING |
| device.mobile_marketing_name | NULLABLE | STRING |
| device.mobile_os_hardware_model | NULLABLE | STRING |
| device.operating_system | NULLABLE | STRING |
| device.operating_system_version | NULLABLE | STRING |
| device.vendor_id | NULLABLE | STRING |
| device.advertising_id | NULLABLE | STRING |
| device.language | NULLABLE | STRING |
| device.is_limited_ad_tracking | NULLABLE | STRING |
| device.time_zone_offset_seconds | NULLABLE | INTEGER |
| device.browser | NULLABLE | STRING |
| device.browser_version | NULLABLE | STRING |
| device.web_info | NULLABLE | RECORD |
| device.web_info.browser | NULLABLE | STRING |
| device.web_info.browser_version | NULLABLE | STRING |
| device.web_info.hostname | NULLABLE | STRING |
| geo | NULLABLE | RECORD |
| geo.continent | NULLABLE | STRING |
| geo.country | NULLABLE | STRING |
| geo.region | NULLABLE | STRING |
| geo.city | NULLABLE | STRING |
| geo.sub_continent | NULLABLE | STRING |
| geo.metro | NULLABLE | STRING |
| app_info | NULLABLE | RECORD |
| app_info.id | NULLABLE | STRING |
| app_info.version | NULLABLE | STRING |
| app_info.install_store | NULLABLE | STRING |
| app_info.firebase_app_id | NULLABLE | STRING |
| app_info.install_source | NULLABLE | STRING |
| ecommerce | REPEATED | RECORD |
| ecommerce.event_timestamp_utc | NULLABLE | TIMESTAMP |
| ecommerce.transaction_id | NULLABLE | STRING |
| ecommerce.currency | NULLABLE | STRING |
| ecommerce.coupon | NULLABLE | STRING |
| ecommerce.total_item_quantity | NULLABLE | INTEGER |
| ecommerce.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.purchase_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.purchase_revenue | NULLABLE | FLOAT |
| ecommerce.refund_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.refund_value_in_usd | NULLABLE | FLOAT |
| ecommerce.refund_value | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_usd | NULLABLE | FLOAT |
| ecommerce.shipping_value | NULLABLE | FLOAT |
| ecommerce.tax_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.tax_value_in_usd | NULLABLE | FLOAT |
| ecommerce.tax_value | NULLABLE | FLOAT |
| ecommerce.unique_items | NULLABLE | INTEGER |
| ecommerce.transaction_duplicate_nr | NULLABLE | INTEGER |
| ecommerce.items | REPEATED | RECORD |
| ecommerce.items.item_id | NULLABLE | STRING |
| ecommerce.items.item_name | NULLABLE | STRING |
| ecommerce.items.item_brand | NULLABLE | STRING |
| ecommerce.items.item_variant | NULLABLE | STRING |
| ecommerce.items.item_category | NULLABLE | STRING |
| ecommerce.items.item_category2 | NULLABLE | STRING |
| ecommerce.items.item_category3 | NULLABLE | STRING |
| ecommerce.items.item_category4 | NULLABLE | STRING |
| ecommerce.items.item_category5 | NULLABLE | STRING |
| ecommerce.items.price_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.price_in_usd | NULLABLE | FLOAT |
| ecommerce.items.price | NULLABLE | FLOAT |
| ecommerce.items.quantity | NULLABLE | INTEGER |
| ecommerce.items.item_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_revenue | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_refund | NULLABLE | FLOAT |
| ecommerce.items.coupon | NULLABLE | STRING |
| ecommerce.items.affiliation | NULLABLE | STRING |
| ecommerce.items.item_params | REPEATED | RECORD |
| ecommerce.items.item_params.key | NULLABLE | STRING |
| ecommerce.items.item_params.value | NULLABLE | RECORD |
| ecommerce.items.item_params.value.string_value | NULLABLE | STRING |
| ecommerce.items.item_params.value.int_value | NULLABLE | INTEGER |
| ecommerce.items.item_params.value.float_value | NULLABLE | FLOAT |
| ecommerce.items.item_params.value.double_value | NULLABLE | FLOAT |
| is_true_direct | NULLABLE | BOOLEAN |
Schemat danych tabeli ga4_sessions_ua_cross_device
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| session_id | NULLABLE | STRING |
| user_pseudo_id | NULLABLE | STRING |
| session_start_time | NULLABLE | INTEGER |
| landing_page | NULLABLE | STRING |
| totals | NULLABLE | RECORD |
| totals.event | NULLABLE | INTEGER |
| totals.page_view | NULLABLE | INTEGER |
| totals.unique_page_view | NULLABLE | INTEGER |
| totals.screen_view | NULLABLE | INTEGER |
| totals.unique_screen_view | NULLABLE | INTEGER |
| totals.engagement | NULLABLE | INTEGER |
| totals.engagement_time_seconds | NULLABLE | FLOAT |
| totals.visit_duration | NULLABLE | INTEGER |
| totals.first_visit | NULLABLE | INTEGER |
| totals.view_item | NULLABLE | INTEGER |
| totals.add_to_cart | NULLABLE | INTEGER |
| totals.begin_checkout | NULLABLE | INTEGER |
| totals.add_shipping_info | NULLABLE | INTEGER |
| totals.add_payment_info | NULLABLE | INTEGER |
| totals.purchase | NULLABLE | INTEGER |
| totals.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| totals.shipping_value_in_property_currency | NULLABLE | FLOAT |
| totals.tax_value_in_property_currency | NULLABLE | FLOAT |
| totals.refund_value_in_property_currency | NULLABLE | FLOAT |
| totals.event_count | NULLABLE | STRING |
| totals.event_value | NULLABLE | STRING |
| stream_id | NULLABLE | STRING |
| platform | NULLABLE | STRING |
| acq_traffic_source | NULLABLE | RECORD |
| acq_traffic_source.name | NULLABLE | STRING |
| acq_traffic_source.medium | NULLABLE | STRING |
| acq_traffic_source.source | NULLABLE | STRING |
| wit_session_ua_cross_device | NULLABLE | RECORD |
| wit_session_ua_cross_device.session_id | NULLABLE | STRING |
| wit_session_ua_cross_device.session_id_group | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source | NULLABLE | RECORD |
| wit_session_ua_cross_device.traffic_source.source | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.medium | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.campaign | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.term | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.content | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.campaign_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.gclid | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info | NULLABLE | RECORD |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.external_customer_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.campaign_name | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_group_name | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.creative_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.gclid | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.user_list_id | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.page | NULLABLE | INTEGER |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.slot | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.device | NULLABLE | STRING |
| wit_session_ua_cross_device.traffic_source.google_ads_click_info.currency | NULLABLE | STRING |
| wit_session_ua_cross_device.attribution_details | NULLABLE | STRING |
| device | NULLABLE | RECORD |
| device.category | NULLABLE | STRING |
| device.mobile_brand_name | NULLABLE | STRING |
| device.mobile_model_name | NULLABLE | STRING |
| device.mobile_marketing_name | NULLABLE | STRING |
| device.mobile_os_hardware_model | NULLABLE | STRING |
| device.operating_system | NULLABLE | STRING |
| device.operating_system_version | NULLABLE | STRING |
| device.vendor_id | NULLABLE | STRING |
| device.advertising_id | NULLABLE | STRING |
| device.language | NULLABLE | STRING |
| device.is_limited_ad_tracking | NULLABLE | STRING |
| device.time_zone_offset_seconds | NULLABLE | INTEGER |
| device.browser | NULLABLE | STRING |
| device.browser_version | NULLABLE | STRING |
| device.web_info | NULLABLE | RECORD |
| device.web_info.browser | NULLABLE | STRING |
| device.web_info.browser_version | NULLABLE | STRING |
| device.web_info.hostname | NULLABLE | STRING |
| geo | NULLABLE | RECORD |
| geo.continent | NULLABLE | STRING |
| geo.country | NULLABLE | STRING |
| geo.region | NULLABLE | STRING |
| geo.city | NULLABLE | STRING |
| geo.sub_continent | NULLABLE | STRING |
| geo.metro | NULLABLE | STRING |
| app_info | NULLABLE | RECORD |
| app_info.id | NULLABLE | STRING |
| app_info.version | NULLABLE | STRING |
| app_info.install_store | NULLABLE | STRING |
| app_info.firebase_app_id | NULLABLE | STRING |
| app_info.install_source | NULLABLE | STRING |
| ecommerce | REPEATED | RECORD |
| ecommerce.event_timestamp_utc | NULLABLE | TIMESTAMP |
| ecommerce.transaction_id | NULLABLE | STRING |
| ecommerce.currency | NULLABLE | STRING |
| ecommerce.coupon | NULLABLE | STRING |
| ecommerce.total_item_quantity | NULLABLE | INTEGER |
| ecommerce.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.purchase_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.purchase_revenue | NULLABLE | FLOAT |
| ecommerce.refund_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.refund_value_in_usd | NULLABLE | FLOAT |
| ecommerce.refund_value | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_usd | NULLABLE | FLOAT |
| ecommerce.shipping_value | NULLABLE | FLOAT |
| ecommerce.tax_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.tax_value_in_usd | NULLABLE | FLOAT |
| ecommerce.tax_value | NULLABLE | FLOAT |
| ecommerce.unique_items | NULLABLE | INTEGER |
| ecommerce.transaction_duplicate_nr | NULLABLE | INTEGER |
| ecommerce.items | REPEATED | RECORD |
| ecommerce.items.item_id | NULLABLE | STRING |
| ecommerce.items.item_name | NULLABLE | STRING |
| ecommerce.items.item_brand | NULLABLE | STRING |
| ecommerce.items.item_variant | NULLABLE | STRING |
| ecommerce.items.item_category | NULLABLE | STRING |
| ecommerce.items.item_category2 | NULLABLE | STRING |
| ecommerce.items.item_category3 | NULLABLE | STRING |
| ecommerce.items.item_category4 | NULLABLE | STRING |
| ecommerce.items.item_category5 | NULLABLE | STRING |
| ecommerce.items.price_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.price_in_usd | NULLABLE | FLOAT |
| ecommerce.items.price | NULLABLE | FLOAT |
| ecommerce.items.quantity | NULLABLE | INTEGER |
| ecommerce.items.item_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_revenue | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_refund | NULLABLE | FLOAT |
| ecommerce.items.coupon | NULLABLE | STRING |
| ecommerce.items.affiliation | NULLABLE | STRING |
| ecommerce.items.item_params | REPEATED | RECORD |
| ecommerce.items.item_params.key | NULLABLE | STRING |
| ecommerce.items.item_params.value | NULLABLE | RECORD |
| ecommerce.items.item_params.value.string_value | NULLABLE | STRING |
| ecommerce.items.item_params.value.int_value | NULLABLE | INTEGER |
| ecommerce.items.item_params.value.float_value | NULLABLE | FLOAT |
| ecommerce.items.item_params.value.double_value | NULLABLE | FLOAT |
| is_true_direct | NULLABLE | BOOLEAN |
Schemat danych tabeli ga4_sessions_ua_device
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| session_id | NULLABLE | STRING |
| user_pseudo_id | NULLABLE | STRING |
| session_start_time | NULLABLE | INTEGER |
| landing_page | NULLABLE | STRING |
| totals | NULLABLE | RECORD |
| totals.event | NULLABLE | INTEGER |
| totals.page_view | NULLABLE | INTEGER |
| totals.unique_page_view | NULLABLE | INTEGER |
| totals.screen_view | NULLABLE | INTEGER |
| totals.unique_screen_view | NULLABLE | INTEGER |
| totals.engagement | NULLABLE | INTEGER |
| totals.engagement_time_seconds | NULLABLE | FLOAT |
| totals.visit_duration | NULLABLE | INTEGER |
| totals.first_visit | NULLABLE | INTEGER |
| totals.view_item | NULLABLE | INTEGER |
| totals.add_to_cart | NULLABLE | INTEGER |
| totals.begin_checkout | NULLABLE | INTEGER |
| totals.add_shipping_info | NULLABLE | INTEGER |
| totals.add_payment_info | NULLABLE | INTEGER |
| totals.purchase | NULLABLE | INTEGER |
| totals.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| totals.shipping_value_in_property_currency | NULLABLE | FLOAT |
| totals.tax_value_in_property_currency | NULLABLE | FLOAT |
| totals.refund_value_in_property_currency | NULLABLE | FLOAT |
| totals.event_count | NULLABLE | STRING |
| totals.event_value | NULLABLE | STRING |
| stream_id | NULLABLE | STRING |
| platform | NULLABLE | STRING |
| acq_traffic_source | NULLABLE | RECORD |
| acq_traffic_source.name | NULLABLE | STRING |
| acq_traffic_source.medium | NULLABLE | STRING |
| acq_traffic_source.source | NULLABLE | STRING |
| wit_session_ua_device | NULLABLE | RECORD |
| wit_session_ua_device.session_id | NULLABLE | STRING |
| wit_session_ua_device.session_id_group | NULLABLE | STRING |
| wit_session_ua_device.traffic_source | NULLABLE | RECORD |
| wit_session_ua_device.traffic_source.source | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.medium | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.campaign | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.term | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.content | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.campaign_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.gclid | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info | NULLABLE | RECORD |
| wit_session_ua_device.traffic_source.google_ads_click_info.external_customer_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.account_descriptive_name | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.campaign_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.campaign_name | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_group_name | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.creative_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.criteria_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.gclid | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.user_list_id | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type1 | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.ad_network_type2 | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.criteria_parameters | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.keyword_match_type | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.page | NULLABLE | INTEGER |
| wit_session_ua_device.traffic_source.google_ads_click_info.slot | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.device | NULLABLE | STRING |
| wit_session_ua_device.traffic_source.google_ads_click_info.currency | NULLABLE | STRING |
| wit_session_ua_device.attribution_details | NULLABLE | STRING |
| device | NULLABLE | RECORD |
| device.category | NULLABLE | STRING |
| device.mobile_brand_name | NULLABLE | STRING |
| device.mobile_model_name | NULLABLE | STRING |
| device.mobile_marketing_name | NULLABLE | STRING |
| device.mobile_os_hardware_model | NULLABLE | STRING |
| device.operating_system | NULLABLE | STRING |
| device.operating_system_version | NULLABLE | STRING |
| device.vendor_id | NULLABLE | STRING |
| device.advertising_id | NULLABLE | STRING |
| device.language | NULLABLE | STRING |
| device.is_limited_ad_tracking | NULLABLE | STRING |
| device.time_zone_offset_seconds | NULLABLE | INTEGER |
| device.browser | NULLABLE | STRING |
| device.browser_version | NULLABLE | STRING |
| device.web_info | NULLABLE | RECORD |
| device.web_info.browser | NULLABLE | STRING |
| device.web_info.browser_version | NULLABLE | STRING |
| device.web_info.hostname | NULLABLE | STRING |
| geo | NULLABLE | RECORD |
| geo.continent | NULLABLE | STRING |
| geo.country | NULLABLE | STRING |
| geo.region | NULLABLE | STRING |
| geo.city | NULLABLE | STRING |
| geo.sub_continent | NULLABLE | STRING |
| geo.metro | NULLABLE | STRING |
| app_info | NULLABLE | RECORD |
| app_info.id | NULLABLE | STRING |
| app_info.version | NULLABLE | STRING |
| app_info.install_store | NULLABLE | STRING |
| app_info.firebase_app_id | NULLABLE | STRING |
| app_info.install_source | NULLABLE | STRING |
| ecommerce | REPEATED | RECORD |
| ecommerce.event_timestamp_utc | NULLABLE | TIMESTAMP |
| ecommerce.transaction_id | NULLABLE | STRING |
| ecommerce.currency | NULLABLE | STRING |
| ecommerce.coupon | NULLABLE | STRING |
| ecommerce.total_item_quantity | NULLABLE | INTEGER |
| ecommerce.purchase_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.purchase_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.purchase_revenue | NULLABLE | FLOAT |
| ecommerce.refund_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.refund_value_in_usd | NULLABLE | FLOAT |
| ecommerce.refund_value | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.shipping_value_in_usd | NULLABLE | FLOAT |
| ecommerce.shipping_value | NULLABLE | FLOAT |
| ecommerce.tax_value_in_property_currency | NULLABLE | FLOAT |
| ecommerce.tax_value_in_usd | NULLABLE | FLOAT |
| ecommerce.tax_value | NULLABLE | FLOAT |
| ecommerce.unique_items | NULLABLE | INTEGER |
| ecommerce.transaction_duplicate_nr | NULLABLE | INTEGER |
| ecommerce.items | REPEATED | RECORD |
| ecommerce.items.item_id | NULLABLE | STRING |
| ecommerce.items.item_name | NULLABLE | STRING |
| ecommerce.items.item_brand | NULLABLE | STRING |
| ecommerce.items.item_variant | NULLABLE | STRING |
| ecommerce.items.item_category | NULLABLE | STRING |
| ecommerce.items.item_category2 | NULLABLE | STRING |
| ecommerce.items.item_category3 | NULLABLE | STRING |
| ecommerce.items.item_category4 | NULLABLE | STRING |
| ecommerce.items.item_category5 | NULLABLE | STRING |
| ecommerce.items.price_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.price_in_usd | NULLABLE | FLOAT |
| ecommerce.items.price | NULLABLE | FLOAT |
| ecommerce.items.quantity | NULLABLE | INTEGER |
| ecommerce.items.item_revenue_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_revenue_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_revenue | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_property_currency | NULLABLE | FLOAT |
| ecommerce.items.item_refund_in_usd | NULLABLE | FLOAT |
| ecommerce.items.item_refund | NULLABLE | FLOAT |
| ecommerce.items.coupon | NULLABLE | STRING |
| ecommerce.items.affiliation | NULLABLE | STRING |
| ecommerce.items.item_params | REPEATED | RECORD |
| ecommerce.items.item_params.key | NULLABLE | STRING |
| ecommerce.items.item_params.value | NULLABLE | RECORD |
| ecommerce.items.item_params.value.string_value | NULLABLE | STRING |
| ecommerce.items.item_params.value.int_value | NULLABLE | INTEGER |
| ecommerce.items.item_params.value.float_value | NULLABLE | FLOAT |
| ecommerce.items.item_params.value.double_value | NULLABLE | FLOAT |
| is_true_direct | NULLABLE | BOOLEAN |
Schemat danych tabeli ga4_users_deduplication
| Field Name | Mode | Type |
|---|---|---|
| node | NULLABLE | STRING |
| group_id | NULLABLE | INTEGER |
