# Google Analytics 360 (Universal)
# Introduction
The Google Analytics 360 module in WitCloud exports and adapts data created by Google Analytics so that the WitCloud platform has access to them and can fully use them. It extends a data diagram about such fields like crmmetrics, crmdimensions, clicks, impressions, cost and more.
# Example of action
- Configure the module on the platform by giving access to the Google Analytics 360 table
- Set the module in the schedule - data will be copied entirely, additional new fields will be added to import business and media data
- After processing the table, you can use other report modules, data imports or attributes that are integrated with it.
# Data scheme
The target Google Analytics table is very extensive, contains several hundred metrics and dimensions. The fields that will be enriched in relation to the standard table exported by Google Analytics have been marked green.
Expand to get acquainted with the data schedule
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
To use the module, you must grant access to the session table created by Google Analytics Premium in BigQuery and to the Google Analytics web property. Expand the sections below to find out how.
Copy Service Account from WitCloud
In the menu on the left, select "Settings" and then "Projects" (1). From the project list, select the correct and then expand details by clicking on the icon of the gear (2).
In the Detail View, there is information about the SERVICE ACCOUNT address - Technical Email address of the project used to authorize WitCloud's user on Google.By clicking the icon, copy the address to the clipboard.
Give access to the Google Analytics 360 table via Service Account
In order to share Google Analytics 360 data, enter BigQuery, search for the correct Dataset on the left menu and select in "Share Dataset".
Then you should give the EMail address generated by WitCloud (Service Account): BigQuery Data Editor, BigQuery User
# Start creating a module
From the menu on the left, select the Collect bookmark, then click Add New Data Collect.
From the list of available modules, select Google Analytics 360.
# Initial settings
In the first step, we have only one field to fill.
Collect Name - name of our module. It will be visible under this name in other places in the platform.
# Authorization with Google Bigquery and Google Analytics
In the next step, we need to access the WitCloud application to BigQuery and our Google Analytics service. This is necessary for WitCloud to eradicate data and settings for Google Analytics.
WARNING
Authorization from Google BigQuery is carried out by giving access for Service Account. This step was described in the Before you start. If you omitted this step necessarily, do it now !!
In the case of correct authorization in BigQuery, after pressing the "Refresh" button will be able to select Project, Dataset and Table, in which there are Google Analytics 360 data.
Then, in a new window from the list, we choose email, which has access to Google Analytics, which we want to set in WitCloud. After selecting a window with accesses that we need to give. The selection should be confirmed by pressing the Allow button.
In the next step, we choose Google AnalyticS account which concern data from the previously selected BigQuery table. Ready! After pressing the Finish 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 determine the schedule and take into account our module in it. About how to do this you can read here LINK (opens new window)