Below are the measures and dimensions Alight Analytics considers standard for Google Analytics - Ecommerce Time Analysis 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)|
|Hour||String||A two-digit hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time. If the timezone follows daylight savings time, there will be an apparent bump in the number of sessions during the changeover hour (e.g., between 1:00 and 2:00) for the day per year when that hour repeats. A corresponding hour with zero sessions will occur at the opposite changeover. (Google Analytics does not track user time more precisely than hours.)|
|Device Category||String||The type of device: desktop, tablet, or mobile|
|Channel Grouping||String||The Channel Group associated with an end user's session for this View (defined by the View's Channel Groupings|
A field created by ChannelMix using the Source, Medium, and Channel Grouping that is intended to provide more consistency to the channel by bucketing it into easily identifiable categories like Paid Social, Organic Social, Paid Search, Organic Search, Email, Display, etc.
|Transactions||Integer||The total number of transactions|
|Insert Date||Time||The time the record was inserted into ChannelMix|
|ChannelMix Profile||String||Distinguishes between Google Analytics Views in ChannelMix|