# Google Analytics 360 (Universal)

# Wprowadzenie

Moduł Google Analytics 360 w WitCloud eksportuje oraz dostosowuje dane tworzone przez Google Analytics tak, aby platforma WitCloud miała do nich dostęp oraz mogła z nich w pełni korzystać. Rozszerza on schemat danych o takie pola jak crmMetrics, crmDimensions, clicks, impressions, cost i inne.

# Przykład działania

  1. Konfigurujemy moduł w platformie poprzez nadanie dostępu do tabeli Google Analytics 360
  2. Ustawiamy moduł w harmonogramie - dane będą kopiowane w całości, dodatkowo zostaną dostawione nowe pola pozwalające na import danych biznesowych i mediowych
  3. Po przetworzeniu tabeli można skorzystać z innych modułów raportowych, importu danych lub atrybucji, które są z nią zintegrowane.

# Schemat danych

Docelowa tabela Google Analytics jest bardzo obszerna, zawiera kilkaset metryk i wymiarów. Na zielono zostały zaznaczone pola, które zostaną wzbogacone w stosunku do standardowej tabeli eksportowanej przez Google Analytics.

Rozwiń aby zapoznać się ze schematem danych
Field name Type Mode
sessionId STRING NULLABLE
visitId INTEGER NULLABLE
visitorId INTEGER NULLABLE
visitNumber INTEGER NULLABLE
visitStartTime INTEGER NULLABLE
date STRING NULLABLE
userid STRING NULLABLE
fullVisitorId STRING NULLABLE
clientId STRING NULLABLE
channelGrouping STRING NULLABLE
socialEngagementType STRING NULLABLE
totals RECORD NULLABLE
totals. visits INTEGER NULLABLE
totals. hits INTEGER NULLABLE
totals. pageviews INTEGER NULLABLE
totals. timeOnSite INTEGER NULLABLE
totals. timeOnSiteNoInteraction INTEGER NULLABLE
totals. bounces INTEGER NULLABLE
totals. transactions INTEGER NULLABLE
totals. transactionRevenue FLOAT NULLABLE
totals. newVisits INTEGER NULLABLE
totals. screenviews INTEGER NULLABLE
totals. uniqueScreenviews INTEGER NULLABLE
totals. timeOnScreen INTEGER NULLABLE
totals. totalTransactionRevenue FLOAT NULLABLE
totals. sessionQualityDim INTEGER NULLABLE
trafficSource RECORD NULLABLE
trafficSource. referralPath STRING NULLABLE
trafficSource. source STRING NULLABLE
trafficSource. medium STRING NULLABLE
trafficSource. campaign STRING NULLABLE
trafficSource. adContent STRING NULLABLE
trafficSource. keyword STRING NULLABLE
trafficSource. dclid STRING NULLABLE
trafficSource. adId STRING NULLABLE
trafficSource. gclid STRING NULLABLE
trafficSource. campaignCode STRING NULLABLE
trafficSource. isTrueDirect BOOLEAN NULLABLE
trafficSource. adwordsClickInfo RECORD NULLABLE
trafficSource.adwordsClickInfo. campaignId STRING NULLABLE
trafficSource.adwordsClickInfo. adGroupId STRING NULLABLE
trafficSource.adwordsClickInfo. creativeId STRING NULLABLE
trafficSource.adwordsClickInfo. criteriaId STRING NULLABLE
trafficSource.adwordsClickInfo. page INTEGER NULLABLE
trafficSource.adwordsClickInfo. slot STRING NULLABLE
trafficSource.adwordsClickInfo. criteriaParameters STRING NULLABLE
trafficSource.adwordsClickInfo. gclid STRING NULLABLE
trafficSource.adwordsClickInfo. customerId STRING NULLABLE
trafficSource.adwordsClickInfo. adNetworkType STRING NULLABLE
trafficSource.adwordsClickInfo. device STRING NULLABLE
trafficSource. facebookClickInfo RECORD NULLABLE
trafficSource.facebookClickInfo. accountId STRING NULLABLE
trafficSource.facebookClickInfo. accountName STRING NULLABLE
trafficSource.facebookClickInfo. campaignId STRING NULLABLE
trafficSource.facebookClickInfo. campaignName STRING NULLABLE
trafficSource.facebookClickInfo. adId STRING NULLABLE
trafficSource.facebookClickInfo. adName STRING NULLABLE
trafficSource.facebookClickInfo. adsetId STRING NULLABLE
trafficSource.facebookClickInfo. adsetName STRING NULLABLE
trafficSource.facebookClickInfo. buyingType STRING NULLABLE
trafficSource.facebookClickInfo. objective STRING NULLABLE
trafficSource. adCost FLOAT NULLABLE
trafficSource. adCostAttributed FLOAT NULLABLE
trafficSource. clicks FLOAT NULLABLE
trafficSource. impressions FLOAT NULLABLE
device RECORD NULLABLE
device. browser STRING NULLABLE
device. browserVersion STRING NULLABLE
device. browserSize STRING NULLABLE
device. operatingSystem STRING NULLABLE
device. operatingSystemVersion STRING NULLABLE
device. isMobile BOOLEAN NULLABLE
device. mobileDeviceBranding STRING NULLABLE
device. mobileDeviceModel STRING NULLABLE
device. mobileInputSelector STRING NULLABLE
device. mobileDeviceInfo STRING NULLABLE
device. mobileDeviceMarketingName STRING NULLABLE
device. flashVersion STRING NULLABLE
device. javaEnabled BOOLEAN NULLABLE
device. language STRING NULLABLE
device. screenColors STRING NULLABLE
device. screenResolution STRING NULLABLE
device. userAgent STRING NULLABLE
device. encoding STRING NULLABLE
device. deviceCategory STRING NULLABLE
geoNetwork RECORD NULLABLE
geoNetwork. continent STRING NULLABLE
geoNetwork. subContinent STRING NULLABLE
geoNetwork. country STRING NULLABLE
geoNetwork. countryCode STRING NULLABLE
geoNetwork. region STRING NULLABLE
geoNetwork. metro STRING NULLABLE
geoNetwork. city STRING NULLABLE
geoNetwork. cityId STRING NULLABLE
geoNetwork. postalcode STRING NULLABLE
geoNetwork. timezone STRING NULLABLE
geoNetwork. networkDomain STRING NULLABLE
geoNetwork. latitude STRING NULLABLE
geoNetwork. longitude STRING NULLABLE
geoNetwork. networkLocation STRING NULLABLE
customDimensions RECORD REPEATED
customDimensions. index INTEGER NULLABLE
customDimensions. value STRING NULLABLE
hits RECORD REPEATED
hits. hitNumber INTEGER NULLABLE
hits. time INTEGER NULLABLE
hits. timestamp INTEGER NULLABLE
hits. hour INTEGER NULLABLE
hits. minute INTEGER NULLABLE
hits. isSecure BOOLEAN NULLABLE
hits. isInteraction BOOLEAN NULLABLE
hits. isEntrance BOOLEAN NULLABLE
hits. isExit BOOLEAN NULLABLE
hits. referer STRING NULLABLE
hits. page RECORD NULLABLE
hits.page. fullUrl STRING NULLABLE
hits.page. pagePath STRING NULLABLE
hits.page. hostname STRING NULLABLE
hits.page. pageTitle STRING NULLABLE
hits.page. searchKeyword STRING NULLABLE
hits.page. searchCategory STRING NULLABLE
hits.page. pagePathLevel1 STRING NULLABLE
hits.page. pagePathLevel2 STRING NULLABLE
hits.page. pagePathLevel3 STRING NULLABLE
hits.page. pagePathLevel4 STRING NULLABLE
hits.page. pagePathLevel5 STRING NULLABLE
hits.page. pagePathLevel6 STRING NULLABLE
hits.page. pagePathLevel7 STRING NULLABLE
hits.page. pagePathLevel8 STRING NULLABLE
hits.page. pagePathLevel9 STRING NULLABLE
hits.page. pagePathLevel10 STRING NULLABLE
hits. transaction RECORD NULLABLE
hits.transaction. transactionId STRING NULLABLE
hits.transaction. transactionRevenue FLOAT NULLABLE
hits.transaction. transactionTax FLOAT NULLABLE
hits.transaction. transactionShipping FLOAT NULLABLE
hits.transaction. affiliation STRING NULLABLE
hits.transaction. currencyCode STRING NULLABLE
hits.transaction. localTransactionRevenue FLOAT NULLABLE
hits.transaction. localTransactionTax FLOAT NULLABLE
hits.transaction. localTransactionShipping FLOAT NULLABLE
hits.transaction. transactionCoupon STRING NULLABLE
hits. item RECORD NULLABLE
hits.item. transactionId STRING NULLABLE
hits.item. productName STRING NULLABLE
hits.item. productCategory STRING NULLABLE
hits.item. productSku STRING NULLABLE
hits.item. itemQuantity INTEGER NULLABLE
hits.item. itemRevenue FLOAT NULLABLE
hits.item. currencyCode STRING NULLABLE
hits.item. localItemRevenue FLOAT NULLABLE
hits. contentInfo RECORD NULLABLE
hits.contentInfo. contentDescription STRING NULLABLE
hits. appInfo RECORD NULLABLE
hits.appInfo. name STRING NULLABLE
hits.appInfo. version STRING NULLABLE
hits.appInfo. id STRING NULLABLE
hits.appInfo. installerId STRING NULLABLE
hits.appInfo. appInstallerId STRING NULLABLE
hits.appInfo. appName STRING NULLABLE
hits.appInfo. appVersion STRING NULLABLE
hits.appInfo. appId STRING NULLABLE
hits.appInfo. screenName STRING NULLABLE
hits.appInfo. landingScreenName STRING NULLABLE
hits.appInfo. exitScreenName STRING NULLABLE
hits.appInfo. screenDepth STRING NULLABLE
hits. exceptionInfo RECORD NULLABLE
hits.exceptionInfo. description STRING NULLABLE
hits.exceptionInfo. isFatal BOOLEAN NULLABLE
hits.exceptionInfo. exceptions INTEGER NULLABLE
hits.exceptionInfo. fatalExceptions INTEGER NULLABLE
hits. eventInfo RECORD NULLABLE
hits.eventInfo. eventCategory STRING NULLABLE
hits.eventInfo. eventAction STRING NULLABLE
hits.eventInfo. eventLabel STRING NULLABLE
hits.eventInfo. eventValue INTEGER NULLABLE
hits. product RECORD REPEATED
hits.product. productSKU STRING NULLABLE
hits.product. v2ProductName STRING NULLABLE
hits.product. v2ProductCategory STRING NULLABLE
hits.product. productVariant STRING NULLABLE
hits.product. productBrand STRING NULLABLE
hits.product. productRevenue FLOAT NULLABLE
hits.product. localProductRevenue FLOAT NULLABLE
hits.product. productPrice FLOAT NULLABLE
hits.product. localProductPrice FLOAT NULLABLE
hits.product. productQuantity INTEGER NULLABLE
hits.product. productRefundAmount FLOAT NULLABLE
hits.product. localProductRefundAmount FLOAT NULLABLE
hits.product. isImpression BOOLEAN NULLABLE
hits.product. isClick BOOLEAN NULLABLE
hits.product. customDimensions RECORD REPEATED
hits.product.customDimensions. index INTEGER NULLABLE
hits.product.customDimensions. value STRING NULLABLE
hits.product. customMetrics RECORD REPEATED
hits.product.customMetrics. index INTEGER NULLABLE
hits.product.customMetrics. value FLOAT NULLABLE
hits.product. productListName STRING NULLABLE
hits.product. productListPosition INTEGER NULLABLE
hits.product. productCouponCode STRING NULLABLE
hits.product. crmMetrics RECORD REPEATED
hits.product.crmMetrics. index STRING NULLABLE
hits.product.crmMetrics. value FLOAT NULLABLE
hits.product. crmDimensions RECORD REPEATED
hits.product.crmDimensions. index STRING NULLABLE
hits.product.crmDimensions. value STRING NULLABLE
hits. promotion RECORD REPEATED
hits.promotion. promoId STRING NULLABLE
hits.promotion. promoName STRING NULLABLE
hits.promotion. promoCreative STRING NULLABLE
hits.promotion. promoPosition STRING NULLABLE
hits. promotionActionInfo RECORD NULLABLE
hits.promotionActionInfo. promoIsView BOOLEAN NULLABLE
hits.promotionActionInfo. promoIsClick BOOLEAN NULLABLE
hits. refund RECORD NULLABLE
hits.refund. refundAmount INTEGER NULLABLE
hits.refund. localRefundAmount INTEGER NULLABLE
hits. eCommerceAction RECORD NULLABLE
hits.eCommerceAction. action_type STRING NULLABLE
hits.eCommerceAction. step INTEGER NULLABLE
hits.eCommerceAction. option STRING NULLABLE
hits. publisher RECORD NULLABLE
hits.publisher. dfpClicks INTEGER NULLABLE
hits.publisher. dfpImpressions INTEGER NULLABLE
hits.publisher. dfpMatchedQueries INTEGER NULLABLE
hits.publisher. dfpMeasurableImpressions INTEGER NULLABLE
hits.publisher. dfpQueries INTEGER NULLABLE
hits.publisher. dfpRevenueCpm INTEGER NULLABLE
hits.publisher. dfpRevenueCpc INTEGER NULLABLE
hits.publisher. dfpViewableImpressions INTEGER NULLABLE
hits.publisher. dfpPagesViewed INTEGER NULLABLE
hits.publisher. adsenseBackfillDfpClicks INTEGER NULLABLE
hits.publisher. adsenseBackfillDfpImpressions INTEGER NULLABLE
hits.publisher. adsenseBackfillDfpMatchedQueries INTEGER NULLABLE
hits.publisher. adsenseBackfillDfpMeasurableImpressions INTEGER NULLABLE
hits.publisher. adsenseBackfillDfpQueries INTEGER NULLABLE
hits.publisher. adsenseBackfillDfpRevenueCpm INTEGER NULLABLE
hits.publisher. adsenseBackfillDfpRevenueCpc INTEGER NULLABLE
hits.publisher. adsenseBackfillDfpViewableImpressions INTEGER NULLABLE
hits.publisher. adsenseBackfillDfpPagesViewed INTEGER NULLABLE
hits.publisher. adxBackfillDfpClicks INTEGER NULLABLE
hits.publisher. adxBackfillDfpImpressions INTEGER NULLABLE
hits.publisher. adxBackfillDfpMatchedQueries INTEGER NULLABLE
hits.publisher. adxBackfillDfpMeasurableImpressions INTEGER NULLABLE
hits.publisher. adxBackfillDfpQueries INTEGER NULLABLE
hits.publisher. adxBackfillDfpRevenueCpm INTEGER NULLABLE
hits.publisher. adxBackfillDfpRevenueCpc INTEGER NULLABLE
hits.publisher. adxBackfillDfpViewableImpressions INTEGER NULLABLE
hits.publisher. adxBackfillDfpPagesViewed INTEGER NULLABLE
hits.publisher. adxClicks INTEGER NULLABLE
hits.publisher. adxImpressions INTEGER NULLABLE
hits.publisher. adxMatchedQueries INTEGER NULLABLE
hits.publisher. adxMeasurableImpressions INTEGER NULLABLE
hits.publisher. adxQueries INTEGER NULLABLE
hits.publisher. adxRevenue INTEGER NULLABLE
hits.publisher. adxViewableImpressions INTEGER NULLABLE
hits.publisher. adxPagesViewed INTEGER NULLABLE
hits.publisher. adsViewed INTEGER NULLABLE
hits.publisher. adsUnitsViewed INTEGER NULLABLE
hits.publisher. adsUnitsMatched INTEGER NULLABLE
hits.publisher. viewableAdsViewed INTEGER NULLABLE
hits.publisher. measurableAdsViewed INTEGER NULLABLE
hits.publisher. adsPagesViewed INTEGER NULLABLE
hits.publisher. adsClicked INTEGER NULLABLE
hits.publisher. adsRevenue INTEGER NULLABLE
hits.publisher. dfpAdGroup STRING NULLABLE
hits.publisher. dfpAdUnits STRING NULLABLE
hits.publisher. dfpNetworkId STRING NULLABLE
hits. customVariables RECORD REPEATED
hits.customVariables. index INTEGER NULLABLE
hits.customVariables. customVarName STRING NULLABLE
hits.customVariables. customVarValue STRING NULLABLE
hits. experiment RECORD REPEATED
hits.experiment. experimentId STRING NULLABLE
hits.experiment. experimentVariant STRING NULLABLE
hits. dataSource STRING NULLABLE
hits. publisher_infos RECORD REPEATED
hits.publisher_infos. dfpClicks INTEGER NULLABLE
hits.publisher_infos. dfpImpressions INTEGER NULLABLE
hits.publisher_infos. dfpMatchedQueries INTEGER NULLABLE
hits.publisher_infos. dfpMeasurableImpressions INTEGER NULLABLE
hits.publisher_infos. dfpQueries INTEGER NULLABLE
hits.publisher_infos. dfpRevenueCpm INTEGER NULLABLE
hits.publisher_infos. dfpRevenueCpc INTEGER NULLABLE
hits.publisher_infos. dfpViewableImpressions INTEGER NULLABLE
hits.publisher_infos. dfpPagesViewed INTEGER NULLABLE
hits.publisher_infos. adsenseBackfillDfpClicks INTEGER NULLABLE
hits.publisher_infos. adsenseBackfillDfpImpressions INTEGER NULLABLE
hits.publisher_infos. adsenseBackfillDfpMatchedQueries INTEGER NULLABLE
hits.publisher_infos. adsenseBackfillDfpMeasurableImpressions INTEGER NULLABLE
hits.publisher_infos. adsenseBackfillDfpQueries INTEGER NULLABLE
hits.publisher_infos. adsenseBackfillDfpRevenueCpm INTEGER NULLABLE
hits.publisher_infos. adsenseBackfillDfpRevenueCpc INTEGER NULLABLE
hits.publisher_infos. adsenseBackfillDfpViewableImpressions INTEGER NULLABLE
hits.publisher_infos. adsenseBackfillDfpPagesViewed INTEGER NULLABLE
hits.publisher_infos. adxBackfillDfpClicks INTEGER NULLABLE
hits.publisher_infos. adxBackfillDfpImpressions INTEGER NULLABLE
hits.publisher_infos. adxBackfillDfpMatchedQueries INTEGER NULLABLE
hits.publisher_infos. adxBackfillDfpMeasurableImpressions INTEGER NULLABLE
hits.publisher_infos. adxBackfillDfpQueries INTEGER NULLABLE
hits.publisher_infos. adxBackfillDfpRevenueCpm INTEGER NULLABLE
hits.publisher_infos. adxBackfillDfpRevenueCpc INTEGER NULLABLE
hits.publisher_infos. adxBackfillDfpViewableImpressions INTEGER NULLABLE
hits.publisher_infos. adxBackfillDfpPagesViewed INTEGER NULLABLE
hits.publisher_infos. adxClicks INTEGER NULLABLE
hits.publisher_infos. adxImpressions INTEGER NULLABLE
hits.publisher_infos. adxMatchedQueries INTEGER NULLABLE
hits.publisher_infos. adxMeasurableImpressions INTEGER NULLABLE
hits.publisher_infos. adxQueries INTEGER NULLABLE
hits.publisher_infos. adxRevenue INTEGER NULLABLE
hits.publisher_infos. adxViewableImpressions INTEGER NULLABLE
hits.publisher_infos. adxPagesViewed INTEGER NULLABLE
hits.publisher_infos. adsViewed INTEGER NULLABLE
hits.publisher_infos. adsUnitsViewed INTEGER NULLABLE
hits.publisher_infos. adsUnitsMatched INTEGER NULLABLE
hits.publisher_infos. viewableAdsViewed INTEGER NULLABLE
hits.publisher_infos. measurableAdsViewed INTEGER NULLABLE
hits.publisher_infos. adsPagesViewed INTEGER NULLABLE
hits.publisher_infos. adsClicked INTEGER NULLABLE
hits.publisher_infos. adsRevenue INTEGER NULLABLE
hits.publisher_infos. dfpAdGroup STRING NULLABLE
hits.publisher_infos. dfpAdUnits STRING NULLABLE
hits.publisher_infos. dfpNetworkId STRING NULLABLE
hits. customDimensions RECORD REPEATED
hits.customDimensions. index INTEGER NULLABLE
hits.customDimensions. value STRING NULLABLE
hits. customMetrics RECORD REPEATED
hits.customMetrics. index INTEGER NULLABLE
hits.customMetrics. value FLOAT NULLABLE
hits. type STRING NULLABLE
hits. social RECORD NULLABLE
hits.social. socialInteractionNetwork STRING NULLABLE
hits.social. socialInteractionAction STRING NULLABLE
hits.social. socialInteractions INTEGER NULLABLE
hits.social. socialInteractionTarget STRING NULLABLE
hits.social. socialNetwork STRING NULLABLE
hits.social. uniqueSocialInteractions INTEGER NULLABLE
hits.social. hasSocialSourceReferral STRING NULLABLE
hits.social. socialInteractionNetworkAction STRING NULLABLE
hits. latencyTracking RECORD NULLABLE
hits.latencyTracking. pageLoadSample INTEGER NULLABLE
hits.latencyTracking. pageLoadTime INTEGER NULLABLE
hits.latencyTracking. pageDownloadTime INTEGER NULLABLE
hits.latencyTracking. redirectionTime INTEGER NULLABLE
hits.latencyTracking. speedMetricsSample INTEGER NULLABLE
hits.latencyTracking. domainLookupTime INTEGER NULLABLE
hits.latencyTracking. serverConnectionTime INTEGER NULLABLE
hits.latencyTracking. serverResponseTime INTEGER NULLABLE
hits.latencyTracking. domLatencyMetricsSample INTEGER NULLABLE
hits.latencyTracking. domInteractiveTime INTEGER NULLABLE
hits.latencyTracking. domContentLoadedTime INTEGER NULLABLE
hits.latencyTracking. userTimingValue INTEGER NULLABLE
hits.latencyTracking. userTimingSample INTEGER NULLABLE
hits.latencyTracking. userTimingVariable STRING NULLABLE
hits.latencyTracking. userTimingCategory STRING NULLABLE
hits.latencyTracking. userTimingLabel STRING NULLABLE
hits. sourcePropertyInfo RECORD NULLABLE
hits.sourcePropertyInfo. sourcePropertyDisplayName STRING NULLABLE
hits.sourcePropertyInfo. sourcePropertyTrackingId STRING NULLABLE
hits.sourcePropertyInfo. sourceGtmId STRING NULLABLE
hits. contentGroup RECORD NULLABLE
hits.contentGroup. contentGroup1 STRING NULLABLE
hits.contentGroup. contentGroup2 STRING NULLABLE
hits.contentGroup. contentGroup3 STRING NULLABLE
hits.contentGroup. contentGroup4 STRING NULLABLE
hits.contentGroup. contentGroup5 STRING NULLABLE
hits.contentGroup. previousContentGroup1 STRING NULLABLE
hits.contentGroup. previousContentGroup2 STRING NULLABLE
hits.contentGroup. previousContentGroup3 STRING NULLABLE
hits.contentGroup. previousContentGroup4 STRING NULLABLE
hits.contentGroup. previousContentGroup5 STRING NULLABLE
hits.contentGroup. contentGroupUniqueViews1 INTEGER NULLABLE
hits.contentGroup. contentGroupUniqueViews2 INTEGER NULLABLE
hits.contentGroup. contentGroupUniqueViews3 INTEGER NULLABLE
hits.contentGroup. contentGroupUniqueViews4 INTEGER NULLABLE
hits.contentGroup. contentGroupUniqueViews5 INTEGER NULLABLE
hits. crmMetrics RECORD REPEATED
hits.crmMetrics. index STRING NULLABLE
hits.crmMetrics. value FLOAT NULLABLE
hits. crmDimensions RECORD REPEATED
hits.crmDimensions. index STRING NULLABLE
hits.crmDimensions. value STRING NULLABLE
crmMetrics RECORD REPEATED
crmMetrics. index STRING NULLABLE
crmMetrics. value FLOAT NULLABLE
crmDimensions RECORD REPEATED
crmDimensions. index STRING NULLABLE
crmDimensions. value STRING NULLABLE
customGoals RECORD REPEATED
customGoals. index STRING NULLABLE
customGoals. value INTEGER NULLABLE
goals RECORD REPEATED
goals. index STRING NULLABLE
goals. value INTEGER NULLABLE

# Konfiguracja

# Zanim zaczniesz

Wymagany dostęp do tabeli Google Analytics 360

W celu skorzystania z tego moduły należy posiadać dostęp do tabeli sesji zrzucanej do BigQuery przez Google Analytics Premium, oraz do usługi w samym Google Analytics. WitCloud działa na kopii tabel Google Analytics więc konieczne jest nadanie platformie stosownych uprawnień! Rozwiń poniższe sekcje żeby dowiedzieć się jak to zrobić.

Skopiuj Service Account projektu WitCloud

W menu po lewej stronie wybierz "Settings" a następnie "Projects" (1). Z listy projektów wybierz właściwy a następnie rozwiń szczegóły klikając w ikonkę koła zębatego (2).

image alt text

W widoku szczegółów dostępna jest informacja o adresie Service Account - technicznym adresie email projektu, używanym do autoryzacji użytkownika WitClouda w serwisach Google. Klikając ikonkę skopiujesz adres do schowka.

image alt text

Nadaj dostęp do tabeli Google Analytics 360 poprzez Service Account

W celu udostępnienia danych Google Analytics 360 należy wejść do BigQuery, w menu z lewej strony wyszukać właściwy dataset po czym wybrać w opcję “share dataset”.

image alt text

Następnie należy na adres email wygenerowany przez WitCloud (Service Account) nadać następujące role: BigQuery Data Editor (Edytujący dane BigQuery), BigQuery User (Użytkownik BigQuery)

image alt text

# Rozpocznij tworzenie modułu

Z menu po lewej stronie wybierz zakładkę "Collect" (1), następnie kliknij w przycisk “Add new Data Collect” (2).

image alt text

Z listy dostępnych modułów wybieramy "Google Analytics 360" (3).

image alt text

# Początkowe ustawienia

W pierwszym kroku mamy do wypełnienia tylko jedno pole.

Collect name - nazwa naszego modułu. Będzie on widoczny pod tą nazwą w innych miejscach w platformie.

image alt text

# Autoryzacja z Google BigQuery i Google Analytics

W następnym kroku musimy nadać dostęp aplikacji WitCloud do BigQuery oraz naszej usługi Google Analytics. Jest to konieczne aby WitCloud mógł zaciągnąć dane oraz ustawienia dotyczące usługi Google Analytics.

WARNING

Autoryzacja z Google BigQuery jest realizowana poprzez nadanie dostępów dla Service Account. Ten krok został opisany w sekcji "Zanim zaczniesz". Jeśli pominąłeś ten krok koniecznie wykonaj to teraz!!

W przypadku poprawnej autoryzacji w BigQuery, po naciśnięciu przycisku "Refresh" będzie możliwość wybrania Projektu, Datasetu BigQuery oraz Tabeli, w której znajdują się dane Google Analytics 360.

image alt text

Następnie w nowym oknie z listy wybieramy email, który posiada dostęp do usługi Google Analytics, która chcemy ustawić w WitCloud. Po wyborze pojawi się okno z dostępami, które musimy nadać. Wybór należy potwierdzić naciskając przycisk "allow".

W następnym kroku wybieramy konto Google Analytics której dotyczą dane z wcześniej wybranej tabeli BigQuery. Gotowe! Po naciśnięciu przycisku "Finish" konfiguracja modułu zostanie utworzona.

image alt text

# Ustawienie modułu w harmonogramie

Twój moduł Google Analytics 360 jest już utworzony w WitCloud 📊. Ostatnim krokiem jest ustalenie harmonogramu i uwzględnienie w nim naszego modułu. O tym jak to zrobić możesz przeczytać tutaj link (opens new window)

Last updated: 4/15/2021, 12:30:11 PM