Rakuten Advertiser: Most-used fields#
The table below gives information about most-used fields that you can import from Rakuten Advertiser. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
# of Cancelled Items Metric
The number of items within a transaction that were cancelled.
# of Clicks Metric
The total number of click-throughs recorded for links within the specified period.
# of Impressions Metric
The total number of times an advertisement or link was displayed.
# of Items Metric
The total quantity of individual items sold in transactions.
# of Net Items Metric
The total number of items purchased in a transaction after accounting for any returns or cancellations. This relates to the 'Items' field which represents `item-count` in the API.
# of Orders Metric
The total count of completed orders.
Adjusted Commission Metric
For tiered commission structures, this is the commission that is added to the baseline commission when a publisher reaches a certain level of sales. This value is populated only at the end of the month when Publisher Invoices are generated.
Advertiser Name Dimension
The name of the advertiser associated with a transaction or payment.
Average Order Value Dimension
The average monetary value of each order.
Baseline Commission Metric
The commission amount that is calculated before adjustments are made at the end of the month for tiered offers.
Click Through Rate (CTR) Metric
The ratio of clicks to impressions, indicating the percentage of users who clicked on a link after viewing it.
Consumer Country Dimension
The country of the consumer who made the purchase.
Cost Per Action (CPA) Metric
This metric represents the cost incurred for each specific action or item, as defined by the advertiser in their offer. It is a type of commission where the advertiser pays a fixed amount for each action or item.
Currency Dimension
The currency in which monetary values are reported (e.g., USD, EUR).
Customer Status Dimension
The status assigned by the advertiser to the consumer for a specific order, based on the customer's order history with the advertiser.
Device Dimension
The type of device a consumer used when clicking a link, for example, PC, Tablet, or Phone.
Estimated Net Total Cost Metric
The estimated net total cost of an item or order.
Gross Commissions Metric
The total of all commissions (excluding CPC commissions) before taking cancellations into account. It is calculated by adding the sum of all commissions with values greater than 0.
Gross Sales Metric
The total sales amount generated before any deductions, as reported in the Gross Sales and Commissions Report.
Gross Total Commissions Metric
The total of all commissions (including CPC commissions) before taking cancellations into account. It is calculated by adding the sum of all commissions with values greater than 0.
MID Dimension
The Merchant ID (MID) for the Advertiser's affiliate program.
Net Items Per Order Metric
The number of items sold after canceled items are subtracted from the gross number of items, divided by the number of orders that were placed.
Network Dimension
The geographical network or region associated with the data, often represented by a specific ID (e.g., '1' for US, '3' for UK).
Network ID Dimension
A unique identifier for the geographical network or region where the transaction or activity occurred.
Order ID Dimension
The ID of the order as reported by the advertiser.
Orders/Click Metric
The conversion rate, representing the number of orders generated per click.
Process Date Dimension
The date when a transaction or event was processed by the Rakuten Advertising system.
Publisher Group ID Metric
Unique identifier for a group of publishers within the Rakuten Advertising network. Publishers are often organized into groups for reporting and management purposes.
Publisher Group Name Dimension
The human-readable name of a publisher group in the Rakuten Advertising network. This name corresponds to the Publisher Group ID.
Publisher ID Metric
A unique identifier for the publisher within the Rakuten Advertising network.
Publisher Name Dimension
The name of the publisher.
Quantity Metric
The number of items purchased in a transaction. This field is numeric and represents the quantity of items sold, excluding any canceled items.
Sales Dimension
The total revenue generated from referred transactions.
Ship-to Country Dimension
The country where the order is being shipped.
Total Commission Metric
The aggregate commission earned from referred transactions.
Transaction Date Dimension
The date when a customer completed a purchase or action.
Transaction ID Dimension
The unique identification number assigned to a specific transaction or order reported by the advertiser.
Transaction Time Dimension
The time of day that a consumer completed a transaction.