Setup Google Analytics Hit Data Extractor in Electrik.AI

Introduction

The Google Analytics Standard is a free service provided by Google Of course, it will have many limitations. Even though technically you can extract data out of Google Analytics there are few problems

  1. It is very difficult to write program with their APIs to get the data
  2. The event/hit data does not provide a Unique Visitor Id hence the data cannot integrate with other omnichannel marketing data such as MailChimp, CRM and others.

The “Google Analytics Hit Data Extractor” is designed to extract hit level data from Google Analytics and provide it in files or database. The current list of destinations is provided here. 

Data Schema

The following is an overview of the dimensions and metrics Electrik.AI can extract from Google Analytics.

The eai_ dimensions (e.g. eai_session_id) are generated by Electrik.AI and added to Google Analytics.
All Google Analytics dimension and metrics are renamed from ga: to ga_. For example, ga_pagepath is the renamed version of ga:pagePath.

IndexCategoryElectrik.AI Column NameScopeDescription
1Electrik.AIeai_client_idUserGA Client ID
2Electrik.AIeai_session_idSessionUnique Session Identifier
3Electrik.AIeai_event_in_visitor_tzHitTimestamp of Hit in Visitor’s timezone
4Electrik.AIeai_vidUserUnique Visitor Identifier
5Electrik.AIeai_hit_typeHitType of hit (pageview,event,transaction, etc.)
6Electrik.AIeai_hit_orderHitOrder of hits in a Session
7Electrik.AIeai_pageview_orderHitOrder of pageviews in a Session
8Electrik.AIeai_event_in_utc_dtHitDate of Hit in UTC timezone
9Electrik.AIeai_event_in_visitor_dtHitDate of Hit in Visitor’s timezone
10Electrik.AIeai_ga_property_idHitGA Property ID
11Electrik.AIeai_ga_view_idHitGA View ID
12Adwordsga_addestinationurlSessionga:adDestinationUrl
13Adwordsga_addisplayurlSessionga:adDisplayUrl
14Adwordsga_addistributionnetworkSessionga:adDistributionNetwork
15Adwordsga_adformatSessionga:adFormat
16Adwordsga_adgroupSessionga:adGroup
17Adwordsga_adkeywordmatchtypeSessionga:adKeywordMatchType
18Adwordsga_admatchedquerySessionga:adMatchedQuery
19Adwordsga_admatchtypeSessionga:adMatchType
20Adwordsga_adplacementdomainSessionga:adPlacementDomain
21Adwordsga_adplacementurlSessionga:adPlacementUrl
22Adwordsga_adquerywordcountSessionga:adQueryWordCount
23Adwordsga_adslotSessionga:adSlot
24Adwordsga_adtargetingoptionSessionga:adTargetingOption
25Adwordsga_adtargetingtypeSessionga:adTargetingType
26Adwordsga_adwordsadgroupidSessionga:adwordsAdGroupID
27Adwordsga_adwordscampaignidSessionga:adwordsCampaignID
28Adwordsga_adwordscreativeidSessionga:adwordsCreativeID
29Adwordsga_adwordscriteriaidSessionga:adwordsCriteriaID
30Adwordsga_adwordscustomeridSessionga:adwordsCustomerID
31Adwordsga_istrueviewvideoadSessionga:isTrueViewVideoAd
32App Trackingga_appidSessionga:appId
33App Trackingga_appinstalleridSessionga:appInstallerId
34App Trackingga_appnameSessionga:appName
35App Trackingga_appversionSessionga:appVersion
37App Trackingga_exitscreennameHitga:exitScreenName
38App Trackingga_landingscreennameHitga:landingScreenName
39App Trackingga_screendepthHitga:screenDepth
40App Trackingga_screennameHitga:screenName
41App Trackingga_screenviewsHitga:screenViews
42App Trackingga_timeonscreenHitga:timeOnScreen
43Channel Groupingga_channelgroupingSessionga:channelGrouping
44Content Experimentsga_experimentidHitga:experimentId
45Content Experimentsga_experimentvariantHitga:experimentVariant
46Custom Variablesga_dimension1Hitga:dimension1
47Custom Variablesga_dimension10Hitga:dimension10
48Custom Variablesga_dimension11Hitga:dimension11
49Custom Variablesga_dimension12Hitga:dimension12
50Custom Variablesga_dimension13Hitga:dimension13
51Custom Variablesga_dimension14Hitga:dimension14
52Custom Variablesga_dimension15Hitga:dimension15
53Custom Variablesga_dimension16Hitga:dimension16
54Custom Variablesga_dimension17Hitga:dimension17
55Custom Variablesga_dimension18Hitga:dimension18
56Custom Variablesga_dimension19Hitga:dimension19
57Custom Variablesga_dimension2Hitga:dimension2
58Custom Variablesga_dimension20Hitga:dimension20
59Custom Variablesga_dimension3Hitga:dimension3
60Custom Variablesga_dimension4Hitga:dimension4
61Custom Variablesga_dimension5Hitga:dimension5
62Custom Variablesga_dimension6Hitga:dimension6
63Custom Variablesga_dimension7Hitga:dimension7
64Custom Variablesga_dimension8Hitga:dimension8
65Custom Variablesga_dimension9Hitga:dimension9
66Custom Variablesga_metric1Hitga:metric1
67Custom Variablesga_metric10Hitga:metric10
68Custom Variablesga_metric11Hitga:metric11
69Custom Variablesga_metric12Hitga:metric12
70Custom Variablesga_metric13Hitga:metric13
71Custom Variablesga_metric14Hitga:metric14
72Custom Variablesga_metric15Hitga:metric15
73Custom Variablesga_metric16Hitga:metric16
74Custom Variablesga_metric17Hitga:metric17
75Custom Variablesga_metric18Hitga:metric18
76Custom Variablesga_metric19Hitga:metric19
77Custom Variablesga_metric2Hitga:metric2
78Custom Variablesga_metric20Hitga:metric20
79Custom Variablesga_metric3Hitga:metric3
80Custom Variablesga_metric4Hitga:metric4
81Custom Variablesga_metric5Hitga:metric5
82Custom Variablesga_metric6Hitga:metric6
83Custom Variablesga_metric7Hitga:metric7
84Custom Variablesga_metric8Hitga:metric8
85Custom Variablesga_metric9Hitga:metric9
86Ecommercega_affiliation ga:affiliation
87Ecommercega_checkoutoptions ga:checkoutOptions
88Ecommercega_currencycode ga:currencyCode
89Ecommercega_daystotransactionProductga:daysToTransaction
90Ecommercega_internalpromotionclicks ga:internalPromotionClicks
91Ecommercega_internalpromotioncreative ga:internalPromotionCreative
92Ecommercega_internalpromotionid ga:internalPromotionId
93Ecommercega_internalpromotionname ga:internalPromotionName
94Ecommercega_internalpromotionposition ga:internalPromotionPosition
95Ecommercega_internalpromotionviews ga:internalPromotionViews
96Ecommercega_itemquantity ga:itemQuantity
97Ecommercega_itemrevenue ga:itemRevenue
98Ecommercega_localitemrevenue ga:localItemRevenue
99Ecommercega_localproductrefundamount ga:localProductRefundAmount
100Ecommercega_localrefundamount ga:localRefundAmount
101Ecommercega_localtransactionrevenue ga:localTransactionRevenue
102Ecommercega_localtransactionshipping ga:localTransactionShipping
103Ecommercega_localtransactiontax ga:localTransactionTax
104Ecommercega_ordercouponcode ga:orderCouponCode
105Ecommercega_productaddstocart ga:productAddsToCart
106Ecommercega_productbrand ga:productBrand
107Ecommercega_productcategory ga:productCategory
108Ecommercega_productcategoryhierarchy ga:productCategoryHierarchy
109Ecommercega_productcheckouts ga:productCheckouts
110Ecommercega_productcouponcode ga:productCouponCode
111Ecommercega_productdetailviews ga:productDetailViews
112Ecommercega_productlistclicks ga:productListClicks
113Ecommercega_productlistname ga:productListName
114Ecommercega_productlistposition ga:productListPosition
115Ecommercega_productlistviews ga:productListViews
116Ecommercega_productname ga:productName
117Ecommercega_productrefundamount ga:productRefundAmount
118Ecommercega_productrefunds ga:productRefunds
119Ecommercega_productremovesfromcart ga:productRemovesFromCart
120Ecommercega_productsku ga:productSku
121Ecommercega_productvariant ga:productVariant
122Ecommercega_quantityaddedtocart ga:quantityAddedToCart
123Ecommercega_quantitycheckedout ga:quantityCheckedOut
124Ecommercega_quantityrefunded ga:quantityRefunded
125Ecommercega_quantityremovedfromcart ga:quantityRemovedFromCart
126Ecommercega_refundamount ga:refundAmount
127Ecommercega_sessionstotransactionProductga:sessionsToTransaction
128Ecommercega_shoppingstage ga:shoppingStage
129Ecommercega_totalrefunds ga:totalRefunds
130Ecommercega_totalvalue ga:totalValue
131Ecommercega_transactionid ga:transactionId
132Ecommercega_transactionrevenue ga:transactionRevenue
133Ecommercega_transactionshipping ga:transactionShipping
134Ecommercega_transactiontax ga:transactionTax
135Ecommercega_uniquepurchases ga:uniquePurchases
136Event Trackingga_eventactionHitga:eventAction
137Event Trackingga_eventcategoryHitga:eventCategory
138Event Trackingga_eventlabelHitga:eventLabel
139Event Trackingga_eventvalueHitga:eventValue
140Event Trackingga_totaleventsHitga:totalEvents
141Exceptionsga_exceptiondescription ga:exceptionDescription
142Exceptionsga_exceptions ga:exceptions
143Exceptionsga_fatalexceptions ga:fatalExceptions
144Geo Networkga_citySessionga:city
145Geo Networkga_cityidSessionga:cityId
146Geo Networkga_continentSessionga:continent
147Geo Networkga_continentidSessionga:continentId
148Geo Networkga_countrySessionga:country
149Geo Networkga_countryisocodeSessionga:countryIsoCode
150Geo Networkga_latitudeSessionga:latitude
151Geo Networkga_longitudeSessionga:longitude
152Geo Networkga_metroSessionga:metro
153Geo Networkga_metroidSessionga:metroId
154Geo Networkga_networkdomainSessionga:networkDomain
155Geo Networkga_networklocationSessionga:networkLocation
156Geo Networkga_regionSessionga:region
157Geo Networkga_regionidSessionga:regionId
158Geo Networkga_regionisocodeSessionga:regionIsoCode
159Geo Networkga_subcontinentSessionga:subContinent
160Geo Networkga_subcontinentcodeSessionga:subContinentCode
161Goal Conversionsga_goal10completionsHitga:goal10Completions
162Goal Conversionsga_goal10startsHitga:goal10Starts
163Goal Conversionsga_goal10valueHitga:goal10Value
164Goal Conversionsga_goal11completionsHitga:goal11Completions
165Goal Conversionsga_goal11startsHitga:goal11Starts
166Goal Conversionsga_goal11valueHitga:goal11Value
167Goal Conversionsga_goal12completionsHitga:goal12Completions
168Goal Conversionsga_goal12startsHitga:goal12Starts
169Goal Conversionsga_goal12valueHitga:goal12Value
170Goal Conversionsga_goal13completionsHitga:goal13Completions
171Goal Conversionsga_goal13startsHitga:goal13Starts
172Goal Conversionsga_goal13valueHitga:goal13Value
173Goal Conversionsga_goal14completionsHitga:goal14Completions
174Goal Conversionsga_goal14startsHitga:goal14Starts
175Goal Conversionsga_goal14valueHitga:goal14Value
176Goal Conversionsga_goal15completionsHitga:goal15Completions
177Goal Conversionsga_goal15startsHitga:goal15Starts
178Goal Conversionsga_goal15valueHitga:goal15Value
179Goal Conversionsga_goal16completionsHitga:goal16Completions
180Goal Conversionsga_goal16startsHitga:goal16Starts
181Goal Conversionsga_goal16valueHitga:goal16Value
182Goal Conversionsga_goal17completionsHitga:goal17Completions
183Goal Conversionsga_goal17startsHitga:goal17Starts
184Goal Conversionsga_goal17valueHitga:goal17Value
185Goal Conversionsga_goal18completionsHitga:goal18Completions
186Goal Conversionsga_goal18startsHitga:goal18Starts
187Goal Conversionsga_goal18valueHitga:goal18Value
188Goal Conversionsga_goal19completionsHitga:goal19Completions
189Goal Conversionsga_goal19startsHitga:goal19Starts
190Goal Conversionsga_goal19valueHitga:goal19Value
191Goal Conversionsga_goal1completionsHitga:goal1Completions
192Goal Conversionsga_goal1startsHitga:goal1Starts
193Goal Conversionsga_goal1valueHitga:goal1Value
194Goal Conversionsga_goal20completionsHitga:goal20Completions
195Goal Conversionsga_goal20startsHitga:goal20Starts
196Goal Conversionsga_goal20valueHitga:goal20Value
197Goal Conversionsga_goal2completionsHitga:goal2Completions
198Goal Conversionsga_goal2startsHitga:goal2Starts
199Goal Conversionsga_goal2valueHitga:goal2Value
200Goal Conversionsga_goal3completionsHitga:goal3Completions
201Goal Conversionsga_goal3startsHitga:goal3Starts
202Goal Conversionsga_goal3valueHitga:goal3Value
203Goal Conversionsga_goal4completionsHitga:goal4Completions
204Goal Conversionsga_goal4startsHitga:goal4Starts
205Goal Conversionsga_goal4valueHitga:goal4Value
206Goal Conversionsga_goal5completionsHitga:goal5Completions
207Goal Conversionsga_goal5startsHitga:goal5Starts
208Goal Conversionsga_goal5valueHitga:goal5Value
209Goal Conversionsga_goal6completionsHitga:goal6Completions
210Goal Conversionsga_goal6startsHitga:goal6Starts
211Goal Conversionsga_goal6valueHitga:goal6Value
212Goal Conversionsga_goal7completionsHitga:goal7Completions
213Goal Conversionsga_goal7startsHitga:goal7Starts
214Goal Conversionsga_goal7valueHitga:goal7Value
215Goal Conversionsga_goal8completionsHitga:goal8Completions
216Goal Conversionsga_goal8startsHitga:goal8Starts
217Goal Conversionsga_goal8valueHitga:goal8Value
218Goal Conversionsga_goal9completionsHitga:goal9Completions
219Goal Conversionsga_goal9startsHitga:goal9Starts
220Goal Conversionsga_goal9valueHitga:goal9Value
221Goal Conversionsga_goalcompletionlocationHitga:goalCompletionLocation
222Goal Conversionsga_goalcompletionsallHitga:goalCompletionsAll
223Goal Conversionsga_goalpreviousstep1Hitga:goalPreviousStep1
224Goal Conversionsga_goalpreviousstep2Hitga:goalPreviousStep2
225Goal Conversionsga_goalpreviousstep3Hitga:goalPreviousStep3
226Goal Conversionsga_goalstartsallHitga:goalStartsAll
227Goal Conversionsga_goalvalueallHitga:goalValueAll
228Internal Searchga_searchafterdestinationpageHitga:searchAfterDestinationPage
229Internal Searchga_searchcategoryHitga:searchCategory
230Internal Searchga_searchdestinationpageHitga:searchDestinationPage
231Internal Searchga_searchexitsHitga:searchExits
232Internal Searchga_searchkeywordHitga:searchKeyword
233Internal Searchga_searchkeywordrefinementHitga:searchKeywordRefinement
234Internal Searchga_searchrefinementsHitga:searchRefinements
235Internal Searchga_searchstartpageHitga:searchStartPage
236Internal Searchga_searchuniquesHitga:searchUniques
237Internal Searchga_searchusedSessionga:searchUsed
238Page Trackingga_exitpagepathHitga:exitPagePath
239Page Trackingga_exitsHitga:exits
240Page Trackingga_hostnameHitga:hostname
241Page Trackingga_landingpagepathHitga:landingPagePath
242Page Trackingga_pagedepthSessionga:pageDepth
243Page Trackingga_pagepathHitga:pagePath
244Page Trackingga_pagepathlevel1Hitga:pagePathLevel1
245Page Trackingga_pagepathlevel2Hitga:pagePathLevel2
246Page Trackingga_pagepathlevel3Hitga:pagePathLevel3
247Page Trackingga_pagepathlevel4Hitga:pagePathLevel4
248Page Trackingga_pagetitleHitga:pageTitle
249Page Trackingga_pagevalueHitga:pageValue
250Page Trackingga_pageviewsHitga:pageviews
251Page Trackingga_previouspagepathHitga:previousPagePath
252Page Trackingga_secondpagepathHitga:secondPagePath
253Page Trackingga_timeonpageSessionga:timeOnPage
254Platform or Devicega_browserSessionga:browser
255Platform or Devicega_browsersizeSessionga:browserSize
256Platform or Devicega_browserversionSessionga:browserVersion
257Platform or Devicega_datasourceHitga:dataSource
258Platform or Devicega_devicecategorySessionga:deviceCategory
259Platform or Devicega_mobiledevicebrandingSessionga:mobileDeviceBranding
260Platform or Devicega_mobiledeviceinfoSessionga:mobileDeviceInfo
261Platform or Devicega_mobiledevicemarketingnameSessionga:mobileDeviceMarketingName
262Platform or Devicega_mobiledevicemodelSessionga:mobileDeviceModel
263Platform or Devicega_mobileinputselectorSessionga:mobileInputSelector
264Platform or Devicega_operatingsystemSessionga:operatingSystem
265Platform or Devicega_operatingsystemversionSessionga:operatingSystemVersion
266Sessionga_bouncesHitga:bounces
267Sessionga_sessiondurationHitga:sessionDuration
268Sessionga_sessiondurationbucketSessionga:sessionDurationBucket
269Sessionga_sessionsHitga:sessions
270Site Speedga_domainlookuptimeHitga:domainLookupTime
271Site Speedga_domcontentloadedtimeHitga:domContentLoadedTime
272Site Speedga_dominteractivetimeHitga:domInteractiveTime
273Site Speedga_domlatencymetricssample ga:domLatencyMetricsSample
274Site Speedga_pagedownloadtimeHitga:pageDownloadTime
275Site Speedga_pageloadsampleHitga:pageLoadSample
276Site Speedga_pageloadtimeHitga:pageLoadTime
277Site Speedga_redirectiontimeHitga:redirectionTime
278Site Speedga_serverconnectiontimeHitga:serverConnectionTime
279Site Speedga_serverresponsetimeHitga:serverResponseTime
280Site Speedga_speedmetricssample ga:speedMetricsSample
281Social Interactionsga_socialengagementtypeHitga:socialEngagementType
282Social Interactionsga_socialinteractionnetworkHitga:socialInteractionNetwork
283Social Interactionsga_socialinteractionnetworkactionHitga:socialInteractionNetworkAction
284Social Interactionsga_socialinteractiontargetHitga:socialInteractionTarget
285Systemga_flashversionSessionga:flashVersion
286Systemga_javaenabledSessionga:javaEnabled
287Systemga_languageSessionga:language
288Systemga_screencolorsSessionga:screenColors
289Systemga_screenresolutionSessionga:screenResolution
290Systemga_sourcepropertydisplaynameSessionga:sourcePropertyDisplayName
291Systemga_sourcepropertytrackingidSessionga:sourcePropertyTrackingId
292Traffic Sourcesga_adcontentSessionga:adContent
293Traffic Sourcesga_campaignSessionga:campaign
294Traffic Sourcesga_campaigncodeSessionga:campaignCode
295Traffic Sourcesga_fullreferrerSessionga:fullReferrer
296Traffic Sourcesga_hassocialsourcereferralSessionga:hasSocialSourceReferral
297Traffic Sourcesga_keywordSessionga:keyword
298Traffic Sourcesga_mediumSessionga:medium
299Traffic Sourcesga_organicsearchesHitga:organicSearches
300Traffic Sourcesga_referralpathSessionga:referralPath
301Traffic Sourcesga_socialnetworkSessionga:socialNetwork
302Traffic Sourcesga_sourceSessionga:source
303Traffic Sourcesga_sourcemediumSessionga:sourceMedium
304Userga_dayssincelastsessionSessionga:daysSinceLastSession
305Userga_hitsHitga:hits
306Userga_newusersHitga:newUsers
307Userga_sessioncountSessionga:sessionCount
308Userga_sessionsperuserUserga:sessionsPerUser
309Userga_userdefinedvalueSessionga:userDefinedValue
310Userga_usertypeSessionga:userType
311User Timingsga_usertimingcategoryUserga:userTimingCategory
312User Timingsga_usertiminglabelUserga:userTimingLabel
313User Timingsga_usertimingvariableUserga:userTimingVariable
314Electrik.AIetl_org  
315Electrik.AIetl_project  
316Electrik.AIetl_start_utc_dttm  
317Electrik.AIetl_create_utc_dttm  
318Electrik.AIetl_update_utc_dttm  
319Electrik.AIetl_flow_nm  
320Electrik.AIetl_flow_instance_id 
321Social Interactionsga_socialinteractionactionHitga:socialInteractionAction