Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Program | Program name | p_program_name | dim | Name of the program. |
| Program ID | p_program_id | dim | ID of the program. | |
| Time | Year | p_partner__year | dim | |
| Year of week (Sun-Sat) | p_partner__year_of_week | dim | ||
| Year of week (Mon-Sun) | p_partner__year_of_week_iso | dim | ||
| Year & month | p_partner__year_month | dim | ||
| Month | p_partner__month | dim | ||
| Year & week (Sun-Sat) | p_partner__year_week | dim | ||
| Year & week (Mon-Sun) | p_partner__year_week_iso | dim | ||
| Week (Sun-Sat) | p_partner__week | dim | ||
| Week (Mon-Sun) | p_partner__week_iso | dim | ||
| Day of month | p_partner__day_of_month | dim | ||
| Day of week (Sun-Sat) | p_partner__day_of_week_name | dim | ||
| Day of week (Mon-Sun) | p_partner__day_of_week_name_iso | dim | ||
| Date | p_partner__date | dim | ||
| Datetime | p_partner__atom | dim | ||
| Partner | Partner name | p_partner__partner_name | dim | Name of the media partner. |
| Partner ID | p_partner__partner_id | dim | ID of the media partner. | |
| Event type | p_partner__event_type | dim | Type of the event. | |
| Landing page | p_partner__landing_page | dim | The landing page for the ad. | |
| Currency | p_partner__currency_code | dim | Currency of the query. Currently set to USD. | |
| Ad | Ad name | p_partner__ad_name | dim | Name of the ad. |
| Ad ID | p_partner__ad_id | dim | ID of the ad. | |
| Ad type | p_partner__ad_type | dim | Type of the ad. | |
| Impressions | p_partner__impressions | met | The number of unique ad impressions tracked. | |
| Clicks | p_partner__clicks | met | The number of unique clicks tracked. | |
| Actions | p_partner__actions | met | Total number of actions tracked excluding reversals. | |
| Action cost | p_partner__action_cost | met | Total amount of cost associated with all actions. | |
| Total cost | p_partner__total_cost | met | Total amount of action and other (non action) costs. | |
| Revenue | p_partner__revenue | met | Total revenue (sale amount) of all actions. | |
| CTR | p_partner__ctr | met | Click through rate (Clicks / Impressions). | |
| Conversion rate | p_partner__conversion_rate | met | Conversion rate (Actions / Clicks). | |
| CPC | p_partner__cpc | met | Cost per click (Total cost / Clicks). | |
| CPA | p_partner__cpa | met | Cost per action (Action cost / Actions). | |
| ROAS | p_partner__roas | met | Return on ad spend (Revenue / Total cost). | |
| Raw impressions | p_partner__raw_impressions | met | The total number of impressions tracked. | |
| Viewable impressions | p_partner__viewable_impressions | met | The number of viewable impressions. | |
| Times impressions viewed | p_partner__times_impressions_viewed | met | The number of times impressions viewed. | |
| Raw clicks | p_partner__raw_clicks | met | The total number of clicks tracked. | |
| Mouseovers | p_partner__mouseovers | met | The number of mouseovers. | |
| Avg pages viewed | p_partner__avg_pages_viewed | met | Average number of pages viewed. | |
| Avg impression duration | p_partner__avg_impression_duration | met | Average impression duration. | |
| Calls | p_partner__calls | met | The number of call actions. | |
| Answered | p_partner__answered | met | The number of answered calls. | |
| Converted calls | p_partner__converted_calls | met | The number of converted calls. | |
| Leads | p_partner__leads | met | The number of leads. | |
| Lead conversion rate | p_partner__lead_conversion_rate | met | Lead conversion rate (Leads / Clicks). | |
| Lead CPA | p_partner__lead_cpa | met | Cost per lead action (Lead cost / Leads). | |
| Sales | p_partner__sales | met | The number of sales. | |
| Item count | p_partner__item_count | met | The number of products in the basket captured at conversion. | |
| Sale conversion rate | p_partner__sale_conversion_rate | met | Sale conversion rate (Sales / Clicks). | |
| Sale CPA | p_partner__sale_cpa | met | Cost per sale action (Sale cost / Sales). | |
| AOV | p_partner__aov | met | Average order value (Sale revenue / Sales). | |
| Call cost | p_partner__call_cost | met | The total cost of call actions. | |
| Client cost | p_partner__client_cost | met | Client cost charged by an agency summed with total cost. | |
| Datapost cost | p_partner__datapost_cost | met | The total cost of datapost actions. | |
| Download cost | p_partner__download_cost | met | The total cost of download actions. | |
| Goods cost | p_partner__goods_cost | met | The total cost of products in the basket captured at conversion. | |
| Install cost | p_partner__install_cost | met | The total cost of install actions. | |
| Lead cost | p_partner__lead_cost | met | The total cost of lead actions. | |
| Other mobile cost | p_partner__other_mobile_cost | met | The total cost of other mobile actions. | |
| Recruit cost | p_partner__recruit_cost | met | The total cost of recruit actions. | |
| Reversed action cost | p_partner__reversed_action_cost | met | The total action cost of reversed actions. | |
| Reversed lead cost | p_partner__reversed_lead_cost | met | The total lead cost of reversed leads. | |
| Reversed sale cost | p_partner__reversed_sale_cost | met | Total cost of the reversed sales. | |
| Sale cost | p_partner__sale_cost | met | The total cost of sale actions. | |
| Total business cost | p_partner__total_business_cost | met | The total business cost, consists of goods cost and total cost. | |
| Action cost (USD) | p_partner__action_cost_usd | met | Total amount of cost in USD associated with all actions. | |
| Action cost (EUR) | p_partner__action_cost_eur | met | Total amount of cost in EUR associated with all actions. | |
| Action cost (GBP) | p_partner__action_cost_gbp | met | Total amount of cost in GBP associated with all actions. | |
| Total cost (USD) | p_partner__total_cost_usd | met | Total amount of action and other (non action) costs in USD. | |
| Total cost (EUR) | p_partner__total_cost_eur | met | Total amount of action and other (non action) costs in EUR. | |
| Total cost (GBP) | p_partner__total_cost_gbp | met | Total amount of action and other (non action) costs in GBP. | |
| Sale revenue | p_partner__sale_revenue | met | The total revenue of sale actions. | |
| Call revenue | p_partner__call_revenue | met | The total revenue of call actions. | |
| Datapost revenue | p_partner__datapost_revenue | met | The total revenue of datapost actions. | |
| Mobile install revenue | p_partner__mobile_install_revenue | met | The total revenue of mobile install actions. | |
| Other mobile revenue | p_partner__other_mobile_revenue | met | The total revenue of other mobile actions. | |
| Reversed revenue | p_partner__reversed_revenue | met | The total revenue of reversed actions. | |
| Margin | p_partner__margin | met | This number represents revenue minus goods cost. | |
| ROI | p_partner__roi | met | Return on investment ((Revenue - Total cost) / Total cost). | |
| Discount | p_partner__discount | met | The discounted amount captured at conversion. | |
| Discount rate | p_partner__discount_rate | met | The percentage discount (Discount / Revenue). | |
| Reversed leads | p_partner__reversed_leads | met | The number of leads that have been reversed. | |
| Leads reversal rate | p_partner__leads_reversal_rate | met | Leads reversal rate (Reversed leads / Leads). | |
| Reversed sales | p_partner__reversed_sales | met | The number of reversed sales. | |
| Sale reversal rate | p_partner__sale_reversal_rate | met | Sale reversal rate (Reversed sales / Sales). | |
| Dataposts | p_partner__dataposts | met | The number of dataposts. | |
| Recruit actions | p_partner__recruit_actions | met | The number of recruit actions. | |
| Downloads | p_partner__downloads | met | The number of downloads. | |
| Installs | p_partner__installs | met | The number of installs. | |
| Other mobile actions | p_partner__other_mobile_actions | met | The number of other mobile actions. | |
| Program | Program name | pg_program_name | dim | Name of the program. |
| Program ID | pg_program_id | dim | ID of the program. | |
| Time | Year | pg_partner_group__year | dim | |
| Year of week (Sun-Sat) | pg_partner_group__year_of_week | dim | ||
| Year of week (Mon-Sun) | pg_partner_group__year_of_week_iso | dim | ||
| Year & month | pg_partner_group__year_month | dim | ||
| Month | pg_partner_group__month | dim | ||
| Year & week (Sun-Sat) | pg_partner_group__year_week | dim | ||
| Year & week (Mon-Sun) | pg_partner_group__year_week_iso | dim | ||
| Week (Sun-Sat) | pg_partner_group__week | dim | ||
| Week (Mon-Sun) | pg_partner_group__week_iso | dim | ||
| Day of month | pg_partner_group__day_of_month | dim | ||
| Day of week (Sun-Sat) | pg_partner_group__day_of_week_name | dim | ||
| Day of week (Mon-Sun) | pg_partner_group__day_of_week_name_iso | dim | ||
| Date | pg_partner_group__date | dim | ||
| Datetime | pg_partner_group__atom | dim | ||
| Partner group | Partner group name | pg_partner_group__partner_group_name | dim | Name of the media partner group. |
| Partner | Partner name | pg_partner_group__partner_name | dim | Name of the media partner. |
| Partner ID | pg_partner_group__partner_id | dim | ID of the media partner. | |
| Company URL | pg_partner_group__company_url | dim | A link to the company. | |
| Other | Network | pg_partner_group__network | dim | Network the data came from. |
| Currency | pg_partner_group__currency_code | dim | Currency of the query. | |
| Impressions | pg_partner_group__impressions | met | The number of unique ad impressions tracked. | |
| Clicks | pg_partner_group__clicks | met | The number of unique clicks tracked. | |
| Actions | pg_partner_group__actions | met | Total number of actions tracked excluding reversals. | |
| Action cost | pg_partner_group__action_cost | met | Total amount of cost associated with all actions. | |
| Total cost | pg_partner_group__total_cost | met | Total amount of action and other (non action) costs. | |
| Revenue | pg_partner_group__revenue | met | Total revenue (sale amount) of all actions. | |
| CTR | pg_partner_group__ctr | met | Click through rate (Clicks / Impressions). | |
| Conversion rate | pg_partner_group__conversion_rate | met | Conversion rate (Actions / Clicks). | |
| CPC | pg_partner_group__cpc | met | Cost per click (Total cost / Clicks). | |
| CPA | pg_partner_group__cpa | met | Cost per action (Action cost / Actions). | |
| ROAS | pg_partner_group__roas | met | Return on ad spend (Revenue / Total cost). | |
| Raw impressions | pg_partner_group__raw_impressions | met | The total number of impressions tracked. | |
| Raw clicks | pg_partner_group__raw_clicks | met | The total number of clicks tracked. | |
| Calls | pg_partner_group__calls | met | The number of call actions. | |
| Item count | pg_partner_group__item_count | met | The number of products in the basket captured at conversion. | |
| Client cost | pg_partner_group__client_cost | met | Client cost charged by an agency summed with total cost. | |
| Goods cost | pg_partner_group__goods_cost | met | The total cost of products in the basket captured at conversion. | |
| Other cost | pg_partner_group__other_cost | met | The total amount of other costs. | |
| Reversed action cost | pg_partner_group__reversed_action_cost | met | The total action cost of reversed actions. | |
| Total business cost | pg_partner_group__total_business_cost | met | The total business cost, consists of goods cost and total cost. | |
| Reversed revenue | pg_partner_group__reversed_revenue | met | The total revenue of reversed actions. | |
| Margin | pg_partner_group__margin | met | This number represents revenue minus goods cost. | |
| ROI | pg_partner_group__roi | met | Return on investment ((Revenue - Total cost) / Total cost). | |
| Discount | pg_partner_group__discount | met | The discounted amount captured at conversion. | |
| Discount rate | pg_partner_group__discount_rate | met | The percentage discount (Discount / Revenue). | |
| Reversed actions | pg_partner_group__reversed_actions | met | The number of actions that have been reversed. | |
| Reversal rate | pg_partner_group__reversal_rate | met | The number of reversals divided by actions (Reversed actions / Actions). | |
| Confirmed actions | pg_partner_group__confirmed_actions | met | The total number of approved actions. | |
| Open-ended actions | pg_partner_group__open_ended_actions | met | The total number of pending actions. | |
| Program | Program name | pc_program_name | dim | Name of the program. |
| Program ID | pc_program_id | dim | ID of the program. | |
| Geo | Country | pc_country__country | dim | The country in which this partner is based. |
| City | pc_country__city | dim | The city in which this partner is based. | |
| Region | pc_country__region | dim | The region in which this partner is based. | |
| Other | Network | pc_country__network | dim | Network the data came from. |
| Currency | pc_country__currency_code | dim | Currency of the query. | |
| Impressions | pc_country__impressions | met | The number of unique ad impressions tracked. | |
| Clicks | pc_country__clicks | met | The number of unique clicks tracked. | |
| Partners | pc_country__partners | met | Total number of media partners involved. | |
| Actions | pc_country__actions | met | Total number of actions tracked excluding reversals. | |
| Action cost | pc_country__action_cost | met | Total amount of cost associated with all actions. | |
| Total cost | pc_country__total_cost | met | Total amount of action and other (non action) costs. | |
| Revenue | pc_country__revenue | met | Total revenue (sale amount) of all actions. | |
| CTR | pc_country__ctr | met | Click through rate (Clicks / Impressions). | |
| Conversion rate | pc_country__conversion_rate | met | Conversion rate (Actions / Clicks). | |
| CPC | pc_country__cpc | met | Cost per click (Total cost / Clicks). | |
| CPA | pc_country__cpa | met | Cost per action (Action cost / Actions). | |
| ROAS | pc_country__roas | met | Return on ad spend (Revenue / Total cost). | |
| Raw impressions | pc_country__raw_impressions | met | The total number of impressions tracked. | |
| Raw clicks | pc_country__raw_clicks | met | The total number of clicks tracked. | |
| Calls | pc_country__calls | met | The number of call actions. | |
| Item count | pc_country__item_count | met | The number of products in the basket captured at conversion. | |
| Client cost | pc_country__client_cost | met | Client cost charged by an agency summed with total cost | |
| Goods cost | pc_country__goods_cost | met | The total cost of products in the basket captured at conversion. | |
| Gross action cost | pc_country__gross_action_cost | met | The total cost of locked and open-ended actions plus reversed action cost. | |
| Other cost | pc_country__other_cost | met | Total amount of other costs. | |
| Reversed action cost | pc_country__reversed_action_cost | met | The total action cost of reversed actions. | |
| Total business cost | pc_country__total_business_cost | met | The total business cost, consists of goods cost and total cost. | |
| Gross revenue | pc_country__gross_revenue | met | The total processing and locked revenue plus reversed revenue. | |
| Reversed revenue | pc_country__reversed_revenue | met | The total revenue of reversed actions. | |
| Margin | pc_country__margin | met | This number represents revenue minus goods cost. | |
| ROI | pc_country__roi | met | Return on investment ((Revenue - Total cost) / Total cost). | |
| Discount | pc_country__discount | met | The discounted amount captured at conversion. | |
| Discount rate | pc_country__discount_rate | met | The percentage discount (Discount / Revenue). | |
| Reversed actions | pc_country__reversed_actions | met | The number of actions that have been reversed. | |
| Reversal rate | pc_country__reversal_rate | met | The number of reversals divided by actions (Reversed actions / Actions). | |
| Confirmed actions | pc_country__confirmed_actions | met | The total number of approved actions. | |
| Open-ended actions | pc_country__open_ended_actions | met | The total number of pending actions. | |
| Gross actions | pc_country__gross_actions | met | The total number of actions including reversed actions. | |
| Program | Program name | a_program_name | dim | Name of the program. |
| Program ID | a_program_id | dim | ID of the program. | |
| Time | Year | a_actions__year | dim | |
| Year of week (Sun-Sat) | a_actions__year_of_week | dim | ||
| Year of week (Mon-Sun) | a_actions__year_of_week_iso | dim | ||
| Year & month | a_actions__year_month | dim | ||
| Month | a_actions__month | dim | ||
| Year & week (Sun-Sat) | a_actions__year_week | dim | ||
| Year & week (Mon-Sun) | a_actions__year_week_iso | dim | ||
| Week (Sun-Sat) | a_actions__week | dim | ||
| Week (Mon-Sun) | a_actions__week_iso | dim | ||
| Day of month | a_actions__day_of_month | dim | ||
| Day of week (Sun-Sat) | a_actions__day_of_week_name | dim | ||
| Day of week (Mon-Sun) | a_actions__day_of_week_name_iso | dim | ||
| Date | a_actions__date | dim | ||
| Datetime | a_actions__atom | dim | ||
| Action | Action ID | a_actions__action_id | dim | Unique impact.com ID for the action. |
| OID | a_actions__oid | dim | Unique OID (Order ID) for the action. | |
| Status | a_actions__status | dim | Current status of the action: Approved, Pending, N/A, or Reversed. | |
| Promo code | a_actions__promo_code | dim | Promotional code applied to the conversion if one was used. | |
| Channel | a_actions__channel | dim | The marketing channel which drove the action. | |
| Event type | a_actions__event_type | dim | Display name for the action tracker (or event type) that tracked the conversion associated with the action. | |
| Event type ID | a_actions__event_type_id | dim | Unique identifier for the action tracker (or event type) that tracked the conversion associated with the action. | |
| Referring URL | a_actions__referring_url | dim | A link of the site that the consumer came from. | |
| Shared ID | a_actions__shared_id | dim | The shared ID value associated with the winning click for the action. | |
| Sub ID 1 | a_actions__sub_id_1 | dim | The first Sub ID value associated with the winning click for the action. | |
| Sub ID 2 | a_actions__sub_id_2 | dim | The second Sub ID value associated with the winning click for the action. | |
| Sub ID 3 | a_actions__sub_id_3 | dim | The third Sub ID value associated with the winning click for the action. | |
| Partner | Partner name | a_actions__partner_name | dim | Name of the media partner which drove the action. |
| Partner ID | a_actions__partner_id | dim | ID of the media partner which drove the action. | |
| Partner group | a_actions__partner_group | dim | The partner group(s) in which the publisher is listed. | |
| Referral ID | a_actions__referral_id | dim | The ID used to tie the referral back to the partner. | |
| Currency | a_actions__currency_code | dim | Currency of the query. | |
| Revenue | a_actions__revenue | met | Total revenue amount associated with the action. | |
| Action cost | a_actions__action_cost | met | Total amount of cost associated with the action. | |
| Rate | a_actions__rate | met | Percentage rate determined by revenue total and action costs (Action cost / Revenue). | |
| Indirect tax (VAT) | a_actions__indirect_tax | met | Tax incurred indirectly on goods and services. |