LiveIntent data warehouse table groups

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

Table: CREATIVE

advertiser__advertiser_id
Display name Advertiser ID
Description The ID of the advertiser
Field type dimension
Data type string.text.value
advertiser__advertiser_name
Display name Advertiser name
Description The name of the advertiser
Field type dimension
Data type string.text.value
advertiser__advertiser_spent
Display name Advertiser spent (USD)
Description The amount spent on advertising
Field type metric
Data type float.currency.value
advertiser__age
Display name Age
Field type dimension
Data type string.text.value
advertiser__browser
Display name Browser
Description The browser that was used
Field type dimension
Data type string.text.value
advertiser__budget_type
Display name Budget type
Description The budget type
Field type dimension
Data type string.text.value
advertiser__campaign_bid_amount
Display name Campaign bid amount
Description The bid amount of the campaign
Field type dimension
Data type string.text.value
advertiser__campaign_budget
Display name Campaign budget
Description The budget set for the campaign
Field type dimension
Data type string.text.value
advertiser__campaign_end_date
Display name Campaign end date
Description The end date of the campaign
Field type dimension
Data type string.text.value
advertiser__campaign_id
Display name Campaign ID
Description The ID of the campaign
Field type dimension
Data type string.text.value
advertiser__campaign_name
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
advertiser__campaign_start_date
Display name Campaign start date
Description The start date of the campaign
Field type dimension
Data type string.text.value
advertiser__clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
advertiser__conversions_pcc
Display name Conversions (PCC)
Description Post click conversions. The number of conversions that occurred after a user clicked a LiveIntent ad within the post click attribution window selected. This metric reflects data up to April 1, 2025
Field type metric
Data type int.number.value
advertiser__conversions_pvc
Display name Conversions (PVC)
Description Post view conversions. The number of conversions that occurred after a user was delivered an impressions but did not click on a LiveIntent Ad within the post view attribution window selected. This metric reflects data up to April 1, 2025
Field type metric
Data type int.number.value
advertiser__country
Display name Country
Field type dimension
Data type string.text.value
advertiser__creative_id
Display name Creative ID
Description The ID of the creative
Field type dimension
Data type string.text.value
advertiser__creative_name
Display name Creative name
Description The name of the creative
Field type dimension
Data type string.text.value
advertiser__creative_size
Display name Creative size
Description The size of the creative
Field type dimension
Data type string.text.value
advertiser__creative_url
Display name Creative URL
Description The URL address of the creative
Field type dimension
Data type string.text.url
advertiser__date
Display name Date
Field type dimension
Data type string.time.date
advertiser__demand_type
Display name Demand type
Description The type of the demand
Field type dimension
Data type string.text.value
advertiser__device_type
Display name Device type
Description The type of the device
Field type dimension
Data type string.text.value
advertiser__gender
Display name Gender
Field type dimension
Data type string.text.value
advertiser__guaranteed
Display name Guaranteed
Field type dimension
Data type bool
advertiser__impressions
Display name Impressions
Description The number of impressions
Field type metric
Data type int.number.value
advertiser__line_item_bid_amount
Display name Line item bid amount
Description The bid amount of the line item
Field type dimension
Data type string.text.value
advertiser__line_item_budget
Display name Line item budget
Description The budget set for the line item
Field type dimension
Data type string.text.value
advertiser__line_item_end_date
Display name Line item end date
Description The end date of the line item
Field type dimension
Data type string.text.value
advertiser__line_item_id
Display name Line item ID
Description The ID of the line item
Field type dimension
Data type string.text.value
advertiser__line_item_name
Display name Line item name
Description The name of the line item
Field type dimension
Data type string.text.value
advertiser__line_item_start_date
Display name Line item start date
Description The start date of the line item
Field type dimension
Data type string.text.value
advertiser__metro
Display name Metro (DMA)
Field type dimension
Data type string.text.value
advertiser__operating_system
Display name Operating system
Description The operating system
Field type dimension
Data type string.text.value
advertiser__pacing
Display name Pacing
Field type dimension
Data type string.text.value
advertiser__publisher_id
Display name Publisher ID
Description The ID of the publisher
Field type dimension
Data type string.text.value
advertiser__region
Display name Region
Field type dimension
Data type string.text.value
advertiser__status
Display name Status
Field type dimension
Data type string.text.value
advertiser__upa_pcc
Display name User purchase amount (PCC)
Description The amount spent on a product or a service. This metric reflects data up to April 1, 2025
Field type metric
Data type float.currency.value
advertiser__upa_pvc
Display name User purchase amount (PVC)
Description The amount spent on a product or a service. This metric reflects data up to April 1, 2025
Field type metric
Data type float.currency.value
advertiser__upa_total
Display name User Purchase Amount (Total Conversions)
Description The total amount spent on a product or a service. This metric reflects data up to April 1, 2025
Field type metric
Data type float.currency.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