# Google Analytics 360 (Universal)
# Introduction
The Google Analytics 360 module in WitCloud exports and adjusts the data created by Google Analytics so that the WitCloud platform has access to it and can use it fully. It extends the data schema to include fields such as crmMetrics, crmDimensions, clicks, impressions, cost and others.
# An example of operation
- We configure the module in the platform by granting access to the Google Analytics 360 table
- We set the module on the schedule - the data will be copied in full, additionally new fields will be added to import business and media data
- After the table is processed, you can use other reporting modules, data import or attribution that are integrated with it.
# Data schema
The Google Analytics target table is very extensive, with several hundred metrics and dimensions. The fields that will be enriched in relation to the standard table exported by Google Analytics have been marked in green.
Expand for the data schema
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 |
# Configuration
# Before you start
Access to the Google Analytics 360 table required
In order to use this module, you must have access to the session table dropped to BigQuery by Google Analytics Premium, and to the service in Google Analytics itself.
# Start creating the module
From the menu on the left, select the "Collect" tab, then click the "Add new Pipeline" button.
Select "Google Analytics 360" from the list of available modules
# Initial settings
In the first step, we only have one field to fill.
Pipeline name - the name of our module. It will be visible under this name elsewhere on the platform.
# Authorization with Google BigQuery and Google Analytics
In the next step, we need to grant WitCloud access to BigQuery and our Google Analytics service. It is necessary for WitCloud to be able to download data and settings for the Google Analytics service.
To do this, press the "Sign in with Google" button
Then, in a new window, select an email from the list that has access to the Google Analytics service that we want to set up in WitCloud. After selecting, a window will appear with the accesses that we have to grant. Confirm your choice by clicking the "allow" button.
After proper authorization, select our email from the list, then the project, data set and the Google Analytics 360 table.
In the next step, we choose the Google Analytics service to which the data from the previously selected BigQuery table relates. Ready! After pressing the create button, the module configuration will be created.
# Setting the module in the schedule
Your Google Analytics 360 module is already created in WitCloud 📊. The last step is to establish a schedule and include our module in it. You can read about how to do it here link (opens new window)