Docs

Google Analytics Hit Data Extractor

What is Google Analytics Hit Data Extractor?

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. You need to build a custom solution using Google Analytics APIs to export data
2. The event/hit data exported from Google Analytics does not provide a Unique Visitor Id, hence the data cannot be integrated with other omnichannel marketing data sources such as Mailchimp, Shopify and other CRM systems. .

Google Analytics Hit Data Extractor by Electrik.AI is designed to export hit level data from Google Analytics and load it in files or database.

How to add a Google Analytics Source Connection in Electrik.AI?

Follow these steps to connect your Google Analytics account to Electrik.AI

Step 1: Ensure you have following prerequisites to create a Google Analytics Connection in Electrik.AI

a. Access to Google Analytics Account.

b. Google Analytics Account User Id and Password.

c. Google Analytics Property Id; View Id details.

d. Google Analytics Tag manager account and Tag container details.

Step 2: Sign-in into your Electrik.AI account

Step 3: Select IO in Electrik.AI dashboard

Select IO in Electrik.AI dashboard

Step 4: Select the Connections tab in the left most panel.

Select-the-Connections-tab-in-the-left-most-navigation-bar-click-on-Add-action-

Step 5: The Source default tab is selected just click on “Google Analytics v3-Hit Level Data” connection.

Step 6: Choose the option that you are currently using with your Google Analytics.

Step 7: Provide your Google Analytics account User Id and Password.

Provide your Google Analytics account User Id and Passwor-ElectrikAI
Succesfully Google Analytics account-ElectrikAI

How to add a Google Analytics Source Connection using Google Tag Manager option?

Step 8:  Allow Electrik.AI to access your Google Analytics account. Access permission for Google Tag Manager option.

Allow Electrik.AI to access your Google Analytics account-ElectrikAI

Step 9: Select the Google Analytics Account details from the dropdown whose data you wish to export.

Select Advanced Setting Checkbox if you wish to edit the default Session timeout settings.

Step 10: Click on Save button on the top.

Congratulations, you have successfully created a Google Analytics Connection using Google Tag Manager in Electrik.AI.

How to add a Google Analytics Source Connection using G Tag option?

Step 8: Allow Electrik.AI to access your Google Analytics account. Access permission for G Tag option.

Step 9: Select the Google Analytics Account details from the dropdown whose data you wish to export.

Select Advanced Setting Checkbox if you wish to edit the default Session timeout settings.

Step 10: Click on Save button on the top.

Congratulations, you have successfully created a Google Analytics Connection using GTag option in Electrik.AI

Step 11: Add this script to header/footer/body tag of your Website URL to complete the setup. This script will capture hit level data from your website and send it to Google Analytics.

What are the supported Data Destinations?

Electrik.AI supports the following databases and Cloud Storage to extract Google Analytics Data. A destination is required to extract data from various marketing data sources using Electrik.AI

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Google Big Query Data Destination-Elecrik.AI
Amazon S3-ElectrikAI
Dropbox Data Destination-Eletrik.AI
Google Cloud Storage Data Destination-Eletrik.AI
Google Drive Data Destination-Electrik.AI
One Drive Data Destination-Eletrik.AI
Amazon-Redshift-Data-Destination-Electrik.AI
EletrikAI
Snowflake-Data-Destination-Electrik.AI
Azure-Data-Lake -Storage-Data-Destination-Electrik.AI

How to export Google Analytics Data?

Electrik.AI creates a data flow (or ETL process) that exports Google Analytics data to a target database or data warehouse or cloud storage. This process runs daily at scheduled time and exports data for the previous day.

Follow these steps to create a Data Flow from Google Analytics to Amazon S3

Step 1: Ensure you have the following prerequisites.

  1. Access to Google Analytics Account.
  2. Google Analytics Account User Id and Password.
  3. Google Analytics Property Id; View Id details.
  4. Google Analytics Tag manager account and Tag container details.
  5. Access to destination of your choice.
  6. Database Connection Details such as Host, Port, DB Name, DB User, DB Password in case you wish to extract to Database.
  7. Cloud storage Account User Id and Password in case you wish to extract your data in a file.

Step 2: Sign-in into your Electrik.AI account

Step 3: Select IO in Electrik.AI dashboard

Select IO in Electrik.AI dashboard

Step 4: Click on Add button to create a Google Analytics Hit Data Extractor Flow.

Click on Add button to create a Microsoft Ads Flow

Step 5: Select Google Analytics Connection present in the list of available source.

Step 6: Select your existing Google Analytics connection in Electrik.AI.

To Configure a new connection, refer to this link.

Step 7: Click on a destination of your choice from list of available destinations.
In this example we are choosing Amazon S3.

Click on a destination of your choice from list of available destinations.

Step 8: Select your existing Amazon S3 connection in Electrik.AI.

To Configure a new connection, refer to this link.

Step 9:
a. Review the Data Source, Data Destination
b. Default File Path/Name is provided, you can provide any name of your choice.
c. You can click here for more information on possible file naming conventions.
d. Click to choose File Separator type between CSV and TAB.
e. Select the Bucket where you wish to load the file.
f. Provide Success Notification Email, Failure Notification Email.
g. Click “Save and Proceed” to continue.

Success Notification Email: Enter a valid Email ID to receive the Flow Success Email Notification.
Failure Notification Email: Enter a valid Email ID to receive the Flow Failure Email Notification.
Note: By Default, Electrik.AI uses the signed-in user’s Email Id.

Step 10: Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen.

You have now successfully setup Google Analytics Performance Report to Amazon S3 flow in Electrik.AI.

Your Google Analytics data will start loading after 24 hours in your Amazon S3 Bucket.

Your Google Analytics data will start loading after 24 hours in your Amazon S3 Bucket-ElectrikAI

Data Schema

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

Click to view

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:<name> to ga_<name>. For example, ga_pagepath is the renamed version of ga:pagePath.

Index Category Electrik.AI Column Name Description Sample Value
1 Electrik.AI eai_client_id User GA Client ID
2 Electrik.AI eai_session_id Session Unique Session Identifier
3 Electrik.AI eai_event_in_visitor_tz Hit Timestamp of Hit in Visitor's timezone
4 Electrik.AI eai_vid User Unique Visitor Identifier
5 Electrik.AI eai_hit_type Hit Type of hit (pageview,event,transaction, etc.)
6 Electrik.AI eai_hit_order Hit Order of hits in a Session
7 Electrik.AI eai_pageview_order Hit Order of pageviews in a Session
8 Electrik.AI eai_event_in_utc_dt Hit Date of Hit in UTC timezone
9 Electrik.AI eai_event_in_visitor_dt Hit Date of Hit in Visitor's timezone
10 Electrik.AI eai_ga_property_id Hit GA Property ID
11 Electrik.AI eai_ga_view_id Hit GA View ID
12 Adwords ga_addestinationurl Session ga:adDestinationUrl
13 Adwords ga_addisplayurl Session ga:adDisplayUrl
14 Adwords ga_addistributionnetwork Session ga:adDistributionNetwork
15 Adwords ga_adformat Session ga:adFormat
16 Adwords ga_adgroup Session ga:adGroup
17 Adwords ga_adkeywordmatchtype Session ga:adKeywordMatchType
18 Adwords ga_admatchedquery Session ga:adMatchedQuery
19 Adwords ga_admatchtype Session ga:adMatchType
20 Adwords ga_adplacementdomain Session ga:adPlacementDomain
21 Adwords ga_adplacementurl Session ga:adPlacementUrl
22 Adwords ga_adquerywordcount Session ga:adQueryWordCount
23 Adwords ga_adslot Session ga:adSlot
24 Adwords ga_adtargetingoption Session ga:adTargetingOption
25 Adwords ga_adtargetingtype Session ga:adTargetingType
26 Adwords ga_adwordsadgroupid Session ga:adwordsAdGroupID
27 Adwords ga_adwordscampaignid Session ga:adwordsCampaignID
28 Adwords ga_adwordscreativeid Session ga:adwordsCreativeID
29 Adwords ga_adwordscriteriaid Session ga:adwordsCriteriaID
30 Adwords ga_adwordscustomerid Session ga:adwordsCustomerID
31 Adwords ga_istrueviewvideoad Session ga:isTrueViewVideoAd
32 App Tracking ga_appid Session ga:appId
33 App Tracking ga_appinstallerid Session ga:appInstallerId
34 App Tracking ga_appname Session ga:appName
35 App Tracking ga_appversion Session ga:appVersion
37 App Tracking ga_exitscreenname Hit ga:exitScreenName
38 App Tracking ga_landingscreenname Hit ga:landingScreenName
39 App Tracking ga_screendepth Hit ga:screenDepth
40 App Tracking ga_screenname Hit ga:screenName
41 App Tracking ga_screenviews Hit ga:screenViews
42 App Tracking ga_timeonscreen Hit ga:timeOnScreen
43 Channel Grouping ga_channelgrouping Session ga:channelGrouping
44 Content Experiments ga_experimentid Hit ga:experimentId
45 Content Experiments ga_experimentvariant Hit ga:experimentVariant
46 Custom Variables ga_dimension1 Hit ga:dimension1
47 Custom Variables ga_dimension10 Hit ga:dimension10
48 Custom Variables ga_dimension11 Hit ga:dimension11
49 Custom Variables ga_dimension12 Hit ga:dimension12
50 Custom Variables ga_dimension13 Hit ga:dimension13
51 Custom Variables ga_dimension14 Hit ga:dimension14
52 Custom Variables ga_dimension15 Hit ga:dimension15
53 Custom Variables ga_dimension16 Hit ga:dimension16
54 Custom Variables ga_dimension17 Hit ga:dimension17
55 Custom Variables ga_dimension18 Hit ga:dimension18
56 Custom Variables ga_dimension19 Hit ga:dimension19
57 Custom Variables ga_dimension2 Hit ga:dimension2
58 Custom Variables ga_dimension20 Hit ga:dimension20
59 Custom Variables ga_dimension3 Hit ga:dimension3
60 Custom Variables ga_dimension4 Hit ga:dimension4
61 Custom Variables ga_dimension5 Hit ga:dimension5
62 Custom Variables ga_dimension6 Hit ga:dimension6
63 Custom Variables ga_dimension7 Hit ga:dimension7
64 Custom Variables ga_dimension8 Hit ga:dimension8
65 Custom Variables ga_dimension9 Hit ga:dimension9
66 Custom Variables ga_metric1 Hit ga:metric1
67 Custom Variables ga_metric10 Hit ga:metric10
68 Custom Variables ga_metric11 Hit ga:metric11
69 Custom Variables ga_metric12 Hit ga:metric12
70 Custom Variables ga_metric13 Hit ga:metric13
71 Custom Variables ga_metric14 Hit ga:metric14
72 Custom Variables ga_metric15 Hit ga:metric15
73 Custom Variables ga_metric16 Hit ga:metric16
74 Custom Variables ga_metric17 Hit ga:metric17
75 Custom Variables ga_metric18 Hit ga:metric18
76 Custom Variables ga_metric19 Hit ga:metric19
77 Custom Variables ga_metric2 Hit ga:metric2
78 Custom Variables ga_metric20 Hit ga:metric20
79 Custom Variables ga_metric3 Hit ga:metric3
80 Custom Variables ga_metric4 Hit ga:metric4
81 Custom Variables ga_metric5 Hit ga:metric5
82 Custom Variables ga_metric6 Hit ga:metric6
83 Custom Variables ga_metric7 Hit ga:metric7
84 Custom Variables ga_metric8 Hit ga:metric8
85 Custom Variables ga_metric9 Hit ga:metric9
86 Ecommerce ga_affiliation   ga:affiliation
87 Ecommerce ga_checkoutoptions   ga:checkoutOptions
88 Ecommerce ga_currencycode   ga:currencyCode
89 Ecommerce ga_daystotransaction Product ga:daysToTransaction
90 Ecommerce ga_internalpromotionclicks   ga:internalPromotionClicks
91 Ecommerce ga_internalpromotioncreative   ga:internalPromotionCreative
92 Ecommerce ga_internalpromotionid   ga:internalPromotionId
93 Ecommerce ga_internalpromotionname   ga:internalPromotionName
94 Ecommerce ga_internalpromotionposition   ga:internalPromotionPosition
95 Ecommerce ga_internalpromotionviews   ga:internalPromotionViews
96 Ecommerce ga_itemquantity   ga:itemQuantity
97 Ecommerce ga_itemrevenue   ga:itemRevenue
98 Ecommerce ga_localitemrevenue   ga:localItemRevenue
99 Ecommerce ga_localproductrefundamount   ga:localProductRefundAmount
100 Ecommerce ga_localrefundamount   ga:localRefundAmount
101 Ecommerce ga_localtransactionrevenue   ga:localTransactionRevenue
102 Ecommerce ga_localtransactionshipping   ga:localTransactionShipping
103 Ecommerce ga_localtransactiontax   ga:localTransactionTax
104 Ecommerce ga_ordercouponcode   ga:orderCouponCode
105 Ecommerce ga_productaddstocart   ga:productAddsToCart
106 Ecommerce ga_productbrand   ga:productBrand
107 Ecommerce ga_productcategory   ga:productCategory
108 Ecommerce ga_productcategoryhierarchy   ga:productCategoryHierarchy
109 Ecommerce ga_productcheckouts   ga:productCheckouts
110 Ecommerce ga_productcouponcode   ga:productCouponCode
111 Ecommerce ga_productdetailviews   ga:productDetailViews
112 Ecommerce ga_productlistclicks   ga:productListClicks
113 Ecommerce ga_productlistname   ga:productListName
114 Ecommerce ga_productlistposition   ga:productListPosition
115 Ecommerce ga_productlistviews   ga:productListViews
116 Ecommerce ga_productname   ga:productName
117 Ecommerce ga_productrefundamount   ga:productRefundAmount
118 Ecommerce ga_productrefunds   ga:productRefunds
119 Ecommerce ga_productremovesfromcart   ga:productRemovesFromCart
120 Ecommerce ga_productsku   ga:productSku
121 Ecommerce ga_productvariant   ga:productVariant
122 Ecommerce ga_quantityaddedtocart   ga:quantityAddedToCart
123 Ecommerce ga_quantitycheckedout   ga:quantityCheckedOut
124 Ecommerce ga_quantityrefunded   ga:quantityRefunded
125 Ecommerce ga_quantityremovedfromcart   ga:quantityRemovedFromCart
126 Ecommerce ga_refundamount   ga:refundAmount
127 Ecommerce ga_sessionstotransaction Product ga:sessionsToTransaction
128 Ecommerce ga_shoppingstage   ga:shoppingStage
129 Ecommerce ga_totalrefunds   ga:totalRefunds
130 Ecommerce ga_totalvalue   ga:totalValue
131 Ecommerce ga_transactionid   ga:transactionId
132 Ecommerce ga_transactionrevenue   ga:transactionRevenue
133 Ecommerce ga_transactionshipping   ga:transactionShipping
134 Ecommerce ga_transactiontax   ga:transactionTax
135 Ecommerce ga_uniquepurchases   ga:uniquePurchases
136 Event Tracking ga_eventaction Hit ga:eventAction
137 Event Tracking ga_eventcategory Hit ga:eventCategory
138 Event Tracking ga_eventlabel Hit ga:eventLabel
139 Event Tracking ga_eventvalue Hit ga:eventValue
140 Event Tracking ga_totalevents Hit ga:totalEvents
141 Exceptions ga_exceptiondescription   ga:exceptionDescription
142 Exceptions ga_exceptions   ga:exceptions
143 Exceptions ga_fatalexceptions   ga:fatalExceptions
144 Geo Network ga_city Session ga:city
145 Geo Network ga_cityid Session ga:cityId
146 Geo Network ga_continent Session ga:continent
147 Geo Network ga_continentid Session ga:continentId
148 Geo Network ga_country Session ga:country
149 Geo Network ga_countryisocode Session ga:countryIsoCode
150 Geo Network ga_latitude Session ga:latitude
151 Geo Network ga_longitude Session ga:longitude
152 Geo Network ga_metro Session ga:metro
153 Geo Network ga_metroid Session ga:metroId
154 Geo Network ga_networkdomain Session ga:networkDomain
155 Geo Network ga_networklocation Session ga:networkLocation
156 Geo Network ga_region Session ga:region
157 Geo Network ga_regionid Session ga:regionId
158 Geo Network ga_regionisocode Session ga:regionIsoCode
159 Geo Network ga_subcontinent Session ga:subContinent
160 Geo Network ga_subcontinentcode Session ga:subContinentCode
161 Goal Conversions ga_goal10completions Hit ga:goal10Completions
162 Goal Conversions ga_goal10starts Hit ga:goal10Starts
163 Goal Conversions ga_goal10value Hit ga:goal10Value
164 Goal Conversions ga_goal11completions Hit ga:goal11Completions
165 Goal Conversions ga_goal11starts Hit ga:goal11Starts
166 Goal Conversions ga_goal11value Hit ga:goal11Value
167 Goal Conversions ga_goal12completions Hit ga:goal12Completions
168 Goal Conversions ga_goal12starts Hit ga:goal12Starts
169 Goal Conversions ga_goal12value Hit ga:goal12Value
170 Goal Conversions ga_goal13completions Hit ga:goal13Completions
171 Goal Conversions ga_goal13starts Hit ga:goal13Starts
172 Goal Conversions ga_goal13value Hit ga:goal13Value
173 Goal Conversions ga_goal14completions Hit ga:goal14Completions
174 Goal Conversions ga_goal14starts Hit ga:goal14Starts
175 Goal Conversions ga_goal14value Hit ga:goal14Value
176 Goal Conversions ga_goal15completions Hit ga:goal15Completions
177 Goal Conversions ga_goal15starts Hit ga:goal15Starts
178 Goal Conversions ga_goal15value Hit ga:goal15Value
179 Goal Conversions ga_goal16completions Hit ga:goal16Completions
180 Goal Conversions ga_goal16starts Hit ga:goal16Starts
181 Goal Conversions ga_goal16value Hit ga:goal16Value
182 Goal Conversions ga_goal17completions Hit ga:goal17Completions
183 Goal Conversions ga_goal17starts Hit ga:goal17Starts
184 Goal Conversions ga_goal17value Hit ga:goal17Value
185 Goal Conversions ga_goal18completions Hit ga:goal18Completions
186 Goal Conversions ga_goal18starts Hit ga:goal18Starts
187 Goal Conversions ga_goal18value Hit ga:goal18Value
188 Goal Conversions ga_goal19completions Hit ga:goal19Completions
189 Goal Conversions ga_goal19starts Hit ga:goal19Starts
190 Goal Conversions ga_goal19value Hit ga:goal19Value
191 Goal Conversions ga_goal1completions Hit ga:goal1Completions
192 Goal Conversions ga_goal1starts Hit ga:goal1Starts
193 Goal Conversions ga_goal1value Hit ga:goal1Value
194 Goal Conversions ga_goal20completions Hit ga:goal20Completions
195 Goal Conversions ga_goal20starts Hit ga:goal20Starts
196 Goal Conversions ga_goal20value Hit ga:goal20Value
197 Goal Conversions ga_goal2completions Hit ga:goal2Completions
198 Goal Conversions ga_goal2starts Hit ga:goal2Starts
199 Goal Conversions ga_goal2value Hit ga:goal2Value
200 Goal Conversions ga_goal3completions Hit ga:goal3Completions
201 Goal Conversions ga_goal3starts Hit ga:goal3Starts
202 Goal Conversions ga_goal3value Hit ga:goal3Value
203 Goal Conversions ga_goal4completions Hit ga:goal4Completions
204 Goal Conversions ga_goal4starts Hit ga:goal4Starts
205 Goal Conversions ga_goal4value Hit ga:goal4Value
206 Goal Conversions ga_goal5completions Hit ga:goal5Completions
207 Goal Conversions ga_goal5starts Hit ga:goal5Starts
208 Goal Conversions ga_goal5value Hit ga:goal5Value
209 Goal Conversions ga_goal6completions Hit ga:goal6Completions
210 Goal Conversions ga_goal6starts Hit ga:goal6Starts
211 Goal Conversions ga_goal6value Hit ga:goal6Value
212 Goal Conversions ga_goal7completions Hit ga:goal7Completions
213 Goal Conversions ga_goal7starts Hit ga:goal7Starts
214 Goal Conversions ga_goal7value Hit ga:goal7Value
215 Goal Conversions ga_goal8completions Hit ga:goal8Completions
216 Goal Conversions ga_goal8starts Hit ga:goal8Starts
217 Goal Conversions ga_goal8value Hit ga:goal8Value
218 Goal Conversions ga_goal9completions Hit ga:goal9Completions
219 Goal Conversions ga_goal9starts Hit ga:goal9Starts
220 Goal Conversions ga_goal9value Hit ga:goal9Value
221 Goal Conversions ga_goalcompletionlocation Hit ga:goalCompletionLocation
222 Goal Conversions ga_goalcompletionsall Hit ga:goalCompletionsAll
223 Goal Conversions ga_goalpreviousstep1 Hit ga:goalPreviousStep1
224 Goal Conversions ga_goalpreviousstep2 Hit ga:goalPreviousStep2
225 Goal Conversions ga_goalpreviousstep3 Hit ga:goalPreviousStep3
226 Goal Conversions ga_goalstartsall Hit ga:goalStartsAll
227 Goal Conversions ga_goalvalueall Hit ga:goalValueAll
228 Internal Search ga_searchafterdestinationpage Hit ga:searchAfterDestinationPage
229 Internal Search ga_searchcategory Hit ga:searchCategory
230 Internal Search ga_searchdestinationpage Hit ga:searchDestinationPage
231 Internal Search ga_searchexits Hit ga:searchExits
232 Internal Search ga_searchkeyword Hit ga:searchKeyword
233 Internal Search ga_searchkeywordrefinement Hit ga:searchKeywordRefinement
234 Internal Search ga_searchrefinements Hit ga:searchRefinements
235 Internal Search ga_searchstartpage Hit ga:searchStartPage
236 Internal Search ga_searchuniques Hit ga:searchUniques
237 Internal Search ga_searchused Session ga:searchUsed
238 Page Tracking ga_exitpagepath Hit ga:exitPagePath
239 Page Tracking ga_exits Hit ga:exits
240 Page Tracking ga_hostname Hit ga:hostname
241 Page Tracking ga_landingpagepath Hit ga:landingPagePath
242 Page Tracking ga_pagedepth Session ga:pageDepth
243 Page Tracking ga_pagepath Hit ga:pagePath
244 Page Tracking ga_pagepathlevel1 Hit ga:pagePathLevel1
245 Page Tracking ga_pagepathlevel2 Hit ga:pagePathLevel2
246 Page Tracking ga_pagepathlevel3 Hit ga:pagePathLevel3
247 Page Tracking ga_pagepathlevel4 Hit ga:pagePathLevel4
248 Page Tracking ga_pagetitle Hit ga:pageTitle
249 Page Tracking ga_pagevalue Hit ga:pageValue
250 Page Tracking ga_pageviews Hit ga:pageviews
251 Page Tracking ga_previouspagepath Hit ga:previousPagePath
252 Page Tracking ga_secondpagepath Hit ga:secondPagePath
253 Page Tracking ga_timeonpage Session ga:timeOnPage
254 Platform or Device ga_browser Session ga:browser
255 Platform or Device ga_browsersize Session ga:browserSize
256 Platform or Device ga_browserversion Session ga:browserVersion
257 Platform or Device ga_datasource Hit ga:dataSource
258 Platform or Device ga_devicecategory Session ga:deviceCategory
259 Platform or Device ga_mobiledevicebranding Session ga:mobileDeviceBranding
260 Platform or Device ga_mobiledeviceinfo Session ga:mobileDeviceInfo
261 Platform or Device ga_mobiledevicemarketingname Session ga:mobileDeviceMarketingName
262 Platform or Device ga_mobiledevicemodel Session ga:mobileDeviceModel
263 Platform or Device ga_mobileinputselector Session ga:mobileInputSelector
264 Platform or Device ga_operatingsystem Session ga:operatingSystem
265 Platform or Device ga_operatingsystemversion Session ga:operatingSystemVersion
266 Session ga_bounces Hit ga:bounces
267 Session ga_sessionduration Hit ga:sessionDuration
268 Session ga_sessiondurationbucket Session ga:sessionDurationBucket
269 Session ga_sessions Hit ga:sessions
270 Site Speed ga_domainlookuptime Hit ga:domainLookupTime
271 Site Speed ga_domcontentloadedtime Hit ga:domContentLoadedTime
272 Site Speed ga_dominteractivetime Hit ga:domInteractiveTime
273 Site Speed ga_domlatencymetricssample   ga:domLatencyMetricsSample
274 Site Speed ga_pagedownloadtime Hit ga:pageDownloadTime
275 Site Speed ga_pageloadsample Hit ga:pageLoadSample
276 Site Speed ga_pageloadtime Hit ga:pageLoadTime
277 Site Speed ga_redirectiontime Hit ga:redirectionTime
278 Site Speed ga_serverconnectiontime Hit ga:serverConnectionTime
279 Site Speed ga_serverresponsetime Hit ga:serverResponseTime
280 Site Speed ga_speedmetricssample   ga:speedMetricsSample
281 Social Interactions ga_socialengagementtype Hit ga:socialEngagementType
282 Social Interactions ga_socialinteractionnetwork Hit ga:socialInteractionNetwork
283 Social Interactions ga_socialinteractionnetworkaction Hit ga:socialInteractionNetworkAction
284 Social Interactions ga_socialinteractiontarget Hit ga:socialInteractionTarget
285 System ga_flashversion Session ga:flashVersion
286 System ga_javaenabled Session ga:javaEnabled
287 System ga_language Session ga:language
288 System ga_screencolors Session ga:screenColors
289 System ga_screenresolution Session ga:screenResolution
290 System ga_sourcepropertydisplayname Session ga:sourcePropertyDisplayName
291 System ga_sourcepropertytrackingid Session ga:sourcePropertyTrackingId
292 Traffic Sources ga_adcontent Session ga:adContent
293 Traffic Sources ga_campaign Session ga:campaign
294 Traffic Sources ga_campaigncode Session ga:campaignCode
295 Traffic Sources ga_fullreferrer Session ga:fullReferrer
296 Traffic Sources ga_hassocialsourcereferral Session ga:hasSocialSourceReferral
297 Traffic Sources ga_keyword Session ga:keyword
298 Traffic Sources ga_medium Session ga:medium
299 Traffic Sources ga_organicsearches Hit ga:organicSearches
300 Traffic Sources ga_referralpath Session ga:referralPath
301 Traffic Sources ga_socialnetwork Session ga:socialNetwork
302 Traffic Sources ga_source Session ga:source
303 Traffic Sources ga_sourcemedium Session ga:sourceMedium
304 User ga_dayssincelastsession Session ga:daysSinceLastSession
305 User ga_hits Hit ga:hits
306 User ga_newusers Hit ga:newUsers
307 User ga_sessioncount Session ga:sessionCount
308 User ga_sessionsperuser User ga:sessionsPerUser
309 User ga_userdefinedvalue Session ga:userDefinedValue
310 User ga_usertype Session ga:userType
311 User Timings ga_usertimingcategory User ga:userTimingCategory
312 User Timings ga_usertiminglabel User ga:userTimingLabel
313 User Timings ga_usertimingvariable User ga:userTimingVariable
314 Electrik.AI etl_org    
315 Electrik.AI etl_project    
316 Electrik.AI etl_start_utc_dttm    
317 Electrik.AI etl_create_utc_dttm    
318 Electrik.AI etl_update_utc_dttm    
319 Electrik.AI etl_flow_nm    
320 Electrik.AI etl_flow_instance_id  
321 Social Interactions ga_socialinteractionaction Hit ga:socialInteractionAction
Google Ads Data Export
Google Analytics Historical Data Extractor

On this page

What is Google Analytics Hit Data Extractor?
How to add a Google Analytics Source Connection in Electrik.AI?
Select either Tag Manager or gtag.js option to connect
How to add a Google Analytics Source Connection using Google Tag Manager option?
How to add a Google Analytics Source Connection using G Tag option?
What are the supported Data Destinations?
How to extract Google Analytics Data?
Data Schema