Google Analytics (Universal Analytics) | Ecommerce Product (non Enhanced Ecommerce)
Below are the fields ChannelMix 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 |
TIMESTAMP |
When the record was inserted into ChannelMix |
ChannelMix Profile |
STRING |
A segment of a ChannelMix Client's data. For Google Analytics (UA) the profile is associated to a Google Analytics View (may include segments and/or filters applied as well) |