LiveIntent fields

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

Supermetrics brings all your LiveIntent data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

23 metrics59 dimensions

ADVERTISER

advertiser__advertiser_id
Field label Advertiser ID
Description The ID of the advertiser
Field type dimension
Data type string.text.value
advertiser__advertiser_name
Field label Advertiser name
Description The name of the advertiser
Field type dimension
Data type string.text.value

AGE AND GENDER

advertiser__age
Field label Age
Field type dimension
Data type string.text.value
advertiser__gender
Field label Gender
Field type dimension
Data type string.text.value

CAMPAIGN

advertiser__campaign_id
Field label Campaign ID
Description The ID of the campaign
Field type dimension
Data type string.text.value
advertiser__campaign_name
Field label Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
advertiser__campaign_budget
Field label Campaign budget
Description The budget set for the campaign
Field type dimension
Data type string.text.value
advertiser__campaign_start_date
Field label Campaign start date
Description The start date of the campaign
Field type dimension
Data type string.text.value
advertiser__campaign_end_date
Field label Campaign end date
Description The end date of the campaign
Field type dimension
Data type string.text.value
advertiser__campaign_bid_amount
Field label Campaign bid amount
Description The bid amount of the campaign
Field type dimension
Data type string.text.value
advertiser__budget_type
Field label Budget type
Description The budget type
Field type dimension
Data type string.text.value

CORE METRICS

advertiser__impressions
Field label Impressions
Description The number of impressions
Field type metric
Data type int.number.value
advertiser__clicks
Field label Clicks
Description The number of clicks
Field type metric
Data type int.number.value
advertiser__ctr
Field label CTR
Description The percentage of ads that were clicked. Clicks / Impressions
Field type metric
Data type float.number.ratio
advertiser__advertiser_spent
Field label Advertiser spent (USD)
Description The amount spent on advertising
Field type metric
Data type float.currency.value
advertiser__advertiser_spent_usd_to_eur
Field label Advertiser spent (EUR)
Description The amount spent converted to EUR
Field type metric
Data type float.currency.value
Services Currency conversion
advertiser__advertiser_spent_usd_to_gbp
Field label Advertiser spent (GBP)
Description The amount spent converted to GBP
Field type metric
Data type float.currency.value
Services Currency conversion
advertiser__cpm
Field label eCPM
Description Cost per 1000 impressions
Field type metric
Data type float.currency.value
advertiser__cost_per_click
Field label eCPC
Description The cost per click. Advertiser spent / Clicks
Field type metric
Data type float.number.ratio
advertiser__cost_per_action_new
Field label eCPA
Description The cost per action (conversion). Advertiser spent / Conversions
Field type metric
Data type float.currency.value
advertiser__conversions
Field label Conversions
Description Conversion events that are attributed to a prior click on a LiveIntent ad by the same user
Field type metric
Data type int.number.value
advertiser__conversion_rate_new
Field label Conversion rate
Description The percentage of users who completed a desired action (conversion). Conversions / Impressions
Field type metric
Data type float.number.ratio
advertiser__ccr_new
Field label CCR
Description Click-to-Conversion Rate. Conversions (PCC) / Clicks
Field type metric
Data type float.number.ratio
advertiser__user_purchase_amount
Field label User purchase amount
Description The amount spent on a product or a service
Field type metric
Data type float.currency.value
advertiser__roas_new
Field label ROAS
Description Return of ad spend. User purchase amount / Advertiser spent
Field type metric
Data type float.currency.value

CREATIVE

advertiser__creative_id
Field label Creative ID
Description The ID of the creative
Field type dimension
Data type string.text.value
advertiser__creative_name
Field label Creative name
Description The name of the creative
Field type dimension
Data type string.text.value
advertiser__creative_size
Field label Creative size
Description The size of the creative
Field type dimension
Data type string.text.value
advertiser__creative_url
Field label Creative URL
Description The URL address of the creative
Field type dimension
Data type string.text.url

DATASOURCE

dataSourceName
Field label 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
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DEVICE

advertiser__device_type
Field label Device type
Description The type of the device
Field type dimension
Data type string.text.value
advertiser__operating_system
Field label Operating system
Description The operating system
Field type dimension
Data type string.text.value
advertiser__browser
Field label Browser
Description The browser that was used
Field type dimension
Data type string.text.value

GEO

advertiser__metro
Field label Metro (DMA)
Field type dimension
Data type string.text.value
advertiser__country
Field label Country
Field type dimension
Data type string.text.value
advertiser__region
Field label Region
Field type dimension
Data type string.text.value

LEGACY METRICS

advertiser__total_conversions
Field label Total conversions
Description The sum of post click conversions (PCC) and post view conversions (PVC). It is calculated as Conversions (PCC) + Conversions (PVC). This metric reflects data up to April 1, 2025
Field type metric
Data type int.number.value
advertiser__conversions_pcc
Field label 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
Field label 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__conversion_rate
Field label Conversion Rate (Total Conversions)
Description The percentage of users who completed a desired action (conversion). Total conversions / Impressions. This metric reflects data up to April 1, 2025
Field type metric
Data type float.number.ratio
advertiser__ccr
Field label CCR (Total Conversions)
Description Click-to-Conversion Rate. Conversions (PCC) / Clicks. This metric reflects data up to April 1, 2025
Field type metric
Data type float.number.ratio
advertiser__upa_total
Field label 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
advertiser__upa_pcc
Field label 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
Field label 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__roas
Field label ROAS (Total Conversions)
Description Return of ad spend. User purchase amount (Total) / Advertiser spent. This metric reflects data up to April 1, 2025
Field type metric
Data type float.currency.value

LINE ITEM

advertiser__line_item_id
Field label Line item ID
Description The ID of the line item
Field type dimension
Data type string.text.value
advertiser__line_item_name
Field label Line item name
Description The name of the line item
Field type dimension
Data type string.text.value
advertiser__line_item_start_date
Field label Line item start date
Description The start date of the line item
Field type dimension
Data type string.text.value
advertiser__line_item_end_date
Field label Line item end date
Description The end date of the line item
Field type dimension
Data type string.text.value
advertiser__line_item_bid_amount
Field label Line item bid amount
Description The bid amount of the line item
Field type dimension
Data type string.text.value
advertiser__line_item_budget
Field label Line item budget
Description The budget set for the line item
Field type dimension
Data type string.text.value

OTHER

advertiser__publisher_id
Field label Publisher ID
Description The ID of the publisher
Field type dimension
Data type string.text.value
advertiser__demand_type
Field label Demand type
Description The type of the demand
Field type dimension
Data type string.text.value
advertiser__guaranteed
Field label Guaranteed
Field type dimension
Data type bool
advertiser__pacing
Field label Pacing
Field type dimension
Data type string.text.value
advertiser__status
Field label Status
Field type dimension
Data type string.text.value
advertiser__clickthough_url
Field label ClickThrough URL
Description The URL of the click-through
Field type dimension
Data type string.text.url

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
advertiser__year
Field label Year
Field type dimension
Data type string.time.year
advertiser__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
advertiser__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
advertiser__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
advertiser__month
Field label Month
Field type dimension
Data type string.time.month
advertiser__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
advertiser__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
advertiser__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
advertiser__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
advertiser__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
advertiser__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
advertiser__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
advertiser__date
Field label Date
Field type dimension
Data type string.time.date
advertiser__atom
Field label Datetime
Field type dimension
Data type string.time.datetime