WitCloud Stream

This module is no longer supported

• Introduction
  • An example of operation
  • Data schema
• Configuration
  • Start creating the module
  • Initial settings
  • Authorization from Google Analytics
  • Custom field definitions
  • Code implementation in Google Tag Manager
  • Setting the module in the schedule

Introduction

The module gives us access to the raw data collected by Google Analytics (Universal). After the correct configuration, the data of the selected Google Analytics service is displayed in BigQuery. This enables advanced analytics, additional data on costs for media or companies. The data is collected from the implementation of the WitCloud tracking code and processed without real-time sampling.

An example of operation

1. We configure the module in the platform and implement the received code on the website where we have Google Analytics code installed.
2. After implementing the code, all hits sent to Google Analytics (Universal) will be copied and sent to Google BigQuery.
3. 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.
4. The processed data will be available in the dataset on your project in Google BigQuery
5. 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

Select the tab Collect in the left menu, then press the button Add new Data Collect

From the list of available modules we select WitCloud Stream

Initial settings

In the first step, you have several settings to choose from.

Collect name - stands for the name of the module we created. It is displayed under this name in the input field.

Timezone- Timezone setting. The data is converted to the specified time zone.

Further after the extension of Advanced options, we can change the advanced options. This is not a mandatory step, but we have access to the following settings:

Session gap duration – This is the duration of the user session, i.e. how long the user must be inactive on the page 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 specifies how far the user’s previous sessions should look back in order to assign them an access source.

Referral exclusion list – denotes a list of domains whose incoming traffic is treated as direct traffic.

Authorization from Google Analytics

In this step, we need to give the WitCloud app access to our Google Analytics service. This is necessary to get the rest of the settings needed to process a user session The access takes place on the “read only” level, i. e. read only without editing possibility.

To do this, press the button Sign in with Google

Then, in a new window from the list, select the email that has access to the Google Analytics service we want to set up in WitCloud. After the selection, a window will appear with the accesses that we have to assign. Confirm the selection by pressing the allow button.

After the correct authorization from the list, select our email, account and Google Analytics service and press the button Next

Custom field definitions

The next step is an informative step. In the settings, we store the custom dimensions and metrics defined in Google Analytics. If everything looks good, press the button Create

Code implementation in Google Tag Manager

The configuration of our module is now complete. The last item you need to do is implement the WitCloud tracking code in Google Tag Manager.

Configuration on the Google Tag Manager page

1. Sign in to your Google Tag Manager account where the implementation of the previously selected Google Analytics service is located

2. Go to the tab Variables and click the button New

3. For example, name the variable cjs witcloud collector, then go to the variable configuration by clicking on the field Variable Configuration.

4. Click on Custom Javascript in the list of variables to be selected

5. Paste the function code copied from the WitCloud panel into the variable content and press the Save button

6. In the Variables section, search for the variable of type Google Analytics Settings and go to its configuration settings

7. Move the variable field and click on this field to change the variable settings

8. Select More Settings -> Field to Set and then add a new entry in the Settings, where the field name should contain the word sendHitTask and the value of our newly created variable cjs witcloud collector. The variable can be selected by clicking the Brick-like button.

9. Then click the Save button to save the changes.

10. After saving, the last step is to publish the changed 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 codes are working correctly.

Setting the module in the schedule

Your module is now created in WitCloud 📊. The final step is to determine the time range for which you need to retrieve historical data. The schedule for retrieving current data will be created automatically.

Enter the appropriate range and click the Finish button.