--- title: "Adtraction data warehouse table groups" slug: "adtraction-data-warehouse-table-groups" description: "Explore the complete Supermetrics data warehouse table groups for Adtraction. See all the tables and the fields included in them." updated: 2026-03-13T12:00:47Z published: 2026-03-13T12:00:47Z canonical: "docs.supermetrics.com/adtraction-data-warehouse-table-groups" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt > Use this file to discover all available pages before exploring further. # Adtraction data warehouse table groups Search fields ### Table: ADVERTISER_CHANNEL | \| adv_channels__affiliate_id \| \| --- \| \| \\| Display name \\| Partner ID \\| \\| --- \\| --- \\| \\| Description \\| Numerical ID of a partner account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Partner ID \| \| Description \| Numerical ID of a partner account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | adv_channels__affiliate_id | | \| Display name \| Partner ID \| \| --- \| --- \| \| Description \| Numerical ID of a partner account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Partner ID | | Description | Numerical ID of a partner account | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_channels__affiliate_name \| \| --- \| \| \\| Display name \\| Partner name \\| \\| --- \\| --- \\| \\| Description \\| Name of the partner. Individual or company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Partner name \| \| Description \| Name of the partner. Individual or company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_channels__affiliate_name | | \| Display name \| Partner name \| \| --- \| --- \| \| Description \| Name of the partner. Individual or company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Partner name | | Description | Name of the partner. Individual or company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_channels__approval_status \| \| --- \| \| \\| Display name \\| Approval status \\| \\| --- \\| --- \\| \\| Description \\| Approval status of a channel for a partner program: 0 = rejected, 1 = approved, 2 = pending review \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Approval status \| \| Description \| Approval status of a channel for a partner program: 0 = rejected, 1 = approved, 2 = pending review \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_channels__approval_status | | \| Display name \| Approval status \| \| --- \| --- \| \| Description \| Approval status of a channel for a partner program: 0 = rejected, 1 = approved, 2 = pending review \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Approval status | | Description | Approval status of a channel for a partner program: 0 = rejected, 1 = approved, 2 = pending review | | Field type | dimension | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_channels__channel_description \| \| --- \| \| \\| Display name \\| Channel description \\| \\| --- \\| --- \\| \\| Description \\| A description of a channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel description \| \| Description \| A description of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_channels__channel_description | | \| Display name \| Channel description \| \| --- \| --- \| \| Description \| A description of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel description | | Description | A description of a channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_channels__channel_id \| \| --- \| \| \\| Display name \\| Channel ID \\| \\| --- \\| --- \\| \\| Description \\| Numerical ID of a channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel ID \| \| Description \| Numerical ID of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_channels__channel_id | | \| Display name \| Channel ID \| \| --- \| --- \| \| Description \| Numerical ID of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel ID | | Description | Numerical ID of a channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_channels__channel_name \| \| --- \| \| \\| Display name \\| Channel name \\| \\| --- \\| --- \\| \\| Description \\| Name of a channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel name \| \| Description \| Name of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_channels__channel_name | | \| Display name \| Channel name \| \| --- \| --- \| \| Description \| Name of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel name | | Description | Name of a channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_channels__channel_type \| \| --- \| \| \\| Display name \\| Channel type \\| \\| --- \\| --- \\| \\| Description \\| The type of a channel, such as Blog, Content, Facebook, Cashback, etc \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel type \| \| Description \| The type of a channel, such as Blog, Content, Facebook, Cashback, etc \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_channels__channel_type | | \| Display name \| Channel type \| \| --- \| --- \| \| Description \| The type of a channel, such as Blog, Content, Facebook, Cashback, etc \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel type | | Description | The type of a channel, such as Blog, Content, Facebook, Cashback, etc | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_channels__channel_url \| \| --- \| \| \\| Display name \\| Channel URL \\| \\| --- \\| --- \\| \\| Description \\| The URL of a channel, if applicable \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel URL \| \| Description \| The URL of a channel, if applicable \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | adv_channels__channel_url | | \| Display name \| Channel URL \| \| --- \| --- \| \| Description \| The URL of a channel, if applicable \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | Display name | Channel URL | | Description | The URL of a channel, if applicable | | Field type | dimension | | Data type | [string.text.url](/apidocs/field-data-types#text) | | \| adv_channels__count \| \| --- \| \| \\| Display name \\| Number of channels \\| \\| --- \\| --- \\| \\| Description \\| Number of channels \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Number of channels \| \| Description \| Number of channels \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_channels__count | | \| Display name \| Number of channels \| \| --- \| --- \| \| Description \| Number of channels \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Number of channels | | Description | Number of channels | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__aov \| \| --- \| \| \\| Display name \\| Average order value \\| \\| --- \\| --- \\| \\| Description \\| Average order value, obtained by dividing order value by number of sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Average order value \| \| Description \| Average order value, obtained by dividing order value by number of sale transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | adv_statistics_channel__aov | | \| Display name \| Average order value \| \| --- \| --- \| \| Description \| Average order value, obtained by dividing order value by number of sale transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Average order value | | Description | Average order value, obtained by dividing order value by number of sale transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| adv_statistics_channel__channel_id \| \| --- \| \| \\| Display name \\| Channel ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel ID \| \| Description \| ID of the channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_statistics_channel__channel_id | | \| Display name \| Channel ID \| \| --- \| --- \| \| Description \| ID of the channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel ID | | Description | ID of the channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_statistics_channel__channel_name \| \| --- \| \| \\| Display name \\| Channel name \\| \\| --- \\| --- \\| \\| Description \\| Name of the channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel name \| \| Description \| Name of the channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_statistics_channel__channel_name | | \| Display name \| Channel name \| \| --- \| --- \| \| Description \| Name of the channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel name | | Description | Name of the channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_statistics_channel__clicks \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__clicks | | \| Display name \| Clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Clicks | | Description | Number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__clicks_unique \| \| --- \| \| \\| Display name \\| Clicks unique \\| \\| --- \\| --- \\| \\| Description \\| Number of unique clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks unique \| \| Description \| Number of unique clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__clicks_unique | | \| Display name \| Clicks unique \| \| --- \| --- \| \| Description \| Number of unique clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Clicks unique | | Description | Number of unique clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__conversion_ratio \| \| --- \| \| \\| Display name \\| Conversion ratio \\| \\| --- \\| --- \\| \\| Description \\| Conversion Ratio, obtained by dividing sales by clicksUnique \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Conversion ratio \| \| Description \| Conversion Ratio, obtained by dividing sales by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics_channel__conversion_ratio | | \| Display name \| Conversion ratio \| \| --- \| --- \| \| Description \| Conversion Ratio, obtained by dividing sales by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | Conversion ratio | | Description | Conversion Ratio, obtained by dividing sales by clicksUnique | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics_channel__cost \| \| --- \| \| \\| Display name \\| Cost \\| \\| --- \\| --- \\| \\| Description \\| The total cost of the transaction, including partner commission and network fee \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Cost \| \| Description \| The total cost of the transaction, including partner commission and network fee \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__cost | | \| Display name \| Cost \| \| --- \| --- \| \| Description \| The total cost of the transaction, including partner commission and network fee \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Cost | | Description | The total cost of the transaction, including partner commission and network fee | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__ctr \| \| --- \| \| \\| Display name \\| CTR \\| \\| --- \\| --- \\| \\| Description \\| Click Through Ratio, obtained by dividing clicks by impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| CTR \| \| Description \| Click Through Ratio, obtained by dividing clicks by impressions \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics_channel__ctr | | \| Display name \| CTR \| \| --- \| --- \| \| Description \| Click Through Ratio, obtained by dividing clicks by impressions \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | CTR | | Description | Click Through Ratio, obtained by dividing clicks by impressions | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics_channel__impressions \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| Number of banner / links impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| Number of banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__impressions | | \| Display name \| Impressions \| \| --- \| --- \| \| Description \| Number of banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions | | Description | Number of banner / links impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__impressions_unique \| \| --- \| \| \\| Display name \\| Impressions unique \\| \\| --- \\| --- \\| \\| Description \\| Number of unique banner / links impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions unique \| \| Description \| Number of unique banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__impressions_unique | | \| Display name \| Impressions unique \| \| --- \| --- \| \| Description \| Number of unique banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions unique | | Description | Number of unique banner / links impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__lead_ratio \| \| --- \| \| \\| Display name \\| Lead ratio \\| \\| --- \\| --- \\| \\| Description \\| Lead Ratio, obtained by dividing leads by clicksUnique \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Lead ratio \| \| Description \| Lead Ratio, obtained by dividing leads by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics_channel__lead_ratio | | \| Display name \| Lead ratio \| \| --- \| --- \| \| Description \| Lead Ratio, obtained by dividing leads by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | Lead ratio | | Description | Lead Ratio, obtained by dividing leads by clicksUnique | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics_channel__leads \| \| --- \| \| \\| Display name \\| Leads \\| \\| --- \\| --- \\| \\| Description \\| Number of lead transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Leads \| \| Description \| Number of lead transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__leads | | \| Display name \| Leads \| \| --- \| --- \| \| Description \| Number of lead transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Leads | | Description | Number of lead transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__order_value \| \| --- \| \| \\| Display name \\| Order value \\| \\| --- \\| --- \\| \\| Description \\| Order value of the sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Order value \| \| Description \| Order value of the sale transactions \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__order_value | | \| Display name \| Order value \| \| --- \| --- \| \| Description \| Order value of the sale transactions \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| | | Display name | Order value | | Description | Order value of the sale transactions | | Field type | metric | | Data type | [float.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__sales \| \| --- \| \| \\| Display name \\| Sales \\| \\| --- \\| --- \\| \\| Description \\| Number of sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Sales \| \| Description \| Number of sale transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__sales | | \| Display name \| Sales \| \| --- \| --- \| \| Description \| Number of sale transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Sales | | Description | Number of sale transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | dataSourceName | | \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Data source | | Description | The name of the source for this data, as listed on supermetrics.com/docs | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### Table: ADVERTISER_CLICK | \| adv_clicks__ad_id \| \| --- \| \| \\| Display name \\| Ad ID \\| \\| --- \\| --- \\| \\| Description \\| Numerical ID of an ad \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad ID \| \| Description \| Numerical ID of an ad \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | adv_clicks__ad_id | | \| Display name \| Ad ID \| \| --- \| --- \| \| Description \| Numerical ID of an ad \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Ad ID | | Description | Numerical ID of an ad | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_clicks__ad_name \| \| --- \| \| \\| Display name \\| Ad name \\| \\| --- \\| --- \\| \\| Description \\| Name of banner or link \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad name \| \| Description \| Name of banner or link \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_clicks__ad_name | | \| Display name \| Ad name \| \| --- \| --- \| \| Description \| Name of banner or link \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Ad name | | Description | Name of banner or link | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_clicks__ad_type \| \| --- \| \| \\| Display name \\| Ad type \\| \\| --- \\| --- \\| \\| Description \\| Type of banner or link \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad type \| \| Description \| Type of banner or link \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_clicks__ad_type | | \| Display name \| Ad type \| \| --- \| --- \| \| Description \| Type of banner or link \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Ad type | | Description | Type of banner or link | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_clicks__channel_id \| \| --- \| \| \\| Display name \\| Channel ID \\| \\| --- \\| --- \\| \\| Description \\| Numerical ID of a channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel ID \| \| Description \| Numerical ID of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_clicks__channel_id | | \| Display name \| Channel ID \| \| --- \| --- \| \| Description \| Numerical ID of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel ID | | Description | Numerical ID of a channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_clicks__count \| \| --- \| \| \\| Display name \\| Number of clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Number of clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_clicks__count | | \| Display name \| Number of clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Number of clicks | | Description | Number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_clicks__status \| \| --- \| \| \\| Display name \\| Click status \\| \\| --- \\| --- \\| \\| Description \\| Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Click status \| \| Description \| Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_clicks__status | | \| Display name \| Click status \| \| --- \| --- \| \| Description \| Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Click status | | Description | Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | dataSourceName | | \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Data source | | Description | The name of the source for this data, as listed on supermetrics.com/docs | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### Table: ADVERTISER_TRANSACTION | \| adv_transactions__ad_id \| \| --- \| \| \\| Display name \\| Ad ID \\| \\| --- \\| --- \\| \\| Description \\| Numerical ID of an ad \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad ID \| \| Description \| Numerical ID of an ad \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | adv_transactions__ad_id | | \| Display name \| Ad ID \| \| --- \| --- \| \| Description \| Numerical ID of an ad \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Ad ID | | Description | Numerical ID of an ad | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_transactions__ad_name \| \| --- \| \| \\| Display name \\| Ad name \\| \\| --- \\| --- \\| \\| Description \\| Name of banner or link \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad name \| \| Description \| Name of banner or link \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_transactions__ad_name | | \| Display name \| Ad name \| \| --- \| --- \| \| Description \| Name of banner or link \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Ad name | | Description | Name of banner or link | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_transactions__ad_type \| \| --- \| \| \\| Display name \\| Ad type \\| \\| --- \\| --- \\| \\| Description \\| Type of banner or link \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad type \| \| Description \| Type of banner or link \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_transactions__ad_type | | \| Display name \| Ad type \| \| --- \| --- \| \| Description \| Type of banner or link \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Ad type | | Description | Type of banner or link | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_transactions__auto_approval_date \| \| --- \| \| \\| Display name \\| Auto approval date \\| \\| --- \\| --- \\| \\| Description \\| Date when a pending transaction (transactionStatus = 2) will be automatically approved unless already approved or rejected \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Auto approval date \| \| Description \| Date when a pending transaction (transactionStatus = 2) will be automatically approved unless already approved or rejected \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | adv_transactions__auto_approval_date | | \| Display name \| Auto approval date \| \| --- \| --- \| \| Description \| Date when a pending transaction (transactionStatus = 2) will be automatically approved unless already approved or rejected \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Auto approval date | | Description | Date when a pending transaction (transactionStatus = 2) will be automatically approved unless already approved or rejected | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| adv_transactions__channel_id \| \| --- \| \| \\| Display name \\| Channel ID \\| \\| --- \\| --- \\| \\| Description \\| Numerical ID of a channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel ID \| \| Description \| Numerical ID of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_transactions__channel_id | | \| Display name \| Channel ID \| \| --- \| --- \| \| Description \| Numerical ID of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel ID | | Description | Numerical ID of a channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_transactions__channel_name \| \| --- \| \| \\| Display name \\| Channel name \\| \\| --- \\| --- \\| \\| Description \\| Name of a channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel name \| \| Description \| Name of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_transactions__channel_name | | \| Display name \| Channel name \| \| --- \| --- \| \| Description \| Name of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel name | | Description | Name of a channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_transactions__click_date \| \| --- \| \| \\| Display name \\| Click date \\| \\| --- \\| --- \\| \\| Description \\| Date of the click that generated the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Click date \| \| Description \| Date of the click that generated the transaction \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | adv_transactions__click_date | | \| Display name \| Click date \| \| --- \| --- \| \| Description \| Date of the click that generated the transaction \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Click date | | Description | Date of the click that generated the transaction | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| adv_transactions__click_time \| \| --- \| \| \\| Display name \\| Click time \\| \\| --- \\| --- \\| \\| Description \\| UTC timestamp of the click that generated the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Click time \| \| Description \| UTC timestamp of the click that generated the transaction \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | adv_transactions__click_time | | \| Display name \| Click time \| \| --- \| --- \| \| Description \| UTC timestamp of the click that generated the transaction \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Click time | | Description | UTC timestamp of the click that generated the transaction | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| adv_transactions__cost \| \| --- \| \| \\| Display name \\| Cost \\| \\| --- \\| --- \\| \\| Description \\| The cost of the transaction, including partner commission and Adtraction network fee \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Cost \| \| Description \| The cost of the transaction, including partner commission and Adtraction network fee \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | adv_transactions__cost | | \| Display name \| Cost \| \| --- \| --- \| \| Description \| The cost of the transaction, including partner commission and Adtraction network fee \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Cost | | Description | The cost of the transaction, including partner commission and Adtraction network fee | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| adv_transactions__count \| \| --- \| \| \\| Display name \\| Number of clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Number of clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_transactions__count | | \| Display name \| Number of clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Number of clicks | | Description | Number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_transactions__device \| \| --- \| \| \\| Display name \\| Device \\| \\| --- \\| --- \\| \\| Description \\| The type of device that was used to complete the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Device \| \| Description \| The type of device that was used to complete the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_transactions__device | | \| Display name \| Device \| \| --- \| --- \| \| Description \| The type of device that was used to complete the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Device | | Description | The type of device that was used to complete the transaction | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_transactions__geo_location \| \| --- \| \| \\| Display name \\| Geo location \\| \\| --- \\| --- \\| \\| Description \\| The geographic market where the transaction was completed, defined by an ISO 3166-1 Alpha-2 country code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Geo location \| \| Description \| The geographic market where the transaction was completed, defined by an ISO 3166-1 Alpha-2 country code \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | adv_transactions__geo_location | | \| Display name \| Geo location \| \| --- \| --- \| \| Description \| The geographic market where the transaction was completed, defined by an ISO 3166-1 Alpha-2 country code \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | Display name | Geo location | | Description | The geographic market where the transaction was completed, defined by an ISO 3166-1 Alpha-2 country code | | Field type | dimension | | Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) | | \| adv_transactions__last_updated \| \| --- \| \| \\| Display name \\| Last updated \\| \\| --- \\| --- \\| \\| Description \\| 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 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Last updated \| \| Description \| 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 \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | adv_transactions__last_updated | | \| Display name \| Last updated \| \| --- \| --- \| \| Description \| 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 \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Last updated | | Description | 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 | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| adv_transactions__last_updated_date \| \| --- \| \| \\| Display name \\| Last updated date \\| \\| --- \\| --- \\| \\| Description \\| Date of when the transactionStatus or orderValue of the transaction was last updated. Only available for transactions where transactionStatus or orderValue has been updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Last updated date \| \| Description \| Date of when the transactionStatus or orderValue of the transaction was last updated. Only available for transactions where transactionStatus or orderValue has been updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | adv_transactions__last_updated_date | | \| Display name \| Last updated date \| \| --- \| --- \| \| Description \| Date of when the transactionStatus or orderValue of the transaction was last updated. Only available for transactions where transactionStatus or orderValue has been updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Last updated date | | Description | Date of when the transactionStatus or orderValue of the transaction was last updated. Only available for transactions where transactionStatus or orderValue has been updated | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| adv_transactions__operating_system \| \| --- \| \| \\| Display name \\| Operating system \\| \\| --- \\| --- \\| \\| Description \\| The operating system used on the device that was used to complete the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Operating system \| \| Description \| The operating system used on the device that was used to complete the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_transactions__operating_system | | \| Display name \| Operating system \| \| --- \| --- \| \| Description \| The operating system used on the device that was used to complete the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Operating system | | Description | The operating system used on the device that was used to complete the transaction | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_transactions__order_value \| \| --- \| \| \\| Display name \\| Order value \\| \\| --- \\| --- \\| \\| Description \\| Order value of the transaction \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Order value \| \| Description \| Order value of the transaction \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | adv_transactions__order_value | | \| Display name \| Order value \| \| --- \| --- \| \| Description \| Order value of the transaction \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Order value | | Description | Order value of the transaction | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| adv_transactions__payment_status \| \| --- \| \| \\| Display name \\| Payment status \\| \\| --- \\| --- \\| \\| Description \\| 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 partner \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Payment status \| \| Description \| 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 partner \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_transactions__payment_status | | \| Display name \| Payment status \| \| --- \| --- \| \| Description \| 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 partner \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Payment status | | Description | 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 partner | | Field type | dimension | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_transactions__reason_text \| \| --- \| \| \\| Display name \\| Rejection reason \\| \\| --- \\| --- \\| \\| Description \\| For rejected transactions (transactionStatus = 5) you may choose to provide the reason for the transaction being rejected \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Rejection reason \| \| Description \| For rejected transactions (transactionStatus = 5) you may choose to provide the reason for the transaction being rejected \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_transactions__reason_text | | \| Display name \| Rejection reason \| \| --- \| --- \| \| Description \| For rejected transactions (transactionStatus = 5) you may choose to provide the reason for the transaction being rejected \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Rejection reason | | Description | For rejected transactions (transactionStatus = 5) you may choose to provide the reason for the transaction being rejected | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_transactions__status \| \| --- \| \| \\| Display name \\| Click status \\| \\| --- \\| --- \\| \\| Description \\| Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Click status \| \| Description \| Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_transactions__status | | \| Display name \| Click status \| \| --- \| --- \| \| Description \| Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Click status | | Description | Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_transactions__transaction_name \| \| --- \| \| \\| Display name \\| Transaction name \\| \\| --- \\| --- \\| \\| Description \\| Name of the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Transaction name \| \| Description \| Name of the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_transactions__transaction_name | | \| Display name \| Transaction name \| \| --- \| --- \| \| Description \| Name of the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Transaction name | | Description | Name of the transaction | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_transactions__transaction_status \| \| --- \| \| \\| Display name \\| Transaction status \\| \\| --- \\| --- \\| \\| Description \\| 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 \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Transaction status \| \| Description \| 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 \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_transactions__transaction_status | | \| Display name \| Transaction status \| \| --- \| --- \| \| Description \| 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 \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Transaction status | | Description | 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 | | Field type | dimension | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_transactions__unique_id \| \| --- \| \| \\| Display name \\| Unique ID \\| \\| --- \\| --- \\| \\| Description \\| Unique ID for the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Unique ID \| \| Description \| Unique ID for the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_transactions__unique_id | | \| Display name \| Unique ID \| \| --- \| --- \| \| Description \| Unique ID for the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Unique ID | | Description | Unique ID for the transaction | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | dataSourceName | | \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Data source | | Description | The name of the source for this data, as listed on supermetrics.com/docs | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### Table: ADVERTISER_STATISTICS | \| adv_statistics__account_name \| \| --- \| \| \\| Display name \\| Account name \\| \\| --- \\| --- \\| \\| Description \\| Account name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account name \| \| Description \| Account name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | adv_statistics__account_name | | \| Display name \| Account name \| \| --- \| --- \| \| Description \| Account name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Account name | | Description | Account name | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_statistics__aov \| \| --- \| \| \\| Display name \\| Average order value \\| \\| --- \\| --- \\| \\| Description \\| Average order value, obtained by dividing order value by number of sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Average order value \| \| Description \| Average order value, obtained by dividing order value by number of sale transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | adv_statistics__aov | | \| Display name \| Average order value \| \| --- \| --- \| \| Description \| Average order value, obtained by dividing order value by number of sale transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Average order value | | Description | Average order value, obtained by dividing order value by number of sale transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| adv_statistics__clicks \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics__clicks | | \| Display name \| Clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Clicks | | Description | Number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics__clicks_unique \| \| --- \| \| \\| Display name \\| Clicks unique \\| \\| --- \\| --- \\| \\| Description \\| Number of unique clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks unique \| \| Description \| Number of unique clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics__clicks_unique | | \| Display name \| Clicks unique \| \| --- \| --- \| \| Description \| Number of unique clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Clicks unique | | Description | Number of unique clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics__conversion_ratio \| \| --- \| \| \\| Display name \\| Conversion ratio \\| \\| --- \\| --- \\| \\| Description \\| Conversion Ratio, obtained by dividing sales by clicksUnique \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Conversion ratio \| \| Description \| Conversion Ratio, obtained by dividing sales by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics__conversion_ratio | | \| Display name \| Conversion ratio \| \| --- \| --- \| \| Description \| Conversion Ratio, obtained by dividing sales by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | Conversion ratio | | Description | Conversion Ratio, obtained by dividing sales by clicksUnique | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics__cost \| \| --- \| \| \\| Display name \\| Cost \\| \\| --- \\| --- \\| \\| Description \\| The total cost of the transaction, including partner commission and network fee \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Cost \| \| Description \| The total cost of the transaction, including partner commission and network fee \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics__cost | | \| Display name \| Cost \| \| --- \| --- \| \| Description \| The total cost of the transaction, including partner commission and network fee \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Cost | | Description | The total cost of the transaction, including partner commission and network fee | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics__ctr \| \| --- \| \| \\| Display name \\| CTR \\| \\| --- \\| --- \\| \\| Description \\| Click Through Ratio, obtained by dividing clicks by impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| CTR \| \| Description \| Click Through Ratio, obtained by dividing clicks by impressions \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics__ctr | | \| Display name \| CTR \| \| --- \| --- \| \| Description \| Click Through Ratio, obtained by dividing clicks by impressions \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | CTR | | Description | Click Through Ratio, obtained by dividing clicks by impressions | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics__impressions \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| Number of banner / links impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| Number of banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics__impressions | | \| Display name \| Impressions \| \| --- \| --- \| \| Description \| Number of banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions | | Description | Number of banner / links impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics__impressions_unique \| \| --- \| \| \\| Display name \\| Impressions unique \\| \\| --- \\| --- \\| \\| Description \\| Number of unique banner / links impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions unique \| \| Description \| Number of unique banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics__impressions_unique | | \| Display name \| Impressions unique \| \| --- \| --- \| \| Description \| Number of unique banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions unique | | Description | Number of unique banner / links impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics__lead_ratio \| \| --- \| \| \\| Display name \\| Lead ratio \\| \\| --- \\| --- \\| \\| Description \\| Lead Ratio, obtained by dividing leads by clicksUnique \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Lead ratio \| \| Description \| Lead Ratio, obtained by dividing leads by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics__lead_ratio | | \| Display name \| Lead ratio \| \| --- \| --- \| \| Description \| Lead Ratio, obtained by dividing leads by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | Lead ratio | | Description | Lead Ratio, obtained by dividing leads by clicksUnique | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics__leads \| \| --- \| \| \\| Display name \\| Leads \\| \\| --- \\| --- \\| \\| Description \\| Number of lead transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Leads \| \| Description \| Number of lead transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics__leads | | \| Display name \| Leads \| \| --- \| --- \| \| Description \| Number of lead transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Leads | | Description | Number of lead transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics__order_value \| \| --- \| \| \\| Display name \\| Order value \\| \\| --- \\| --- \\| \\| Description \\| Order value of the sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Order value \| \| Description \| Order value of the sale transactions \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| | | adv_statistics__order_value | | \| Display name \| Order value \| \| --- \| --- \| \| Description \| Order value of the sale transactions \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| | | Display name | Order value | | Description | Order value of the sale transactions | | Field type | metric | | Data type | [float.number.value](/apidocs/field-data-types#number) | | \| adv_statistics__sales \| \| --- \| \| \\| Display name \\| Sales \\| \\| --- \\| --- \\| \\| Description \\| Number of sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Sales \| \| Description \| Number of sale transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics__sales | | \| Display name \| Sales \| \| --- \| --- \| \| Description \| Number of sale transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Sales | | Description | Number of sale transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | dataSourceName | | \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Data source | | Description | The name of the source for this data, as listed on supermetrics.com/docs | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### Table: ADVERTISER_AD | \| adv_statistics_ads__ad_id \| \| --- \| \| \\| Display name \\| Ad ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the ad \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad ID \| \| Description \| ID of the ad \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | adv_statistics_ads__ad_id | | \| Display name \| Ad ID \| \| --- \| --- \| \| Description \| ID of the ad \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Ad ID | | Description | ID of the ad | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_statistics_ads__ad_name \| \| --- \| \| \\| Display name \\| Ad name \\| \\| --- \\| --- \\| \\| Description \\| Name of the ad \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ad name \| \| Description \| Name of the ad \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_statistics_ads__ad_name | | \| Display name \| Ad name \| \| --- \| --- \| \| Description \| Name of the ad \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Ad name | | Description | Name of the ad | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_statistics_ads__aov \| \| --- \| \| \\| Display name \\| Average order value \\| \\| --- \\| --- \\| \\| Description \\| Average order value, obtained by dividing order value by number of sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Average order value \| \| Description \| Average order value, obtained by dividing order value by number of sale transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | adv_statistics_ads__aov | | \| Display name \| Average order value \| \| --- \| --- \| \| Description \| Average order value, obtained by dividing order value by number of sale transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Average order value | | Description | Average order value, obtained by dividing order value by number of sale transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| adv_statistics_ads__clicks \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_ads__clicks | | \| Display name \| Clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Clicks | | Description | Number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_ads__clicks_unique \| \| --- \| \| \\| Display name \\| Clicks unique \\| \\| --- \\| --- \\| \\| Description \\| Number of unique clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks unique \| \| Description \| Number of unique clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_ads__clicks_unique | | \| Display name \| Clicks unique \| \| --- \| --- \| \| Description \| Number of unique clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Clicks unique | | Description | Number of unique clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_ads__conversion_ratio \| \| --- \| \| \\| Display name \\| Conversion ratio \\| \\| --- \\| --- \\| \\| Description \\| Conversion Ratio, obtained by dividing sales by clicksUnique \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Conversion ratio \| \| Description \| Conversion Ratio, obtained by dividing sales by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics_ads__conversion_ratio | | \| Display name \| Conversion ratio \| \| --- \| --- \| \| Description \| Conversion Ratio, obtained by dividing sales by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | Conversion ratio | | Description | Conversion Ratio, obtained by dividing sales by clicksUnique | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics_ads__cost \| \| --- \| \| \\| Display name \\| Cost \\| \\| --- \\| --- \\| \\| Description \\| The total cost of the transaction, including partner commission and network fee \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Cost \| \| Description \| The total cost of the transaction, including partner commission and network fee \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_ads__cost | | \| Display name \| Cost \| \| --- \| --- \| \| Description \| The total cost of the transaction, including partner commission and network fee \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Cost | | Description | The total cost of the transaction, including partner commission and network fee | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_ads__ctr \| \| --- \| \| \\| Display name \\| CTR \\| \\| --- \\| --- \\| \\| Description \\| Click Through Ratio, obtained by dividing clicks by impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| CTR \| \| Description \| Click Through Ratio, obtained by dividing clicks by impressions \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics_ads__ctr | | \| Display name \| CTR \| \| --- \| --- \| \| Description \| Click Through Ratio, obtained by dividing clicks by impressions \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | CTR | | Description | Click Through Ratio, obtained by dividing clicks by impressions | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics_ads__impressions \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| Number of banner / links impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| Number of banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_ads__impressions | | \| Display name \| Impressions \| \| --- \| --- \| \| Description \| Number of banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions | | Description | Number of banner / links impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_ads__impressions_unique \| \| --- \| \| \\| Display name \\| Impressions unique \\| \\| --- \\| --- \\| \\| Description \\| Number of unique banner / links impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions unique \| \| Description \| Number of unique banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_ads__impressions_unique | | \| Display name \| Impressions unique \| \| --- \| --- \| \| Description \| Number of unique banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions unique | | Description | Number of unique banner / links impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_ads__lead_ratio \| \| --- \| \| \\| Display name \\| Lead ratio \\| \\| --- \\| --- \\| \\| Description \\| Lead Ratio, obtained by dividing leads by clicksUnique \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Lead ratio \| \| Description \| Lead Ratio, obtained by dividing leads by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics_ads__lead_ratio | | \| Display name \| Lead ratio \| \| --- \| --- \| \| Description \| Lead Ratio, obtained by dividing leads by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | Lead ratio | | Description | Lead Ratio, obtained by dividing leads by clicksUnique | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics_ads__leads \| \| --- \| \| \\| Display name \\| Leads \\| \\| --- \\| --- \\| \\| Description \\| Number of lead transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Leads \| \| Description \| Number of lead transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_ads__leads | | \| Display name \| Leads \| \| --- \| --- \| \| Description \| Number of lead transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Leads | | Description | Number of lead transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_ads__order_value \| \| --- \| \| \\| Display name \\| Order value \\| \\| --- \\| --- \\| \\| Description \\| Order value of the sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Order value \| \| Description \| Order value of the sale transactions \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_ads__order_value | | \| Display name \| Order value \| \| --- \| --- \| \| Description \| Order value of the sale transactions \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| | | Display name | Order value | | Description | Order value of the sale transactions | | Field type | metric | | Data type | [float.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_ads__sales \| \| --- \| \| \\| Display name \\| Sales \\| \\| --- \\| --- \\| \\| Description \\| Number of sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Sales \| \| Description \| Number of sale transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_ads__sales | | \| Display name \| Sales \| \| --- \| --- \| \| Description \| Number of sale transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Sales | | Description | Number of sale transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | dataSourceName | | \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Data source | | Description | The name of the source for this data, as listed on supermetrics.com/docs | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### Table: ADVERTISER_CHANNEL | \| adv_channels__affiliate_id \| \| --- \| \| \\| Display name \\| Partner ID \\| \\| --- \\| --- \\| \\| Description \\| Numerical ID of a partner account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Partner ID \| \| Description \| Numerical ID of a partner account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | adv_channels__affiliate_id | | \| Display name \| Partner ID \| \| --- \| --- \| \| Description \| Numerical ID of a partner account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Partner ID | | Description | Numerical ID of a partner account | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_channels__affiliate_name \| \| --- \| \| \\| Display name \\| Partner name \\| \\| --- \\| --- \\| \\| Description \\| Name of the partner. Individual or company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Partner name \| \| Description \| Name of the partner. Individual or company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_channels__affiliate_name | | \| Display name \| Partner name \| \| --- \| --- \| \| Description \| Name of the partner. Individual or company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Partner name | | Description | Name of the partner. Individual or company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_channels__approval_status \| \| --- \| \| \\| Display name \\| Approval status \\| \\| --- \\| --- \\| \\| Description \\| Approval status of a channel for a partner program: 0 = rejected, 1 = approved, 2 = pending review \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Approval status \| \| Description \| Approval status of a channel for a partner program: 0 = rejected, 1 = approved, 2 = pending review \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_channels__approval_status | | \| Display name \| Approval status \| \| --- \| --- \| \| Description \| Approval status of a channel for a partner program: 0 = rejected, 1 = approved, 2 = pending review \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Approval status | | Description | Approval status of a channel for a partner program: 0 = rejected, 1 = approved, 2 = pending review | | Field type | dimension | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_channels__channel_description \| \| --- \| \| \\| Display name \\| Channel description \\| \\| --- \\| --- \\| \\| Description \\| A description of a channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel description \| \| Description \| A description of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_channels__channel_description | | \| Display name \| Channel description \| \| --- \| --- \| \| Description \| A description of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel description | | Description | A description of a channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_channels__channel_id \| \| --- \| \| \\| Display name \\| Channel ID \\| \\| --- \\| --- \\| \\| Description \\| Numerical ID of a channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel ID \| \| Description \| Numerical ID of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_channels__channel_id | | \| Display name \| Channel ID \| \| --- \| --- \| \| Description \| Numerical ID of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel ID | | Description | Numerical ID of a channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_channels__channel_name \| \| --- \| \| \\| Display name \\| Channel name \\| \\| --- \\| --- \\| \\| Description \\| Name of a channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel name \| \| Description \| Name of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_channels__channel_name | | \| Display name \| Channel name \| \| --- \| --- \| \| Description \| Name of a channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel name | | Description | Name of a channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_channels__channel_type \| \| --- \| \| \\| Display name \\| Channel type \\| \\| --- \\| --- \\| \\| Description \\| The type of a channel, such as Blog, Content, Facebook, Cashback, etc \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel type \| \| Description \| The type of a channel, such as Blog, Content, Facebook, Cashback, etc \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_channels__channel_type | | \| Display name \| Channel type \| \| --- \| --- \| \| Description \| The type of a channel, such as Blog, Content, Facebook, Cashback, etc \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel type | | Description | The type of a channel, such as Blog, Content, Facebook, Cashback, etc | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_channels__channel_url \| \| --- \| \| \\| Display name \\| Channel URL \\| \\| --- \\| --- \\| \\| Description \\| The URL of a channel, if applicable \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel URL \| \| Description \| The URL of a channel, if applicable \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | adv_channels__channel_url | | \| Display name \| Channel URL \| \| --- \| --- \| \| Description \| The URL of a channel, if applicable \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | Display name | Channel URL | | Description | The URL of a channel, if applicable | | Field type | dimension | | Data type | [string.text.url](/apidocs/field-data-types#text) | | \| adv_channels__count \| \| --- \| \| \\| Display name \\| Number of channels \\| \\| --- \\| --- \\| \\| Description \\| Number of channels \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Number of channels \| \| Description \| Number of channels \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_channels__count | | \| Display name \| Number of channels \| \| --- \| --- \| \| Description \| Number of channels \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Number of channels | | Description | Number of channels | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__aov \| \| --- \| \| \\| Display name \\| Average order value \\| \\| --- \\| --- \\| \\| Description \\| Average order value, obtained by dividing order value by number of sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Average order value \| \| Description \| Average order value, obtained by dividing order value by number of sale transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | adv_statistics_channel__aov | | \| Display name \| Average order value \| \| --- \| --- \| \| Description \| Average order value, obtained by dividing order value by number of sale transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Average order value | | Description | Average order value, obtained by dividing order value by number of sale transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| adv_statistics_channel__channel_id \| \| --- \| \| \\| Display name \\| Channel ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel ID \| \| Description \| ID of the channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_statistics_channel__channel_id | | \| Display name \| Channel ID \| \| --- \| --- \| \| Description \| ID of the channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel ID | | Description | ID of the channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_statistics_channel__channel_name \| \| --- \| \| \\| Display name \\| Channel name \\| \\| --- \\| --- \\| \\| Description \\| Name of the channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel name \| \| Description \| Name of the channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_statistics_channel__channel_name | | \| Display name \| Channel name \| \| --- \| --- \| \| Description \| Name of the channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Channel name | | Description | Name of the channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_statistics_channel__clicks \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__clicks | | \| Display name \| Clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Clicks | | Description | Number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__clicks_unique \| \| --- \| \| \\| Display name \\| Clicks unique \\| \\| --- \\| --- \\| \\| Description \\| Number of unique clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks unique \| \| Description \| Number of unique clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__clicks_unique | | \| Display name \| Clicks unique \| \| --- \| --- \| \| Description \| Number of unique clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Clicks unique | | Description | Number of unique clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__conversion_ratio \| \| --- \| \| \\| Display name \\| Conversion ratio \\| \\| --- \\| --- \\| \\| Description \\| Conversion Ratio, obtained by dividing sales by clicksUnique \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Conversion ratio \| \| Description \| Conversion Ratio, obtained by dividing sales by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics_channel__conversion_ratio | | \| Display name \| Conversion ratio \| \| --- \| --- \| \| Description \| Conversion Ratio, obtained by dividing sales by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | Conversion ratio | | Description | Conversion Ratio, obtained by dividing sales by clicksUnique | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics_channel__cost \| \| --- \| \| \\| Display name \\| Cost \\| \\| --- \\| --- \\| \\| Description \\| The total cost of the transaction, including partner commission and network fee \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Cost \| \| Description \| The total cost of the transaction, including partner commission and network fee \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__cost | | \| Display name \| Cost \| \| --- \| --- \| \| Description \| The total cost of the transaction, including partner commission and network fee \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Cost | | Description | The total cost of the transaction, including partner commission and network fee | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__ctr \| \| --- \| \| \\| Display name \\| CTR \\| \\| --- \\| --- \\| \\| Description \\| Click Through Ratio, obtained by dividing clicks by impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| CTR \| \| Description \| Click Through Ratio, obtained by dividing clicks by impressions \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics_channel__ctr | | \| Display name \| CTR \| \| --- \| --- \| \| Description \| Click Through Ratio, obtained by dividing clicks by impressions \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | CTR | | Description | Click Through Ratio, obtained by dividing clicks by impressions | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics_channel__impressions \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| Number of banner / links impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| Number of banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__impressions | | \| Display name \| Impressions \| \| --- \| --- \| \| Description \| Number of banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions | | Description | Number of banner / links impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__impressions_unique \| \| --- \| \| \\| Display name \\| Impressions unique \\| \\| --- \\| --- \\| \\| Description \\| Number of unique banner / links impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions unique \| \| Description \| Number of unique banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__impressions_unique | | \| Display name \| Impressions unique \| \| --- \| --- \| \| Description \| Number of unique banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions unique | | Description | Number of unique banner / links impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__lead_ratio \| \| --- \| \| \\| Display name \\| Lead ratio \\| \\| --- \\| --- \\| \\| Description \\| Lead Ratio, obtained by dividing leads by clicksUnique \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Lead ratio \| \| Description \| Lead Ratio, obtained by dividing leads by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics_channel__lead_ratio | | \| Display name \| Lead ratio \| \| --- \| --- \| \| Description \| Lead Ratio, obtained by dividing leads by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | Lead ratio | | Description | Lead Ratio, obtained by dividing leads by clicksUnique | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics_channel__leads \| \| --- \| \| \\| Display name \\| Leads \\| \\| --- \\| --- \\| \\| Description \\| Number of lead transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Leads \| \| Description \| Number of lead transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__leads | | \| Display name \| Leads \| \| --- \| --- \| \| Description \| Number of lead transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Leads | | Description | Number of lead transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__order_value \| \| --- \| \| \\| Display name \\| Order value \\| \\| --- \\| --- \\| \\| Description \\| Order value of the sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Order value \| \| Description \| Order value of the sale transactions \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__order_value | | \| Display name \| Order value \| \| --- \| --- \| \| Description \| Order value of the sale transactions \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| | | Display name | Order value | | Description | Order value of the sale transactions | | Field type | metric | | Data type | [float.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_channel__sales \| \| --- \| \| \\| Display name \\| Sales \\| \\| --- \\| --- \\| \\| Description \\| Number of sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Sales \| \| Description \| Number of sale transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_channel__sales | | \| Display name \| Sales \| \| --- \| --- \| \| Description \| Number of sale transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Sales | | Description | Number of sale transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | dataSourceName | | \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Data source | | Description | The name of the source for this data, as listed on supermetrics.com/docs | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### Table: ADVERTISER_DAILY_STATISTICS | \| adv_statistics_days__clicks \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | --- | | adv_statistics_days__clicks | | \| Display name \| Clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Clicks | | Description | Number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_days__clicks_unique \| \| --- \| \| \\| Display name \\| Clicks unique \\| \\| --- \\| --- \\| \\| Description \\| Number of unique clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks unique \| \| Description \| Number of unique clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_days__clicks_unique | | \| Display name \| Clicks unique \| \| --- \| --- \| \| Description \| Number of unique clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Clicks unique | | Description | Number of unique clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_days__conversion_ratio \| \| --- \| \| \\| Display name \\| Conversion ratio \\| \\| --- \\| --- \\| \\| Description \\| Conversion Ratio, obtained by dividing sales by clicksUnique \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Conversion ratio \| \| Description \| Conversion Ratio, obtained by dividing sales by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics_days__conversion_ratio | | \| Display name \| Conversion ratio \| \| --- \| --- \| \| Description \| Conversion Ratio, obtained by dividing sales by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | Conversion ratio | | Description | Conversion Ratio, obtained by dividing sales by clicksUnique | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics_days__cost \| \| --- \| \| \\| Display name \\| Cost \\| \\| --- \\| --- \\| \\| Description \\| The total cost of the transaction, including partner commission and network fee \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Cost \| \| Description \| The total cost of the transaction, including partner commission and network fee \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_days__cost | | \| Display name \| Cost \| \| --- \| --- \| \| Description \| The total cost of the transaction, including partner commission and network fee \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Cost | | Description | The total cost of the transaction, including partner commission and network fee | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_days__date \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | adv_statistics_days__date | | \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Date | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| adv_statistics_days__impressions \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| Number of banner / links impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| Number of banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_days__impressions | | \| Display name \| Impressions \| \| --- \| --- \| \| Description \| Number of banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions | | Description | Number of banner / links impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_days__impressions_unique \| \| --- \| \| \\| Display name \\| Impressions unique \\| \\| --- \\| --- \\| \\| Description \\| Number of unique banner / links impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions unique \| \| Description \| Number of unique banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_days__impressions_unique | | \| Display name \| Impressions unique \| \| --- \| --- \| \| Description \| Number of unique banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions unique | | Description | Number of unique banner / links impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_days__leads \| \| --- \| \| \\| Display name \\| Leads \\| \\| --- \\| --- \\| \\| Description \\| Number of lead transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Leads \| \| Description \| Number of lead transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_days__leads | | \| Display name \| Leads \| \| --- \| --- \| \| Description \| Number of lead transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Leads | | Description | Number of lead transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_days__order_value \| \| --- \| \| \\| Display name \\| Order value \\| \\| --- \\| --- \\| \\| Description \\| Order value of the sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Order value \| \| Description \| Order value of the sale transactions \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_days__order_value | | \| Display name \| Order value \| \| --- \| --- \| \| Description \| Order value of the sale transactions \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| | | Display name | Order value | | Description | Order value of the sale transactions | | Field type | metric | | Data type | [float.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_days__sales \| \| --- \| \| \\| Display name \\| Sales \\| \\| --- \\| --- \\| \\| Description \\| Number of sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Sales \| \| Description \| Number of sale transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_days__sales | | \| Display name \| Sales \| \| --- \| --- \| \| Description \| Number of sale transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Sales | | Description | Number of sale transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | dataSourceName | | \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Data source | | Description | The name of the source for this data, as listed on supermetrics.com/docs | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### Table: ADVERTISER_SEGMENT | \| adv_statistics_segments__aov \| \| --- \| \| \\| Display name \\| Average order value \\| \\| --- \\| --- \\| \\| Description \\| Average order value, obtained by dividing order value by number of sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Average order value \| \| Description \| Average order value, obtained by dividing order value by number of sale transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | --- | | adv_statistics_segments__aov | | \| Display name \| Average order value \| \| --- \| --- \| \| Description \| Average order value, obtained by dividing order value by number of sale transactions \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Average order value | | Description | Average order value, obtained by dividing order value by number of sale transactions | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| adv_statistics_segments__clicks \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_segments__clicks | | \| Display name \| Clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Clicks | | Description | Number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_segments__clicks_unique \| \| --- \| \| \\| Display name \\| Clicks unique \\| \\| --- \\| --- \\| \\| Description \\| Number of unique clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks unique \| \| Description \| Number of unique clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_segments__clicks_unique | | \| Display name \| Clicks unique \| \| --- \| --- \| \| Description \| Number of unique clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Clicks unique | | Description | Number of unique clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_segments__conversion_ratio \| \| --- \| \| \\| Display name \\| Conversion ratio \\| \\| --- \\| --- \\| \\| Description \\| Conversion Ratio, obtained by dividing sales by clicksUnique \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Conversion ratio \| \| Description \| Conversion Ratio, obtained by dividing sales by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics_segments__conversion_ratio | | \| Display name \| Conversion ratio \| \| --- \| --- \| \| Description \| Conversion Ratio, obtained by dividing sales by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | Conversion ratio | | Description | Conversion Ratio, obtained by dividing sales by clicksUnique | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics_segments__cost \| \| --- \| \| \\| Display name \\| Cost \\| \\| --- \\| --- \\| \\| Description \\| The total cost of the transaction, including partner commission and network fee \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Cost \| \| Description \| The total cost of the transaction, including partner commission and network fee \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_segments__cost | | \| Display name \| Cost \| \| --- \| --- \| \| Description \| The total cost of the transaction, including partner commission and network fee \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Cost | | Description | The total cost of the transaction, including partner commission and network fee | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_segments__ctr \| \| --- \| \| \\| Display name \\| CTR \\| \\| --- \\| --- \\| \\| Description \\| Click Through Ratio, obtained by dividing clicks by impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| CTR \| \| Description \| Click Through Ratio, obtained by dividing clicks by impressions \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics_segments__ctr | | \| Display name \| CTR \| \| --- \| --- \| \| Description \| Click Through Ratio, obtained by dividing clicks by impressions \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | CTR | | Description | Click Through Ratio, obtained by dividing clicks by impressions | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics_segments__impressions \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| Number of banner / links impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| Number of banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_segments__impressions | | \| Display name \| Impressions \| \| --- \| --- \| \| Description \| Number of banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions | | Description | Number of banner / links impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_segments__impressions_unique \| \| --- \| \| \\| Display name \\| Impressions unique \\| \\| --- \\| --- \\| \\| Description \\| Number of unique banner / links impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions unique \| \| Description \| Number of unique banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_segments__impressions_unique | | \| Display name \| Impressions unique \| \| --- \| --- \| \| Description \| Number of unique banner / links impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions unique | | Description | Number of unique banner / links impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_segments__lead_ratio \| \| --- \| \| \\| Display name \\| Lead ratio \\| \\| --- \\| --- \\| \\| Description \\| Lead Ratio, obtained by dividing leads by clicksUnique \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Lead ratio \| \| Description \| Lead Ratio, obtained by dividing leads by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | adv_statistics_segments__lead_ratio | | \| Display name \| Lead ratio \| \| --- \| --- \| \| Description \| Lead Ratio, obtained by dividing leads by clicksUnique \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | Lead ratio | | Description | Lead Ratio, obtained by dividing leads by clicksUnique | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| adv_statistics_segments__leads \| \| --- \| \| \\| Display name \\| Leads \\| \\| --- \\| --- \\| \\| Description \\| Number of lead transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Leads \| \| Description \| Number of lead transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_segments__leads | | \| Display name \| Leads \| \| --- \| --- \| \| Description \| Number of lead transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Leads | | Description | Number of lead transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_segments__order_value \| \| --- \| \| \\| Display name \\| Order value \\| \\| --- \\| --- \\| \\| Description \\| Order value of the sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Order value \| \| Description \| Order value of the sale transactions \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_segments__order_value | | \| Display name \| Order value \| \| --- \| --- \| \| Description \| Order value of the sale transactions \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| | | Display name | Order value | | Description | Order value of the sale transactions | | Field type | metric | | Data type | [float.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_segments__sales \| \| --- \| \| \\| Display name \\| Sales \\| \\| --- \\| --- \\| \\| Description \\| Number of sale transactions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Sales \| \| Description \| Number of sale transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | adv_statistics_segments__sales | | \| Display name \| Sales \| \| --- \| --- \| \| Description \| Number of sale transactions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Sales | | Description | Number of sale transactions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| adv_statistics_segments__segment_id \| \| --- \| \| \\| Display name \\| Segment ID \\| \\| --- \\| --- \\| \\| Description \\| Numerical ID of a commission segment \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Segment ID \| \| Description \| Numerical ID of a commission segment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_statistics_segments__segment_id | | \| Display name \| Segment ID \| \| --- \| --- \| \| Description \| Numerical ID of a commission segment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Segment ID | | Description | Numerical ID of a commission segment | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| adv_statistics_segments__segment_name \| \| --- \| \| \\| Display name \\| Segment name \\| \\| --- \\| --- \\| \\| Description \\| Name of a commission segment \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Segment name \| \| Description \| Name of a commission segment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | adv_statistics_segments__segment_name | | \| Display name \| Segment name \| \| --- \| --- \| \| Description \| Name of a commission segment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Segment name | | Description | Name of a commission segment | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | dataSourceName | | \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Data source | | Description | The name of the source for this data, as listed on supermetrics.com/docs | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) |