Google Analytics 360 (Universal)

• Wprowadzenie
  • Przykład działania
  • Schemat danych
• Konfiguracja
  • Zanim zaczniesz
  • Rozpocznij tworzenie modułu
  • Początkowe ustawienia
  • Autoryzacja z Google BigQuery i Google Analytics
  • Ustawienie modułu w harmonogramie

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

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.

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

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)

Rozpocznij tworzenie modułu

Z menu po lewej stronie wybierz zakładkę Collect, następnie kliknij w przycisk Add new Data Collect.

Z listy dostępnych modułów wybieramy Google Analytics 360.

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.

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.

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.

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)