Columns

The COMMERCE view contains the following columns. Columns marked with an asterisk comprise the primary key.

Column Name Data Type Notes
​_AFFILIATION String(255) A product affiliation to designate a supplying company or brick and mortar location.
​_CAMPAIGN String(255) 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).
​_CITY String(255) Users' city, derived from their IP addresses or Geographical IDs.
​_CONTINENT String(255) Users' continent, derived from users' IP addresses or Geographical IDs.
​_COUNTRY String(255) Users' country, derived from their IP addresses or Geographical IDs.
​_DATE Date The date of the session formatted as YYYYMMDD.
​_DAY String(255) The day of the month, a two-digit number from 01 to 31.
​_DAYOFWEEK String(255) Day of the week, a one-digit number from 0 (Sunday) to 6 (Saturday).
​_DAYOFWEEKNAME String(255) Name (in English) of the day of the week.
​_DAYSSINCELASTSESSION String(255) The number of days elapsed since users last visited the property, used to calculate user loyalty.
​_DAYSTOTRANSACTION String(255) The number of days between users' purchases and the most recent campaign source prior to the purchase.
​_HOSTNAME String(255) The hostname from which the tracking request was made.
​_HOUR String(255) 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.)
​_KEYWORD String(255) For manual campaign tracking, it is the value of the utm_term campaign tracking parameter. For AdWords traffic, it contains the best matching targeting criteria. For the display network, where multiple targeting criteria could have caused the ad to show up, it returns the best matching targeting criteria as selected by Ads. This could be display_keyword, site placement, boomuserlist, user_interest, age, or gender. Otherwise its value is (not set).
​_LANGUAGE String(255) The language, in ISO-639 code format (e.g., en-gb for British English), provided by the HTTP Request for the browser.
​_METRO String(255) The Designated Market Area (DMA) from where traffic arrived.
​_MONTH String(255) Month of the session, a two digit integer from 01 to 12.
​_NETWORKDOMAIN String(255) The domain name of users' ISP, derived from the domain name registered to the ISP's IP address.
​_NETWORKLOCATION String(255) The names of the service providers used to reach the property. For example, if most users of the website come via the major cable internet service providers, its value will be these service providers' names.
​_REGION String(255) Users' region, derived from their IP addresses or Geographical IDs. In U.S., a region is a state, New York, for example.
​_SOURCE String(255) 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).
​_USERGENDER String(255) Gender of users.
​_USERTYPE String(255) A boolean, either New Visitor or Returning Visitor, indicating if the users are new or returning.
​_WEEK String(255) The week of the session, a two-digit number from 01 to 53. Each week starts on Sunday.
​_YEAR String(255) The year of the session, a four-digit year from 2005 to the current year.
​_YEARMONTH String(255) Combined values of ga:year and ga:month.
ENDDATE Date
ITEMQUANTITY Integer Total number of items purchased. For example, if users purchase 2 frisbees and 5 tennis balls, this will be 7.
SEGMENTID String(255)
SESSIONS Integer The total number of sessions.
STARTDATE Date
TRANSACTIONREVENUE Decimal(18, 2) The total sale revenue (excluding shipping and tax) of the transaction.
TRANSACTIONS Integer The total number of transactions.
TRANSACTIONSHIPPING Decimal(18, 2) The total cost of shipping.
TRANSACTIONTAX Decimal(18, 2) Total tax for the transaction.
UNIQUEPURCHASES 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.
USERS Integer The total number of users for the requested time period.
VIEWID String(255)