Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | pub_year | dim | Year |
| Year & month | pub_yearmonth | dim | Year and month | |
| Month | pub_month | dim | Month | |
| Account | Advertiser ID | pub_advertiser_id | dim | ID of the advertiser |
| Advertiser name | pub_advertiser_name | dim | Name of the advertiser | |
| Publisher ID | pub_publisher_id | dim | ID of the publisher | |
| Publisher name | pub_publisher_name | dim | Name of the publisher | |
| Creative ID | pub_creative_id | dim | ||
| Creative name | pub_creative_name | dim | Name of the creative | |
| Tag name | pub_tag_name | dim | Tag name of the creative, used by the advertiser to group creatives | |
| Region | Region | pub_region | dim | |
| Currency | pub_currency | dim | ||
| Impressions | pub_impressions | met | Number of impressions | |
| Clicks | pub_clicks | met | Number of clicks | |
| CTR | pub_ctr | met | Clicks / Impressions | |
| Pending transactions | pub_pending_no | met | Number of pending transactions | |
| Pending value | pub_pending_value | met | Value of pending transactions | |
| Pending commission | pub_pending_comm | met | Commission of the pending transactions | |
| Confirmed transactions | pub_confirmed_no | met | Number of confirmed transactions | |
| Confirmed value | pub_confirmed_value | met | Value of confirmed transactions | |
| Confirmed commission | pub_confirmed_comm | met | Commission of the confirmed transactions | |
| Bonus transactions | pub_bonus_no | met | Number of bonus transactions | |
| Bonus value | pub_bonus_value | met | Value of the bonus transactions | |
| Bonus commission | pub_bonus_comm | met | Commission of the bonus transactions | |
| Total transactions | pub_total_no | met | Total number of transactions | |
| Total value | pub_total_value | met | Total value of transactions | |
| Total commission | pub_total_comm | met | Commission of the all transactions | |
| Declined transactions | pub_declined_no | met | Number of declined transactions | |
| Declined value | pub_declined_value | met | Value of the declined transactions | |
| Declined commission | pub_declined_comm | met | Commission of the declined transactions | |
| TIME | Year | pub_dwh_year | dim | Year |
| Year & month | pub_dwh_yearmonth | dim | Year and month | |
| Month | pub_dwh_month | dim | Month | |
| Date | pub_dwh_date | dim | Date | |
| Account | Advertiser ID | pub_dwh_advertiser_id | dim | ID of the advertiser |
| Advertiser name | pub_dwh_advertiser_name | dim | Name of the advertiser | |
| Publisher ID | pub_dwh_publisher_id | dim | ID of the publisher | |
| Publisher name | pub_dwh_publisher_name | dim | Name of the publisher | |
| Creative ID | pub_dwh_creative_id | dim | ||
| Creative name | pub_dwh_creative_name | dim | Name of the creative | |
| Tag name | pub_dwh_tag_name | dim | Tag name of the creative, used by the advertiser to group creatives | |
| Region | Region | pub_dwh_region | dim | |
| Currency | pub_dwh_currency | dim | ||
| Impressions | pub_dwh_impressions | met | Number of impressions | |
| Clicks | pub_dwh_clicks | met | Number of clicks | |
| CTR | pub_dwh_ctr | met | Clicks / Impressions | |
| Pending transactions | pub_dwh_pending_no | met | Number of pending transactions | |
| Pending value | pub_dwh_pending_value | met | Value of pending transactions | |
| Pending commission | pub_dwh_pending_comm | met | Commission of the pending transactions | |
| Confirmed transactions | pub_dwh_confirmed_no | met | Number of confirmed transactions | |
| Confirmed value | pub_dwh_confirmed_value | met | Value of confirmed transactions | |
| Confirmed commission | pub_dwh_confirmed_comm | met | Commission of the confirmed transactions | |
| Bonus transactions | pub_dwh_bonus_no | met | Number of bonus transactions | |
| Bonus value | pub_dwh_bonus_value | met | Value of the bonus transactions | |
| Bonus commission | pub_dwh_bonus_comm | met | Commission of the bonus transactions | |
| Total transactions | pub_dwh_total_no | met | Total number of transactions | |
| Total value | pub_dwh_total_value | met | Total value of transactions | |
| Total commission | pub_dwh_total_comm | met | Commission of the all transactions | |
| Declined transactions | pub_dwh_declined_no | met | Number of declined transactions | |
| Declined value | pub_dwh_declined_value | met | Value of the declined transactions | |
| Declined commission | pub_dwh_declined_comm | met | Commission of the declined transactions | |
| TIME | Year | crea_year | dim | Year |
| Year & month | crea_yearmonth | dim | Year and month | |
| Month | crea_month | dim | Month | |
| Account | Advertiser ID | crea_advertiser_id | dim | ID of the advertiser |
| Advertiser name | crea_advertiser_name | dim | Name of the advertiser | |
| Publisher ID | crea_publisher_id | dim | ID of the publisher | |
| Publisher name | crea_publisher_name | dim | Name of the publisher | |
| Creative ID | crea_creative_id | dim | ||
| Creative name | crea_creative_name | dim | Name of the creative | |
| Tag name | crea_tag_name | dim | Tag name of the creative, used by the advertiser to group creatives | |
| Region | Region | crea_region | dim | |
| Currency | crea_currency | dim | ||
| Impressions | crea_impressions | met | Number of impressions | |
| Clicks | crea_clicks | met | Number of clicks | |
| CTR | crea_ctr | met | Clicks / Impressions | |
| Pending transactions | crea_pending_no | met | Number of pending transactions | |
| Pending value | crea_pending_value | met | Value of pending transactions | |
| Pending commission | crea_pending_comm | met | Commission of the pending transactions | |
| Confirmed transactions | crea_confirmed_no | met | Number of confirmed transactions | |
| Confirmed value | crea_confirmed_value | met | Value of confirmed transactions | |
| Confirmed commission | crea_confirmed_comm | met | Commission of the confirmed transactions | |
| Bonus transactions | crea_bonus_no | met | Number of bonus transactions | |
| Bonus value | crea_bonus_value | met | Value of the bonus transactions | |
| Bonus commission | crea_bonus_comm | met | Commission of the bonus transactions | |
| Total transactions | crea_total_no | met | Total number of transactions | |
| Total value | crea_total_value | met | Total value of transactions | |
| Total commission | crea_total_comm | met | Commission of the all transactions | |
| Declined transactions | crea_declined_no | met | Number of declined transactions | |
| Declined value | crea_declined_value | met | Value of the declined transactions | |
| Declined commission | crea_declined_comm | met | Commission of the declined transactions | |
| TIME | Year | crea_dwh_year | dim | Year |
| Year & month | crea_dwh_yearmonth | dim | Year and month | |
| Month | crea_dwh_month | dim | Month | |
| Date | crea_dwh_date | dim | Date | |
| Account | Advertiser ID | crea_dwh_advertiser_id | dim | ID of the advertiser |
| Advertiser name | crea_dwh_advertiser_name | dim | Name of the advertiser | |
| Publisher ID | crea_dwh_publisher_id | dim | ID of the publisher | |
| Publisher name | crea_dwh_publisher_name | dim | Name of the publisher | |
| Creative ID | crea_dwh_creative_id | dim | ||
| Creative name | crea_dwh_creative_name | dim | Name of the creative | |
| Tag name | crea_dwh_tag_name | dim | Tag name of the creative, used by the advertiser to group creatives | |
| Region | Region | crea_dwh_region | dim | |
| Currency | crea_dwh_currency | dim | ||
| Impressions | crea_dwh_impressions | met | Number of impressions | |
| Clicks | crea_dwh_clicks | met | Number of clicks | |
| CTR | crea_dwh_ctr | met | Clicks / Impressions | |
| Pending transactions | crea_dwh_pending_no | met | Number of pending transactions | |
| Pending value | crea_dwh_pending_value | met | Value of pending transactions | |
| Pending commission | crea_dwh_pending_comm | met | Commission of the pending transactions | |
| Confirmed transactions | crea_dwh_confirmed_no | met | Number of confirmed transactions | |
| Confirmed value | crea_dwh_confirmed_value | met | Value of confirmed transactions | |
| Confirmed commission | crea_dwh_confirmed_comm | met | Commission of the confirmed transactions | |
| Bonus transactions | crea_dwh_bonus_no | met | Number of bonus transactions | |
| Bonus value | crea_dwh_bonus_value | met | Value of the bonus transactions | |
| Bonus commission | crea_dwh_bonus_comm | met | Commission of the bonus transactions | |
| Total transactions | crea_dwh_total_no | met | Total number of transactions | |
| Total value | crea_dwh_total_value | met | Total value of transactions | |
| Total commission | crea_dwh_total_comm | met | Commission of the all transactions | |
| Declined transactions | crea_dwh_declined_no | met | Number of declined transactions | |
| Declined value | crea_dwh_declined_value | met | Value of the declined transactions | |
| Declined commission | crea_dwh_declined_comm | met | Commission of the declined transactions | |
| Time | Year | trans_year | dim | |
| Year of week (Sun-Sat) | trans_year_of_week | dim | ||
| Year of week (Mon-Sun) | trans_year_of_week_iso | dim | ||
| Year & month | trans_year_month | dim | ||
| Month | trans_month | dim | ||
| Year & week (Sun-Sat) | trans_year_week | dim | ||
| Year & week (Mon-Sun) | trans_year_week_iso | dim | ||
| Week (Sun-Sat) | trans_week | dim | ||
| Week (Mon-Sun) | trans_week_iso | dim | ||
| Day of month | trans_day_of_month | dim | ||
| Day of week (Sun-Sat) | trans_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | trans_day_of_week_name_iso | dim | ||
| Date | trans_date | dim | ||
| Datetime | trans_atom | dim | ||
| Transaction | Campaign name | trans_campaign | dim | Name of the campaign |
| Transaction ID | trans_transaction_id | dim | ID of the transaction | |
| Transaction query ID | trans_transaction_query_id | dim | The unique ID of the transaction query | |
| Transaction type | trans_type | dim | The type of the transaction | |
| Transaction URL | trans_transaction_url | dim | URL of the transaction | |
| Transaction date | trans_transaction_date | dim | The date and time of the click | |
| Transaction date and time | trans_transaction_date_time | dim | The date and time of the transaction | |
| Transaction decline reason | trans_decline_reason | dim | The decline reason of the transaction | |
| Transaction device | trans_transaction_device | dim | Device where transaction happened | |
| Voucher code used | trans_voucher_code_used | dim | Whether voucher code was used or not for transaction | |
| Voucher code | trans_voucher_code | dim | The voucher code that was used for the transaction | |
| Amended | trans_amended | dim | Whether transaction has been amended or not | |
| Amend reason | trans_amend_reason | dim | Reason why transaction was amended | |
| Advertiser | Advertiser ID | trans_advertiser_id | dim | ID of the advertiser |
| Advertiser country | trans_advertiser_country | dim | The country of the advertiser | |
| Publisher | Publisher ID | trans_publisher_id | dim | ID of the publisher |
| Site name | trans_site_name | dim | Name of the site | |
| Publisher URL | trans_publisher_url | dim | The URL of the publisher | |
| Commission sharing publisher ID | trans_commission_sharing_publisher_id | dim | ID of the commission sharing publisher | |
| Commission sharing selected rate publisher ID | trans_commission_sharing_selected_rate_publisher_id | dim | ID of the commission sharing selected rate publisher | |
| Customer | Customer country | trans_customer_country | dim | Country of the customer |
| IP hash | trans_ip_hash | dim | Hash of the IP address | |
| Click | Click reference | trans_click_ref | dim | Click reference for transaction |
| Click date | trans_click_date | dim | The date of the click | |
| Click date and time | trans_click_date_time | dim | The date and time of the click | |
| Click device | trans_click_device | dim | Device where click happened | |
| Commission | Order reference | trans_order_ref | dim | The reference of the order |
| Sale currency | trans_sale_currency | dim | Currency of the sale | |
| Commission currency | trans_commission_currency | dim | Currency of the commission | |
| Commission status | trans_commission_status | dim | Status of the commission | |
| Paid to publisher | trans_paid_to_publisher | dim | Whether transaction commission has been paid to publisher or not | |
| Payment ID | trans_payment_id | dim | The unique ID of the payment | |
| Commission amount | trans_commission_amount | met | The amount of commission | |
| Sale amount | trans_sale_amount | met | The amount of sale | |
| Old sale amount | trans_old_sale_amount | met | ||
| Old commission amount | trans_old_commission_amount | met | ||
| Original sale amount | trans_original_sale_amount | met | The original sale amount | |
| Lapse time | trans_lapse_time | met | The conversion time in seconds |