Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Affiliate | Affiliate ID | adv_channels_affiliate_id | dim | Numerical ID of an affiliate account. |
| Affiliate name | adv_channels_affiliate_name | dim | Name of the affiliate. Individual or company. | |
| Channel | Channel ID | adv_channels_channel_id | dim | Numerical ID of a channel. |
| Channel name | adv_channels_channel_name | dim | Name of a channel. | |
| Channel description | adv_channels_channel_description | dim | A description of a channel. | |
| Channel URL | adv_channels_channel_url | dim | The URL of a channel, if applicable. | |
| Channel type | adv_channels_channel_type | dim | The type of a channel, such as Blog, Content, Facebook, Cashback, etc. | |
| Approval status | adv_channels_approval_status | dim | Approval status of a channel for an affiliate program: 0 = rejected, 1 = approved, 2 = pending review. | |
| Number of channels | adv_channels_count | met | Number of channels. | |
| Ad | Ad ID | adv_clicks_ad_id | dim | Numerical ID of an ad. |
| Ad name | adv_clicks_ad_name | dim | Name of banner or link. | |
| Ad type | adv_clicks_ad_type | dim | Type of banner or link. | |
| Channel | Channel ID | adv_clicks_channel_id | dim | Numerical ID of a channel. |
| Click | Click status | adv_clicks_status | dim | Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration. |
| Number of clicks | adv_clicks_count | met | Number of clicks. | |
| Transaction | Unique ID | adv_transactions_unique_id | dim | Unique ID for the transaction. |
| Transaction name | adv_transactions_transaction_name | dim | Name of the transaction. | |
| Transaction status | adv_transactions_transaction_status | dim | The status of the transactions to be included in the dataset. Impressions and clicks are not affected by this input. 1 = approved, 2 = pending, 3 = approved + pending, 4 = open claims, 5 = rejected. | |
| Rejection reason | adv_transactions_reason_text | dim | For rejected transactions (transactionStatus = 5) you may choose to provide the reason for the transaction being rejected. | |
| Payment status | adv_transactions_payment_status | dim | Specifies what payment status of transaction should be included in the dataset. 1 = not invoiced, 2 = invoiced to advertiser, 3 = ready for payment, 4 = paid to affiliate. | |
| Last updated | adv_transactions_last_updated | dim | UTC timestamp of when the transactionStatus or orderValue of the transaction was last updated. Only available for transactions where transactionStatus or orderValue has been updated. | |
| Last updated date | adv_transactions_last_updated_date | dim | Date of when the transactionStatus or orderValue of the transaction was last updated. Only available for transactions where transactionStatus or orderValue has been updated. | |
| Auto approval date | adv_transactions_auto_approval_date | dim | Date when a pending transaction (transactionStatus = 2) will be automatically approved unless already approved or rejected. | |
| Device | Device | adv_transactions_device | dim | The type of device that was used to complete the transaction. |
| Operating system | adv_transactions_operating_system | dim | The operating system used on the device that was used to complete the transaction. | |
| Geo | Geo location | adv_transactions_geo_location | dim | The geographic market where the transaction was completed, defined by an ISO 3166-1 Alpha-2 country code. |
| Ad | Ad ID | adv_transactions_ad_id | dim | Numerical ID of an ad. |
| Ad name | adv_transactions_ad_name | dim | Name of banner or link. | |
| Ad type | adv_transactions_ad_type | dim | Type of banner or link. | |
| Channel | Channel ID | adv_transactions_channel_id | dim | Numerical ID of a channel. |
| Channel name | adv_transactions_channel_name | dim | Name of a channel. | |
| Click | Click time | adv_transactions_click_time | dim | UTC timestamp of the click that generated the transaction. |
| Click date | adv_transactions_click_date | dim | Date of the click that generated the transaction. | |
| Click status | adv_transactions_status | dim | Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration. | |
| Number of clicks | adv_transactions_count | met | Number of clicks. | |
| Cost | adv_transactions_cost | met | The cost of the transaction, including affiliate commission and Adtraction network fee. | |
| Order value | adv_transactions_order_value | met | Order value of the transaction. | |
| Advertiser | Account name | adv_statistics_account_name | dim | Account name. |
| Clicks | adv_statistics_clicks | met | Number of clicks. | |
| Clicks unique | adv_statistics_clicks_unique | met | Number of unique clicks. | |
| Cost | adv_statistics_cost | met | The total cost of the transaction, including affiliate commission and network fee. | |
| Impressions | adv_statistics_impressions | met | Number of banner / links impressions. | |
| Impressions unique | adv_statistics_impressions_unique | met | Number of unique banner / links impressions. | |
| Order value | adv_statistics_order_value | met | Order value of the sale transactions. | |
| Leads | adv_statistics_leads | met | Number of lead transactions. | |
| Sales | adv_statistics_sales | met | Number of sale transactions. | |
| CTR | adv_statistics_ctr | met | Click Through Ratio, obtained by dividing clicks by impressions. | |
| Lead ratio | adv_statistics_lead_ratio | met | Lead Ratio, obtained by dividing leads by clicksUnique. | |
| Conversion ratio | adv_statistics_conversion_ratio | met | Conversion Ratio, obtained by dividing sales by clicksUnique. | |
| Average order value | adv_statistics_aov | met | Average order value, obtained by dividing order value by number of sale transactions. | |
| Ad | Ad ID | adv_statistics_ads_ad_id | dim | ID of the ad. |
| Ad name | adv_statistics_ads_ad_name | dim | Name of the ad. | |
| Clicks | adv_statistics_ads_clicks | met | Number of clicks. | |
| Clicks unique | adv_statistics_ads_clicks_unique | met | Number of unique clicks. | |
| Cost | adv_statistics_ads_cost | met | The total cost of the transaction, including affiliate commission and network fee. | |
| Impressions | adv_statistics_ads_impressions | met | Number of banner / links impressions. | |
| Impressions unique | adv_statistics_ads_impressions_unique | met | Number of unique banner / links impressions. | |
| Order value | adv_statistics_ads_order_value | met | Order value of the sale transactions. | |
| Leads | adv_statistics_ads_leads | met | Number of lead transactions. | |
| Sales | adv_statistics_ads_sales | met | Number of sale transactions. | |
| CTR | adv_statistics_ads_ctr | met | Click Through Ratio, obtained by dividing clicks by impressions. | |
| Lead ratio | adv_statistics_ads_lead_ratio | met | Lead Ratio, obtained by dividing leads by clicksUnique. | |
| Conversion ratio | adv_statistics_ads_conversion_ratio | met | Conversion Ratio, obtained by dividing sales by clicksUnique. | |
| Average order value | adv_statistics_ads_aov | met | Average order value, obtained by dividing order value by number of sale transactions. | |
| Channel | Channel ID | adv_statistics_channel_channel_id | dim | ID of the channel. |
| Channel name | adv_statistics_channel_channel_name | dim | Name of the channel. | |
| Clicks | adv_statistics_channel_clicks | met | Number of clicks. | |
| Clicks unique | adv_statistics_channel_clicks_unique | met | Number of unique clicks. | |
| Cost | adv_statistics_channel_cost | met | The total cost of the transaction, including affiliate commission and network fee. | |
| Impressions | adv_statistics_channel_impressions | met | Number of banner / links impressions. | |
| Impressions unique | adv_statistics_channel_impressions_unique | met | Number of unique banner / links impressions. | |
| Order value | adv_statistics_channel_order_value | met | Order value of the sale transactions. | |
| Leads | adv_statistics_channel_leads | met | Number of lead transactions. | |
| Sales | adv_statistics_channel_sales | met | Number of sale transactions. | |
| CTR | adv_statistics_channel_ctr | met | Click Through Ratio, obtained by dividing clicks by impressions. | |
| Lead ratio | adv_statistics_channel_lead_ratio | met | Lead Ratio, obtained by dividing leads by clicksUnique. | |
| Conversion ratio | adv_statistics_channel_conversion_ratio | met | Conversion Ratio, obtained by dividing sales by clicksUnique. | |
| Average order value | adv_statistics_channel_aov | met | Average order value, obtained by dividing order value by number of sale transactions. | |
| Time | Year | adv_statistics_days_year | dim | |
| Year of week (Sun-Sat) | adv_statistics_days_year_of_week | dim | ||
| Year of week (Mon-Sun) | adv_statistics_days_year_of_week_iso | dim | ||
| Year & month | adv_statistics_days_year_month | dim | ||
| Month | adv_statistics_days_month | dim | ||
| Year & week (Sun-Sat) | adv_statistics_days_year_week | dim | ||
| Year & week (Mon-Sun) | adv_statistics_days_year_week_iso | dim | ||
| Week (Sun-Sat) | adv_statistics_days_week | dim | ||
| Week (Mon-Sun) | adv_statistics_days_week_iso | dim | ||
| Day of month | adv_statistics_days_day_of_month | dim | ||
| Day of week (Sun-Sat) | adv_statistics_days_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | adv_statistics_days_day_of_week_name_iso | dim | ||
| Date | adv_statistics_days_date | dim | ||
| Datetime | adv_statistics_days_atom | dim | ||
| Clicks | adv_statistics_days_clicks | met | Number of clicks. | |
| Clicks unique | adv_statistics_days_clicks_unique | met | Number of unique clicks. | |
| Cost | adv_statistics_days_cost | met | The total cost of the transaction, including affiliate commission and network fee. | |
| Impressions | adv_statistics_days_impressions | met | Number of banner / links impressions. | |
| Impressions unique | adv_statistics_days_impressions_unique | met | Number of unique banner / links impressions. | |
| Order value | adv_statistics_days_order_value | met | Order value of the sale transactions. | |
| Leads | adv_statistics_days_leads | met | Number of lead transactions. | |
| Sales | adv_statistics_days_sales | met | Number of sale transactions. | |
| CTR | adv_statistics_days_ctr | met | Click Through Ratio, obtained by dividing clicks by impressions. | |
| Lead ratio | adv_statistics_days_lead_ratio | met | Lead Ratio, obtained by dividing leads by clicksUnique. | |
| Conversion ratio | adv_statistics_days_conversion_ratio | met | Conversion Ratio, obtained by dividing sales by clicksUnique. | |
| Average order value | adv_statistics_days_aov | met | Average order value, obtained by dividing order value by number of sale transactions. | |
| Segment | Segment ID | adv_statistics_segments_segment_id | dim | Numerical ID of a commission segment. |
| Segment name | adv_statistics_segments_segment_name | dim | Name of a commission segment. | |
| Clicks | adv_statistics_segments_clicks | met | Number of clicks. | |
| Clicks unique | adv_statistics_segments_clicks_unique | met | Number of unique clicks. | |
| Cost | adv_statistics_segments_cost | met | The total cost of the transaction, including affiliate commission and network fee. | |
| Impressions | adv_statistics_segments_impressions | met | Number of banner / links impressions. | |
| Impressions unique | adv_statistics_segments_impressions_unique | met | Number of unique banner / links impressions. | |
| Order value | adv_statistics_segments_order_value | met | Order value of the sale transactions. | |
| Leads | adv_statistics_segments_leads | met | Number of lead transactions. | |
| Sales | adv_statistics_segments_sales | met | Number of sale transactions. | |
| CTR | adv_statistics_segments_ctr | met | Click Through Ratio, obtained by dividing clicks by impressions. | |
| Lead ratio | adv_statistics_segments_lead_ratio | met | Lead Ratio, obtained by dividing leads by clicksUnique. | |
| Conversion ratio | adv_statistics_segments_conversion_ratio | met | Conversion Ratio, obtained by dividing sales by clicksUnique. | |
| Average order value | adv_statistics_segments_aov | met | Average order value, obtained by dividing order value by number of sale transactions. | |
| Market | Market code | aff_markets_market_code | dim | ISO 3166-1 Alpha-2 country code. |
| Market name | aff_markets_market_name | dim | Name of the market | |
| Market ID | aff_markets_market_id | dim | Numerical Adtraction ID of the market. | |
| Channel | Channel ID | aff_channels_channel_id | dim | Numerical ID of the channel. |
| Channel name | aff_channels_channel_name | dim | Name of the channel | |
| Channel URL | aff_channels_channel_url | dim | The URL of a channel, if applicable. | |
| Currency | Currency | aff_currencies_currency | dim | Currency in ISO 4217 format. |
| Currency ID | aff_currencies_currency_id | dim | Numerical ID of the currency. | |
| Application | Channel ID | aff_applications_channel_id | dim | Numerical ID of a channel. |
| Channel name | aff_applications_channel_name | dim | Name of a publisher channel. | |
| Status | aff_applications_status | dim | Status of the channel's application for the specified program. 0 = rejected, 1 = approved, 2 = pending. | |
| Program ID | aff_applications_program_id | dim | Numerical ID of an affiliate program. | |
| Program name | aff_applications_program_name | dim | Name of an affiliate program. | |
| Ad | Ad ID | aff_clicks_ad_id | dim | Numerical ID of an ad. |
| Ad name | aff_clicks_ad_name | dim | Name of banner or link. | |
| Ad type | aff_clicks_ad_type | dim | Type of banner or link. | |
| Click info | Channel ID | aff_clicks_channel_id | dim | Numerical ID of a channel. Your Channel IDs can be found by navigating to "Account" > "My channels" in your Adtraction account. |
| Click datetime | aff_clicks_click_datetime | dim | UTC timestamp of the click that generated the transaction. | |
| Click date | aff_clicks_click_date | dim | UTC date of the click that generated the transaction. | |
| Referrer | aff_clicks_referrer | dim | HTTP referrer for the click. | |
| Program ID | aff_clicks_program_id | dim | Numerical ID of an affiliate program. | |
| Program name | aff_clicks_program_name | dim | Name of an affiliate program. | |
| Status | aff_clicks_status | dim | Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration. | |
| EPI | aff_clicks_epi | dim | EPI extracted from the tracking link that generated the click. | |
| Google click ID | aff_clicks_gclid | dim | Google Click ID. Extracted from the tracking link that generated the transaction. | |
| Count | aff_clicks_count | met | Number of clicks. | |
| Ad | Ad ID | aff_transactions_ad_id | dim | Numerical ID of an ad. |
| Ad name | aff_transactions_ad_name | dim | Name of banner or link. | |
| Ad type | aff_transactions_ad_type | dim | Type of banner or link. | |
| Click info | Channel ID | aff_transactions_channel_id | dim | Numerical ID of a channel. Your Channel IDs can be found by navigating to "Account" > "My channels" in your Adtraction account. |
| Click datetime | aff_transactions_click_datetime | dim | UTC timestamp of the click that generated the transaction. | |
| Click date | aff_transactions_click_date | dim | UTC date of the click that generated the transaction. | |
| Referrer | aff_transactions_referrer | dim | HTTP referrer for the click. | |
| Program ID | aff_transactions_program_id | dim | Numerical ID of an affiliate program. | |
| Program name | aff_transactions_program_name | dim | Name of an affiliate program. | |
| Status | aff_transactions_status | dim | Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration. | |
| EPI | aff_transactions_epi | dim | EPI extracted from the tracking link that generated the click. | |
| Google click ID | aff_transactions_gclid | dim | Google Click ID. Extracted from the tracking link that generated the transaction. | |
| Transaction | Transaction ID | aff_transactions_unique_id | dim | Unique ID for the transaction. |
| Transaction name | aff_transactions_transaction_name | dim | Name of the transaction. | |
| Transaction type | aff_transactions_transaction_type | dim | Specifies the type of the transaction where: 3 = Sale, 4 = Lead, 31 = iSale (post impression Sale), 41 = iLead (post impression Lead). | |
| Transaction status | aff_transactions_transaction_status | dim | The status of the transactions to be included in the dataset. Impressions and clicks are not affected by this input. 1 = approved, 2 = pending, 3 = approved + pending, 4 = open claims, 5 = rejected. | |
| Currency | aff_transactions_currency | dim | Currency in ISO 4217 format. | |
| Payment status | aff_transactions_payment_status | dim | Specifies what payment status of transaction should be included in the dataset. 1 = not invoiced, 2 = invoiced to advertiser, 3 = ready for payment, 4 = paid to affiliate. | |
| Reason text | aff_transactions_reason_text | dim | For rejected transactions (transactionStatus = 5) the advertiser can may choose to provide the reason for the transaction being rejected. | |
| Transaction datetime | aff_transactions_transaction_datetime | dim | UTC timestamp of when the transaction was reported by the advertiser. | |
| Transaction date | aff_transactions_transaction_date | dim | UTC date of when the transaction was reported by the advertiser. | |
| Last updated datetime | aff_transactions_last_updated_datetime | dim | UTC timestamp of when the transactionStatus or orderValue of the transaction was last updated. Only available for transactions where transactionStatus or orderValue has been updated. | |
| Last updated date | aff_transactions_last_updated_date | dim | UTC date of when the transactionStatus or orderValue of the transaction was last updated. Only available for transactions where transactionStatus or orderValue has been updated. | |
| Last updated date | aff_transactions_auto_approval_date | dim | Date when a pending transaction (transactionStatus = 2) will be automatically approved unless already approved or rejected by the advertiser. | |
| Device | Device | aff_transactions_device | dim | The type of device that was used to complete the transaction. |
| Operating system | aff_transactions_operating_system | dim | The operating system used on the device that was used to complete the transaction. | |
| Geo | Geo location | aff_transactions_geo_location | dim | The geographic market where the transaction was completed, defined by an ISO 3166-1 Alpha-2 country code. |
| Count | aff_transactions_count | met | Number of transactions. | |
| Commission | aff_transactions_commission | met | The affiliate commission for the transaction. If the commission amount has been updated after the creation of the transaction, this parameter will hold the updated commission amount. | |
| Order value | aff_transactions_order_value | met | Order value of the transaction. | |
| Original commission | aff_transactions_original_commission | met | Affiliate commission for the transaction. If the commission amount has been updated after the creation of the transaction, this parameter will hold the commission amount that existed before the update. | |
| Original order value | aff_transactions_original_order_value | met | Advertiser order value for the transaction. If the order value has been updated after the creation of the transaction, this parameter will hold the order value that existed before the update. | |
| Ad | Ad ID | aff_transactions_latest_ad_id | dim | Numerical ID of an ad. |
| Ad name | aff_transactions_latest_ad_name | dim | Name of banner or link. | |
| Ad type | aff_transactions_latest_ad_type | dim | Type of banner or link. | |
| Click info | Channel ID | aff_transactions_latest_channel_id | dim | Numerical ID of a channel. Your Channel IDs can be found by navigating to "Account" > "My channels" in your Adtraction account. |
| Click datetime | aff_transactions_latest_click_datetime | dim | UTC timestamp of the click that generated the transaction. | |
| Click date | aff_transactions_latest_click_date | dim | UTC date of the click that generated the transaction. | |
| Referrer | aff_transactions_latest_referrer | dim | HTTP referrer for the click. | |
| Program ID | aff_transactions_latest_program_id | dim | Numerical ID of an affiliate program. | |
| Program name | aff_transactions_latest_program_name | dim | Name of an affiliate program. | |
| Status | aff_transactions_latest_status | dim | Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration. | |
| EPI | aff_transactions_latest_epi | dim | EPI extracted from the tracking link that generated the click. | |
| Google click ID | aff_transactions_latest_gclid | dim | Google Click ID. Extracted from the tracking link that generated the transaction. | |
| Transaction | Transaction ID | aff_transactions_latest_unique_id | dim | Unique ID for the transaction. |
| Transaction name | aff_transactions_latest_transaction_name | dim | Name of the transaction. | |
| Transaction type | aff_transactions_latest_transaction_type | dim | Specifies the type of the transaction where: 3 = Sale, 4 = Lead, 31 = iSale (post impression Sale), 41 = iLead (post impression Lead). | |
| Transaction status | aff_transactions_latest_transaction_status | dim | The status of the transactions to be included in the dataset. Impressions and clicks are not affected by this input. 1 = approved, 2 = pending, 3 = approved + pending, 4 = open claims, 5 = rejected. | |
| Currency | aff_transactions_latest_currency | dim | Currency in ISO 4217 format. | |
| Payment status | aff_transactions_latest_payment_status | dim | Specifies what payment status of transaction should be included in the dataset. 1 = not invoiced, 2 = invoiced to advertiser, 3 = ready for payment, 4 = paid to affiliate. | |
| Reason text | aff_transactions_latest_reason_text | dim | For rejected transactions (transactionStatus = 5) the advertiser can may choose to provide the reason for the transaction being rejected. | |
| Transaction datetime | aff_transactions_latest_transaction_datetime | dim | UTC timestamp of when the transaction was reported by the advertiser. | |
| Transaction date | aff_transactions_latest_transaction_date | dim | UTC date of when the transaction was reported by the advertiser. | |
| Last updated datetime | aff_transactions_latest_last_updated_datetime | dim | UTC timestamp of when the transactionStatus or orderValue of the transaction was last updated. Only available for transactions where transactionStatus or orderValue has been updated. | |
| Last updated date | aff_transactions_latest_last_updated_date | dim | UTC date of when the transactionStatus or orderValue of the transaction was last updated. Only available for transactions where transactionStatus or orderValue has been updated. | |
| Last updated date | aff_transactions_latest_auto_approval_date | dim | Date when a pending transaction (transactionStatus = 2) will be automatically approved unless already approved or rejected by the advertiser. | |
| Device | Device | aff_transactions_latest_device | dim | The type of device that was used to complete the transaction. |
| Operating system | aff_transactions_latest_operating_system | dim | The operating system used on the device that was used to complete the transaction. | |
| Geo | Geo location | aff_transactions_latest_geo_location | dim | The geographic market where the transaction was completed, defined by an ISO 3166-1 Alpha-2 country code. |
| Count | aff_transactions_latest_count | met | Number of transactions. | |
| Commission | aff_transactions_latest_commission | met | The affiliate commission for the transaction. If the commission amount has been updated after the creation of the transaction, this parameter will hold the updated commission amount. | |
| Order value | aff_transactions_latest_order_value | met | Order value of the transaction. | |
| Original commission | aff_transactions_latest_original_commission | met | Affiliate commission for the transaction. If the commission amount has been updated after the creation of the transaction, this parameter will hold the commission amount that existed before the update. | |
| Original order value | aff_transactions_latest_original_order_value | met | Advertiser order value for the transaction. If the order value has been updated after the creation of the transaction, this parameter will hold the order value that existed before the update. | |
| Currency | Currency | aff_statistics_currency | dim | Currency in ISO 4217 format. |
| Clicks | aff_statistics_clicks | met | Number of clicks. | |
| Clicks unique | aff_statistics_clicks_unique | met | Number of unique clicks. | |
| Commission | aff_statistics_commission | met | Amount of affiliate commission. | |
| Impressions | aff_statistics_impressions | met | Number of banner / links impressions. | |
| Impressions unique | aff_statistics_impressions_unique | met | Number of unique banner / links impressions. | |
| Order value | aff_statistics_order_value | met | Order value of the sale transactions. | |
| Leads | aff_statistics_leads | met | Number of lead transactions. | |
| Sales | aff_statistics_sales | met | Number of sale transactions. | |
| CTR | aff_statistics_ctr | met | Click Through Ratio, obtained by dividing clicks by impressions. | |
| Lead ratio | aff_statistics_lead_ratio | met | Lead Ratio, obtained by dividing leads by clicksUnique. | |
| Conversion ratio | aff_statistics_conversion_ratio | met | Conversion Ratio, obtained by dividing sales by clicksUnique. | |
| Average order value | aff_statistics_aov | met | Average order value, obtained by dividing order value by number of sale transactions. | |
| EPC | aff_statistics_epc | met | Earnings Per Click obtained by dividing the commission by clicksUnique. | |
| Ad | Ad ID | aff_statistics_ads_ad_id | dim | ID of the ad. |
| Ad name | aff_statistics_ads_ad_name | dim | Name of the ad. | |
| Clicks | aff_statistics_ads_clicks | met | Number of clicks. | |
| Clicks unique | aff_statistics_ads_clicks_unique | met | Number of unique clicks. | |
| Commission | aff_statistics_ads_commission | met | Amount of affiliate commission. | |
| Impressions | aff_statistics_ads_impressions | met | Number of banner / links impressions. | |
| Impressions unique | aff_statistics_ads_impressions_unique | met | Number of unique banner / links impressions. | |
| Order value | aff_statistics_ads_order_value | met | Order value of the sale transactions. | |
| Leads | aff_statistics_ads_leads | met | Number of lead transactions. | |
| Sales | aff_statistics_ads_sales | met | Number of sale transactions. | |
| CTR | aff_statistics_ads_ctr | met | Click Through Ratio, obtained by dividing clicks by impressions. | |
| Lead ratio | aff_statistics_ads_lead_ratio | met | Lead Ratio, obtained by dividing leads by clicksUnique. | |
| Conversion ratio | aff_statistics_ads_conversion_ratio | met | Conversion Ratio, obtained by dividing sales by clicksUnique. | |
| Average order value | aff_statistics_ads_aov | met | Average order value, obtained by dividing order value by number of sale transactions. | |
| EPC | aff_statistics_ads_epc | met | Earnings Per Click obtained by dividing the commission by clicksUnique. | |
| Channel | Channel ID | aff_statistics_channel_channel_id | dim | ID of the channel. |
| Channel name | aff_statistics_channel_channel_name | dim | Name of the channel. | |
| Clicks | aff_statistics_channel_clicks | met | Number of clicks. | |
| Clicks unique | aff_statistics_channel_clicks_unique | met | Number of unique clicks. | |
| Commission | aff_statistics_channel_commission | met | Amount of affiliate commission. | |
| Impressions | aff_statistics_channel_impressions | met | Number of banner / links impressions. | |
| Impressions unique | aff_statistics_channel_impressions_unique | met | Number of unique banner / links impressions. | |
| Order value | aff_statistics_channel_order_value | met | Order value of the sale transactions. | |
| Leads | aff_statistics_channel_leads | met | Number of lead transactions. | |
| Sales | aff_statistics_channel_sales | met | Number of sale transactions. | |
| CTR | aff_statistics_channel_ctr | met | Click Through Ratio, obtained by dividing clicks by impressions. | |
| Lead ratio | aff_statistics_channel_lead_ratio | met | Lead Ratio, obtained by dividing leads by clicksUnique. | |
| Conversion ratio | aff_statistics_channel_conversion_ratio | met | Conversion Ratio, obtained by dividing sales by clicksUnique. | |
| Average order value | aff_statistics_channel_aov | met | Average order value, obtained by dividing order value by number of sale transactions. | |
| EPC | aff_statistics_channel_epc | met | Earnings Per Click obtained by dividing the commission by clicksUnique. | |
| Time | Year | aff_statistics_day_year | dim | |
| Year of week (Sun-Sat) | aff_statistics_day_year_of_week | dim | ||
| Year of week (Mon-Sun) | aff_statistics_day_year_of_week_iso | dim | ||
| Year & month | aff_statistics_day_year_month | dim | ||
| Month | aff_statistics_day_month | dim | ||
| Year & week (Sun-Sat) | aff_statistics_day_year_week | dim | ||
| Year & week (Mon-Sun) | aff_statistics_day_year_week_iso | dim | ||
| Week (Sun-Sat) | aff_statistics_day_week | dim | ||
| Week (Mon-Sun) | aff_statistics_day_week_iso | dim | ||
| Day of month | aff_statistics_day_day_of_month | dim | ||
| Day of week (Sun-Sat) | aff_statistics_day_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | aff_statistics_day_day_of_week_name_iso | dim | ||
| Date | aff_statistics_day_date | dim | ||
| Datetime | aff_statistics_day_atom | dim | ||
| Date | Clicks | aff_statistics_day_clicks | met | Number of clicks. |
| Clicks unique | aff_statistics_day_clicks_unique | met | Number of unique clicks. | |
| Commission | aff_statistics_day_commission | met | Amount of affiliate commission. | |
| Impressions | aff_statistics_day_impressions | met | Number of banner / links impressions. | |
| Impressions unique | aff_statistics_day_impressions_unique | met | Number of unique banner / links impressions. | |
| Order value | aff_statistics_day_order_value | met | Order value of the sale transactions. | |
| Leads | aff_statistics_day_leads | met | Number of lead transactions. | |
| Sales | aff_statistics_day_sales | met | Number of sale transactions. | |
| CTR | aff_statistics_day_ctr | met | Click Through Ratio, obtained by dividing clicks by impressions. | |
| Lead ratio | aff_statistics_day_lead_ratio | met | Lead Ratio, obtained by dividing leads by clicksUnique. | |
| Conversion ratio | aff_statistics_day_conversion_ratio | met | Conversion Ratio, obtained by dividing sales by clicksUnique. | |
| Average order value | aff_statistics_day_aov | met | Average order value, obtained by dividing order value by number of sale transactions. | |
| EPC | aff_statistics_day_epc | met | Earnings Per Click obtained by dividing the commission by clicksUnique. | |
| Clicks | aff_statistics_epi_clicks | met | Number of clicks. | |
| Clicks unique | aff_statistics_epi_clicks_unique | met | Number of unique clicks. | |
| Commission | aff_statistics_epi_commission | met | Amount of affiliate commission. | |
| Impressions | aff_statistics_epi_impressions | met | Number of banner / links impressions. | |
| Impressions unique | aff_statistics_epi_impressions_unique | met | Number of unique banner / links impressions. | |
| Order value | aff_statistics_epi_order_value | met | Order value of the sale transactions. | |
| Leads | aff_statistics_epi_leads | met | Number of lead transactions. | |
| Sales | aff_statistics_epi_sales | met | Number of sale transactions. | |
| CTR | aff_statistics_epi_ctr | met | Click Through Ratio, obtained by dividing clicks by impressions. | |
| Lead ratio | aff_statistics_epi_lead_ratio | met | Lead Ratio, obtained by dividing leads by clicksUnique. | |
| Conversion ratio | aff_statistics_epi_conversion_ratio | met | Conversion Ratio, obtained by dividing sales by clicksUnique. | |
| Average order value | aff_statistics_epi_aov | met | Average order value, obtained by dividing order value by number of sale transactions. | |
| EPC | aff_statistics_epi_epc | met | Earnings Per Click obtained by dividing the commission by clicksUnique. | |
| Program | Program ID | aff_statistics_program_program_id | dim | Numerical ID of an affiliate program. |
| Program name | aff_statistics_program_program_name | dim | Name of an affiliate program. | |
| Clicks | aff_statistics_program_clicks | met | Number of clicks. | |
| Clicks unique | aff_statistics_program_clicks_unique | met | Number of unique clicks. | |
| Commission | aff_statistics_program_commission | met | Amount of affiliate commission. | |
| Impressions | aff_statistics_program_impressions | met | Number of banner / links impressions. | |
| Impressions unique | aff_statistics_program_impressions_unique | met | Number of unique banner / links impressions. | |
| Order value | aff_statistics_program_order_value | met | Order value of the sale transactions. | |
| Leads | aff_statistics_program_leads | met | Number of lead transactions. | |
| Sales | aff_statistics_program_sales | met | Number of sale transactions. | |
| CTR | aff_statistics_program_ctr | met | Click Through Ratio, obtained by dividing clicks by impressions. | |
| Lead ratio | aff_statistics_program_lead_ratio | met | Lead Ratio, obtained by dividing leads by clicksUnique. | |
| Conversion ratio | aff_statistics_program_conversion_ratio | met | Conversion Ratio, obtained by dividing sales by clicksUnique. | |
| Average order value | aff_statistics_program_aov | met | Average order value, obtained by dividing order value by number of sale transactions. | |
| EPC | aff_statistics_program_epc | met | Earnings Per Click obtained by dividing the commission by clicksUnique. |