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
Average Order Value	Average Order Value	The average monetary value of each order.	dimension
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
Estimated Net Total Cost	Estimated Net Total Cost	The estimated net total cost of an item or order.	metric
Net Items Per Order	Net Items Per Order	The total number of items sold divided by the number of orders that were placed.	metric
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
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
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