--- title: "Rakuten Advertising data warehouse table groups" slug: "rakuten-advertising-data-warehouse-table-groups" description: "Explore the complete Supermetrics data warehouse table groups for Rakuten Advertising. See all the tables and the fields included in them." updated: 2026-03-05T14:12:30Z published: 2026-03-05T14:12:30Z --- > ## 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. # Rakuten Advertising data warehouse table groups Search fields ### Table: RAK_QUERY | \| 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) | | \| partners_daily__adjusted_commission** \| \| --- \| \| \\| Display name \\| Adjusted commission \\| \\| --- \\| --- \\| \\| Description \\| The commission that is added to the baseline commission when a Publisher reaches a certain level of sales. For tiered commission structures \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Adjusted commission \| \| Description \| The commission that is added to the baseline commission when a Publisher reaches a certain level of sales. For tiered commission structures \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | partners_daily__adjusted_commission** | | \| Display name \| Adjusted commission \| \| --- \| --- \| \| Description \| The commission that is added to the baseline commission when a Publisher reaches a certain level of sales. For tiered commission structures \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Adjusted commission | | Description | The commission that is added to the baseline commission when a Publisher reaches a certain level of sales. For tiered commission structures | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| partners_daily__baseline_commission** \| \| --- \| \| \\| Display name \\| Baseline commission \\| \\| --- \\| --- \\| \\| Description \\| The commission amount that is calculated before adjustments are made at the end of the month for tiered offers \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Baseline commission \| \| Description \| The commission amount that is calculated before adjustments are made at the end of the month for tiered offers \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | partners_daily__baseline_commission** | | \| Display name \| Baseline commission \| \| --- \| --- \| \| Description \| The commission amount that is calculated before adjustments are made at the end of the month for tiered offers \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Baseline commission | | Description | The commission amount that is calculated before adjustments are made at the end of the month for tiered offers | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| partners_daily__cancelled_items** \| \| --- \| \| \\| Display name \\| Cancelled items \\| \\| --- \\| --- \\| \\| Description \\| The number of items cancelled or returned \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Cancelled items \| \| Description \| The number of items cancelled or returned \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | partners_daily__cancelled_items** | | \| Display name \| Cancelled items \| \| --- \| --- \| \| Description \| The number of items cancelled or returned \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Cancelled items | | Description | The number of items cancelled or returned | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| partners_daily__clicks** \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| The number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| The number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | partners_daily__clicks** | | \| Display name \| Clicks \| \| --- \| --- \| \| Description \| The number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Clicks | | Description | The number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| partners_daily__commission_status** \| \| --- \| \| \\| Display name \\| Commission status \\| \\| --- \\| --- \\| \\| Description \\| The status indicates whether the commission for an order is approved, pending or cancelled \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Commission status \| \| Description \| The status indicates whether the commission for an order is approved, pending or cancelled \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | partners_daily__commission_status** | | \| Display name \| Commission status \| \| --- \| --- \| \| Description \| The status indicates whether the commission for an order is approved, pending or cancelled \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Commission status | | Description | The status indicates whether the commission for an order is approved, pending or cancelled | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| partners_daily__commissionable_order_amount** \| \| --- \| \| \\| Display name \\| Commissionable order amount \\| \\| --- \\| --- \\| \\| Description \\| The commissionable sales total of the order, not including tax or shipping \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Commissionable order amount \| \| Description \| The commissionable sales total of the order, not including tax or shipping \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | partners_daily__commissionable_order_amount** | | \| Display name \| Commissionable order amount \| \| --- \| --- \| \| Description \| The commissionable sales total of the order, not including tax or shipping \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Commissionable order amount | | Description | The commissionable sales total of the order, not including tax or shipping | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| partners_daily__commissioning_list_id** \| \| --- \| \| \\| Display name \\| Commissioning list ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the commissioning list \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Commissioning list ID \| \| Description \| The unique ID of the commissioning list \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | partners_daily__commissioning_list_id** | | \| Display name \| Commissioning list ID \| \| --- \| --- \| \| Description \| The unique ID of the commissioning list \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Commissioning list ID | | Description | The unique ID of the commissioning list | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| partners_daily__currency** \| \| --- \| \| \\| Display name \\| Currency \\| \\| --- \\| --- \\| \\| Description \\| The currency that the transaction was reported in \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Display name \| Currency \| \| Description \| The currency that the transaction was reported in \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | partners_daily__currency** | | \| Display name \| Currency \| \| --- \| --- \| \| Description \| The currency that the transaction was reported in \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | Display name | Currency | | Description | The currency that the transaction was reported in | | Field type | dimension | | Data type | [string.currency.code](/apidocs/field-data-types#currency) | | \| partners_daily__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) \| | | partners_daily__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) | | \| partners_daily__gross_commissions** \| \| --- \| \| \\| Display name \\| Gross commissions \\| \\| --- \\| --- \\| \\| Description \\| Total of all commissions (CPC commissions excluded) without taking cancellations into account \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Gross commissions \| \| Description \| Total of all commissions (CPC commissions excluded) without taking cancellations into account \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | partners_daily__gross_commissions** | | \| Display name \| Gross commissions \| \| --- \| --- \| \| Description \| Total of all commissions (CPC commissions excluded) without taking cancellations into account \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Gross commissions | | Description | Total of all commissions (CPC commissions excluded) without taking cancellations into account | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| partners_daily__gross_sales** \| \| --- \| \| \\| Display name \\| Gross sales \\| \\| --- \\| --- \\| \\| Description \\| The total of all sales without taking cancellations into account. It consists of the sum of all sales with values greater than 0, plus any sales marked as discounts. Note that discounts have a value that is less than 0 but are considered to be part of Gross sales because they are taken into account as part of the total sales price at checkout \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Gross sales \| \| Description \| The total of all sales without taking cancellations into account. It consists of the sum of all sales with values greater than 0, plus any sales marked as discounts. Note that discounts have a value that is less than 0 but are considered to be part of Gross sales because they are taken into account as part of the total sales price at checkout \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | partners_daily__gross_sales** | | \| Display name \| Gross sales \| \| --- \| --- \| \| Description \| The total of all sales without taking cancellations into account. It consists of the sum of all sales with values greater than 0, plus any sales marked as discounts. Note that discounts have a value that is less than 0 but are considered to be part of Gross sales because they are taken into account as part of the total sales price at checkout \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Gross sales | | Description | The total of all sales without taking cancellations into account. It consists of the sum of all sales with values greater than 0, plus any sales marked as discounts. Note that discounts have a value that is less than 0 but are considered to be part of Gross sales because they are taken into account as part of the total sales price at checkout | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| partners_daily__gross_total_commissions** \| \| --- \| \| \\| Display name \\| Gross total commissions \\| \\| --- \\| --- \\| \\| Description \\| Total of all commissions (including CPC commissions) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Gross total commissions \| \| Description \| Total of all commissions (including CPC commissions) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | partners_daily__gross_total_commissions** | | \| Display name \| Gross total commissions \| \| --- \| --- \| \| Description \| Total of all commissions (including CPC commissions) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Gross total commissions | | Description | Total of all commissions (including CPC commissions) | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| partners_daily__impressions** \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| The number of impressions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| The number of impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | partners_daily__impressions** | | \| Display name \| Impressions \| \| --- \| --- \| \| Description \| The number of impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions | | Description | The number of impressions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| partners_daily__items** \| \| --- \| \| \\| Display name \\| Items \\| \\| --- \\| --- \\| \\| Description \\| The number items sold, including cancelled items \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Items \| \| Description \| The number items sold, including cancelled items \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | partners_daily__items** | | \| Display name \| Items \| \| --- \| --- \| \| Description \| The number items sold, including cancelled items \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Items | | Description | The number items sold, including cancelled items | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| partners_daily__net_items** \| \| --- \| \| \\| Display name \\| Net items \\| \\| --- \\| --- \\| \\| Description \\| The number of items sold after cancelled items \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Net items \| \| Description \| The number of items sold after cancelled items \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | partners_daily__net_items** | | \| Display name \| Net items \| \| --- \| --- \| \| Description \| The number of items sold after cancelled items \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Net items | | Description | The number of items sold after cancelled items | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| partners_daily__net_items_per_order** \| \| --- \| \| \\| Display name \\| Net items per order \\| \\| --- \\| --- \\| \\| Description \\| The number of items you sold divided by the number of order that were placed. Items / Orders \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Net items per order \| \| Description \| The number of items you sold divided by the number of order that were placed. Items / Orders \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | partners_daily__net_items_per_order** | | \| Display name \| Net items per order \| \| --- \| --- \| \| Description \| The number of items you sold divided by the number of order that were placed. Items / Orders \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Display name | Net items per order | | Description | The number of items you sold divided by the number of order that were placed. Items / Orders | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| partners_daily__network** \| \| --- \| \| \\| Display name \\| Network \\| \\| --- \\| --- \\| \\| Description \\| The name of the Rakuten LinkShare Network you are in \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Network \| \| Description \| The name of the Rakuten LinkShare Network you are in \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | partners_daily__network** | | \| Display name \| Network \| \| --- \| --- \| \| Description \| The name of the Rakuten LinkShare Network you are in \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Network | | Description | The name of the Rakuten LinkShare Network you are in | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| partners_daily__offer_name** \| \| --- \| \| \\| Display name \\| Offer name \\| \\| --- \\| --- \\| \\| Description \\| The name given to an offer by the advertiser \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Offer name \| \| Description \| The name given to an offer by the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | partners_daily__offer_name** | | \| Display name \| Offer name \| \| --- \| --- \| \| Description \| The name given to an offer by the advertiser \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Offer name | | Description | The name given to an offer by the advertiser | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| partners_daily__offer_number** \| \| --- \| \| \\| Display name \\| Offer number \\| \\| --- \\| --- \\| \\| Description \\| The offer number is a sequential number assigned by Rakuten to each base commission, SKU list, and commissioning rule \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Offer number \| \| Description \| The offer number is a sequential number assigned by Rakuten to each base commission, SKU list, and commissioning rule \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | partners_daily__offer_number** | | \| Display name \| Offer number \| \| --- \| --- \| \| Description \| The offer number is a sequential number assigned by Rakuten to each base commission, SKU list, and commissioning rule \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Offer number | | Description | The offer number is a sequential number assigned by Rakuten to each base commission, SKU list, and commissioning rule | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| partners_daily__order_id** \| \| --- \| \| \\| Display name \\| Order ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order ID \| \| Description \| The unique ID of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | partners_daily__order_id** | | \| Display name \| Order ID \| \| --- \| --- \| \| Description \| The unique ID of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Order ID | | Description | The unique ID of the order | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| partners_daily__orders** \| \| --- \| \| \\| Display name \\| Orders \\| \\| --- \\| --- \\| \\| Description \\| The number of orders \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Orders \| \| Description \| The number of orders \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | partners_daily__orders** | | \| Display name \| Orders \| \| --- \| --- \| \| Description \| The number of orders \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Orders | | Description | The number of orders | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| partners_daily__product_name** \| \| --- \| \| \\| Display name \\| Product name \\| \\| --- \\| --- \\| \\| Description \\| The name of the product sold \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Product name \| \| Description \| The name of the product sold \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | partners_daily__product_name** | | \| Display name \| Product name \| \| --- \| --- \| \| Description \| The name of the product sold \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Product name | | Description | The name of the product sold | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| partners_daily__publisher_group_name** \| \| --- \| \| \\| Display name \\| Publisher group name \\| \\| --- \\| --- \\| \\| Description \\| The name of the publisher group \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Publisher group name \| \| Description \| The name of the publisher group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | partners_daily__publisher_group_name** | | \| Display name \| Publisher group name \| \| --- \| --- \| \| Description \| The name of the publisher group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Publisher group name | | Description | The name of the publisher group | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| partners_daily__publisher_name** \| \| --- \| \| \\| Display name \\| Publisher name \\| \\| --- \\| --- \\| \\| Description \\| The name of the publisher \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Publisher name \| \| Description \| The name of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | partners_daily__publisher_name** | | \| Display name \| Publisher name \| \| --- \| --- \| \| Description \| The name of the publisher \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Publisher name | | Description | The name of the publisher | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| partners_daily__quantity** \| \| --- \| \| \\| Display name \\| Quantity \\| \\| --- \\| --- \\| \\| Description \\| The number items sold, excluding cancelled items \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Quantity \| \| Description \| The number items sold, excluding cancelled items \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | partners_daily__quantity** | | \| Display name \| Quantity \| \| --- \| --- \| \| Description \| The number items sold, excluding cancelled items \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Quantity | | Description | The number items sold, excluding cancelled items | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| partners_daily__sales** \| \| --- \| \| \\| Display name \\| Sales \\| \\| --- \\| --- \\| \\| Description \\| The total sales \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Sales \| \| Description \| The total sales \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | partners_daily__sales** | | \| Display name \| Sales \| \| --- \| --- \| \| Description \| The total sales \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Sales | | Description | The total sales | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| partners_daily__sku** \| \| --- \| \| \\| Display name \\| SKU \\| \\| --- \\| --- \\| \\| Description \\| The SKU number of the product sold \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| SKU \| \| Description \| The SKU number of the product sold \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | partners_daily__sku** | | \| Display name \| SKU \| \| --- \| --- \| \| Description \| The SKU number of the product sold \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | SKU | | Description | The SKU number of the product sold | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| partners_daily__transaction_created_on_date** \| \| --- \| \| \\| Display name \\| Transaction created on date \\| \\| --- \\| --- \\| \\| Description \\| The date of the referring click-through for a transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Transaction created on date \| \| Description \| The date of the referring click-through for a transaction \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | partners_daily__transaction_created_on_date** | | \| Display name \| Transaction created on date \| \| --- \| --- \| \| Description \| The date of the referring click-through for a transaction \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Transaction created on date | | Description | The date of the referring click-through for a transaction | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| partners_daily__transaction_date** \| \| --- \| \| \\| Display name \\| Transaction date \\| \\| --- \\| --- \\| \\| Description \\| The date that a consumer complete a transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Transaction date \| \| Description \| The date that a consumer complete a transaction \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | partners_daily__transaction_date** | | \| Display name \| Transaction date \| \| --- \| --- \| \| Description \| The date that a consumer complete a transaction \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Transaction date | | Description | The date that a consumer complete a transaction | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| partners_daily__transaction_id** \| \| --- \| \| \\| Display name \\| Transaction ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Transaction ID \| \| Description \| The unique ID of the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | partners_daily__transaction_id** | | \| Display name \| Transaction ID \| \| --- \| --- \| \| Description \| The unique ID of the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Transaction ID | | Description | The unique ID of the transaction | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) |