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.

a. You need to write a build a custom solution using Google Analytics APIs to extract data.
b. The event/hit data 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 extract 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-ElectrikAI

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

Step 5: Click on “Add” action button.

Step 6: The Source default tab is selected just click on “Google Analytics” connection.

The Source default tab is selected just click on “Google Analytics” connection-ElectrikAI

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

Step 8: Allow Electrik.AI to access your Google Analytics account.

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 extract.

Select the Google Analytics Account details from the dropdown whose data you wish to export-ElectrikAI

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

Step 10: Click on Save button on the top.

Click on Save button on the top-ElectrikAI

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

What are the supported Data Destinations?

Electrik.AI supports the following databases and Cloud Storage to extract Google Analytics Data. It is important to note that Electrik.AI itself is not a destination. A destination is required to extract data from various marketing data sources using Electrik.AI

Google Big Query Data Destination-Elecrik.AI

Google Cloud Storage Data Destination-Eletrik.AI

Google Drive Data Destination-Electrik.AI

How to extract Google Analytics Data?

Electrik.AI creates a data flow (or ETL process) that extract Google Analytics data to a target database or data warehouse or cloud storage. This process runs daily at scheduled time and extract 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.

Access to Google Analytics Account.
Google Analytics Account User Id and Password.
Google Analytics Property Id; View Id details.
Google Analytics Tag manager account and Tag container details.
Access to a Database of your choice (PostgreSQL, MySQL, Azure SQL, BigQuery) or a cloud storage (Amazon S3, Dropbox, Google Cloud Storage, Google Drive, One Drive)
Database Connection Details such as Host, Port, DB Name, DB User, DB Password in case you wish to extract to Database.
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

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

Click on Add button to create a Google Analytics Hit Data Extractor Flow-ElectrikAI

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

Select Google Analytics Connection present in the list of available source-ElectrikAI

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 destination-ElectrikAI

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.

Review the Data Source, Data Destination-ElectrikAI

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.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen-ElectrikAI

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.

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	Scope	Description
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

Docs

APPLICATION

SOURCES

DESTINATIONS