Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | program_year | dim | |
| Year of week (Sun-Sat) | program_year_of_week | dim | ||
| Year of week (Mon-Sun) | program_year_of_week_iso | dim | ||
| Year & month | program_year_month | dim | ||
| Month | program_month | dim | ||
| Year & week (Sun-Sat) | program_year_week | dim | ||
| Year & week (Mon-Sun) | program_year_week_iso | dim | ||
| Week (Sun-Sat) | program_week | dim | ||
| Week (Mon-Sun) | program_week_iso | dim | ||
| Day of month | program_day_of_month | dim | ||
| Day of week (Sun-Sat) | program_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | program_day_of_week_name_iso | dim | ||
| Date | program_date | dim | ||
| Datetime | program_atom | dim | ||
| Program | Program ID | program_program_id | dim | The unique ID of the program. |
| Program name | program_program_name | dim | The name of the program. | |
| Program country code | program_program_country_code | dim | The country code of the program. | |
| Other | Reporting currency | program_currency | dim | The selected reporting currency. |
| Digital wallet | Invoice ID | program_digital_wallet__invoice_id | dim | Invoice ID. |
| Invoice source ID | program_digital_wallet__invoice_source_id | dim | Invoice source ID. | |
| Invoice source name | program_digital_wallet__source_name | dim | Invoice source name. | |
| Invoice event name | program_digital_wallet__invoice_event_name | dim | Invoice event name. | |
| Invoice event ID | program_digital_wallet__invoice_event_id | dim | Invoice event name. | |
| Invoice description | program_digital_wallet__invoice_description | dim | Invoice description. | |
| Invoice number | program_digital_wallet__invoice_number | dim | Invoice number. | |
| Invoiced | program_digital_wallet__invoiced | dim | Invoiced status. | |
| Invoice created at | program_digital_wallet__invoice_created_at | dim | datetime when the invoice was created. | |
| Impressions | program_impressions | met | The number of impressions. | |
| Unique impressions | program_unique_impressions | met | The number of unique impressions. | |
| Clicks | program_clicks | met | The number of clicks. | |
| CTR | program_ctr | met | Click-through rate. Clicks / Impressions | |
| Conversion rate | program_cr | met | The conversion rate. Sales / clicks | |
| Leads | program_leads | met | The number of leads. | |
| Lead rate | program_lr | met | The lead rate. Leads / clicks | |
| Sales | program_sales | met | The number of sales. | |
| iSales | program_isales | met | The number of iSales. | |
| EPC | program_epc | met | Earnings per click. Publisher commission / Clicks | |
| Publisher commission | program_commission | met | The amount publisher commission. | |
| Tradedoubler commission | program_commission_td | met | The amount of Tradedoubler commission. | |
| Impression commission (Publisher) | program_impression_commission | met | The amount of impression commission (Publisher). | |
| Impression commission (Tradedoubler) | program_impression_commission_td | met | The amount of impression commission (Tradedoubler). | |
| Unique impression commission (Publisher) | program_unique_impression_commission | met | The amount of unique impression commission (Publisher). | |
| Unique impression commission (Tradedoubler) | program_unique_impression_commission_td | met | The amount of unique impression commission (Tradedoubler). | |
| Click commission (Publisher) | program_click_commission | met | The amount of click commission (Publisher). | |
| Click commission (Tradedoubler) | program_click_commission_td | met | The amount of click commission (Tradedoubler). | |
| Unique visitors commission (Publisher) | program_uv_commission | met | The amount of unique visitors commission (Publisher). | |
| Unique visitors commission (Tradedoubler) | program_uv_commission_td | met | The amount of unique visitors commission (Tradedoubler). | |
| Lead commission (Publisher) | program_lead_commission | met | The amount of unique lead commission (Publisher). | |
| Lead commission (Tradedoubler) | program_lead_commission_td | met | The amount of lead commission (Tradedoubler). | |
| iLead commission (Publisher) | program_ilead_commission | met | The amount of iLead commission (Publisher). | |
| iLead commission (Tradedoubler) | program_ilead_commission_td | met | The amount of iLead commission (Tradedoubler). | |
| Sales commission (Publisher) | program_sales_commission | met | The amount of sales commission (Publisher). | |
| Sales commission (Tradedoubler) | program_sales_commission_td | met | The amount of sales commission (Tradedoubler). | |
| iSales commission (Publisher) | program_isales_commission | met | The amount of iSales commission (Publisher). | |
| iSales commission (Tradedoubler) | program_isales_commission_td | met | The amount of iSales commission (Tradedoubler). | |
| Order value | program_order_value | met | The value of the orders. | |
| Average order value | program_aov | met | The average order value. Order value / sales | |
| Cost per order | program_cpo | met | The cost per order. Publisher commission / sales | |
| Deposit | program_deposit | met | The amount deposited. | |
| Withdraw | program_withdraw | met | The amount withdrawn. | |
| Invoice amount | program_digital_wallet__invoice_amount | met | Invoice amount. | |
| Time | Year | affiliate_site_year | dim | |
| Year of week (Sun-Sat) | affiliate_site_year_of_week | dim | ||
| Year of week (Mon-Sun) | affiliate_site_year_of_week_iso | dim | ||
| Year & month | affiliate_site_year_month | dim | ||
| Month | affiliate_site_month | dim | ||
| Year & week (Sun-Sat) | affiliate_site_year_week | dim | ||
| Year & week (Mon-Sun) | affiliate_site_year_week_iso | dim | ||
| Week (Sun-Sat) | affiliate_site_week | dim | ||
| Week (Mon-Sun) | affiliate_site_week_iso | dim | ||
| Day of month | affiliate_site_day_of_month | dim | ||
| Day of week (Sun-Sat) | affiliate_site_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | affiliate_site_day_of_week_name_iso | dim | ||
| Date | affiliate_site_date | dim | ||
| Datetime | affiliate_site_atom | dim | ||
| Affiliate site | Site ID | affiliate_site_site_id | dim | The unique ID of the affiliate site. |
| Site name | affiliate_site_site_name | dim | The name of the affiliate site. | |
| Site country code | affiliate_site_site_country_code | dim | The country code of the affiliate site. | |
| Other | Reporting currency | affiliate_site_currency | dim | The selected reporting currency. |
| Impressions | affiliate_site_impressions | met | The number of impressions. | |
| Unique impressions | affiliate_site_unique_impressions | met | The number of unique impressions. | |
| Clicks | affiliate_site_clicks | met | The number of clicks. | |
| CTR | affiliate_site_ctr | met | Click-through rate. Clicks / Impressions | |
| Conversion rate | affiliate_site_cr | met | The conversion rate. Sales / clicks | |
| Leads | affiliate_site_leads | met | The number of leads. | |
| Lead rate | affiliate_site_lr | met | The lead rate. Leads / clicks | |
| Sales | affiliate_site_sales | met | The number of sales. | |
| iSales | affiliate_site_isales | met | The number of iSales. | |
| EPC | affiliate_site_epc | met | Earnings per click. Publisher commission / Clicks | |
| Publisher commission | affiliate_site_commission | met | The amount publisher commission. | |
| Tradedoubler commission | affiliate_site_commission_td | met | The amount of Tradedoubler commission. | |
| Impression commission (Publisher) | affiliate_site_impression_commission | met | The amount of impression commission (Publisher). | |
| Impression commission (Tradedoubler) | affiliate_site_impression_commission_td | met | The amount of impression commission (Tradedoubler). | |
| Unique impression commission (Publisher) | affiliate_site_unique_impression_commission | met | The amount of unique impression commission (Publisher). | |
| Unique impression commission (Tradedoubler) | affiliate_site_unique_impression_commission_td | met | The amount of unique impression commission (Tradedoubler). | |
| Click commission (Publisher) | affiliate_site_click_commission | met | The amount of click commission (Publisher). | |
| Click commission (Tradedoubler) | affiliate_site_click_commission_td | met | The amount of click commission (Tradedoubler). | |
| Unique visitors commission (Publisher) | affiliate_site_uv_commission | met | The amount of unique visitors commission (Publisher). | |
| Unique visitors commission (Tradedoubler) | affiliate_site_uv_commission_td | met | The amount of unique visitors commission (Tradedoubler). | |
| Lead commission (Publisher) | affiliate_site_lead_commission | met | The amount of unique lead commission (Publisher). | |
| Lead commission (Tradedoubler) | affiliate_site_lead_commission_td | met | The amount of lead commission (Tradedoubler). | |
| iLead commission (Publisher) | affiliate_site_ilead_commission | met | The amount of iLead commission (Publisher). | |
| iLead commission (Tradedoubler) | affiliate_site_ilead_commission_td | met | The amount of iLead commission (Tradedoubler). | |
| Sales commission (Publisher) | affiliate_site_sales_commission | met | The amount of sales commission (Publisher). | |
| Sales commission (Tradedoubler) | affiliate_site_sales_commission_td | met | The amount of sales commission (Tradedoubler). | |
| iSales commission (Publisher) | affiliate_site_isales_commission | met | The amount of iSales commission (Publisher). | |
| iSales commission (Tradedoubler) | affiliate_site_isales_commission_td | met | The amount of iSales commission (Tradedoubler). | |
| Order value | affiliate_site_order_value | met | The value of the orders. | |
| Average order value | affiliate_site_aov | met | The average order value. Order value / sales | |
| Cost per order | affiliate_site_cpo | met | The cost per order. Publisher commission / sales | |
| Deposit | affiliate_site_deposit | met | The amount deposited. | |
| Withdraw | affiliate_site_withdraw | met | The amount withdrawn. | |
| Time | Year | ad_year | dim | |
| Year of week (Sun-Sat) | ad_year_of_week | dim | ||
| Year of week (Mon-Sun) | ad_year_of_week_iso | dim | ||
| Year & month | ad_year_month | dim | ||
| Month | ad_month | dim | ||
| Year & week (Sun-Sat) | ad_year_week | dim | ||
| Year & week (Mon-Sun) | ad_year_week_iso | dim | ||
| Week (Sun-Sat) | ad_week | dim | ||
| Week (Mon-Sun) | ad_week_iso | dim | ||
| Day of month | ad_day_of_month | dim | ||
| Day of week (Sun-Sat) | ad_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | ad_day_of_week_name_iso | dim | ||
| Date | ad_date | dim | ||
| Datetime | ad_atom | dim | ||
| Ad | Ad ID | ad_ad_id | dim | The unique ID of the ad. |
| Ad name | ad_ad_name | dim | The name of the ad. | |
| Ad category ID | ad_ad_category_id | dim | The unique ID of the ad category. | |
| Ad category name | ad_ad_category_name | dim | The name of the ad category. | |
| Ad type ID | ad_ad_type_id | dim | The unique ID of the ad type. | |
| Ad type | ad_ad_type | dim | The name of the ad type. | |
| Ad group ID | ad_ad_group_id | dim | The unique ID of the ad group. | |
| Ad group name | ad_ad_group | dim | The name of the ad group. | |
| Ad size | ad_ad_size | dim | The size of the ad. | |
| Other | Reporting currency | ad_currency | dim | The selected reporting currency. |
| Impressions | ad_impressions | met | The number of impressions. | |
| Unique impressions | ad_unique_impressions | met | The number of unique impressions. | |
| Clicks | ad_clicks | met | The number of clicks. | |
| CTR | ad_ctr | met | Click-through rate. Clicks / Impressions | |
| Conversion rate | ad_cr | met | The conversion rate. Sales / clicks | |
| Leads | ad_leads | met | The number of leads. | |
| Lead rate | ad_lr | met | The lead rate. Leads / clicks | |
| Sales | ad_sales | met | The number of sales. | |
| iSales | ad_isales | met | The number of iSales. | |
| EPC | ad_epc | met | Earnings per click. Publisher commission / Clicks | |
| Publisher commission | ad_commission | met | The amount publisher commission. | |
| Tradedoubler commission | ad_commission_td | met | The amount of Tradedoubler commission. | |
| Impression commission (Publisher) | ad_impression_commission | met | The amount of impression commission (Publisher). | |
| Impression commission (Tradedoubler) | ad_impression_commission_td | met | The amount of impression commission (Tradedoubler). | |
| Unique impression commission (Publisher) | ad_unique_impression_commission | met | The amount of unique impression commission (Publisher). | |
| Unique impression commission (Tradedoubler) | ad_unique_impression_commission_td | met | The amount of unique impression commission (Tradedoubler). | |
| Click commission (Publisher) | ad_click_commission | met | The amount of click commission (Publisher). | |
| Click commission (Tradedoubler) | ad_click_commission_td | met | The amount of click commission (Tradedoubler). | |
| Unique visitors commission (Publisher) | ad_uv_commission | met | The amount of unique visitors commission (Publisher). | |
| Unique visitors commission (Tradedoubler) | ad_uv_commission_td | met | The amount of unique visitors commission (Tradedoubler). | |
| Lead commission (Publisher) | ad_lead_commission | met | The amount of unique lead commission (Publisher). | |
| Lead commission (Tradedoubler) | ad_lead_commission_td | met | The amount of lead commission (Tradedoubler). | |
| iLead commission (Publisher) | ad_ilead_commission | met | The amount of iLead commission (Publisher). | |
| iLead commission (Tradedoubler) | ad_ilead_commission_td | met | The amount of iLead commission (Tradedoubler). | |
| Sales commission (Publisher) | ad_sales_commission | met | The amount of sales commission (Publisher). | |
| Sales commission (Tradedoubler) | ad_sales_commission_td | met | The amount of sales commission (Tradedoubler). | |
| iSales commission (Publisher) | ad_isales_commission | met | The amount of iSales commission (Publisher). | |
| iSales commission (Tradedoubler) | ad_isales_commission_td | met | The amount of iSales commission (Tradedoubler). | |
| Order value | ad_order_value | met | The value of the orders. | |
| Average order value | ad_aov | met | The average order value. Order value / sales | |
| Cost per order | ad_cpo | met | The cost per order. Publisher commission / sales | |
| Deposit | ad_deposit | met | The amount deposited. | |
| Withdraw | ad_withdraw | met | The amount withdrawn. |