Google Ad Manager data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: LINE_ITEM

account
Display name Account
Field type dimension
Data type string.text.value
AccountId
Display name Account ID
Field type dimension
Data type string.text.value
advertiserID
Display name Advertiser ID
Description Breaks down reporting data by advertising company id
Field type dimension
Data type string.text.value
advertiserName
Display name Advertiser
Description Breaks down reporting data by advertising company
Field type dimension
Data type string.text.value
clicks
Display name Total clicks
Description The total number of clicks delivered including line item-level dynamic allocation
Field type metric
Data type int.number.value
creativeID
Display name Creative ID
Description Breaks down reporting data by creative ID or creative set ID (master's creative ID) if the creative is part of a creative set
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
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Total impressions
Description The total number of impressions delivered including line item-level dynamic allocation
Field type metric
Data type int.number.value
LINE_ITEM_STATUS
Display name Item status
Field type dimension
Data type string.text.value
lineItemID
Display name Line item ID
Description Breaks down reporting data by line item
Field type dimension
Data type string.text.value
lineItemType
Display name Line item type
Description Breaks down reporting data by line item
Field type dimension
Data type string.text.value
orderID
Display name Order ID
Description Breaks down reporting data by order ID
Field type dimension
Data type string.text.value
orderName
Display name Order
Description Breaks down reporting data by order
Field type dimension
Data type string.text.value

Table: CREATIVE

account
Display name Account
Field type dimension
Data type string.text.value
AccountId
Display name Account ID
Field type dimension
Data type string.text.value
CREATIVE_SIZE_DELIVERED
Display name Creative size for the ad
Description Breaks down reporting data by the creative size the ad was delivered to
Field type dimension
Data type string.text.value
creativeID
Display name Creative ID
Description Breaks down reporting data by creative ID or creative set ID (master's creative ID) if the creative is part of a creative set
Field type dimension
Data type string.text.value
creativeName
Display name Creative
Description Breaks down reporting data by creative
Field type dimension
Data type string.text.value
creativeSize
Display name Creative size
Description Breaks down reporting data by creative size
Field type dimension
Data type string.text.value
creativeType
Display name Creative type
Description Breaks down reporting data by creative type
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
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Total impressions
Description The total number of impressions delivered including line item-level dynamic allocation
Field type metric
Data type int.number.value
MASTER_COMPANION_CREATIVE_ID
Display name Master and Companion creative ID
Description Breaks down reporting data by creative ID. This includes regular creatives, and master and companions in case of creative sets
Field type dimension
Data type string.text.value
MASTER_COMPANION_CREATIVE_NAME
Display name Master and Companion creative
Description Breaks down reporting data by creative. This includes regular creatives, and master and companions in case of creative sets
Field type dimension
Data type string.text.value

Table: DEVICE

account
Display name Account
Field type dimension
Data type string.text.value
AccountId
Display name Account ID
Field type dimension
Data type string.text.value
clicks
Display name Total clicks
Description The total number of clicks delivered including line item-level dynamic allocation
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
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
deviceID
Display name Device ID
Description The ID of the device category to which an ad is being targeted
Field type dimension
Data type string.text.value
deviceName
Display name Device
Description The category of device (smartphone, feature phone, tablet, or desktop) to which an ad is being targeted
Field type dimension
Data type string.text.value
impressions
Display name Total impressions
Description The total number of impressions delivered including line item-level dynamic allocation
Field type metric
Data type int.number.value