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.

API name	Adverity UI name	Description	Use in Adverity
# of Cancelled Items	# of Cancelled Items	The number of items within a transaction that were cancelled.	metric
# of Clicks	# of Clicks	The total number of click-throughs recorded for links within the specified period.	metric
# of Impressions	# of Impressions	The total number of times an advertisement or link was displayed.	metric
# of Items	# of Items	The total quantity of individual items sold in transactions.	metric
# of Net Items	# of Net Items	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.	metric
# of Orders	# of Orders	The total count of completed orders.	metric
Adjusted Commission	Adjusted Commission	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.	metric
Average Order Value	Average Order Value	The average monetary value of each order.	dimension
Baseline Commission	Baseline Commission	The commission amount that is calculated before adjustments are made at the end of the month for tiered offers.	metric
Click Through Rate (CTR)	Click Through Rate (CTR)	The ratio of clicks to impressions, indicating the percentage of users who clicked on a link after viewing it.	metric
Consumer Country	Consumer Country	The country of the consumer who made the purchase.	dimension
Currency	Currency	The currency in which monetary values are reported (e.g., USD, EUR).	dimension
Customer Status	Customer Status	The status assigned by the advertiser to the consumer for a specific order, based on the customer’s order history with the advertiser.	dimension
Device	Device	The type of device a consumer used when clicking a link, for example, PC, Tablet, or Phone.	dimension
Estimated Net Total Cost	Estimated Net Total Cost	The estimated net total cost of an item or order.	metric
Gross Commissions	Gross Commissions	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.	metric
Gross Total Commissions	Gross Total Commissions	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.	metric
Net Items Per Order	Net Items Per Order	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.	metric
Offer Group ID	Offer Group ID	A unique identifier assigned by the system that connects the base commission, SKU lists, and commissioning rules for more complex offers.	metric
Order ID	Order ID	The ID of the order as reported by the advertiser.	dimension
Orders/Click	Orders/Click	The conversion rate, representing the number of orders generated per click.	metric
Process Date	Process Date	The date when a transaction or event was processed by the Rakuten Advertising system.	dimension
Product Name	Product Name	The name of the product sold.	dimension
Publisher Group ID	Publisher Group ID		metric
Publisher Group Name	Publisher Group Name		dimension
Publisher ID	Publisher ID	A unique identifier for the publisher within the Rakuten Advertising network.	metric
Publisher Name	Publisher Name	The name of the publisher.	dimension
SKU	SKU	The stock-keeping unit (SKU) number of the product sold.	dimension
Sales	Sales	The total revenue generated from referred transactions.	dimension
Ship-to Country	Ship-to Country	The country where the order is being shipped.	dimension
Total Commission	Total Commission	The aggregate commission earned from referred transactions.	metric
Transaction Date	Transaction Date	The date when a customer completed a purchase or action.	dimension
Transaction Time	Transaction Time	The time of day that a consumer completed a transaction.	dimension
datetime	datetime	A combined date and time field, likely generated for ease of use within the data integration platform from available date and time fields like ‘Transaction Date’ and ‘Transaction Time’.	dimension