Rakuten Advertising data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

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
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
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
partners_daily__cancelled_items
Display name Cancelled items
Description The number of items cancelled or returned
Field type metric
Data type int.number.value
partners_daily__clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
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
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
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
partners_daily__currency
Display name Currency
Description The currency that the transaction was reported in
Field type dimension
Data type string.currency.code
partners_daily__date
Display name Date
Field type dimension
Data type string.time.date
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
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
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
partners_daily__impressions
Display name Impressions
Description The number of impressions
Field type metric
Data type int.number.value
partners_daily__items
Display name Items
Description The number items sold, including cancelled items
Field type metric
Data type int.number.value
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
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
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
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
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
partners_daily__order_id
Display name Order ID
Description The unique ID of the order
Field type dimension
Data type string.text.value
partners_daily__orders
Display name Orders
Description The number of orders
Field type metric
Data type int.number.value
partners_daily__product_name
Display name Product name
Description The name of the product sold
Field type dimension
Data type string.text.value
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
partners_daily__publisher_name
Display name Publisher name
Description The name of the publisher
Field type dimension
Data type string.text.value
partners_daily__quantity
Display name Quantity
Description The number items sold, excluding cancelled items
Field type metric
Data type int.number.value
partners_daily__sales
Display name Sales
Description The total sales
Field type metric
Data type float.currency.value
partners_daily__sku
Display name SKU
Description The SKU number of the product sold
Field type dimension
Data type string.text.value
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
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
partners_daily__transaction_id
Display name Transaction ID
Description The unique ID of the transaction
Field type dimension
Data type string.text.value