TikTok Shop: Most-used fields#
The table below gives information about most-used fields that you can import from TikTok Shop. 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 |
|---|---|---|---|
actual_return_shipping_fee_amount |
actual_return_shipping_fee_amount |
The actual shipping fee amount for a returned item. |
metric |
actual_shipping_fee_amount |
actual_shipping_fee_amount |
The actual shipping fee amount for an item. |
metric |
adjustment_amount |
adjustment_amount |
The amount of any adjustments made. |
metric |
affiliate_ads_commission_amount |
affiliate_ads_commission_amount |
The commission amount earned from affiliate advertisements. |
metric |
affiliate_commission_amount |
affiliate_commission_amount |
The total commission amount earned by affiliates. |
metric |
affiliate_commission_before_pit |
affiliate_commission_before_pit |
The affiliate commission amount calculated before the deduction of personal income tax. |
metric |
affiliate_partner_commission_amount |
affiliate_partner_commission_amount |
The commission amount earned by affiliate partners. |
metric |
after_seller_discounts_subtotal_amount |
after_seller_discounts_subtotal_amount |
The subtotal amount after applying seller discounts. |
metric |
amount.currency |
amount.currency |
The currency of the transaction amount. |
dimension |
amount.value |
amount.value |
The numerical value of the transaction amount. |
dimension |
bank_account |
bank_account |
Bank account details associated with the transaction. |
dimension |
child_title |
child_title |
The title of the child product variation. |
dimension |
cost_of_goods_sold |
cost_of_goods_sold |
The direct costs attributable to the production of the goods sold. |
metric |
create_time |
create_time |
The timestamp when the record was created. |
dimension |
create_time_date |
create_time_date |
The date when the record was created. |
dimension |
currency |
currency |
The currency code relevant to the transaction or record. |
dimension |
customer_order_refund_amount |
customer_order_refund_amount |
The total refund amount issued to the customer for an order. |
metric |
customer_paid_shipping_fee_amount |
customer_paid_shipping_fee_amount |
The amount of shipping fee paid by the customer. |
metric |
customer_paid_shipping_fee_refund_amount |
customer_paid_shipping_fee_refund_amount |
The refund amount for the shipping fee paid by the customer. |
metric |
customer_payment_amount |
customer_payment_amount |
The total amount paid by the customer. |
metric |
customer_refund_amount |
customer_refund_amount |
The total refund amount provided to the customer. |
metric |
customer_shipping_fee_amount |
customer_shipping_fee_amount |
The total shipping fee amount applicable to the customer. |
metric |
customer_shipping_fee_offset_amount |
customer_shipping_fee_offset_amount |
The offset amount applied to the customer’s shipping fee. |
metric |
exchange_rate |
exchange_rate |
The exchange rate used for currency conversion. |
dimension |
fbm_shipping_cost_amount |
fbm_shipping_cost_amount |
The shipping cost amount for items fulfilled by the merchant (FBM). |
metric |
fbt_fulfillment_fee_amount |
fbt_fulfillment_fee_amount |
The fulfillment fee amount for items fulfilled by TikTok (FBT). |
metric |
fbt_shipping_cost_amount |
fbt_shipping_cost_amount |
The shipping cost amount for items fulfilled by TikTok (FBT). |
metric |
fee_amount |
fee_amount |
The amount of fees charged for a transaction. |
metric |
gross_sales |
gross_sales |
The total sales revenue before any deductions. |
metric |
gross_sales_amount |
gross_sales_amount |
The total gross sales amount before any deductions. |
metric |
gross_sales_refund_amount |
gross_sales_refund_amount |
The total refund amount deducted from gross sales. |
metric |
id |
id |
A unique identifier for the record. |
dimension |
line_items.cancel_reason |
line_items.cancel_reason |
The reason provided for the cancellation of a specific line item within an order. |
dimension |
line_items.cancel_user |
line_items.cancel_user |
The user who initiated the cancellation of a specific line item. |
dimension |
line_items.currency |
line_items.currency |
The currency in which the line item prices are denominated. |
dimension |
line_items.display_status |
line_items.display_status |
dimension |
|
line_items.id |
line_items.id |
A unique identifier for the individual line item. |
metric |
line_items.is_gift |
line_items.is_gift |
Indicates whether the line item is marked as a gift. |
dimension |
line_items.original_price |
line_items.original_price |
The original price of the line item before any discounts or promotions. |
metric |
line_items.package_status |
line_items.package_status |
The current status of the package associated with this line item. |
dimension |
line_items.platform_discount |
line_items.platform_discount |
The discount amount applied to the line item by the platform. |
metric |
line_items.product_id |
line_items.product_id |
A unique identifier for the product associated with the line item. |
dimension |
line_items.product_name |
line_items.product_name |
The name of the product in the line item. |
dimension |
line_items.retail_delivery_fee |
line_items.retail_delivery_fee |
metric |
|
line_items.rts_time |
line_items.rts_time |
The Ready-To-Ship (RTS) time for the line item. |
dimension |
line_items.sale_price |
line_items.sale_price |
The final sale price of the line item after all discounts. |
metric |
line_items.seller_discount |
line_items.seller_discount |
The discount amount applied to the line item by the seller. |
metric |
line_items.seller_sku |
line_items.seller_sku |
The Stock Keeping Unit (SKU) identifier assigned by the seller for the product. |
dimension |
line_items.shipping_provider_id |
line_items.shipping_provider_id |
A unique identifier for the shipping provider handling this line item. |
dimension |
line_items.shipping_provider_name |
line_items.shipping_provider_name |
The name of the shipping provider handling this line item. |
dimension |
line_items.sku_id |
line_items.sku_id |
A unique identifier for the SKU of the product in the line item. |
dimension |
line_items.sku_image |
line_items.sku_image |
The URL or identifier for the image of the SKU. |
dimension |
line_items.sku_name |
line_items.sku_name |
The name of the SKU in the line item. |
dimension |
line_items.sku_type |
line_items.sku_type |
The type of the SKU (e.g., physical, digital). |
dimension |
line_items.tracking_number |
line_items.tracking_number |
The tracking number for the shipment associated with the line item. |
dimension |
master_title |
master_title |
The main title of the product or product group. |
dimension |
net_sales |
net_sales |
The total sales revenue after deducting returns, allowances, and discounts. |
metric |
net_sales_amount |
net_sales_amount |
The total net sales amount after all deductions. |
metric |
order_amount |
order_amount |
The total monetary amount of the order. |
metric |
order_create_time |
order_create_time |
The timestamp when the order was created. |
dimension |
order_create_time_date |
order_create_time_date |
The date when the order was created. |
dimension |
order_id |
order_id |
A unique identifier for the order. |
dimension |
orders.buyer_email |
orders.buyer_email |
The email address of the buyer who placed the order. |
dimension |
orders.buyer_message |
orders.buyer_message |
Any message or special instructions provided by the buyer for the order. |
dimension |
orders.cancel_order_sla_time |
orders.cancel_order_sla_time |
The Service Level Agreement (SLA) time for order cancellation. |
dimension |
orders.cancel_reason |
orders.cancel_reason |
The reason provided for the cancellation of the order. |
dimension |
orders.cancel_time |
orders.cancel_time |
The timestamp when the order was cancelled. |
dimension |
orders.cancellation_initiator |
orders.cancellation_initiator |
The entity (e.g., buyer, seller, platform) that initiated the order cancellation. |
dimension |
orders.collection_due_time |
orders.collection_due_time |
The due time for the collection of the order. |
dimension |
orders.collection_time |
orders.collection_time |
The actual time when the order was collected. |
dimension |
orders.commerce_platform |
orders.commerce_platform |
dimension |
|
orders.create_time |
orders.create_time |
The timestamp when the order was created. |
dimension |
orders.create_time_date |
orders.create_time_date |
The date when the order was created. |
dimension |
orders.delivery_option_id |
orders.delivery_option_id |
A unique identifier for the selected delivery option. |
dimension |
orders.delivery_option_name |
orders.delivery_option_name |
The name of the selected delivery option. |
dimension |
orders.delivery_sla_time |
orders.delivery_sla_time |
The Service Level Agreement (SLA) time for order delivery. |
dimension |
orders.delivery_time |
orders.delivery_time |
The actual time when the order was delivered. |
dimension |
orders.delivery_type |
orders.delivery_type |
The type of delivery selected for the order. |
dimension |
orders.fulfillment_type |
orders.fulfillment_type |
The method of fulfillment for the order (e.g., shipped by seller, fulfilled by TikTok). |
dimension |
orders.id |
orders.id |
A unique identifier for the order. |
metric |
orders.is_cod |
orders.is_cod |
Indicates if the order is Cash On Delivery (COD). |
dimension |
orders.is_on_hold_order |
orders.is_on_hold_order |
Indicates if the order is currently on hold. |
dimension |
orders.is_replacement_order |
orders.is_replacement_order |
dimension |
|
orders.order_type |
orders.order_type |
The type of order (e.g., standard, return). |
dimension |
orders.packages |
orders.packages |
Details about the packages associated with the order. |
dimension |
orders.paid_time |
orders.paid_time |
The timestamp when the order was paid. |
dimension |
orders.payment_card_type |
orders.payment_card_type |
The type of payment card used for the order. |
dimension |
orders.payment_method_code |
orders.payment_method_code |
The code for the payment method used for the order. |
dimension |
orders.payment_method_name |
orders.payment_method_name |
The name of the payment method used for the order. |
dimension |
orders.pick_up_cut_off_time |
orders.pick_up_cut_off_time |
The cut-off time for picking up the order. |
dimension |
orders.replaced_order_id |
orders.replaced_order_id |
dimension |
|
orders.rts_sla_time |
orders.rts_sla_time |
The Service Level Agreement (SLA) time for the order to be Ready-To-Ship. |
dimension |
orders.rts_time |
orders.rts_time |
The actual time when the order was marked as Ready-To-Ship (RTS). |
dimension |
orders.shipping_provider |
orders.shipping_provider |
The name of the shipping provider for the order. |
dimension |
orders.shipping_provider_id |
orders.shipping_provider_id |
A unique identifier for the shipping provider handling the order. |
dimension |
orders.shipping_type |
orders.shipping_type |
The type of shipping selected for the order. |
dimension |
orders.status |
orders.status |
The current status of the order (e.g., PENDING, SHIPPED, DELIVERED). |
dimension |
orders.tracking_number |
orders.tracking_number |
The tracking number for the order’s shipment. |
dimension |
orders.tts_sla_time |
orders.tts_sla_time |
The Service Level Agreement (SLA) time for the order to be delivered. |
dimension |
orders.update_time |
orders.update_time |
The timestamp when the order was last updated. |
dimension |
orders.update_time_date |
orders.update_time_date |
The date when the order was last updated. |
dimension |
orders.user_id |
orders.user_id |
A unique identifier for the user who placed the order. |
dimension |
orders.warehouse_id |
orders.warehouse_id |
A unique identifier for the warehouse from which the order is shipped. |
dimension |
package.create_time |
package.create_time |
The timestamp when the package was created. |
dimension |
package.delivery_option_id |
package.delivery_option_id |
A unique identifier for the delivery option selected for the package. |
dimension |
package.delivery_option_name |
package.delivery_option_name |
The name of the delivery option selected for the package. |
dimension |
package.has_multi_skus |
package.has_multi_skus |
dimension |
|
package.last_mile_tracking_number |
package.last_mile_tracking_number |
dimension |
|
package.order_line_item_ids |
package.order_line_item_ids |
A list of order line item identifiers included in this package. |
dimension |
package.orders |
package.orders |
Details about the orders associated with this package. |
dimension |
package.package_id |
package.package_id |
A unique identifier for the package. |
dimension |
package.package_status |
package.package_status |
The current status of the package. |
dimension |
package.recipient_address.address_detail |
package.recipient_address.address_detail |
Additional details for the recipient’s address for the package. |
dimension |
package.recipient_address.address_line1 |
package.recipient_address.address_line1 |
The first line of the recipient’s address for the package. |
dimension |
package.recipient_address.address_line2 |
package.recipient_address.address_line2 |
The second line of the recipient’s address for the package. |
dimension |
package.recipient_address.address_line3 |
package.recipient_address.address_line3 |
The third line of the recipient’s address for the package. |
dimension |
package.recipient_address.address_line4 |
package.recipient_address.address_line4 |
The fourth line of the recipient’s address for the package. |
dimension |
package.recipient_address.full_address |
package.recipient_address.full_address |
The complete formatted address of the package recipient. |
dimension |
package.recipient_address.name |
package.recipient_address.name |
The name of the recipient for the package. |
dimension |
package.recipient_address.phone_number |
package.recipient_address.phone_number |
The phone number of the recipient for the package. |
dimension |
package.recipient_address.postal_code |
package.recipient_address.postal_code |
The postal code of the recipient’s address for the package. |
dimension |
package.recipient_address.region_code |
package.recipient_address.region_code |
The region code (e.g., country code) of the recipient’s address for the package. |
dimension |
package.sender_address.address_detail |
package.sender_address.address_detail |
Additional details for the sender’s address for the package. |
dimension |
package.sender_address.address_line1 |
package.sender_address.address_line1 |
The first line of the sender’s address for the package. |
dimension |
package.sender_address.address_line2 |
package.sender_address.address_line2 |
The second line of the sender’s address for the package. |
dimension |
package.sender_address.address_line3 |
package.sender_address.address_line3 |
The third line of the sender’s address for the package. |
dimension |
package.sender_address.address_line4 |
package.sender_address.address_line4 |
The fourth line of the sender’s address for the package. |
dimension |
package.sender_address.full_address |
package.sender_address.full_address |
The complete formatted address of the package sender. |
dimension |
package.sender_address.name |
package.sender_address.name |
The name of the sender for the package. |
dimension |
package.sender_address.phone_number |
package.sender_address.phone_number |
The phone number of the sender for the package. |
dimension |
package.sender_address.postal_code |
package.sender_address.postal_code |
The postal code of the sender’s address for the package. |
dimension |
package.sender_address.region_code |
package.sender_address.region_code |
The region code (e.g., country code) of the sender’s address for the package. |
dimension |
package.shipping_provider_id |
package.shipping_provider_id |
A unique identifier for the shipping provider handling this package. |
dimension |
package.shipping_provider_name |
package.shipping_provider_name |
The name of the shipping provider handling this package. |
dimension |
package.shipping_type |
package.shipping_type |
The type of shipping used for the package. |
dimension |
package.tracking_number |
package.tracking_number |
The tracking number for the package’s shipment. |
dimension |
package.update_time |
package.update_time |
The timestamp when the package details were last updated. |
dimension |
paid_time |
paid_time |
The timestamp when the payment was made. |
dimension |
paid_time_date |
paid_time_date |
The date when the payment was made. |
dimension |
payment.buyer_service_fee |
payment.buyer_service_fee |
The service fee charged to the buyer as part of the payment. |
dimension |
payment.currency |
payment.currency |
The currency used for the payment. |
dimension |
payment.handling_fee |
payment.handling_fee |
The fee incurred for handling the payment. |
dimension |
payment.item_insurance_fee |
payment.item_insurance_fee |
The fee for insuring individual items within an order. |
dimension |
payment.original_shipping_fee |
payment.original_shipping_fee |
The original shipping fee charged for the order. |
metric |
payment.original_total_product_price |
payment.original_total_product_price |
The original total price of all products in the order before any discounts. |
metric |
payment.platform_discount |
payment.platform_discount |
The discount amount applied to the payment by the platform. |
metric |
payment.product_tax |
payment.product_tax |
The tax amount applied to the products in the payment. |
metric |
payment.retail_delivery_fee |
payment.retail_delivery_fee |
The retail delivery fee included in the payment. |
metric |
payment.seller_discount |
payment.seller_discount |
The discount amount applied to the payment by the seller. |
metric |
payment.shipping_fee |
payment.shipping_fee |
The shipping fee charged for the order. |
metric |
payment.shipping_fee_cofunded_discount |
payment.shipping_fee_cofunded_discount |
The shipping fee discount amount co-funded by multiple parties. |
metric |
payment.shipping_fee_platform_discount |
payment.shipping_fee_platform_discount |
The platform’s discount applied to the shipping fee. |
metric |
payment.shipping_fee_seller_discount |
payment.shipping_fee_seller_discount |
The seller’s discount applied to the shipping fee. |
metric |
payment.shipping_fee_tax |
payment.shipping_fee_tax |
The tax amount applied to the shipping fee. |
metric |
payment.shipping_insurance_fee |
payment.shipping_insurance_fee |
The fee for insuring the shipping of an order. |
dimension |
payment.small_order_fee |
payment.small_order_fee |
A fee applied to orders that do not meet a certain minimum value. |
dimension |
payment.sub_total |
payment.sub_total |
The subtotal amount of the payment before taxes and shipping fees. |
metric |
payment.tax |
payment.tax |
The total tax amount applied to the payment. |
metric |
payment.total_amount |
payment.total_amount |
The total amount of the payment. |
metric |
payment_amount_before_exchange.currency |
payment_amount_before_exchange.currency |
The currency of the payment amount before any exchange rate is applied. |
dimension |
payment_amount_before_exchange.value |
payment_amount_before_exchange.value |
The numeric value of the payment amount before any currency exchange. |
dimension |
payment_id |
payment_id |
A unique identifier for the payment. |
dimension |
payment_method_name |
payment_method_name |
The name of the payment method used for the transaction, such as ‘Credit Card’ or ‘PayPal’. |
dimension |
payment_status |
payment_status |
The current status of the payment. |
dimension |
pit_amount |
pit_amount |
The amount of Personal Income Tax (PIT) applicable to the transaction. |
metric |
platform_commission_amount |
platform_commission_amount |
The commission amount charged by the TikTok Shop platform for the transaction. |
metric |
platform_discount_amount |
platform_discount_amount |
The total discount amount provided by the platform. |
metric |
platform_discount_refund_amount |
platform_discount_refund_amount |
The amount of discount refunded by the platform. |
metric |
platform_refund_subsidy_amount |
platform_refund_subsidy_amount |
The subsidy amount provided by the platform for a refund. |
metric |
platform_shipping_fee_discount_amount |
platform_shipping_fee_discount_amount |
The discount amount applied by the platform to the shipping fee. |
metric |
product_name |
product_name |
The name of the product. |
dimension |
profit_margin |
profit_margin |
The percentage of revenue that exceeds costs. |
metric |
promo_shipping_incentive_amount |
promo_shipping_incentive_amount |
The incentive amount related to promotional shipping offers. |
metric |
quantity |
quantity |
The number of items in the order or line item. |
metric |
recipient_address.address_detail |
recipient_address.address_detail |
Additional details for the recipient’s address. |
dimension |
recipient_address.address_line1 |
recipient_address.address_line1 |
The first line of the recipient’s address. |
dimension |
recipient_address.address_line2 |
recipient_address.address_line2 |
The second line of the recipient’s address. |
dimension |
recipient_address.address_line3 |
recipient_address.address_line3 |
The third line of the recipient’s address. |
dimension |
recipient_address.address_line4 |
recipient_address.address_line4 |
The fourth line of the recipient’s address. |
dimension |
recipient_address.district_info |
recipient_address.district_info |
Information about the district of the recipient’s address. |
dimension |
recipient_address.first_name |
recipient_address.first_name |
The first name of the recipient. |
dimension |
recipient_address.first_name_local_script |
recipient_address.first_name_local_script |
The first name of the recipient in local script. |
dimension |
recipient_address.full_address |
recipient_address.full_address |
The complete formatted address of the recipient. |
dimension |
recipient_address.last_name |
recipient_address.last_name |
The last name of the recipient. |
dimension |
recipient_address.last_name_local_script |
recipient_address.last_name_local_script |
The last name of the recipient in local script. |
dimension |
recipient_address.name |
recipient_address.name |
The full name of the recipient. |
dimension |
recipient_address.phone_number |
recipient_address.phone_number |
The phone number of the recipient. |
dimension |
recipient_address.post_town |
recipient_address.post_town |
The post town of the recipient’s address. |
dimension |
recipient_address.postal_code |
recipient_address.postal_code |
The postal code of the recipient’s address. |
dimension |
recipient_address.region_code |
recipient_address.region_code |
The region code (e.g., country code) of the recipient’s address. |
dimension |
referral_fee_amount |
referral_fee_amount |
The fee paid for a referral that led to a sale. |
metric |
refund_administration_fee_amount |
refund_administration_fee_amount |
The administrative fee incurred for processing a refund. |
metric |
refund_amount |
refund_amount |
The total monetary amount refunded for an order or item. |
metric |
refund_amount.currency |
refund_amount.currency |
The currency of the refund amount. |
dimension |
refund_amount.refund_shipping_fee |
refund_amount.refund_shipping_fee |
The portion of the refund corresponding to the shipping fee. |
metric |
refund_amount.refund_subtotal |
refund_amount.refund_subtotal |
The subtotal amount of the refund, excluding tax and shipping. |
metric |
refund_amount.refund_tax |
refund_amount.refund_tax |
The tax amount included in the refund. |
metric |
refund_amount.refund_total |
refund_amount.refund_total |
The total amount of the refund, including subtotal, tax, and shipping. |
metric |
refund_shipping_cost_discount_amount |
refund_shipping_cost_discount_amount |
The discounted amount of shipping cost applied to a refund. |
metric |
reserve_amount.currency |
reserve_amount.currency |
The currency of the reserved amount. |
dimension |
reserve_amount.value |
reserve_amount.value |
The numeric value of the amount held in reserve. |
dimension |
retail_delivery_fee_amount |
retail_delivery_fee_amount |
The fee charged for retail delivery. |
metric |
retail_delivery_fee_payment_amount |
retail_delivery_fee_payment_amount |
The amount paid for the retail delivery fee. |
metric |
retail_delivery_fee_refund_amount |
retail_delivery_fee_refund_amount |
The refunded amount of the retail delivery fee. |
metric |
return_line_items.order_line_item_id |
return_line_items.order_line_item_id |
The identifier for the original order line item associated with the returned item. |
dimension |
return_line_items.product_image.height |
return_line_items.product_image.height |
The height of the product image for the returned item. |
metric |
return_line_items.product_image.url |
return_line_items.product_image.url |
The URL of the product image for the returned item. |
dimension |
return_line_items.product_image.width |
return_line_items.product_image.width |
The width of the product image for the returned item. |
metric |
return_line_items.product_name |
return_line_items.product_name |
The name of the product that was returned. |
dimension |
return_line_items.refund_amount.currency |
return_line_items.refund_amount.currency |
The currency of the refund amount for this specific returned line item. |
dimension |
return_line_items.refund_amount.refund_shipping_fee |
return_line_items.refund_amount.refund_shipping_fee |
The shipping fee portion of the refund for this returned line item. |
metric |
return_line_items.refund_amount.refund_subtotal |
return_line_items.refund_amount.refund_subtotal |
The subtotal amount of the refund for this returned line item, excluding tax and shipping. |
metric |
return_line_items.refund_amount.refund_tax |
return_line_items.refund_amount.refund_tax |
The tax amount included in the refund for this returned line item. |
metric |
return_line_items.refund_amount.refund_total |
return_line_items.refund_amount.refund_total |
The total refund amount for this returned line item, including subtotal, tax, and shipping. |
metric |
return_line_items.return_line_item_id |
return_line_items.return_line_item_id |
A unique identifier for the specific line item within a return. |
dimension |
return_line_items.seller_sku |
return_line_items.seller_sku |
The Seller SKU (Stock Keeping Unit) for the returned item. |
dimension |
return_line_items.sku_id |
return_line_items.sku_id |
The unique identifier for the SKU (Stock Keeping Unit) of the returned product. |
dimension |
return_line_items.sku_name |
return_line_items.sku_name |
The name of the SKU (Stock Keeping Unit) for the returned product. |
dimension |
return_orders.arbitration_status |
return_orders.arbitration_status |
The current status of arbitration for the return order. |
dimension |
return_orders.can_buyer_keep_item |
return_orders.can_buyer_keep_item |
Indicates whether the buyer is allowed to keep the item even after a refund. |
dimension |
return_orders.combined_return_id |
return_orders.combined_return_id |
The identifier for a combined return order, if multiple returns are grouped. |
dimension |
return_orders.create_time |
return_orders.create_time |
The timestamp when the return order was created. |
dimension |
return_orders.create_time_date |
return_orders.create_time_date |
The date when the return order was created. |
dimension |
return_orders.discount_amount |
return_orders.discount_amount |
The total discount amount applied to the return order. |
dimension |
return_orders.handover_method |
return_orders.handover_method |
The method used for handing over the returned item, e.g., ‘Pickup’, ‘Drop-off’. |
dimension |
return_orders.is_combined_return |
return_orders.is_combined_return |
A boolean indicating if this return order is part of a combined return. |
dimension |
return_orders.next_return_id |
return_orders.next_return_id |
The ID of the subsequent return order in a sequence, if applicable. |
dimension |
return_orders.order_id |
return_orders.order_id |
The identifier of the original order associated with this return. |
dimension |
return_orders.pre_return_id |
return_orders.pre_return_id |
The ID of the previous return order in a sequence, if applicable. |
dimension |
return_orders.return_id |
return_orders.return_id |
A unique identifier for the return order. |
dimension |
return_orders.return_method |
return_orders.return_method |
The method specified for the return, such as ‘Refund Only’ or ‘Return and Refund’. |
dimension |
return_orders.return_provider_id |
return_orders.return_provider_id |
The identifier of the service provider handling the return process. |
dimension |
return_orders.return_provider_name |
return_orders.return_provider_name |
The name of the service provider handling the return process. |
dimension |
return_orders.return_reason |
return_orders.return_reason |
The coded reason for the return, e.g., ‘DEFECTIVE_ITEM’, ‘WRONG_SIZE’. |
dimension |
return_orders.return_reason_text |
return_orders.return_reason_text |
A descriptive text explaining the reason for the return. |
dimension |
return_orders.return_status |
return_orders.return_status |
The current status of the return order, such as ‘Pending Approval’, ‘Item Received’, ‘Refunded’. |
dimension |
return_orders.return_tracking_number |
return_orders.return_tracking_number |
The tracking number for the shipment of the returned item. |
dimension |
return_orders.return_type |
return_orders.return_type |
The type of return, e.g., ‘Full Refund’, ‘Partial Refund’, ‘Exchange’. |
dimension |
return_orders.role |
return_orders.role |
The role associated with the return order, such as ‘Seller’ or ‘Buyer’. |
dimension |
return_orders.seller_next_action_response |
return_orders.seller_next_action_response |
The seller’s response regarding the next action to be taken for the return. |
dimension |
return_orders.shipment_type |
return_orders.shipment_type |
The type of shipment for the return, e.g., ‘Standard’, ‘Express’. |
dimension |
return_orders.shipping_fee_amount |
return_orders.shipping_fee_amount |
The shipping fee amount associated with the return order. |
dimension |
return_orders.update_time |
return_orders.update_time |
The timestamp when the return order record was last updated. |
dimension |
return_orders.update_time_date |
return_orders.update_time_date |
The date when the return order record was last updated. |
dimension |
return_shipping_fee_amount |
return_shipping_fee_amount |
The fee associated with shipping an item back for a return. |
metric |
return_warehouse_address.full_address |
return_warehouse_address.full_address |
The complete address of the warehouse where returned items are sent. |
dimension |
revenue_amount |
revenue_amount |
The total revenue generated. |
metric |
sales_tax_amount |
sales_tax_amount |
The amount of sales tax applied to the transaction. |
metric |
sales_tax_payment_amount |
sales_tax_payment_amount |
The amount of sales tax paid for the transaction. |
metric |
sales_tax_refund_amount |
sales_tax_refund_amount |
The refunded amount of sales tax. |
metric |
seller_discount_amount |
seller_discount_amount |
The total discount amount provided by the seller. |
metric |
seller_discount_refund_amount |
seller_discount_refund_amount |
The refund amount specifically for seller-provided discounts. |
metric |
settlement_amount |
settlement_amount |
The amount of money settled to the seller. |
metric |
settlement_amount.currency |
settlement_amount.currency |
The currency of the settlement amount. |
dimension |
settlement_amount.value |
settlement_amount.value |
The numerical value of the settlement amount. |
dimension |
shipping_cost_amount |
shipping_cost_amount |
The total cost associated with shipping the order. |
metric |
shipping_cost_discount_amount |
shipping_cost_discount_amount |
The discount amount applied to the shipping cost. |
metric |
shipping_fee_amount |
shipping_fee_amount |
The fee charged for shipping the items. |
metric |
shipping_fee_subsidy_amount |
shipping_fee_subsidy_amount |
The subsidy amount provided for the shipping fee. |
metric |
shipping_insurance_fee_amount |
shipping_insurance_fee_amount |
The amount paid for shipping insurance. |
metric |
signature_confirmation_fee_amount |
signature_confirmation_fee_amount |
The fee for requiring a signature upon delivery confirmation. |
metric |
sku |
sku |
The Stock Keeping Unit (SKU) identifier for a product. |
dimension |
sku_id |
sku_id |
A unique identifier for the Stock Keeping Unit (SKU). |
dimension |
sku_name |
sku_name |
The name of the Stock Keeping Unit (SKU). |
dimension |
sku_sales_amount |
sku_sales_amount |
The total sales amount for a specific SKU. |
metric |
sku_transactions.product_name |
sku_transactions.product_name |
The name of the product involved in the SKU transaction. |
dimension |
sku_transactions.sku_id |
sku_transactions.sku_id |
A unique identifier for the SKU involved in the SKU transaction. |
dimension |
sku_transactions.sku_name |
sku_transactions.sku_name |
The name of the SKU involved in the SKU transaction. |
dimension |
sku_transactions.statement_id |
sku_transactions.statement_id |
A unique identifier for the financial statement associated with the SKU transaction. |
dimension |
statement_id |
statement_id |
A unique identifier for the financial statement. |
dimension |
statement_time |
statement_time |
The timestamp when the financial statement was generated. |
dimension |
statement_time_date |
statement_time_date |
The date when the financial statement was generated. |
dimension |
status |
status |
The current status of the record or entity. |
dimension |
transaction_fee_amount |
transaction_fee_amount |
The fee charged for processing the transaction. |
metric |
transaction_id |
transaction_id |
A unique identifier for the transaction. |
dimension |
update_time |
update_time |
The timestamp when the record was last updated. |
dimension |
update_time_date |
update_time_date |
The date when the record was last updated. |
dimension |