Ecommerce

Columns

Name	Type	Dimension	DefaultMetric	DefaultDimension	Description
Date	Date	True			The date of the session formatted as YYYYMMDD.
Year	Integer	True			The year of the session. A four-digit year from 2005 to the current year.
Month	Integer	True			The month of the session. An integer from 01 to 12.
Week	Integer	True			The week of the session. A number from 01 to 53. Each week starts on Sunday.
Day	Integer	True			The day of the month. A number from 01 to 31.
Hour	Integer	True			An hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time.
Country	String	True			The country of users, derived from IP addresses.
City	String	True			The cities of property users, derived from IP addresses.
ProductName	String	True			The product name for purchased items, as supplied by your e-commerce tracking application.
ProductSku	String	True			The product SKUs for purchased items, as you have defined them in your e-commerce tracking application.
ProductCategory	String	True			Any product variations (e.g., size or color) for purchased items, as supplied by your e-commerce application.
TransactionId	String	True			The transaction ID for the shopping cart purchase.
Sessions	Integer	False	True		Counts the total number of sessions.
Users	Integer	False	True		Total number of users to your property for the requested time period.
Transactions	Integer	False	True		The total number of transactions.
TransactionRevenue	Decimal	False	True		The total sale revenue provided in the transaction, excluding shipping and tax.
TransactionShipping	Decimal	False	True		The total cost of shipping.
TransactionTax	Decimal	False	True		The total amount of tax.
RevenuePerTransaction	Decimal	False	True		The average revenue for an e-commerce transaction.
UniquePurchases	Integer	False	True		The number of product sets purchased.
ItemQuantity	Integer	False	True		The total number of items purchased.
ItemRevenue	Decimal	False	True		The total revenue from purchased product items on your property.
StartDate	String				Start date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo).
EndDate	String				End date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo).
Dimensions	String				A comma-separated list of dimensions to retrieve in addition to the columns defined in the schema. Set to empty string to retrieve no dimensions.
Metrics	String				A comma-separated list of metrics to retrieve in addition to the columns defined in the schema.
CohortTypes	String				Available only when using the V4 API. A comma-separated list of cohort types. The default value is FIRST_VISIT_DATE
CohortStartDates	Date				Available only when using the V4 API. A comma-separated list of cohort start dates.
CohortEndDates	Date				Available only when using the V4 API. A comma-separated list of cohort end dates.
SamplesReadCounts	String				Comma separated list of samples read counts when the response data is sampled.
SamplingSpaceSizes	String				Comma separated list of samples space sizes counts when the response data is sampled.

Pseudo-Columns

Name	Type	Description
Segments	String	Segments the data returned for your request. Either a SegmentId or a custom segment.
Profile	String	The Profile ID or website URL to retrieve data from.