Rakuten Advertising fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Rakuten Advertising data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

30 metrics139 dimensions

ADDITIONAL COST DATA

partners_daily__estimated_placement_fees
Field label Estimated placement fees
Description Approximate amount paid in Flat Fees to publishers for paid placements. Placement Flat Fees are divided equally into Daily Cost for the length of the placement and are associated with transactions which occurred during that time window
Field type metric
Data type float.currency.value
partners_daily__estimated_tracking_fee
Field label Estimated tracking fee
Description Approximate amount charged by Rakuten Advertising for transaction tracking. Tracking Fees are approximate based on the base Tracking Fee for the account, and do not include Service Fees, Monthly Minimums, Variable Rates, or Tiered Rates
Field type metric
Data type float.currency.value
partners_daily__estimated_net_total_cost
Field label Estimated net total cost
Description Approximate total net cost charged to the Advertiser
Field type metric
Data type float.currency.value
partners_daily__estimated_gross_total_cost
Field label Estimated gross total cost
Description Approximate total gross cost charged to the Advertiser
Field type metric
Data type float.currency.value

ADDITIONAL TRANSACTION DETAILS

partners_daily__order_coupon_codes
Field label Order coupon code(s)
Description The coupon code(s) applied to an order
Field type dimension
Data type string.text.value
partners_daily__order_discount_amount
Field label Order discount amount
Description The discounted by the advertiser
Field type dimension
Data type float.currency.value
partners_daily__in_store_id
Field label In-Store ID
Description The unique ID assigned by the advertiser to the in-store location of the purchase
Field type dimension
Data type string.text.value
partners_daily__in_store_name
Field label In-Store name
Description The name assigned by the advertiser to the in-store location of the purchase
Field type dimension
Data type string.text.value
partners_daily__in_store_address
Field label In-Store address
Description The address assigned by the advertiser to the in-store location of the purchase
Field type dimension
Data type string.text.value
partners_daily__in_store_city
Field label In-Store city
Description The city provided by the advertiser for the in-store location of the purchase
Field type dimension
Data type string.geo.city
partners_daily__in_store_state
Field label In-Store state
Description The state provided by the advertiser for the in-store location of the purchase
Field type dimension
Data type string.text.value
partners_daily__in_store_zip_code
Field label In-Store zip code
Description The zip code provided by the advertiser for the in-store location of the purchase
Field type dimension
Data type string.geo.zip
partners_daily__in_store_country
Field label In-Store country
Description The country provided by the advertiser for the in-store location of the purchase
Field type dimension
Data type string.geo.country
partners_daily__order_status
Field label Order status
Description The status of an order
Field type dimension
Data type string.text.value
partners_daily__customer_score
Field label Customer score
Description The value provided by the advertiser that represents their rank of the customer
Field type dimension
Data type string.text.value
partners_daily__ship_to_country
Field label Ship-to country
Description The country where the order will be shipped
Field type dimension
Data type string.geo.country
partners_daily__merchant_store_id
Field label Merchant store ID
Description The unique ID of the company who offers the product
Field type dimension
Data type string.text.value
partners_daily__merchant_store_category
Field label Merchant store category
Description The merchant category of the company who offers the product
Field type dimension
Data type string.text.value
partners_daily__card_type
Field label Card type
Description The credit card type the consumer used to make the purchase
Field type dimension
Data type string.text.value
partners_daily__customer_segment
Field label Customer segment
Description Advertiser defined customer segment
Field type dimension
Data type string.text.value
partners_daily__alternate_order_id
Field label Alternate order ID
Description An alternate version of the order ID created by the advertiser
Field type dimension
Data type string.text.value
partners_daily__device_id
Field label Device ID
Description The advertising ID of the mobile device
Field type dimension
Data type string.text.value
partners_daily__customer_status
Field label Customer status
Description The status assigned by the advertiser to the consumer for a specific order
Field type dimension
Data type string.text.value
partners_daily__conversion_type
Field label Conversion type
Description The advertiser defined value representing the attribution method used by the Advertiser to attribute the conversion
Field type dimension
Data type string.text.value
partners_daily__placement_name
Field label Placement name
Description The advertiser defined value representing that represents the placement of the advertisement
Field type dimension
Data type string.text.value
partners_daily__customer_id
Field label Customer ID
Description The unique ID assigned to a consumer by the advertiser
Field type dimension
Data type string.text.value
partners_daily__check_in_date
Field label Check in date
Description The date the traveler checks in to a hotel, resort, or other lodging type
Field type dimension
Data type string.time.date
partners_daily__check_out_date
Field label Check out date
Description The date the traveler checks out of a hotel, resort, or other lodging type
Field type dimension
Data type string.time.date
partners_daily__is_weekend
Field label Is weekend
Description Identifies if a reservation or event took place over the weekend
Field type dimension
Data type bool
partners_daily__converting_site_name
Field label Converting site name
Description The name of the site where the conversion took place
Field type dimension
Data type string.text.value
partners_daily__booking_consumed_date
Field label Booking consumed date
Description The date indicating when a reservation was fulfilled
Field type dimension
Data type string.time.date
partners_daily__order_ship_date
Field label Order ship date
Description The date indicating when the item was shipped
Field type dimension
Data type string.time.date
partners_daily__item_coupon_codes
Field label Item coupon code(s)
Description The coupon code applied to an item
Field type dimension
Data type string.text.value
partners_daily__item_discount_amount
Field label Item discount amount
Description The amount discounted by the advertiser for an item in an order
Field type dimension
Data type float.currency.value
partners_daily__tax_exempt
Field label Tax exempt
Description Some advertisers include tax within the Sales value. The Item Tax Exempt flag will be set to Y by the advertiser to identify if the item is tax exempt. The flag will be set to N by the advertiser if the item is not tax exempt
Field type dimension
Data type string.text.value
partners_daily__item_profit_margin
Field label Item profit margin
Description A percentage representing the profit margin for an item
Field type dimension
Data type float.number.percentage
partners_daily__product_category_id
Field label Product category ID
Description The category ID of the product or service
Field type dimension
Data type string.text.value
partners_daily__product_category
Field label Product category
Description The category of the product or service
Field type dimension
Data type string.text.value
partners_daily__product_category_id_2
Field label Product category ID 2
Description The second category level ID of the product or service
Field type dimension
Data type string.text.value
partners_daily__product_category_2
Field label Product category 2
Description The second category of the product or service
Field type dimension
Data type string.text.value
partners_daily__product_category_id_3
Field label Product category ID 3
Description The third category level ID of the product or service
Field type dimension
Data type string.text.value
partners_daily__product_category_3
Field label Product category 3
Description The third category of the product or service
Field type dimension
Data type string.text.value
partners_daily__product_category_id_4
Field label Product category ID 4
Description The fourth category level ID of the product or service
Field type dimension
Data type string.text.value
partners_daily__product_category_4
Field label Product category 4
Description The fourth category of the product or service
Field type dimension
Data type string.text.value
partners_daily__product_category_id_5
Field label Product category ID 5
Description The fifth category level ID of the product or service
Field type dimension
Data type string.text.value
partners_daily__product_category_5
Field label Product category 5
Description The fifth category of the product or service
Field type dimension
Data type string.text.value
partners_daily__sale_flag
Field label Sale flag
Description A flag that identifies if the item is on sale
Field type dimension
Data type bool
partners_daily__clearance_flag
Field label Clearance flag
Description A flag that identifies if the item is on clearance
Field type dimension
Data type bool
partners_daily__marketplace_flag
Field label Marketplace flag
Description A flag to identify marketplace items
Field type dimension
Data type bool
partners_daily__item_status
Field label Item status
Description The status of the item purchased by the consumer
Field type dimension
Data type string.text.value
partners_daily__discount_type
Field label Discount type
Description The type of the discount
Field type dimension
Data type string.text.value
partners_daily__shipped_by
Field label Shipped by
Description Identifies who shipped the item
Field type dimension
Data type string.text.value
partners_daily__shipment_id
Field label Shipment ID
Description The unique ID that identifies a collection of items that are shipped or returned together
Field type dimension
Data type string.text.value
partners_daily__sequence_number
Field label Sequence number
Description The unique ID that identifies the sequence in which items are grouped in a shipment or return
Field type dimension
Data type string.text.value
partners_daily__product_brand
Field label Product brand
Description The brand associated with the product or service
Field type dimension
Data type string.text.value
partners_daily__region
Field label Region
Description The where the travel takes place
Field type dimension
Data type string.geo.region
partners_daily__quintiles_score
Field label Quintiles score
Description Values 1 - 5 that represents a segmentation of an Advertiser's users into 1 of 5 groups as defined by the Advertiser
Field type dimension
Data type string.text.value
partners_daily__reservation_start_date
Field label Reservation start date
Description The date when a travel reservation begins
Field type dimension
Data type string.time.date
partners_daily__reservation_end_date
Field label Reservation end date
Description The date when a travel reservation ends
Field type dimension
Data type string.time.date
partners_daily__departure_location
Field label Departure location
Description The location where a traveler beings their trip
Field type dimension
Data type string.text.value
partners_daily__departure_country
Field label Departure country
Description The country where a traveler beings their trip
Field type dimension
Data type string.geo.country
partners_daily__destination_location
Field label Destination location
Description The location where a traveler ends their trip
Field type dimension
Data type string.text.value
partners_daily__destination_country
Field label Destination country
Description The country where a traveler ends their trip
Field type dimension
Data type string.geo.country
partners_daily__paid_with_loyalty_points
Field label Paid with loyalty points
Description The customer paid for the travel reservation using loyalty points. This is a Y/N flag
Field type dimension
Data type string.text.value
partners_daily__fare_type
Field label Fare type
Description The fare type associated with an airline ticket such as first class, business class, or economy
Field type dimension
Data type string.text.value
partners_daily__vehicle_type
Field label Vehicle type
Description The vehicle type associated with a car rental
Field type dimension
Data type string.text.value
partners_daily__property_type
Field label Property type
Description The classification of the property such as resort, hotel, motel, or house
Field type dimension
Data type string.text.value
partners_daily__accommodation_type
Field label Accommodation type
Description The cabin class for a cruise such as balcony, ocean view, or interior, or the room class at a hotel such as penthouse or standard
Field type dimension
Data type string.text.value
partners_daily__travel_type
Field label Travel type
Description The specific type of travel reservation such as airline, cruise, hotel, rental car, or activity
Field type dimension
Data type string.text.value
partners_daily__travel_reason
Field label Travel reason
Description The reason the traveler booked the trip such as personal or business
Field type dimension
Data type string.text.value
partners_daily__reservation_cancellation_deadline_date
Field label Reservation cancellation deadline date
Description The deadline date for a traveler to cancel their travel reservation. Any money paid towards to trip is non-refundable at this point
Field type dimension
Data type string.time.date
partners_daily__commissionable_order_amount
Field label 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__item_amount
Field label Item amount
Description The sales amount of a single item
Field type metric
Data type float.number.value
partners_daily__number_of_rooms
Field label Number of rooms
Description The number of rooms in a travel reservation
Field type metric
Data type int.number.value

COMMISSION

partners_daily__commission_status
Field label 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__commissioning_list_id
Field label Commissioning list ID
Description The unique ID of the commissioning list
Field type dimension
Data type string.text.value
partners_daily__commissioning_list_name
Field label Commissioning list name
Description The name of the commissioning list
Field type dimension
Data type string.text.value
partners_daily__adjusted_commission
Field label 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
Field label 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__gross_commissions
Field label 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_total_commissions
Field label Gross total commissions
Description Total of all commissions (including CPC commissions)
Field type metric
Data type float.currency.value
partners_daily__total_commission
Field label Total commissions
Description The sum of baseline commissions and adjusted commissions
Field type metric
Data type float.currency.value

CORE METRICS

partners_daily__impressions
Field label Impressions
Description The number of impressions
Field type metric
Data type int.number.value
partners_daily__clicks
Field label Clicks
Description The number of clicks
Field type metric
Data type int.number.value
partners_daily__ctr
Field label CTR
Description Click through rate (CTR). Clicks / Impressions
Field type metric
Data type float.number.ratio
partners_daily__cpa
Field label CPA
Description Cost per action (CPA). Total commission / Items
Field type metric
Data type float.currency.value
partners_daily__epc
Field label EPC
Description Earnings per click (EPC). Total commission / Clicks
Field type metric
Data type float.currency.value

CREATIVE

partners_daily__link_id
Field label Link ID
Description The unique ID of the link
Field type dimension
Data type string.text.value
partners_daily__link_name
Field label Link name
Description The name of the link
Field type dimension
Data type string.text.value
partners_daily__link_size
Field label Link size
Description The size of the banner, DRM, Flex Link, or other creative type. This does not apply to text links
Field type dimension
Data type string.text.value
partners_daily__link_type
Field label Link type
Description The creative type such as banner, Flex Link, and so on
Field type dimension
Data type string.text.value

DATASOURCE

dataSourceName
Field label 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
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

GEOGRAPHY

partners_daily__consumer_city
Field label Consumer city
Description The city that the consumer was in when they clicked your link
Field type dimension
Data type string.geo.city
partners_daily__consumer_country
Field label Consumer country
Description The country that the consumer was in when they clicked your link
Field type dimension
Data type string.geo.country
partners_daily__consumer_region
Field label Consumer region
Description The region that the consumer was in when they clicked your link
Field type dimension
Data type string.geo.region

ITEMS

partners_daily__items
Field label Items
Description The number items sold, including cancelled items
Field type metric
Data type int.number.value
partners_daily__cancelled_items
Field label Cancelled items
Description The number of items cancelled or returned
Field type metric
Data type int.number.value
partners_daily__cancellation_rate
Field label Cancellation rate
Description Cancellation rate. Cancelled items / Items
Field type metric
Data type float.number.ratio
partners_daily__net_items
Field label Net items
Description The number of items sold after cancelled items
Field type metric
Data type int.number.value
partners_daily__average_item_value
Field label Average item value
Description The sum of your s ales divided by the total number of items sold
Field type metric
Data type float.number.ratio
partners_daily__net_items_per_order
Field label 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__quantity
Field label Quantity
Description The number items sold, excluding cancelled items
Field type metric
Data type int.number.value

MOBILE AND TECHNOLOGY

partners_daily__browser
Field label Browser
Description The browser consumer used when clicking your link
Field type dimension
Data type string.text.value
partners_daily__browser_major_version
Field label Browser major version
Description The major version of the browser consumer used when clicking your link
Field type dimension
Data type string.text.value
partners_daily__browser_name
Field label Browser name
Description The name of the browser consumer used when clicking your link
Field type dimension
Data type string.text.value
partners_daily__browser_version
Field label Browser version
Description The version of the browser consumer used when clicking your link
Field type dimension
Data type string.text.value
partners_daily__consumer_connection_speed
Field label Consumer connection speed
Description The consumer's Internet connection speed at the time they clicked your link
Field type dimension
Data type string.text.value
partners_daily__device
Field label Device
Description The device consumer used when clicking your link
Field type dimension
Data type string.text.value
partners_daily__mobile_operating_system
Field label Mobile operating system
Description The operating system of the device consumer used when they clicking your link
Field type dimension
Data type string.text.value

NETWORK

partners_daily__currency
Field label Currency
Description The currency that the transaction was reported in
Field type dimension
Data type string.currency.code
partners_daily__network
Field label Network
Description The name of the Rakuten LinkShare Network you are in
Field type dimension
Data type string.text.value
partners_daily__network_id
Field label Network ID
Description The unique ID of the Rakuten LinkShare Network you are in
Field type dimension
Data type string.text.value

OFFER

partners_daily__group_offer_id
Field label Group offer ID
Description The group offer ID is a single number assigned by Rakuten that connects base commission, SKU lists, and commissioning rules for more complex offers
Field type dimension
Data type string.text.value
partners_daily__offer_group_id
Field label Offer group ID
Description The offer group ID is a number assigned by Rakuten LinkShare to the offer and each of its SKU lists
Field type dimension
Data type string.text.value
partners_daily__offer_id
Field label Offer ID
Description The unique ID assigned by Rakuten LinkShare to each SKU list with an offer group
Field type dimension
Data type string.text.value
partners_daily__offer_name
Field label Offer name
Description The name given to an offer by the advertiser
Field type dimension
Data type string.text.value
partners_daily__offer_number
Field label 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__offer_rule
Field label Offer rule
Description The reason a transaction was deemed commissionable as defined in its offer's commission structure
Field type dimension
Data type string.text.value

ORDER

partners_daily__order_id
Field label Order ID
Description The unique ID of the order
Field type dimension
Data type string.text.value

ORDERS

partners_daily__orders
Field label Orders
Description The number of orders
Field type metric
Data type int.number.value
partners_daily__orders_per_clicks
Field label Orders/click
Description The number of orders divided by the number of clicks. Orders / Clicks
Field type metric
Data type float.number.ratio
partners_daily__average_order_value
Field label Average order value
Description Total sales divided by total number of orders. Sales / Orders
Field type metric
Data type float.number.value

PRODUCT

partners_daily__product_name
Field label Product name
Description The name of the product sold
Field type dimension
Data type string.text.value
partners_daily__sku
Field label SKU
Description The SKU number of the product sold
Field type dimension
Data type string.text.value

PUBLISHER

partners_daily__publisher_encrypted_id
Field label Publisher encrypted ID
Description The 11-character alphanumeric code unique to a publisher. This code can be found in a publisher's LinkShare linking code, following "id=" and before "&offerid="
Field type dimension
Data type string.text.value
partners_daily__publisher_group_id
Field label Publisher group ID
Description The unique ID of the publisher group
Field type dimension
Data type string.text.value
partners_daily__publisher_group_name
Field label Publisher group name
Description The name of the publisher group
Field type dimension
Data type string.text.value
partners_daily__publisher_id
Field label Publisher ID
Description The unique ID of the publisher. Also known as SID
Field type dimension
Data type string.text.value
partners_daily__publisher_name
Field label Publisher name
Description The name of the publisher
Field type dimension
Data type string.text.value
partners_daily__publisher_url
Field label Publisher URL
Description The URL of the publisher
Field type dimension
Data type string.text.url
partners_daily__publishers_per_group
Field label Publishers per group
Description The total number of publishers in the group
Field type metric
Data type int.number.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

SALES

partners_daily__gross_sales
Field label 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__sales
Field label Sales
Description The total sales
Field type metric
Data type float.currency.value

SUB-NETWORK

partners_daily__sub_publisher_id
Field label Sub-Publisher ID
Description The ID assigned by a publisher to a member of their network
Field type dimension
Data type string.text.value
partners_daily__sub_publisher_name
Field label Sub-Publisher Name
Description The name assigned by a publisher to a member of their network
Field type dimension
Data type string.text.value
partners_daily__sub_publisher_url
Field label Sub-Publisher URL
Description The URL assigned by a publisher to a member of their network
Field type dimension
Data type string.text.url

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
partners_daily__year
Field label Year
Field type dimension
Data type string.time.year
partners_daily__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
partners_daily__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
partners_daily__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
partners_daily__month
Field label Month
Field type dimension
Data type string.time.month
partners_daily__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
partners_daily__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
partners_daily__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
partners_daily__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
partners_daily__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
partners_daily__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
partners_daily__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
partners_daily__date
Field label Date
Field type dimension
Data type string.time.date
partners_daily__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
partners_daily__transaction_date
Field label Transaction date
Description The date that a consumer complete a transaction
Field type dimension
Data type string.time.date
partners_daily__transaction_created_on_date
Field label 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__signature_match_date
Field label Signature Match Date
Description The date that matched the referring Signature information to a transaction
Field type dimension
Data type string.time.date
partners_daily__process_date
Field label Process date
Description The date when transaction was sent
Field type dimension
Data type string.time.date

TRANSACTION DETAILS

partners_daily__click_ip_address
Field label Click IP address
Description The IP address of the customer who clicked your link
Field type dimension
Data type string.text.value
partners_daily__member_id
Field label Member ID (U1)
Description Unique ID that is appended to the Rakuten LinkShare tracking process. Used to capture member information
Field type dimension
Data type string.text.value
partners_daily__referrer_url
Field label Referrer URL
Description The URL of the publisher's site that referred a customer to the advertiser's site
Field type dimension
Data type string.text.url
partners_daily__transaction_id
Field label Transaction ID
Description The unique ID of the transaction
Field type dimension
Data type string.text.value