Google Campaign Manager 360 data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

account
Display name Account
Field type dimension
Data type string.text.value
account_id
Display name Account ID
Field type dimension
Data type string.text.value
activity
Display name Activity
Field type dimension
Data type string.text.value
activityClickThroughConversions
Display name Click-through Conversions
Field type metric
Data type float.number.value
activityClickThroughRevenue
Display name Click-through Revenue
Field type metric
Data type float.number.value
activityGroup
Display name Activity Group
Field type dimension
Data type string.text.value
activityGroupId
Display name Activity Group ID
Field type dimension
Data type string.text.value
activityId
Display name Activity ID
Field type dimension
Data type string.text.value
activityViewThroughConversions
Display name View-through Conversions
Field type metric
Data type float.number.value
activityViewThroughRevenue
Display name View-through Revenue
Field type metric
Data type float.number.value
advertiser
Display name Advertiser
Field type dimension
Data type string.text.value
advertiserId
Display name Advertiser ID
Field type dimension
Data type string.text.value
campaign
Display name Campaign
Field type dimension
Data type string.text.value
campaignEndDate
Display name Campaign End Date
Field type dimension
Data type string.time.date
campaignId
Display name Campaign ID
Field type dimension
Data type string.text.value
campaignStartDate
Display name Campaign Start Date
Field type dimension
Data type string.time.date
clicks
Display name Clicks
Field type metric
Data type int.number.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Field type dimension
Data type string.time.date
dbmCost
Display name DBM Cost (Account Currency)
Field type metric
Data type float.number.value
dbmCostUsd
Display name DBM Cost USD
Field type metric
Data type float.number.value
impressions
Display name Impressions
Field type metric
Data type int.number.value
mediaCost
Display name Media Cost
Field type metric
Data type float.number.value
packageRoadblock
Display name Package/Roadblock
Field type dimension
Data type string.text.value
packageRoadblockId
Display name Package/Roadblock ID
Field type dimension
Data type string.text.value
packageRoadblockStrategy
Display name Package/Roadblock Strategy
Field type dimension
Data type string.text.value
packageRoadblockTotalBookedUnits
Display name Package/Roadblock Total Booked Units
Field type dimension
Data type string.text.value
plannedMediaCost
Display name Planned Media Cost
Field type metric
Data type float.number.value
richMediaBackupImages
Display name Backup Image
Field type metric
Data type int.number.value
richMediaClicks
Display name Rich Media Clicks
Field type metric
Data type int.number.value
richMediaCodeServes
Display name Code Serves
Field type metric
Data type int.number.value
site
Display name Site (DCM)
Field type dimension
Data type string.text.value

Table: AD

account
Display name Account
Field type dimension
Data type string.text.value
account_id
Display name Account ID
Field type dimension
Data type string.text.value
activity
Display name Activity
Field type dimension
Data type string.text.value
activityGroup
Display name Activity Group
Field type dimension
Data type string.text.value
activityGroupId
Display name Activity Group ID
Field type dimension
Data type string.text.value
activityId
Display name Activity ID
Field type dimension
Data type string.text.value
ad
Display name Ad
Field type dimension
Data type string.text.value
adId
Display name Ad ID
Field type dimension
Data type string.text.value
adStatus
Display name Ad Status
Field type dimension
Data type string.text.value
adType
Display name Ad Type
Field type dimension
Data type string.text.value
advertiser
Display name Advertiser
Field type dimension
Data type string.text.value
advertiserId
Display name Advertiser ID
Field type dimension
Data type string.text.value
campaign
Display name Campaign
Field type dimension
Data type string.text.value
campaignEndDate
Display name Campaign End Date
Field type dimension
Data type string.time.date
campaignId
Display name Campaign ID
Field type dimension
Data type string.text.value
campaignStartDate
Display name Campaign Start Date
Field type dimension
Data type string.time.date
clicks
Display name Clicks
Field type metric
Data type int.number.value
clickThroughUrl
Display name Click-through URL
Field type dimension
Data type string.text.url
companionCreative
Display name Companion Creative
Field type dimension
Data type string.text.value
companionCreativeId
Display name Companion Creative ID
Field type dimension
Data type string.text.value
companionCreativeSize
Display name Companion Creative Pixel Size
Field type dimension
Data type string.text.value
creativeSize
Display name Creative Pixel Size
Field type dimension
Data type string.text.value
creativeType
Display name Creative Type
Field type dimension
Data type string.text.value
creativeVersion
Display name Creative Version
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Field type dimension
Data type string.time.date
dbmCost
Display name DBM Cost (Account Currency)
Field type metric
Data type float.number.value
dbmCostUsd
Display name DBM Cost USD
Field type metric
Data type float.number.value
impressions
Display name Impressions
Field type metric
Data type int.number.value
mediaCost
Display name Media Cost
Field type metric
Data type float.number.value
packageRoadblock
Display name Package/Roadblock
Field type dimension
Data type string.text.value
packageRoadblockId
Display name Package/Roadblock ID
Field type dimension
Data type string.text.value
packageRoadblockStrategy
Display name Package/Roadblock Strategy
Field type dimension
Data type string.text.value
packageRoadblockTotalBookedUnits
Display name Package/Roadblock Total Booked Units
Field type dimension
Data type string.text.value
placement
Display name Placement
Field type dimension
Data type string.text.value
placementEndDate
Display name Placement End Date
Field type dimension
Data type string.time.date
placementId
Display name Placement ID
Field type dimension
Data type string.text.value
placementStartDate
Display name Placement Start Date
Field type dimension
Data type string.time.date
plannedMediaCost
Display name Planned Media Cost
Field type metric
Data type float.number.value
richMediaBackupImages
Display name Backup Image
Field type metric
Data type int.number.value
richMediaClicks
Display name Rich Media Clicks
Field type metric
Data type int.number.value
richMediaCodeServes
Display name Code Serves
Field type metric
Data type int.number.value
richMediaHtml5Impressions
Display name HTML5 Impressions
Field type metric
Data type int.number.value
richMediaVideoFullScreens
Display name Video Full-Screen
Field type metric
Data type int.number.value
richMediaVideoInteractions
Display name Video Interactions
Field type metric
Data type int.number.value
richMediaVideoMidpoints
Display name Video Midpoints
Field type metric
Data type int.number.value
richMediaVideoMutes
Display name Video Mutes
Field type metric
Data type int.number.value
richMediaVideoPauses
Display name Video Pauses
Field type metric
Data type int.number.value
richMediaVideoPlays
Display name Video Plays
Field type metric
Data type int.number.value
richMediaVideoSkips
Display name Video Skips
Field type metric
Data type int.number.value
richMediaVideoUnmutes
Display name Video Unmutes
Field type metric
Data type int.number.value
richMediaVideoViews
Display name Video Views
Field type metric
Data type int.number.value
site
Display name Site (DCM)
Field type dimension
Data type string.text.value
siteDirectory
Display name Site (Site Directory)
Field type dimension
Data type string.text.value
siteDirectoryId
Display name Site ID (Site Directory)
Field type dimension
Data type string.text.value
siteId
Display name Site ID (DCM)
Field type dimension
Data type string.text.value
siteKeyname
Display name Site Keyname
Field type dimension
Data type string.text.value