CAMPAIGN
- Last Updated: July 2, 2025
- 1 minute read
- DataDirect Connectors
- JDBC
- Documentation
Columns
The CAMPAIGN view contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type | Notes |
|---|---|---|
| _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. |
| _DCMLASTEVENTAD | String(255) | DCM ad name of the last DCM event (impression or click within the DCM lookback window) associated with the Google Analytics session (Analytics 360 only). |
| _DCMLASTEVENTADTYPE | String(255) | DCM ad type name of the last DCM event (impression or click within the DCM lookback window) associated with the Google Analytics session (Analytics 360 only). |
| _DCMLASTEVENTADVERTISER | String(255) | DCM advertiser name of the last DCM event (impression or click within the DCM lookback window) associated with the Google Analytics session (Analytics 360 only). |
| _DCMLASTEVENTCAMPAIGN | String(255) | DCM campaign name of the last DCM event (impression or click within the DCM lookback window) associated with the Google Analytics session (Analytics 360 only). |
| _DCMLASTEVENTCREATIVE | String(255) | DCM creative name of the last DCM event (impression or click within the DCM lookback window) associated with the Google Analytics session (Analytics 360 only). |
| _DCMLASTEVENTCREATIVETYPE | String(255) | DCM creative type name of the last DCM event (impression or click within the DCM lookback window) associated with the Google Analytics session (Analytics 360 only). |
| _DCMLASTEVENTCREATIVEVERSION | String(255) | DCM creative version of the last DCM event (impression or click within the DCM lookback window) associated with the Google Analytics session (Analytics 360 only). |
| _DCMLASTEVENTSITE | String(255) | Site name where the DCM creative was shown and clicked on for the last DCM event (impression or click within the DCM lookback window) associated with the Google Analytics session (Analytics 360 only). |
| _DCMLASTEVENTSITEPLACEMENT | String(255) | DCM site placement name of the last DCM event (impression or click within the DCM lookback window) associated with the Google Analytics session (Analytics 360 only). |
| _DCMLASTEVENTSPOTID | String(255) | DCM Floodlight configuration ID of the last DCM event (impression or click within the DCM lookback window) associated with the Google Analytics session (Analytics 360 only). |
| _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. |
| DCMCLICKS | Integer | DCM Total Clicks (Analytics 360 only). |
| DCMCOST | Decimal(18, 2) | DCM Total Cost (Analytics 360 only). |
| DCMCPC | Decimal(18, 2) | DCM Cost Per Click (Analytics 360 only). |
| DCMCTR | Percent | DCM Click Through Rate (Analytics 360 only). |
| DCMIMPRESSIONS | Integer | DCM Total Impressions (Analytics 360 only). |
| DCMRPC | Decimal(18, 2) | DCM Revenue Per Click (Analytics 360 only). |
| ENDDATE | Date | |
| SEGMENTID | String(255) | |
| STARTDATE | Date | |
| VIEWID | String(255) |