Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | performance_year | dim | |
| Year of week (Sun-Sat) | performance_year_of_week | dim | ||
| Year of week (Mon-Sun) | performance_year_of_week_iso | dim | ||
| Year & month | performance_year_month | dim | ||
| Month | performance_month | dim | ||
| Year & week (Sun-Sat) | performance_year_week | dim | ||
| Year & week (Mon-Sun) | performance_year_week_iso | dim | ||
| Week (Sun-Sat) | performance_week | dim | ||
| Week (Mon-Sun) | performance_week_iso | dim | ||
| Day of month | performance_day_of_month | dim | ||
| Day of week (Sun-Sat) | performance_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | performance_day_of_week_name_iso | dim | ||
| Date | performance_date | dim | ||
| Datetime | performance_atom | dim | ||
| Advertiser | Advertiser name | performance_advertiser_name | dim | Advertiser name |
| Advertiser ID | performance_advertiser_id | dim | Advertiser ID | |
| Event | Event Name | performance_event_name | dim | Event name |
| Partner | Partner name | performance_affiliate_name | dim | Partner name |
| Partner ID | performance_affiliate_id | dim | Partner ID | |
| Partner status | performance_affiliate_status | dim | Partner status | |
| Offer | Offer name | performance_offer_name | dim | Offer name |
| Offer ID | performance_offer_id | dim | Offer ID | |
| Offer status | performance_offer_status | dim | Offer status | |
| Offer group | performance_offer_group_name | dim | Offer group | |
| Category | performance_category | dim | Category | |
| Misc | Sub1 | performance_sub1 | dim | Sub1 |
| Sub2 | performance_sub2 | dim | Sub2 | |
| Sub3 | performance_sub3 | dim | Sub3 | |
| Sub4 | performance_sub4 | dim | Sub4 | |
| Sub5 | performance_sub5 | dim | Sub5 | |
| Impressions | performance_impressions | met | Number of impressions. | |
| Clicks | performance_total_clicks | met | Total number of clicks. | |
| CTR | performance_ctr | met | The amount of users that clicked on the advertisement, divided by the number of total users who viewed the advertising creative. (Total clicks / impressions). | |
| Gross clicks | performance_gross_clicks | met | These are all clicks, including unique, duplicates and invalid. | |
| Unique clicks | performance_unique_clicks | met | Unique click is an approved click from a user. | |
| Duplicate clicks | performance_duplicate_clicks | met | These are clicks that have been considered duplicates. | |
| Invalid clicks | performance_invalid_clicks | met | Clicks that fail the offer for any reason. | |
| Total CV | performance_total_cv | met | Total conversions are the sum of view through conversions and base conversions. | |
| CV | performance_cv | met | These are the total amount of base conversions. | |
| CVR | performance_cvr | met | Average number of conversions per click. (CV / total clicks). | |
| View through CV | performance_view_through_cv | met | This is the number of conversions counted through view-through attribution. | |
| Throttle | performance_throttle | met | Invalid conversion scrub. | |
| Events | performance_events | met | These are any additional actions that you would like tracked. | |
| View through events | performance_view_through_events | met | View through events. | |
| Payout | performance_payout | met | Payout owed to the partner or publishing source. | |
| CPC | performance_cpc | met | Total cost (Payout) divided by the number of clicks. (Payout / total clicks). | |
| CPM | performance_cpm | met | This is the payout per 1000 impressions delivered from an advertisement. ((Payout / impressions) * 1000). | |
| CPA | performance_cpa | met | Cost per action. (Payout / total conversions). | |
| Revenue | performance_revenue | met | Gross revenue payable by the advertiser, or reported to Everflow by your internal carts/tools if you are the advertiser. | |
| Gross sales | performance_gross_sales | met | Sum of the data passed in the amount spot in the postback URL. | |
| Avg sale value | performance_avg_sale_value | met | Average sale value. (Gross sales / total conversions). | |
| ROAS | performance_roas | met | Gross sales divided by total revenue. (Gross sales / revenue). | |
| RPM | performance_rpm | met | Revenue per mille. (Revenue / impressions) * 1000). | |
| EPC | performance_epc | met | Total earnings divided by the number of clicks. (Revenue / total clicks). | |
| RPC | performance_rpc | met | Total revenue divided by the number of clicks. (Revenue / total clicks). | |
| RPA | performance_rpa | met | Total revenue for each conversion. (Revenue / total conversions). | |
| Profit | performance_profit | met | Revenue less payout. | |
| Margin | performance_margin | met | Difference between revenue and payout. (Profit / revenue). |