Columns

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

Column Name Data Type Notes
​_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).
​_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.
​_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.)
​_MONTH String(255) Month of the session, a two digit integer from 01 to 12.
​_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.
ADSENSEADSCLICKS Integer The number of times AdSense ads on the site were clicked (requires integration with AdSense).
ADSENSEPAGEIMPRESSIO​NS Integer The number of pageviews during which an AdSense ad was displayed (requires integration with AdSense). A page impression can have multiple ad Units.
ADSENSEREVENUE Decimal(18, 2) The total revenue from AdSense ads.
ENDDATE Date
GOALVALUEALL Decimal(18, 2) Total numeric value for all goals defined in the profile.
ORGANICSEARCHES Integer The number of organic searches happened in a session. This metric is search engine agnostic.
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.
USERS Integer The total number of users for the requested time period.
VIEWID String(255)