Google Analytics | Ecommerce Product Standard Dataset (non Enhanced Ecommerce)

Below are the measures and dimensions Alight Analytics considers standard for Google Analytics - Ecommerce dataset. There is a one day lag on Google Analytics and data is pulled for the previous three days, after which Google guarantees the data to be unchanged.

 

Field Name Field Type Description
Report Date Date  The date the activity occurred
Source String The source of referrals. For manual campaign tracking, it is the value of the utm_source campaign tracking parameter. For AdWords autotagging, it is google. If you use neither, it is the domain of the source (e.g., document.referrer) referring the users. It may also contain a port address. If users arrived without a referrer, its value is (direct).
Medium String The type of referrals. For manual campaign tracking, it is the value of the utm_medium campaign tracking parameter. For AdWords autotagging, it is cpc. If users came from a search engine detected by Google Analytics, it is organic. If the referrer is not a search engine, it is referral. If users came directly to the property and document.referrer is empty, its value is (none).
Campaign String For manual campaign tracking, it is the value of the utm_campaign campaign tracking parameter. For AdWords autotagging, it is the name(s) of the online ad campaign(s) you use for the property. If you use neither, its value is (not set).
Ad Content String For manual campaign tracking, it is the value of the utm_content campaign tracking parameter. For AdWords autotagging, it is the first line of the text for the online Ad campaign. If you use mad libs for the AdWords content, it contains the keywords you provided for the mad libs keyword match. If you use none of the above, its value is (not set).
Device Category String The type of device: desktop, tablet, or mobile.
Product Category String Any product variation (size, color) supplied by the ecommerce application for purchased items, not compatible with Enhanced Ecommerce.
Product Name String The product name, supplied by the ecommerce tracking application, for purchased items.
Product SKU String The product SKU, defined in the ecommerce tracking application, for purchased items.
Unique Purchases Integer The number of product sets purchased. For example, if users purchase 2 frisbees and 5 tennis balls from the site, this will be 2.
Item Quantity Integer Total number of items purchased. For example, if users purchase 2 frisbees and 5 tennis balls, this will be 7.
Item Revenue Money The total revenue from purchased product items.
Insert Date  Time  The time the record was inserted into ChannelMix 
ChannelMix Profile  String  Distinguishes between Google Analytics Views in ChannelMix

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.