Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | report_year | dim | |
| Year of week (Sun-Sat) | report_year_of_week | dim | ||
| Year of week (Mon-Sun) | report_year_of_week_iso | dim | ||
| Year & month | report_year_month | dim | ||
| Month | report_month | dim | ||
| Year & week (Sun-Sat) | report_year_week | dim | ||
| Year & week (Mon-Sun) | report_year_week_iso | dim | ||
| Week (Sun-Sat) | report_week | dim | ||
| Week (Mon-Sun) | report_week_iso | dim | ||
| Day of month | report_day_of_month | dim | ||
| Day of week (Sun-Sat) | report_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | report_day_of_week_name_iso | dim | ||
| Date | report_date | dim | ||
| Datetime | report_atom | dim | ||
| Account | Account ID | report_account_id | dim | The unique ID number of your account |
| Account name | report_account_name | dim | The name of your account | |
| Currency | report_currency | dim | ||
| Brand | Brand name | report_brand_name | dim | The name of the brand for which advertising is running |
| Brand ID | report_brand_id | dim | The unique ID of the brand for which advertising is running | |
| Brand group | report_brand_group | dim | The name of the brand group for which advertising is running | |
| Brand vertical | report_brand_vertical | dim | The vertical of the brand for which advertising is running | |
| Brand account manager name | report_brand_manager_name | dim | The name of the account manager | |
| Brand account manager ID | report_brand_manager_id | dim | The ID of the account manager | |
| Brand tags | report_brand_tags | dim | List of tags associated with the brand | |
| Campaign | Campaign | report_campaign | dim | The name of the campaign |
| Campaign ID | report_campaign_id | dim | The unique ID of the campaign | |
| Creative | Creative | report_creative | dim | The name of the creative |
| Creative ID | report_creative_id | dim | The unique ID of the creative | |
| Creative type | report_creative_type | dim | The type of the creative | |
| SKU | SKU product name | report_sku_name | dim | The name of the product |
| SKU | report_sku_id | dim | The SKU of the product | |
| SKU created at | report_sku_affluent_created_at | dim | Time SKU was recorded in Affluent | |
| SKU modified at | report_sku_affluent_modified_at | dim | Time SKU was modified in Affluent | |
| SKU product category | report_sku_category | dim | The name of the product category | |
| SKU parent product category | report_sku_category_parent | dim | The name of the parent product category | |
| SKU second parent product category | report_sku_category_parent_two | dim | The name of the second parent product category | |
| Geo | Country | report_country | dim | |
| Country code | report_country_code | dim | The two-letter code of the country | |
| City | report_city | dim | ||
| District | report_district | dim | ||
| Post code | report_post_code | dim | ||
| Device | Device model | report_device_model | dim | The model of the device |
| Device type | report_device_type | dim | The type of the device | |
| Operating System | report_os | dim | The operating system | |
| Browser | report_browser | dim | The browser that was used | |
| Publisher | Publisher name | report_publisher_name | dim | The name of the publisher |
| Publisher ID | report_publisher_id | dim | A unique ID associated with the publisher | |
| Publisher country | report_publisher_country | dim | The country of the publisher | |
| Publisher group | report_publisher_group | dim | A description of how the publisher is categorized | |
| Publisher tags | report_publisher_tags | dim | List of tags associated with the publisher | |
| Publisher terms | report_publisher_terms_name | dim | Publisher IO / Contract Name | |
| Publisher terms ID | report_publisher_terms_id | dim | Publisher IO / Contract Id | |
| Publisher type | report_publisher_type | dim | The type of marketing the publisher engages in | |
| Publisher website name | report_publisher_website_name | dim | The name of the publisher website | |
| Publisher website URL | report_publisher_website_url | dim | The URL address of the publisher website | |
| Publisher website ID | report_publisher_website_id | dim | The unique ID of the publisher website | |
| Merged publisher name | report_publisher_name_merged | dim | The merged name of the publisher | |
| General | Affluent ID | report_affluent_id | dim | The unique Affluent ID |
| Created at | report_affluent_created_at | dim | The time data was recorded in Affluent | |
| Action type | report_action_type | dim | The type of the action | |
| Action status | report_status | dim | ||
| Action ID | report_action_id | dim | The unique ID of the action | |
| Event code | report_event_code | dim | The code of the event | |
| Event type ID | report_event_type_id | dim | The unique ID of the event type | |
| Event type name | report_event_type_name | dim | The name of the event type | |
| Network ID | report_network_id | dim | The unique ID of the network | |
| Referral domain | report_referral_domain | dim | The referral domain | |
| Referral URL | report_referral_url | dim | The referral URL | |
| Platform name | report_platform_name | dim | The name of the platform | |
| Commission type | report_commission_type | dim | The type of the commission | |
| Cross-device | report_cross_device | dim | ||
| Details/comment | report_details | dim | Details / comments | |
| Landing page | report_landing_page | dim | The landing page | |
| New to file | report_new_to_file | dim | New to file customer | |
| Merchant ID | report_merchant_id | dim | The unique ID of the merchant | |
| Order ID | report_order_id | dim | The unique ID of the order | |
| Promo code | report_promo_code | dim | ||
| Repeating customer | report_repeat_customer | dim | Whether the customer is a repeating one or not | |
| Clicks | report_click_count | met | The count of clicks | |
| Impressions | report_impression_count | met | The count of impressions | |
| ROAS | report_roas_net | met | Return on ad spend | |
| CTR | report_click_through_rate | met | Click-through rate | |
| Total profit | report_total_profit_net | met | ||
| CPA | report_cpa | met | Cost per acquisition | |
| CR | report_cr | met | Conversion rate | |
| ALV | report_alv | met | Average lead value | |
| EPC | report_epc | met | ||
| Active publishers | report_active_publisher_count | met | Active publisher count (driving clicks) | |
| Productive publishers | report_productive_publisher_count | met | Productive publisher count (driving actions) | |
| New publishers | report_new_publisher_count | met | New publisher count | |
| Total spend (net) | report_total_spend_net | met | ||
| Total spend (gross) | report_total_spend_gross | met | ||
| Total spend (approved) | report_total_spend_approved | met | ||
| Total spend (pending) | report_total_spend_pending | met | ||
| Total spend (disputed) | report_total_spend_disputed | met | ||
| Total spend (rejected) | report_total_spend_rejected | met | ||
| Revenue (net) | report_advertiser_revenue_net | met | ||
| Revenue (gross) | report_advertiser_revenue_gross | met | ||
| Revenue (approved) | report_advertiser_revenue_approved | met | ||
| Revenue (pending) | report_advertiser_revenue_pending | met | ||
| Revenue (disputed) | report_advertiser_revenue_disputed | met | ||
| Revenue (refunded) | report_advertiser_revenue_refunded | met | ||
| Revenue (rejected) | report_advertiser_revenue_rejected | met | ||
| Cost-to-Revenue | report_cost_to_revenue | met | ||
| Actions | report_action_count_net | met | Net action count | |
| Actions (gross) | report_action_count_gross | met | Gross action count | |
| Actions (approved) | report_action_count_approved | met | Approved action count | |
| Actions (pending) | report_action_count_pending | met | Pending action count | |
| Actions (disputed) | report_action_count_disputed | met | Disputed action count | |
| Leads | report_lead_count_net | met | ||
| Leads (gross) | report_lead_count_gross | met | ||
| Leads (approved) | report_lead_count_approved | met | ||
| Leads (pending) | report_lead_count_pending | met | ||
| Leads (disputed) | report_lead_count_disputed | met | ||
| Lead revenue | report_lead_advertiser_revenue_net | met | ||
| CPL | report_cpl | met | Cost per lead | |
| Lead CR | report_lead_cr | met | Lead conversion rate | |
| Sales revenue | report_sale_advertiser_revenue_net | met | ||
| AOV | report_average_order_value_net | met | Average order value. Sales revenue / Sales count net | |
| Sales count (net) | report_sale_count_net | met | ||
| Sales count (gross) | report_sale_count_gross | met | ||
| Sales count (approved) | report_sale_count_approved | met | ||
| Sales count (pending) | report_sale_count_pending | met | ||
| Sales count (disputed) | report_sale_count_disputed | met | ||
| SKU quantity | report_sku_quantity_net | met | ||
| SKU quantity (gross) | report_sku_quantity_gross | met | ||
| SKU quantity (approved) | report_sku_quantity_approved | met | ||
| SKU quantity (disputed) | report_sku_quantity_disputed | met | ||
| SKU revenue | report_sku_advertiser_revenue_net | met | ||
| SKU revenue (gross) | report_sku_advertiser_revenue_gross | met | ||
| SKU revenue (approved) | report_sku_advertiser_revenue_approved | met | ||
| SKU revenue (pending) | report_sku_advertiser_revenue_pending | met | ||
| SKU revenue (disputed) | report_sku_advertiser_revenue_disputed | met | ||
| SKU average item value | report_average_item_value | met | ||
| SKU commissions | report_sku_publisher_commissions_net | met | ||
| SKU commissions (gross) | report_sku_publisher_commissions_gross | met | ||
| SKU commissions (approved) | report_sku_publisher_commissions_approved | met | ||
| SKU commissions (pending) | report_sku_publisher_commissions_pending | met | ||
| SKU commissions (disputed) | report_sku_publisher_commissions_disputed | met | ||
| Total commission (net) | report_total_commission_net | met | ||
| Total commission (gross) | report_total_commission_gross | met | ||
| Total commission (approved) | report_total_commission_approved | met | ||
| Total commission (disputed) | report_total_commission_disputed | met | ||
| Total commission (rejected) | report_total_commission_rejected | met | ||
| Publisher commission (net) | report_publisher_commission_net | met | ||
| Publisher commission (gross) | report_publisher_commission_gross | met | ||
| Publisher commission (approved) | report_publisher_commission_approved | met | ||
| Publisher commission (pending) | report_publisher_commission_pending | met | ||
| Publisher commission (disputed) | report_publisher_commission_disputed | met | ||
| Publisher commission (excluding bonuses) (net) | report_publisher_commission_exc_bonus_net | met | ||
| Publisher commission (excluding bonuses) (gross) | report_publisher_commission_exc_bonus_gross | met | ||
| Publisher commission (excluding bonuses) (approved) | report_publisher_commission_exc_bonus_approved | met | ||
| Publisher commission (excluding bonuses) (pending) | report_publisher_commission_exc_bonus_pending | met | ||
| Publisher commission (excluding bonuses) (disputed) | report_publisher_commission_exc_bonus_disputed | met | ||
| Network commission (net) | report_network_fee_net | met | ||
| Network commission (gross) | report_network_fee_gross | met | ||
| Network commission (approved) | report_network_fee_approved | met | ||
| Network commission (pending) | report_network_fee_pending | met | ||
| Network commission (disputed) | report_network_fee_disputed | met | ||
| Bonuses (net) | report_bonus_count_net | met | Net bonus count | |
| Bonus amount (net) | report_bonus_amount_net | met | Net bonus amount | |
| Agency fee | report_agency_fee | met | ||
| Placement fees | report_placement_fee_net | met | ||
| Commissionable click count | report_commissionable_click_count_net | met | Net commissionable click count | |
| Non-commissionable click count | report_non_commissionable_click_count | met | Non-commissionable click count | |
| Two-tier bounties | report_two_tier_bounty_count_net | met | ||
| Fee | report_fee | met | ||
| Custom metric 1 | report_custom_0001 | met | ||
| Custom metric 2 | report_custom_0002 | met | ||
| Custom metric 3 | report_custom_0003 | met | ||
| Custom metric 4 | report_custom_0004 | met | ||
| Custom metric 5 | report_custom_0005 | met | ||
| Custom metric 6 | report_custom_0006 | met | ||
| Custom metric 7 | report_custom_0007 | met | ||
| Custom metric 8 | report_custom_0008 | met | ||
| Custom metric 9 | report_custom_0009 | met | ||
| Custom metric 10 | report_custom_00010 | met | ||
| Custom metric 11 | report_custom_00011 | met | ||
| Custom metric 12 | report_custom_00012 | met | ||
| Custom metric 13 | report_custom_00013 | met | ||
| Custom metric 14 | report_custom_00014 | met | ||
| Custom metric 15 | report_custom_00015 | met | ||
| Custom metric 16 | report_custom_00016 | met | ||
| Custom metric 17 | report_custom_00017 | met | ||
| Custom metric 18 | report_custom_00018 | met | ||
| Custom metric 19 | report_custom_00019 | met | ||
| Custom metric 20 | report_custom_00020 | met | ||
| Custom metric 21 | report_custom_00021 | met | ||
| Custom metric 22 | report_custom_00022 | met | ||
| Custom metric 23 | report_custom_00023 | met | ||
| Custom metric 24 | report_custom_00024 | met | ||
| Custom metric 25 | report_custom_00025 | met | ||
| Custom metric 26 | report_custom_00026 | met | ||
| Custom metric 27 | report_custom_00027 | met | ||
| Custom metric 28 | report_custom_00028 | met | ||
| Custom metric 29 | report_custom_00029 | met | ||
| Custom metric 30 | report_custom_00030 | met | ||
| Custom metric 31 | report_custom_00031 | met | ||
| Custom metric 32 | report_custom_00032 | met | ||
| Custom metric 33 | report_custom_00033 | met | ||
| Custom metric 34 | report_custom_00034 | met | ||
| Custom metric 35 | report_custom_00035 | met | ||
| Custom metric 36 | report_custom_00036 | met | ||
| Custom metric 37 | report_custom_00037 | met | ||
| Custom metric 38 | report_custom_00038 | met | ||
| Custom metric 39 | report_custom_00039 | met | ||
| Custom metric 40 | report_custom_00040 | met | ||
| Custom metric 41 | report_custom_00041 | met | ||
| Custom metric 42 | report_custom_00042 | met | ||
| Custom metric 43 | report_custom_00043 | met | ||
| Custom metric 44 | report_custom_00044 | met | ||
| Custom metric 45 | report_custom_00045 | met | ||
| Custom metric 46 | report_custom_00046 | met | ||
| Custom metric 47 | report_custom_00047 | met | ||
| Custom metric 48 | report_custom_00048 | met | ||
| Custom metric 49 | report_custom_00049 | met | ||
| Custom metric 50 | report_custom_00050 | met |