Impact data warehouse table groups

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

Table: AD

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
p__partner__action_cost
Display name Action cost
Description Total amount of cost associated with all actions
Field type metric
Data type float.currency.value
p__partner__action_cost_eur
Display name Action cost (EUR)
Description Total amount of cost in EUR associated with all actions
Field type metric
Data type float.currency.value
p__partner__action_cost_gbp
Display name Action cost (GBP)
Description Total amount of cost in GBP associated with all actions
Field type metric
Data type float.currency.value
p__partner__action_cost_usd
Display name Action cost (USD)
Description Total amount of cost in USD associated with all actions
Field type metric
Data type float.currency.value
p__partner__actions
Display name Actions
Description Total number of actions tracked excluding reversals
Field type metric
Data type int.number.value
p__partner__ad_id
Display name Ad ID
Description ID of the ad
Field type dimension
Data type string.text.value
p__partner__ad_name
Display name Ad name
Description Name of the ad
Field type dimension
Data type string.text.value
p__partner__ad_type
Display name Ad type
Description Type of the ad
Field type dimension
Data type string.text.value
p__partner__answered
Display name Answered
Description The number of answered calls
Field type metric
Data type int.number.value
p__partner__aov
Display name AOV
Description Average order value (Sale revenue / Sales)
Field type metric
Data type float.currency.value
p__partner__call_cost
Display name Call cost
Description The total cost of call actions
Field type metric
Data type float.currency.value
p__partner__call_revenue
Display name Call revenue
Description The total revenue of call actions
Field type metric
Data type float.currency.value
p__partner__calls
Display name Calls
Description The number of call actions
Field type metric
Data type int.number.value
p__partner__clicks
Display name Clicks
Description The number of unique clicks tracked
Field type metric
Data type int.number.value
p__partner__client_cost
Display name Client cost
Description Client cost charged by an agency summed with total cost
Field type metric
Data type float.currency.value
p__partner__converted_calls
Display name Converted calls
Description The number of converted calls
Field type metric
Data type int.number.value
p__partner__currency_code
Display name Currency (Deprecated)
Description Currency of the query. Currently set to USD. Please note that this field will be removed on 2025-03-11
Field type dimension
Data type string.currency.code
p__partner__datapost_cost
Display name Datapost cost
Description The total cost of datapost actions
Field type metric
Data type float.currency.value
p__partner__datapost_revenue
Display name Datapost revenue
Description The total revenue of datapost actions
Field type metric
Data type float.currency.value
p__partner__dataposts
Display name Dataposts
Description The number of dataposts
Field type metric
Data type int.number.value
p__partner__date
Display name Date
Field type dimension
Data type string.time.date
p__partner__discount
Display name Discount
Description The discounted amount captured at conversion
Field type metric
Data type float.currency.value
p__partner__download_cost
Display name Download cost
Description The total cost of download actions
Field type metric
Data type float.currency.value
p__partner__downloads
Display name Downloads
Description The number of downloads
Field type metric
Data type int.number.value
p__partner__goods_cost
Display name Goods cost
Description The total cost of products in the basket captured at conversion
Field type metric
Data type float.currency.value
p__partner__impressions
Display name Impressions
Description The number of unique ad impressions tracked
Field type metric
Data type int.number.value
p__partner__install_cost
Display name Install cost
Description The total cost of install actions
Field type metric
Data type float.currency.value
p__partner__installs
Display name Installs
Description The number of installs
Field type metric
Data type int.number.value
p__partner__item_count
Display name Item count
Description The number of products in the basket captured at conversion
Field type metric
Data type int.number.value
p__partner__landing_page
Display name Landing page
Description The landing page for the ad
Field type dimension
Data type string.text.url
p__partner__lead_cost
Display name Lead cost
Description The total cost of lead actions
Field type metric
Data type float.currency.value
p__partner__leads
Display name Leads
Description The number of leads
Field type metric
Data type int.number.value
p__partner__margin
Display name Margin
Description This number represents revenue minus goods cost
Field type metric
Data type float.currency.value
p__partner__mobile_install_revenue
Display name Mobile install revenue
Description The total revenue of mobile install actions
Field type metric
Data type float.currency.value
p__partner__mouseovers
Display name Mouseovers
Description The number of mouseovers. Please note that this field will be removed on 2024-04-09
Field type metric
Data type int.number.value
p__partner__other_mobile_actions
Display name Other mobile actions
Description The number of other mobile actions
Field type metric
Data type int.number.value
p__partner__other_mobile_cost
Display name Other mobile cost
Description The total cost of other mobile actions
Field type metric
Data type float.currency.value
p__partner__other_mobile_revenue
Display name Other mobile revenue
Description The total revenue of other mobile actions
Field type metric
Data type float.currency.value
p__partner__partner_id
Display name Partner ID
Description ID of the media partner
Field type dimension
Data type string.text.value
p__partner__partner_name
Display name Partner name
Description Name of the media partner
Field type dimension
Data type string.text.value
p__partner__raw_clicks
Display name Raw clicks
Description The total number of clicks tracked
Field type metric
Data type int.number.value
p__partner__raw_impressions
Display name Raw impressions
Description The total number of impressions tracked
Field type metric
Data type int.number.value
p__partner__recruit_actions
Display name Recruit actions
Description The number of recruit actions
Field type metric
Data type int.number.value
p__partner__recruit_cost
Display name Recruit cost
Description The total cost of recruit actions
Field type metric
Data type float.currency.value
p__partner__revenue
Display name Revenue
Description Total revenue (sale amount) of all actions
Field type metric
Data type float.currency.value
p__partner__reversed_action_cost
Display name Reversed action cost
Description The total action cost of reversed actions
Field type metric
Data type float.currency.value
p__partner__reversed_lead_cost
Display name Reversed lead cost
Description The total lead cost of reversed leads
Field type metric
Data type float.currency.value
p__partner__reversed_leads
Display name Reversed leads
Description The number of leads that have been reversed
Field type metric
Data type int.number.value
p__partner__reversed_revenue
Display name Reversed revenue
Description The total revenue of reversed actions
Field type metric
Data type float.currency.value
p__partner__reversed_sale_cost
Display name Reversed sale cost
Description Total cost of the reversed sales
Field type metric
Data type float.currency.value
p__partner__reversed_sales
Display name Reversed sales
Description The number of reversed sales
Field type metric
Data type int.number.value
p__partner__sale_cost
Display name Sale cost
Description The total cost of sale actions
Field type metric
Data type float.currency.value
p__partner__sale_revenue
Display name Sale revenue
Description The total revenue of sale actions
Field type metric
Data type float.currency.value
p__partner__sales
Display name Sales
Description The number of sales
Field type metric
Data type int.number.value
p__partner__times_impressions_viewed
Display name Times impressions viewed
Description The number of times impressions viewed
Field type metric
Data type int.number.value
p__partner__total_business_cost
Display name Total business cost
Description The total business cost, consists of goods cost and total cost
Field type metric
Data type float.currency.value
p__partner__total_cost
Display name Total cost
Description Total amount of action and other (non action) costs
Field type metric
Data type float.currency.value
p__partner__viewable_impressions
Display name Viewable impressions
Description The number of viewable impressions
Field type metric
Data type int.number.value
p__program_id
Display name Program ID
Description ID of the program
Field type dimension
Data type string.text.value
p__program_name
Display name Program name
Description Name of the program
Field type dimension
Data type string.text.value

Table: PARTNER_GROUP

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
pg__partner_group__action_cost
Display name Action cost
Description Total amount of cost associated with all actions
Field type metric
Data type float.currency.value
pg__partner_group__actions
Display name Actions
Description Total number of actions tracked excluding reversals
Field type metric
Data type int.number.value
pg__partner_group__calls
Display name Calls
Description The number of call actions
Field type metric
Data type int.number.value
pg__partner_group__clicks
Display name Clicks
Description The number of unique clicks tracked
Field type metric
Data type int.number.value
pg__partner_group__client_cost
Display name Client cost
Description Client cost charged by an agency summed with total cost
Field type metric
Data type float.currency.value
pg__partner_group__company_url
Display name Company URL
Description A link to the company
Field type dimension
Data type string.text.url
pg__partner_group__confirmed_actions
Display name Confirmed actions
Description The total number of approved actions
Field type metric
Data type int.number.value
pg__partner_group__currency_code
Display name Currency
Description Currency of the query
Field type dimension
Data type string.currency.code
pg__partner_group__date
Display name Date
Field type dimension
Data type string.time.date
pg__partner_group__discount
Display name Discount
Description The discounted amount captured at conversion
Field type metric
Data type float.currency.value
pg__partner_group__goods_cost
Display name Goods cost
Description The total cost of products in the basket captured at conversion
Field type metric
Data type float.currency.value
pg__partner_group__impressions
Display name Impressions
Description The number of unique ad impressions tracked
Field type metric
Data type int.number.value
pg__partner_group__item_count
Display name Item count
Description The number of products in the basket captured at conversion
Field type metric
Data type int.number.value
pg__partner_group__margin
Display name Margin
Description This number represents revenue minus goods cost
Field type metric
Data type float.currency.value
pg__partner_group__network
Display name Network
Description Network the data came from
Field type dimension
Data type string.text.value
pg__partner_group__open_ended_actions
Display name Open-ended actions
Description The total number of pending actions
Field type metric
Data type int.number.value
pg__partner_group__other_cost
Display name Other cost
Description The total amount of other costs
Field type metric
Data type float.currency.value
pg__partner_group__partner_group_name
Display name Partner group name
Description Name of the media partner group
Field type dimension
Data type string.text.value
pg__partner_group__partner_id
Display name Partner ID
Description ID of the media partner
Field type dimension
Data type string.text.value
pg__partner_group__partner_name
Display name Partner name
Description Name of the media partner
Field type dimension
Data type string.text.value
pg__partner_group__raw_clicks
Display name Raw clicks
Description The total number of clicks tracked
Field type metric
Data type int.number.value
pg__partner_group__raw_impressions
Display name Raw impressions
Description The total number of impressions tracked
Field type metric
Data type int.number.value
pg__partner_group__revenue
Display name Revenue
Description Total revenue (sale amount) of all actions
Field type metric
Data type float.currency.value
pg__partner_group__reversed_action_cost
Display name Reversed action cost
Description The total action cost of reversed actions
Field type metric
Data type float.currency.value
pg__partner_group__reversed_actions
Display name Reversed actions
Description The number of actions that have been reversed
Field type metric
Data type int.number.value
pg__partner_group__reversed_revenue
Display name Reversed revenue
Description The total revenue of reversed actions
Field type metric
Data type float.currency.value
pg__partner_group__total_business_cost
Display name Total business cost
Description The total business cost, consists of goods cost and total cost
Field type metric
Data type float.currency.value
pg__partner_group__total_cost
Display name Total cost
Description Total amount of action and other (non action) costs
Field type metric
Data type float.currency.value
pg__program_id
Display name Program ID
Description ID of the program
Field type dimension
Data type string.text.value
pg__program_name
Display name Program name
Description Name of the program
Field type dimension
Data type string.text.value

Table: ACTION

a__actions__action_cost
Display name Action cost
Description Total amount of cost associated with the action
Field type metric
Data type float.currency.value
a__actions__action_id
Display name Action ID
Description Unique impact.com ID for the action
Field type dimension
Data type string.text.value
a__actions__channel
Display name Channel
Description The marketing channel which drove the action
Field type dimension
Data type string.text.value
a__actions__currency_code
Display name Currency
Description Currency of the query
Field type dimension
Data type string.currency.code
a__actions__date
Display name Date
Field type dimension
Data type string.time.date
a__actions__event_type
Display name Event type
Description Display name for the action tracker (or event type) that tracked the conversion associated with the action
Field type dimension
Data type string.text.value
a__actions__event_type_id
Display name Event type ID
Description Unique identifier for the action tracker (or event type) that tracked the conversion associated with the action
Field type dimension
Data type string.text.value
a__actions__indirect_tax
Display name Indirect tax (VAT)
Description Tax incurred indirectly on goods and services
Field type metric
Data type float.currency.value
a__actions__oid
Display name OID
Description Unique OID (Order ID) for the action
Field type dimension
Data type string.text.value
a__actions__partner_group
Display name Partner group
Description The partner group(s) in which the publisher is listed
Field type dimension
Data type string.text.value
a__actions__partner_id
Display name Partner ID
Description ID of the media partner which drove the action
Field type dimension
Data type string.text.value
a__actions__partner_name
Display name Partner name
Description Name of the media partner which drove the action
Field type dimension
Data type string.text.value
a__actions__promo_code
Display name Promo code
Description Promotional code applied to the conversion if one was used
Field type dimension
Data type string.text.value
a__actions__referral_id
Display name Referral ID
Description The ID used to tie the referral back to the partner
Field type dimension
Data type string.text.value
a__actions__referring_url
Display name Referring URL
Description A link of the site that the consumer came from
Field type dimension
Data type string.text.url
a__actions__revenue
Display name Revenue
Description Total revenue amount associated with the action
Field type metric
Data type float.currency.value
a__actions__shared_id
Display name Shared ID
Description The shared ID value associated with the winning click for the action
Field type dimension
Data type string.text.value
a__actions__status
Display name Status
Description Current status of the action: Approved, Pending, N/A, or Reversed
Field type dimension
Data type string.text.value
a__actions__sub_id_1
Display name Sub ID 1
Description The first Sub ID value associated with the winning click for the action
Field type dimension
Data type string.text.value
a__actions__sub_id_2
Display name Sub ID 2
Description The second Sub ID value associated with the winning click for the action
Field type dimension
Data type string.text.value
a__actions__sub_id_3
Display name Sub ID 3
Description The third Sub ID value associated with the winning click for the action
Field type dimension
Data type string.text.value
a__program_id
Display name Program ID
Description ID of the program
Field type dimension
Data type string.text.value
a__program_name
Display name Program name
Description Name of the program
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