# Google Analytics (Universal)
# Introduction
The module gives us access to raw data collected by Google Analytics (Universal). After proper configuration, data from the selected Google Analytics service will appear in BigQuery. This allows for more advanced analyzes, adding additional data on media or business costs. Data will start collecting from the moment you implement the WitCloud tracking code, and will be processed without sampling.
# An example of operation
- We configure the module in the platform and implement the received code on the website where we have Google Analytics code installed.
- After implementing the code, all hits sent to Google Analytics (Universal) will be copied and sent to Google BigQuery.
- In the WitCloud tool, we run a module that will process hits into sessions and assign appropriate traffic sources in accordance with the Google Analytics methodology.
- The processed data will be available in the dataset on your project in Google BigQuery
- After the session 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
# Start creating the module
From the menu on the left, select the "Collect" tab, then click the "Add new Pipeline" button
Select Google Analytics from the list of available modules
# Initial settings
In the first step, we have several settings to choose from.
Pipeline name - means the name of the module we created. It will be visible under this name in the panel.
Timezone - setting the time zone. The data will be converted to the specified time zone.
Further, after expanding Advanced options, we can change the advanced options. This is not a mandatory step, but we have access to settings such as:
Session gap duration - this is the length of the user's session, i.e. how long the user must be inactive on the website to start a new session. By default, it is set to 30 minutes, it can be set up to 4 hours.
User state lifecycle - this setting determines how far back we should look at previous user sessions to assign the source of the page entry.
Referral exclusion list - means the list of domains whose incoming traffic is treated as direct traffic.
# Authorization from Google Analytics
In this step, we need to grant WitCloud access to our Google Analytics service. This is necessary to retrieve the rest of the settings needed to process the user's session. Access is granted on the "read only" level, ie read only without editing.
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 from the list, select our email, account and Google Analytics service and press the Next button
# Custom field definitions
The next step is an informative step. We save custom dimensions and metrics defined in the selected Google Analytics service in the settings. If everything looks good, press the "Create Pipeline" button
# Code implementation in Google Tag Manager
The configuration of our module is now ready. The last thing that needs to be done is the implementation of the WitCloud tracking code in Google Tag Manager.
Configuration on the Google Tag Manager side
Log in to your Google Tag Manager account, which has the implementation of the previously selected Google Analytics service
Go to the "Variables" tab and click the "New" button
- Name the variable, eg "cjs witcloud collector", then go to the variable configuration by clicking the "Variable Configuration" field
- In the list of variables to choose from, click "Custom Javascript"
- Paste the function code copied from the WitCloud panel into the variable content and press the "Save" button
- In the "Variables" section, find the variable of the "Google Analytics Settings" type and enter its configuration settings
- Hover over a variable's field and click it to modify its settings
- Select "More Settings" -> "Field to Set", then add a new item in the settings, where Field Name should contain the word "sendHitTask" and its value should be set to our newly created variable, ie "cjs witcloud collector". The variable can be selected by clicking the block-like button.
- After all, click the "Save" button to save the changes.
- After saving, the last step is to publish the modified settings by clicking the "Submit" button in the upper right corner of the Google Tag Manager interface. Before publishing it is recommended to use the “Preview” button to check if all the codes are working properly.
# Setting the module in the schedule
Your Google Analytics 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)