Partnerize data warehouse table groups

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

Table: CLICKS

campaign_clicks__clicks__advertiser_reference
Display name Advertiser reference
Description Advertiser reference
Field type dimension
Data type string.text.value
campaign_clicks__clicks__browser_family
Display name Browser family
Description Browser family
Field type dimension
Data type string.text.value
campaign_clicks__clicks__browser_major
Display name Browser major
Description Browser major
Field type dimension
Data type string.text.value
campaign_clicks__clicks__browser_minor
Display name Browser minor
Description Browser minor
Field type dimension
Data type string.text.value
campaign_clicks__clicks__browser_patch
Display name Browser patch
Description Browser patch
Field type dimension
Data type string.text.value
campaign_clicks__clicks__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaign_clicks__clicks__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_clicks__clicks__country
Display name Country code
Description Country code
Field type dimension
Data type string.geo.country.twolettercode
campaign_clicks__clicks__country_name
Display name Country name
Description Country name
Field type dimension
Data type string.geo.country
campaign_clicks__clicks__creative_advertiser_reference
Display name Creative advertiser reference
Description Creative advertiser reference
Field type dimension
Data type string.text.value
campaign_clicks__clicks__creative_description
Display name Creative description
Description Creative description
Field type dimension
Data type string.text.value
campaign_clicks__clicks__creative_id
Display name Creative ID
Description Creative ID
Field type dimension
Data type string.text.value
campaign_clicks__clicks__date
Display name Date
Description Date
Field type dimension
Data type string.time.date
campaign_clicks__clicks__device_id
Display name Device ID
Description ID of the device
Field type dimension
Data type string.text.value
campaign_clicks__clicks__device_name
Display name Device name
Description Name of the device
Field type dimension
Data type string.text.value
campaign_clicks__clicks__os_family
Display name OS family
Description Operating system family
Field type dimension
Data type string.text.value
campaign_clicks__clicks__os_major
Display name OS major
Description Operating system major
Field type dimension
Data type string.text.value
campaign_clicks__clicks__os_minor
Display name OS minor
Description Operating system minor
Field type dimension
Data type string.text.value
campaign_clicks__clicks__os_patch
Display name OS patch
Description Operating system patch
Field type dimension
Data type string.text.value
campaign_clicks__clicks__partner_id
Display name Partner ID
Description ID of the partner
Field type dimension
Data type string.text.value
campaign_clicks__clicks__partner_name
Display name Partner name
Description Name of the partner
Field type dimension
Data type string.text.value
campaign_clicks__clicks__partnership_model_id
Display name Partnership model ID
Description Partnership model ID
Field type dimension
Data type string.text.value
campaign_clicks__clicks__partnership_model_name
Display name Partnership model name
Description Partnership model name
Field type dimension
Data type string.text.value
campaign_clicks__clicks__total_clicks
Display name Clicks
Description Total number of clicks
Field type metric
Data type int.number.value
campaign_clicks__clicks__total_clicks_converted
Display name Converted clicks
Description Total number of converted clicks
Field type metric
Data type int.number.value
campaign_clicks__clicks__total_unique_clicks
Display name Unique clicks
Description Total number of unique clicks
Field type metric
Data type int.number.value
campaign_clicks__clicks__traffic_source_id
Display name Traffic source ID
Description Traffic source ID
Field type dimension
Data type string.text.value
campaign_clicks__clicks__traffic_source_name
Display name Traffic source name
Description Traffic source name
Field type dimension
Data type string.text.value
campaign_clicks__clicks__type
Display name Customer type
Description Type of the customer
Field type dimension
Data type string.text.value
campaign_clicks__clicks__user_context_id
Display name User context ID
Description User context ID
Field type dimension
Data type string.text.value
campaign_clicks__clicks__user_context_name
Display name User context name
Description User context name
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

Table: IMPRESSIONS

campaign_impressions__impressions__advertiser_reference
Display name Advertiser reference
Description Advertiser reference
Field type dimension
Data type string.text.value
campaign_impressions__impressions__browser_family
Display name Browser family
Description Browser family
Field type dimension
Data type string.text.value
campaign_impressions__impressions__browser_major
Display name Browser major
Description Browser major
Field type dimension
Data type string.text.value
campaign_impressions__impressions__browser_minor
Display name Browser minor
Description Browser minor
Field type dimension
Data type string.text.value
campaign_impressions__impressions__browser_patch
Display name Browser patch
Description Browser patch
Field type dimension
Data type string.text.value
campaign_impressions__impressions__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaign_impressions__impressions__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_impressions__impressions__creative_advertiser_reference
Display name Creative advertiser reference
Description Creative advertiser reference
Field type dimension
Data type string.text.value
campaign_impressions__impressions__creative_description
Display name Creative description
Description Creative description
Field type dimension
Data type string.text.value
campaign_impressions__impressions__creative_id
Display name Creative ID
Description Creative ID
Field type dimension
Data type string.text.value
campaign_impressions__impressions__date
Display name Date
Description Date
Field type dimension
Data type string.time.date
campaign_impressions__impressions__device_id
Display name Device ID
Description ID of the device
Field type dimension
Data type string.text.value
campaign_impressions__impressions__device_name
Display name Device name
Description Name of the device
Field type dimension
Data type string.text.value
campaign_impressions__impressions__os_family
Display name OS family
Description Operating system family
Field type dimension
Data type string.text.value
campaign_impressions__impressions__os_major
Display name OS major
Description Operating system major
Field type dimension
Data type string.text.value
campaign_impressions__impressions__os_minor
Display name OS minor
Description Operating system minor
Field type dimension
Data type string.text.value
campaign_impressions__impressions__os_patch
Display name OS patch
Description Operating system patch
Field type dimension
Data type string.text.value
campaign_impressions__impressions__partner_id
Display name Partner ID
Description ID of the partner
Field type dimension
Data type string.text.value
campaign_impressions__impressions__partner_name
Display name Partner name
Description name of the partner
Field type dimension
Data type string.text.value
campaign_impressions__impressions__partnership_model_id
Display name Partnership model ID
Description Partnership model ID
Field type dimension
Data type string.text.value
campaign_impressions__impressions__partnership_model_name
Display name Partnership model name
Description Partnership model name
Field type dimension
Data type string.text.value
campaign_impressions__impressions__total_impressions
Display name Impressions
Description Total number of impressions
Field type metric
Data type int.number.value
campaign_impressions__impressions__traffic_source_id
Display name Traffic source ID
Description Traffic source ID
Field type dimension
Data type string.text.value
campaign_impressions__impressions__traffic_source_name
Display name Traffic source name
Description Traffic source name
Field type dimension
Data type string.text.value
campaign_impressions__impressions__user_context_id
Display name User context ID
Description User context ID
Field type dimension
Data type string.text.value
campaign_impressions__impressions__user_context_name
Display name User context name
Description User context name
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

Table: CONVERSIONS

campaign_conversions__conversions__advertiser_reference
Display name Advertiser reference
Description Advertiser reference
Field type dimension
Data type string.text.value
campaign_conversions__conversions__average_order_size
Display name Average order size
Description Average order size
Field type metric
Data type float.number.value
campaign_conversions__conversions__browser_family
Display name Browser family
Description Browser family
Field type dimension
Data type string.text.value
campaign_conversions__conversions__browser_major
Display name Browser major
Description Browser major
Field type dimension
Data type string.text.value
campaign_conversions__conversions__browser_minor
Display name Browser minor
Description Browser minor
Field type dimension
Data type string.text.value
campaign_conversions__conversions__browser_patch
Display name Browser patch
Description Browser patch
Field type dimension
Data type string.text.value
campaign_conversions__conversions__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaign_conversions__conversions__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_conversions__conversions__category
Display name Product category
Description Product category
Field type dimension
Data type string.text.value
campaign_conversions__conversions__conversion_metric_id
Display name Conversion metric ID
Description Conversion metric ID
Field type dimension
Data type string.text.value
campaign_conversions__conversions__conversion_metric_name
Display name Conversion metric name
Description Conversion metric name
Field type dimension
Data type string.text.value
campaign_conversions__conversions__conversion_reference
Display name Conversion reference
Description Conversion reference
Field type dimension
Data type string.text.value
campaign_conversions__conversions__conversion_status
Display name Conversion status
Description Conversion status
Field type dimension
Data type string.text.value
campaign_conversions__conversions__conversion_type_id
Display name Conversion type ID
Description Conversion type ID
Field type dimension
Data type string.text.value
campaign_conversions__conversions__conversion_type_name
Display name Conversion type name
Description Conversion type name
Field type dimension
Data type string.text.value
campaign_conversions__conversions__country
Display name Country
Description Country code
Field type dimension
Data type string.geo.country.twolettercode
campaign_conversions__conversions__country_name
Display name Country name
Description Country name
Field type dimension
Data type string.geo.country
campaign_conversions__conversions__creative_advertiser_reference
Display name Creative advertiser reference
Description Creative advertiser reference
Field type dimension
Data type string.text.value
campaign_conversions__conversions__creative_description
Display name Creative description
Description Creative description
Field type dimension
Data type string.text.value
campaign_conversions__conversions__creative_id
Display name Creative ID
Description Creative ID
Field type dimension
Data type string.text.value
campaign_conversions__conversions__currency
Display name Currency
Description Currency code
Field type dimension
Data type string.currency.code
campaign_conversions__conversions__customer_reference
Display name Customer reference
Description Customer reference
Field type dimension
Data type string.text.value
campaign_conversions__conversions__customer_type
Display name Customer type
Description Type of the
Field type dimension
Data type string.text.value
campaign_conversions__conversions__date
Display name Date
Description Date
Field type dimension
Data type string.time.date
campaign_conversions__conversions__device_id
Display name Device ID
Description Device ID
Field type dimension
Data type string.text.value
campaign_conversions__conversions__device_name
Display name Device name
Description Device name
Field type dimension
Data type string.text.value
campaign_conversions__conversions__os_family
Display name OS family
Description Operating system family
Field type dimension
Data type string.text.value
campaign_conversions__conversions__os_major
Display name OS major
Description Operating system major
Field type dimension
Data type string.text.value
campaign_conversions__conversions__os_minor
Display name OS minor
Description Operating system minor
Field type dimension
Data type string.text.value
campaign_conversions__conversions__os_patch
Display name OS patch
Description Operating system patch
Field type dimension
Data type string.text.value
campaign_conversions__conversions__partner_id
Display name Partner ID
Description ID of the partner
Field type dimension
Data type string.text.value
campaign_conversions__conversions__partner_name
Display name Partner name
Description Partner name
Field type dimension
Data type string.text.value
campaign_conversions__conversions__partnership_model_id
Display name Partnership model ID
Description Partnership model ID
Field type dimension
Data type string.text.value
campaign_conversions__conversions__partnership_model_name
Display name Partnership model name
Description Partnership model name
Field type dimension
Data type string.text.value
campaign_conversions__conversions__sku
Display name SKU
Description Stock Keeping Unit
Field type dimension
Data type string.text.value
campaign_conversions__conversions__total_commission
Display name Total commission
Description Total commission for approved, rejected & pending commissions
Field type metric
Data type float.currency.value
campaign_conversions__conversions__total_conversion_items
Display name Conversion items
Description Total number of conversion items
Field type metric
Data type int.number.value
campaign_conversions__conversions__total_conversions
Display name Conversions
Description Total number of conversions
Field type metric
Data type int.number.value
campaign_conversions__conversions__total_order_value
Display name Total order value
Description Total order value
Field type metric
Data type float.currency.value
campaign_conversions__conversions__total_partner_commission
Display name Partner commission
Description Total partner commission
Field type metric
Data type float.currency.value
campaign_conversions__conversions__traffic_source_id
Display name Traffic source ID
Description Traffic source ID
Field type dimension
Data type string.text.value
campaign_conversions__conversions__traffic_source_name
Display name Traffic source name
Description Traffic source name
Field type dimension
Data type string.text.value
campaign_conversions__conversions__type
Display name Customer type
Description Type of the customer
Field type dimension
Data type string.text.value
campaign_conversions__conversions__user_context_id
Display name User context ID
Description User context ID
Field type dimension
Data type string.text.value
campaign_conversions__conversions__user_context_name
Display name User context name
Description User context name
Field type dimension
Data type string.text.value
campaign_conversions__conversions__voucher_code
Display name Voucher code
Description Voucher code
Field type dimension
Data type string.text.value
campaign_conversions__conversions__voucher_status
Display name Voucher status
Description Voucher status
Field type dimension
Data type string.text.value
campaign_conversions__conversions__voucher_status_name
Display name Voucher status name
Description Voucher status name
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