Rakuten Advertiser: Most-used fields

The number of items within a transaction that were cancelled.

The total number of click-throughs recorded for links within the specified period.

The total number of times an advertisement or link was displayed.

The total quantity of individual items sold in transactions.

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.

The total count of completed orders.

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.

The name of the advertiser associated with a transaction or payment.

The average monetary value of each order.

The commission amount that is calculated before adjustments are made at the end of the month for tiered offers.

The ratio of clicks to impressions, indicating the percentage of users who clicked on a link after viewing it.

The country of the consumer who made the purchase.

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.

The currency in which monetary values are reported (e.g., USD, EUR).

The status assigned by the advertiser to the consumer for a specific order, based on the customer's order history with the advertiser.

The type of device a consumer used when clicking a link, for example, PC, Tablet, or Phone.

The estimated net total cost of an item or order.

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.

The total sales amount generated before any deductions, as reported in the Gross Sales and Commissions Report.

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.

The unique identifier for a specific link used in advertiser programs, which can include text, banner, or DRM links.

The name assigned by the advertiser to a particular link, such as a text link, banner link, or DRM link.

The classification of the link, indicating its creative format such as Banner, Text, or Flex Link.

The Merchant ID (MID) for the Advertiser's affiliate program.

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.

The geographical network or region associated with the data, often represented by a specific ID (e.g., '1' for US, '3' for UK).

A unique identifier for the geographical network or region where the transaction or activity occurred.

The ID of the order as reported by the advertiser.

The conversion rate, representing the number of orders generated per click.

The date when a transaction or event was processed by the Rakuten Advertising system.

Unique identifier for a group of publishers within the Rakuten Advertising network. Publishers are often organized into groups for reporting and management purposes.

The human-readable name of a publisher group in the Rakuten Advertising network. This name corresponds to the Publisher Group ID.

A unique identifier for the publisher within the Rakuten Advertising network.

The name of the publisher.

The total revenue generated from referred transactions.

The country where the order is being shipped.

The aggregate commission earned from referred transactions.

The date when a customer completed a purchase or action.

The unique identification number assigned to a specific transaction or order reported by the advertiser.

The time of day that a consumer completed a transaction.