Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | partners_daily_year | dim | |
| Year of week (Sun-Sat) | partners_daily_year_of_week | dim | ||
| Year of week (Mon-Sun) | partners_daily_year_of_week_iso | dim | ||
| Year & month | partners_daily_year_month | dim | ||
| Month | partners_daily_month | dim | ||
| Year & week (Sun-Sat) | partners_daily_year_week | dim | ||
| Year & week (Mon-Sun) | partners_daily_year_week_iso | dim | ||
| Week (Sun-Sat) | partners_daily_week | dim | ||
| Week (Mon-Sun) | partners_daily_week_iso | dim | ||
| Day of month | partners_daily_day_of_month | dim | ||
| Day of week (Sun-Sat) | partners_daily_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | partners_daily_day_of_week_name_iso | dim | ||
| Date | partners_daily_date | dim | ||
| Datetime | partners_daily_atom | dim | ||
| Transaction date | partners_daily_transaction_date | dim | The date that a consumer complete a transaction | |
| Transaction created on date | partners_daily_transaction_created_on_date | dim | The date of the referring click-through for a transaction | |
| Signature Match Date | partners_daily_signature_match_date | dim | The date that matched the referring Signature information to a transaction | |
| Process date | partners_daily_process_date | dim | The date when transaction was sent | |
| Commission | Commission status | partners_daily_commission_status | dim | The status indicates whether the commission for an order is approved, pending or cancelled |
| Commissioning list ID | partners_daily_commissioning_list_id | dim | The unique ID of the commissioning list | |
| Commissioning list name | partners_daily_commissioning_list_name | dim | The name of the commissioning list | |
| Network | Currency | partners_daily_currency | dim | The currency that the transaction was reported in |
| Network | partners_daily_network | dim | The name of the Rakuten LinkShare Network you are in | |
| Network ID | partners_daily_network_id | dim | The unique ID of the Rakuten LinkShare Network you are in | |
| Offer | Group offer ID | partners_daily_group_offer_id | dim | The group offer ID is a single number assigned by Rakuten that connects base commission, SKU lists, and commissioning rules for more complex offers |
| Offer group ID | partners_daily_offer_group_id | dim | The offer group ID is a number assigned by Rakuten LinkShare to the offer and each of its SKU lists | |
| Offer ID | partners_daily_offer_id | dim | The unique ID assigned by Rakuten LinkShare to each SKU list with an offer group | |
| Offer name | partners_daily_offer_name | dim | The name given to an offer by the advertiser | |
| Offer number | partners_daily_offer_number | dim | The offer number is a sequential number assigned by Rakuten to each base commission, SKU list, and commissioning rule | |
| Offer rule | partners_daily_offer_rule | dim | The reason a transaction was deemed commissionable as defined in its offer's commission structure | |
| Order | Order ID | partners_daily_order_id | dim | The unique ID of the order |
| Product | Product name | partners_daily_product_name | dim | The name of the product sold |
| SKU | partners_daily_sku | dim | The SKU number of the product sold | |
| Publisher | Publisher encrypted ID | partners_daily_publisher_encrypted_id | dim | 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=" |
| Publisher group ID | partners_daily_publisher_group_id | dim | The unique ID of the publisher group | |
| Publisher group name | partners_daily_publisher_group_name | dim | The name of the publisher group | |
| Publisher ID | partners_daily_publisher_id | dim | The unique ID of the publisher. Also known as SID | |
| Publisher name | partners_daily_publisher_name | dim | The name of the publisher | |
| Publisher URL | partners_daily_publisher_url | dim | The URL of the publisher | |
| Sub-Network | Sub-Publisher ID | partners_daily_sub_publisher_id | dim | The ID assigned by a publisher to a member of their network |
| Sub-Publisher Name | partners_daily_sub_publisher_name | dim | The name assigned by a publisher to a member of their network | |
| Sub-Publisher URL | partners_daily_sub_publisher_url | dim | The URL assigned by a publisher to a member of their network | |
| Transaction Details | Click IP address | partners_daily_click_ip_address | dim | The IP address of the customer who clicked your link |
| Member ID (U1) | partners_daily_member_id | dim | Unique ID that is appended to the Rakuten LinkShare tracking process. Used to capture member information | |
| Referrer URL | partners_daily_referrer_url | dim | The URL of the publisher's site that referred a customer to the advertiser's site | |
| Transaction ID | partners_daily_transaction_id | dim | The unique ID of the transaction | |
| Additional Transaction Details | Order coupon code(s) | partners_daily_order_coupon_codes | dim | The coupon code(s) applied to an order |
| Order discount amount | partners_daily_order_discount_amount | dim | The discounted by the advertiser | |
| In-Store ID | partners_daily_in_store_id | dim | The unique ID assigned by the advertiser to the in-store location of the purchase | |
| In-Store name | partners_daily_in_store_name | dim | The name assigned by the advertiser to the in-store location of the purchase | |
| In-Store address | partners_daily_in_store_address | dim | The address assigned by the advertiser to the in-store location of the purchase | |
| In-Store city | partners_daily_in_store_city | dim | The city provided by the advertiser for the in-store location of the purchase | |
| In-Store state | partners_daily_in_store_state | dim | The state provided by the advertiser for the in-store location of the purchase | |
| In-Store zip code | partners_daily_in_store_zip_code | dim | The zip code provided by the advertiser for the in-store location of the purchase | |
| In-Store country | partners_daily_in_store_country | dim | The country provided by the advertiser for the in-store location of the purchase | |
| Order status | partners_daily_order_status | dim | The status of an order | |
| Customer score | partners_daily_customer_score | dim | The value provided by the advertiser that represents their rank of the customer | |
| Ship-to country | partners_daily_ship_to_country | dim | The country where the order will be shipped | |
| Merchant store ID | partners_daily_merchant_store_id | dim | The unique ID of the company who offers the product | |
| Merchant store category | partners_daily_merchant_store_category | dim | The merchant category of the company who offers the product | |
| Card type | partners_daily_card_type | dim | The credit card type the consumer used to make the purchase | |
| Customer segment | partners_daily_customer_segment | dim | Advertiser defined customer segment | |
| Alternate order ID | partners_daily_alternate_order_id | dim | An alternate version of the order ID created by the advertiser | |
| Device ID | partners_daily_device_id | dim | The advertising ID of the mobile device | |
| Customer status | partners_daily_customer_status | dim | The status assigned by the advertiser to the consumer for a specific order | |
| Conversion type | partners_daily_conversion_type | dim | The advertiser defined value representing the attribution method used by the Advertiser to attribute the conversion | |
| Placement name | partners_daily_placement_name | dim | The advertiser defined value representing that represents the placement of the advertisement | |
| Customer ID | partners_daily_customer_id | dim | The unique ID assigned to a consumer by the advertiser | |
| Check in date | partners_daily_check_in_date | dim | The date the traveler checks in to a hotel, resort, or other lodging type | |
| Check out date | partners_daily_check_out_date | dim | The date the traveler checks out of a hotel, resort, or other lodging type | |
| Is weekend | partners_daily_is_weekend | dim | Identifies if a reservation or event took place over the weekend | |
| Converting site name | partners_daily_converting_site_name | dim | The name of the site where the conversion took place | |
| Booking consumed date | partners_daily_booking_consumed_date | dim | The date indicating when a reservation was fulfilled | |
| Order ship date | partners_daily_order_ship_date | dim | The date indicating when the item was shipped | |
| Item coupon code(s) | partners_daily_item_coupon_codes | dim | The coupon code applied to an item | |
| Item discount amount | partners_daily_item_discount_amount | dim | The amount discounted by the advertiser for an item in an order | |
| Tax exempt | partners_daily_tax_exempt | dim | 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 | |
| Item profit margin | partners_daily_item_profit_margin | dim | A percentage representing the profit margin for an item | |
| Product category ID | partners_daily_product_category_id | dim | The category ID of the product or service | |
| Product category | partners_daily_product_category | dim | The category of the product or service | |
| Product category ID 2 | partners_daily_product_category_id_2 | dim | The second category level ID of the product or service | |
| Product category 2 | partners_daily_product_category_2 | dim | The second category of the product or service | |
| Product category ID 3 | partners_daily_product_category_id_3 | dim | The third category level ID of the product or service | |
| Product category 3 | partners_daily_product_category_3 | dim | The third category of the product or service | |
| Product category ID 4 | partners_daily_product_category_id_4 | dim | The fourth category level ID of the product or service | |
| Product category 4 | partners_daily_product_category_4 | dim | The fourth category of the product or service | |
| Product category ID 5 | partners_daily_product_category_id_5 | dim | The fifth category level ID of the product or service | |
| Product category 5 | partners_daily_product_category_5 | dim | The fifth category of the product or service | |
| Sale flag | partners_daily_sale_flag | dim | A flag that identifies if the item is on sale | |
| Clearance flag | partners_daily_clearance_flag | dim | A flag that identifies if the item is on clearance | |
| Marketplace flag | partners_daily_marketplace_flag | dim | A flag to identify marketplace items | |
| Item status | partners_daily_item_status | dim | The status of the item purchased by the consumer | |
| Discount type | partners_daily_discount_type | dim | The type of the discount | |
| Shipped by | partners_daily_shipped_by | dim | Identifies who shipped the item | |
| Shipment ID | partners_daily_shipment_id | dim | The unique ID that identifies a collection of items that are shipped or returned together | |
| Sequence number | partners_daily_sequence_number | dim | The unique ID that identifies the sequence in which items are grouped in a shipment or return | |
| Product brand | partners_daily_product_brand | dim | The brand associated with the product or service | |
| Region | partners_daily_region | dim | The where the travel takes place | |
| Quintiles score | partners_daily_quintiles_score | dim | Values 1 - 5 that represents a segmentation of an Advertiser's users into 1 of 5 groups as defined by the Advertiser | |
| Reservation start date | partners_daily_reservation_start_date | dim | The date when a travel reservation begins | |
| Reservation end date | partners_daily_reservation_end_date | dim | The date when a travel reservation ends | |
| Departure location | partners_daily_departure_location | dim | The location where a traveler beings their trip | |
| Departure country | partners_daily_departure_country | dim | The country where a traveler beings their trip | |
| Destination location | partners_daily_destination_location | dim | The location where a traveler ends their trip | |
| Destination country | partners_daily_destination_country | dim | The country where a traveler ends their trip | |
| Paid with loyalty points | partners_daily_paid_with_loyalty_points | dim | The customer paid for the travel reservation using loyalty points. This is a Y/N flag | |
| Fare type | partners_daily_fare_type | dim | The fare type associated with an airline ticket such as first class, business class, or economy | |
| Vehicle type | partners_daily_vehicle_type | dim | The vehicle type associated with a car rental | |
| Property type | partners_daily_property_type | dim | The classification of the property such as resort, hotel, motel, or house | |
| Accommodation type | partners_daily_accommodation_type | dim | 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 | |
| Travel type | partners_daily_travel_type | dim | The specific type of travel reservation such as airline, cruise, hotel, rental car, or activity | |
| Travel reason | partners_daily_travel_reason | dim | The reason the traveler booked the trip such as personal or business | |
| Reservation cancellation deadline date | partners_daily_reservation_cancellation_deadline_date | dim | The deadline date for a traveler to cancel their travel reservation. Any money paid towards to trip is non-refundable at this point | |
| Creative | Link ID | partners_daily_link_id | dim | The unique ID of the link |
| Link name | partners_daily_link_name | dim | The name of the link | |
| Link size | partners_daily_link_size | dim | The size of the banner, DRM, Flex Link, or other creative type. This does not apply to text links | |
| Link type | partners_daily_link_type | dim | The creative type such as banner, Flex Link, and so on | |
| Mobile and Technology | Browser | partners_daily_browser | dim | The browser consumer used when clicking your link |
| Browser major version | partners_daily_browser_major_version | dim | The major version of the browser consumer used when clicking your link | |
| Browser name | partners_daily_browser_name | dim | The name of the browser consumer used when clicking your link | |
| Browser version | partners_daily_browser_version | dim | The version of the browser consumer used when clicking your link | |
| Consumer connection speed | partners_daily_consumer_connection_speed | dim | The consumer's Internet connection speed at the time they clicked your link | |
| Device | partners_daily_device | dim | The device consumer used when clicking your link | |
| Mobile operating system | partners_daily_mobile_operating_system | dim | The operating system of the device consumer used when they clicking your link | |
| Geography | Consumer city | partners_daily_consumer_city | dim | The city that the consumer was in when they clicked your link |
| Consumer country | partners_daily_consumer_country | dim | The country that the consumer was in when they clicked your link | |
| Consumer region | partners_daily_consumer_region | dim | The region that the consumer was in when they clicked your link | |
| Impressions | partners_daily_impressions | met | The number of impressions | |
| Clicks | partners_daily_clicks | met | The number of clicks | |
| CTR | partners_daily_ctr | met | Click through rate (CTR). Clicks / Impressions | |
| CPA | partners_daily_cpa | met | Cost per action (CPA). Total commission / Items | |
| EPC | partners_daily_epc | met | Earnings per click (EPC). Total commission / Clicks | |
| Adjusted commission | partners_daily_adjusted_commission | met | The commission that is added to the baseline commission when a Publisher reaches a certain level of sales. For tiered commission structures | |
| Baseline commission | partners_daily_baseline_commission | met | The commission amount that is calculated before adjustments are made at the end of the month for tiered offers | |
| Gross commissions | partners_daily_gross_commissions | met | Total of all commissions (CPC commissions excluded) without taking cancellations into account | |
| Gross total commissions | partners_daily_gross_total_commissions | met | Total of all commissions (including CPC commissions) | |
| Total commissions | partners_daily_total_commission | met | The sum of baseline commissions and adjusted commissions | |
| Items | partners_daily_items | met | The number items sold, including cancelled items | |
| Cancelled items | partners_daily_cancelled_items | met | The number of items cancelled or returned | |
| Cancellation rate | partners_daily_cancellation_rate | met | Cancellation rate. Cancelled items / Items | |
| Net items | partners_daily_net_items | met | The number of items sold after cancelled items | |
| Average item value | partners_daily_average_item_value | met | The sum of your s ales divided by the total number of items sold. | |
| Net items per order | partners_daily_net_items_per_order | met | The number of items you sold divided by the number of order that were placed. Items / Orders | |
| Quantity | partners_daily_quantity | met | The number items sold, excluding cancelled items | |
| Orders | partners_daily_orders | met | The number of orders | |
| Orders/click | partners_daily_orders_per_clicks | met | The number of orders divided by the number of clicks. Orders / Clicks | |
| Average order value | partners_daily_average_order_value | met | Total sales divided by total number of orders. Sales / Orders | |
| Publishers per group | partners_daily_publishers_per_group | met | The total number of publishers in the group | |
| Gross sales | partners_daily_gross_sales | met | 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 | |
| Sales | partners_daily_sales | met | The total sales | |
| Commissionable order amount | partners_daily_commissionable_order_amount | met | The commissionable sales total of the order, not including tax or shipping | |
| Item amount | partners_daily_item_amount | met | The sales amount of a single item | |
| Number of rooms | partners_daily_number_of_rooms | met | The number of rooms in a travel reservation | |
| Estimated placement fees | partners_daily_estimated_placement_fees | met | 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. | |
| Estimated tracking fee | partners_daily_estimated_tracking_fee | met | 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. | |
| Estimated net total cost | partners_daily_estimated_net_total_cost | met | Approximate total net cost charged to the Advertiser. | |
| Estimated gross total cost | partners_daily_estimated_gross_total_cost | met | Approximate total gross cost charged to the Advertiser. |