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 |
|---|---|---|---|
currency |
currency |
The currency code used for all monetary values related to the order or transaction. |
dimension |
fee_and_tax_amount |
fee_and_tax_amount |
The total amount of fees and taxes applied to an order or SKU transaction. |
metric |
line_items.cancel_reason |
line_items.cancel_reason |
The reason provided for the cancellation of a specific line item. |
dimension |
line_items.cancel_user |
line_items.cancel_user |
The user or entity who initiated the cancellation of a specific line item. |
dimension |
line_items.currency |
line_items.currency |
The currency code for the amounts related to the line item. |
dimension |
line_items.display_status |
line_items.display_status |
The current display status of the line item (e.g., shipped, delivered, cancelled). |
dimension |
line_items.id |
line_items.id |
The unique identifier for the line item. |
metric |
line_items.is_gift |
line_items.is_gift |
dimension |
|
line_items.item_tax |
line_items.item_tax |
The tax amount specifically applied to this line item. |
dimension |
line_items.original_price |
line_items.original_price |
The original price of the product in the line item before any discounts. |
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 by the platform to this line item. |
metric |
line_items.product_id |
line_items.product_id |
The unique identifier for the product associated with this line item. |
dimension |
line_items.product_name |
line_items.product_name |
The name of the product associated with this line item. |
dimension |
line_items.retail_delivery_fee |
line_items.retail_delivery_fee |
The retail delivery fee charged for this line item. |
metric |
line_items.rts_time |
line_items.rts_time |
The Ready-To-Ship (RTS) time for the line item, indicating when it is prepared for shipment. |
dimension |
line_items.sale_price |
line_items.sale_price |
The selling price of the product in the line item after discounts, inclusive of taxes. |
metric |
line_items.seller_discount |
line_items.seller_discount |
The discount amount applied by the seller to this line item. |
metric |
line_items.seller_sku |
line_items.seller_sku |
The Stock Keeping Unit (SKU) identifier assigned by the seller for the product in this line item. |
dimension |
line_items.shipping_provider_id |
line_items.shipping_provider_id |
The unique identifier of the shipping provider used for this line item. |
dimension |
line_items.shipping_provider_name |
line_items.shipping_provider_name |
The name of the shipping provider used for this line item. |
dimension |
line_items.sku_id |
line_items.sku_id |
The unique identifier for the Stock Keeping Unit (SKU) associated with this line item. |
dimension |
line_items.sku_image |
line_items.sku_image |
The URL or identifier for the image of the SKU associated with this line item. |
dimension |
line_items.sku_name |
line_items.sku_name |
The name of the Stock Keeping Unit (SKU) associated with this line item. |
dimension |
line_items.sku_type |
line_items.sku_type |
dimension |
|
line_items.tracking_number |
line_items.tracking_number |
The tracking number for the shipment containing this line item. |
metric |
order_create_time |
order_create_time |
The timestamp when the order was initially created. |
dimension |
order_create_time_date |
order_create_time_date |
The date when the order was initially created. |
dimension |
order_id |
order_id |
The unique identifier for the order. |
dimension |
orders.buyer_email |
orders.buyer_email |
The anonymized email address of the buyer for 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 by which an order must be canceled if not fulfilled, to avoid penalties. |
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 canceled. |
dimension |
orders.cancellation_initiator |
orders.cancellation_initiator |
The party who initiated the order cancellation (e.g., Buyer, Seller, TikTok SYSTEM, TikTok OPERATOR). |
dimension |
orders.collection_due_time |
orders.collection_due_time |
dimension |
|
orders.collection_time |
orders.collection_time |
The timestamp when all items in the order were collected by the carrier. |
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 |
The unique identifier for the selected delivery option for the order. |
dimension |
orders.delivery_option_name |
orders.delivery_option_name |
The name of the selected delivery option for the order. |
dimension |
orders.delivery_sla_time |
orders.delivery_sla_time |
dimension |
|
orders.delivery_time |
orders.delivery_time |
The timestamp when all items in the order were delivered to the buyer. |
dimension |
orders.delivery_type |
orders.delivery_type |
dimension |
|
orders.fulfillment_type |
orders.fulfillment_type |
The method by which the order is fulfilled (FULFILLMENT_BY_SELLER or FULFILLMENT_BY_TIKTOK). |
dimension |
orders.has_updated_recipient_address |
orders.has_updated_recipient_address |
Indicates whether the recipient’s address for the order has been updated since the order was placed. |
dimension |
orders.id |
orders.id |
The unique identifier for the order. |
metric |
orders.is_cod |
orders.is_cod |
Indicates whether the order’s payment method is Cash on Delivery (COD). |
dimension |
orders.is_on_hold_order |
orders.is_on_hold_order |
Indicates if the order is currently on hold, typically during a remorse period after payment where the buyer can cancel without seller approval. |
dimension |
orders.order_type |
orders.order_type |
dimension |
|
orders.packages |
orders.packages |
A collection of packages associated with the order. |
dimension |
orders.paid_time |
orders.paid_time |
The timestamp when the order was successfully paid. |
dimension |
orders.payment_card_type |
orders.payment_card_type |
dimension |
|
orders.payment_method_code |
orders.payment_method_code |
dimension |
|
orders.payment_method_name |
orders.payment_method_name |
dimension |
|
orders.rts_sla_time |
orders.rts_sla_time |
The Service Level Agreement (SLA) time by which the order should be Ready To Ship (RTS). |
dimension |
orders.rts_time |
orders.rts_time |
The actual timestamp when the order was marked as Ready To Ship (RTS). |
dimension |
orders.shipping_provider |
orders.shipping_provider |
The name of the shipping provider handling the order. |
dimension |
orders.shipping_provider_id |
orders.shipping_provider_id |
The unique identifier for the shipping provider handling the order. |
dimension |
orders.shipping_type |
orders.shipping_type |
The type of shipping service used for the order, e.g., ‘TikTok Shipping’ or ‘Seller Shipping’. |
dimension |
orders.split_or_combine_tag |
orders.split_or_combine_tag |
A tag indicating if an order has been split into multiple packages or combined with other orders for fulfillment. |
dimension |
orders.status |
orders.status |
The current status of the order (e.g., UNPAID, ON_HOLD, AWAITING_SHIPMENT). |
dimension |
orders.tracking_number |
orders.tracking_number |
The main tracking number associated with the order. |
metric |
orders.tts_sla_time |
orders.tts_sla_time |
The Service Level Agreement (SLA) time by which the order should be shipped. |
dimension |
orders.update_time |
orders.update_time |
The timestamp when the order record was last updated. |
dimension |
orders.update_time_date |
orders.update_time_date |
The date when the order record was last updated. |
dimension |
orders.user_id |
orders.user_id |
The unique identifier of the user who placed the order. |
dimension |
orders.warehouse_id |
orders.warehouse_id |
The identifier of the warehouse from which the order is fulfilled. |
dimension |
package.create_time |
package.create_time |
The timestamp when the package record was created. |
dimension |
package.delivery_option_id |
package.delivery_option_id |
The unique identifier for the delivery option chosen for the package. |
dimension |
package.delivery_option_name |
package.delivery_option_name |
The name of the delivery option chosen for the package. |
dimension |
package.dimension.height |
package.dimension.height |
The height of the packaged product. |
metric |
package.dimension.length |
package.dimension.length |
The length of the packaged product. |
metric |
package.dimension.unit |
package.dimension.unit |
The unit of measure for the package dimensions (e.g., CENTIMETER, CM). |
dimension |
package.dimension.width |
package.dimension.width |
The width of the packaged product. |
metric |
package.has_multi_skus |
package.has_multi_skus |
Indicates whether the package contains multiple Stock Keeping Units (SKUs). |
dimension |
package.last_mile_tracking_number |
package.last_mile_tracking_number |
metric |
|
package.order_line_item_ids |
package.order_line_item_ids |
A list of identifiers for the order line items included in this package. |
dimension |
package.orders |
package.orders |
The order or orders that this package belongs to. |
dimension |
package.package_id |
package.package_id |
The 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 shipping address for the package. |
dimension |
package.recipient_address.address_line2 |
package.recipient_address.address_line2 |
The second line of the recipient’s shipping address for the package. |
dimension |
package.recipient_address.address_line3 |
package.recipient_address.address_line3 |
The third line of the recipient’s shipping address for the package. |
dimension |
package.recipient_address.address_line4 |
package.recipient_address.address_line4 |
The fourth line of the recipient’s shipping address for the package. |
dimension |
package.recipient_address.full_address |
package.recipient_address.full_address |
The complete formatted shipping address for the package recipient. |
dimension |
package.recipient_address.name |
package.recipient_address.name |
The full 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 shipping 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 shipping 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 full 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 |
The unique identifier for the shipping provider handling the package. |
dimension |
package.shipping_provider_name |
package.shipping_provider_name |
The name of the shipping provider handling the package. |
dimension |
package.shipping_type |
package.shipping_type |
The type of shipping service used for the package. |
dimension |
package.tracking_number |
package.tracking_number |
The tracking number assigned to the package by the shipping provider. |
dimension |
package.update_time |
package.update_time |
The timestamp when the package record was last updated. |
dimension |
package.weight.unit |
package.weight.unit |
The unit of measure for the package weight (e.g., GRAM, KILOGRAM, POUND). |
dimension |
package.weight.value |
package.weight.value |
The weight of the packaged product. |
metric |
payment.currency |
payment.currency |
The currency code used for all monetary values within the payment details. |
dimension |
payment.original_shipping_fee |
payment.original_shipping_fee |
The shipping fee before any discounts or promotions were applied. |
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.payment_platform_discount |
payment.payment_platform_discount |
The discount amount applied by the platform during the payment process. |
metric |
payment.platform_discount |
payment.platform_discount |
The discount amount applied by the TikTok platform. |
metric |
payment.product_tax |
payment.product_tax |
The tax applied specifically to the products in the order. |
metric |
payment.retail_delivery_fee |
payment.retail_delivery_fee |
The retail delivery fee applied to the order. |
metric |
payment.seller_discount |
payment.seller_discount |
The discount amount applied by the seller to the order. |
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 co-funded discount amount applied to the shipping fee. |
metric |
payment.shipping_fee_platform_discount |
payment.shipping_fee_platform_discount |
The discount amount applied by the platform specifically to the shipping fee. |
metric |
payment.shipping_fee_seller_discount |
payment.shipping_fee_seller_discount |
The discount amount applied by the seller specifically to the shipping fee. |
metric |
payment.shipping_fee_tax |
payment.shipping_fee_tax |
The tax applied to the shipping fee. |
metric |
payment.sub_total |
payment.sub_total |
The sub-total amount of the order, typically the sum of product prices before shipping and taxes. |
metric |
payment.tax |
payment.tax |
The total tax amount applied to the order. |
metric |
payment.total_amount |
payment.total_amount |
The total amount paid for the order, including products, shipping, and taxes, after all discounts. |
metric |
recipient_address.address_detail |
recipient_address.address_detail |
Additional details or instructions for the recipient’s shipping address. |
dimension |
recipient_address.address_line1 |
recipient_address.address_line1 |
The first line of the recipient’s shipping address. |
dimension |
recipient_address.address_line2 |
recipient_address.address_line2 |
The second line of the recipient’s shipping address. |
dimension |
recipient_address.address_line3 |
recipient_address.address_line3 |
The third line of the recipient’s shipping address. |
dimension |
recipient_address.address_line4 |
recipient_address.address_line4 |
The fourth line of the recipient’s shipping address. |
dimension |
recipient_address.district_info |
recipient_address.district_info |
District-level information for the recipient’s shipping 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 as written in the local script or language. |
dimension |
recipient_address.full_address |
recipient_address.full_address |
The complete, formatted shipping 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 as written in the local script or language. |
dimension |
recipient_address.name |
recipient_address.name |
The full name of the recipient for the order. |
dimension |
recipient_address.phone_number |
recipient_address.phone_number |
The phone number of the recipient. |
dimension |
recipient_address.postal_code |
recipient_address.postal_code |
The postal code of the recipient’s shipping address. |
dimension |
recipient_address.region_code |
recipient_address.region_code |
The region code (e.g., country code) of the recipient’s shipping address. |
dimension |
revenue_amount |
revenue_amount |
The total revenue generated from the order or transaction. |
metric |
settlement_amount |
settlement_amount |
The amount settled or paid out for the order or transaction after deductions. |
metric |
shipping_cost_amount |
shipping_cost_amount |
The cost incurred for shipping the order. |
metric |
sku_transactions.fee_tax_amount |
sku_transactions.fee_tax_amount |
The total amount of fees and taxes for a specific SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.affiliate_ads_commission_amount |
sku_transactions.fee_tax_breakdown.fee.affiliate_ads_commission_amount |
The commission amount related to affiliate advertising for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.affiliate_commission_amount |
sku_transactions.fee_tax_breakdown.fee.affiliate_commission_amount |
The commission amount paid to affiliates for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.affiliate_commission_amount_before_pit |
sku_transactions.fee_tax_breakdown.fee.affiliate_commission_amount_before_pit |
The affiliate commission amount before Personal Income Tax for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.affiliate_partner_commission_amount |
sku_transactions.fee_tax_breakdown.fee.affiliate_partner_commission_amount |
The commission amount paid to an affiliate partner for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.bonus_cashback_service_fee_amount |
sku_transactions.fee_tax_breakdown.fee.bonus_cashback_service_fee_amount |
The service fee amount associated with bonus cashback programs for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.cofunded_creator_bonus_amount |
sku_transactions.fee_tax_breakdown.fee.cofunded_creator_bonus_amount |
The bonus amount co-funded for creators related to the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.cofunded_promotion_service_fee_amount |
sku_transactions.fee_tax_breakdown.fee.cofunded_promotion_service_fee_amount |
The service fee amount for co-funded promotions related to the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.credit_card_handling_fee_amount |
sku_transactions.fee_tax_breakdown.fee.credit_card_handling_fee_amount |
The fee amount for handling credit card payments for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.dynamic_commission_amount |
sku_transactions.fee_tax_breakdown.fee.dynamic_commission_amount |
The commission amount that may vary dynamically for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.epr_pob_service_fee_amount |
sku_transactions.fee_tax_breakdown.fee.epr_pob_service_fee_amount |
metric |
|
sku_transactions.fee_tax_breakdown.fee.external_affiliate_marketing_fee_amount |
sku_transactions.fee_tax_breakdown.fee.external_affiliate_marketing_fee_amount |
The fee amount for external affiliate marketing related to the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.fee_per_item_sold_amount |
sku_transactions.fee_tax_breakdown.fee.fee_per_item_sold_amount |
The fee amount charged per item sold within the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.flash_sales_service_fee_amount |
sku_transactions.fee_tax_breakdown.fee.flash_sales_service_fee_amount |
The service fee amount for flash sales promotions related to the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.live_specials_fee_amount |
sku_transactions.fee_tax_breakdown.fee.live_specials_fee_amount |
The fee amount for live special promotions related to the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.mall_service_fee_amount |
sku_transactions.fee_tax_breakdown.fee.mall_service_fee_amount |
The service fee amount for products sold on the TikTok Shop Mall related to the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.platform_commission_amount |
sku_transactions.fee_tax_breakdown.fee.platform_commission_amount |
The commission amount charged by the TikTok platform for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.pre_order_service_fee_amount |
sku_transactions.fee_tax_breakdown.fee.pre_order_service_fee_amount |
The service fee amount for pre-order items related to the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.referral_fee_amount |
sku_transactions.fee_tax_breakdown.fee.referral_fee_amount |
The fee amount charged for referring a sale (marketplace commission) for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.refund_administration_fee_amount |
sku_transactions.fee_tax_breakdown.fee.refund_administration_fee_amount |
The administrative fee amount for processing a refund related to the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.seller_paylater_handling_fee_amount |
sku_transactions.fee_tax_breakdown.fee.seller_paylater_handling_fee_amount |
The handling fee amount for seller-initiated ‘Buy Now, Pay Later’ options related to the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.sfp_service_fee_amount |
sku_transactions.fee_tax_breakdown.fee.sfp_service_fee_amount |
metric |
|
sku_transactions.fee_tax_breakdown.fee.transaction_fee_amount |
sku_transactions.fee_tax_breakdown.fee.transaction_fee_amount |
The fee amount associated with the overall transaction for the SKU. |
metric |
sku_transactions.fee_tax_breakdown.fee.tsp_commission_amount |
sku_transactions.fee_tax_breakdown.fee.tsp_commission_amount |
metric |
|
sku_transactions.fee_tax_breakdown.fee.voucher_xtra_service_fee_amount |
sku_transactions.fee_tax_breakdown.fee.voucher_xtra_service_fee_amount |
The service fee amount for extra vouchers used in the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.tax.anti_dumping_duty_amount |
sku_transactions.fee_tax_breakdown.tax.anti_dumping_duty_amount |
The tax amount related to anti-dumping duties for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.tax.customs_clearance_amount |
sku_transactions.fee_tax_breakdown.tax.customs_clearance_amount |
The amount charged for customs clearance for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.tax.customs_duty_amount |
sku_transactions.fee_tax_breakdown.tax.customs_duty_amount |
The amount charged for customs duty for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.tax.gst_amount |
sku_transactions.fee_tax_breakdown.tax.gst_amount |
The Goods and Services Tax (GST) amount for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.tax.import_vat_amount |
sku_transactions.fee_tax_breakdown.tax.import_vat_amount |
The Import Value Added Tax (VAT) amount for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.tax.isr_amount |
sku_transactions.fee_tax_breakdown.tax.isr_amount |
The Income Tax Withholding (ISR) amount for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.tax.iva_amount |
sku_transactions.fee_tax_breakdown.tax.iva_amount |
The Value Added Tax (IVA) amount for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.tax.pit_amount |
sku_transactions.fee_tax_breakdown.tax.pit_amount |
The Personal Income Tax (PIT) amount for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.tax.sst_amount |
sku_transactions.fee_tax_breakdown.tax.sst_amount |
The Sales and Service Tax (SST) amount for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.tax.vat_amount |
sku_transactions.fee_tax_breakdown.tax.vat_amount |
The Value Added Tax (VAT) amount for the SKU transaction. |
metric |
sku_transactions.product_name |
sku_transactions.product_name |
The name of the product associated with the SKU in the transaction. |
dimension |
sku_transactions.quantity |
sku_transactions.quantity |
The quantity of the specific SKU included in the transaction. |
metric |
sku_transactions.revenue_amount |
sku_transactions.revenue_amount |
The total revenue amount generated from the specific SKU transaction. |
metric |
sku_transactions.revenue_breakdown.cod_service_fee_amount |
sku_transactions.revenue_breakdown.cod_service_fee_amount |
The service fee amount for Cash on Delivery (COD) for the SKU transaction. |
metric |
sku_transactions.revenue_breakdown.refund_cod_service_fee_amount |
sku_transactions.revenue_breakdown.refund_cod_service_fee_amount |
The refund amount for the Cash on Delivery (COD) service fee for the SKU transaction. |
metric |
sku_transactions.revenue_breakdown.refund_subtotal_before_discount_amount |
sku_transactions.revenue_breakdown.refund_subtotal_before_discount_amount |
The refunded subtotal amount of the SKU before any discounts were applied. |
metric |
sku_transactions.revenue_breakdown.seller_discount_amount |
sku_transactions.revenue_breakdown.seller_discount_amount |
The discount amount applied by the seller to the SKU transaction. |
metric |
sku_transactions.revenue_breakdown.seller_discount_refund_amount |
sku_transactions.revenue_breakdown.seller_discount_refund_amount |
The refund amount for the seller’s discount applied to the SKU transaction. |
metric |
sku_transactions.revenue_breakdown.subtotal_before_discount_amount |
sku_transactions.revenue_breakdown.subtotal_before_discount_amount |
The subtotal amount of the SKU before any discounts were applied. |
metric |
sku_transactions.settlement_amount |
sku_transactions.settlement_amount |
The final amount settled for the specific SKU transaction after all deductions and additions. |
metric |
sku_transactions.shipping_cost_amount |
sku_transactions.shipping_cost_amount |
The total shipping cost for the specific SKU transaction. |
metric |
sku_transactions.shipping_cost_breakdown.actual_shipping_fee_amount |
sku_transactions.shipping_cost_breakdown.actual_shipping_fee_amount |
The actual shipping fee incurred for the SKU. |
metric |
sku_transactions.shipping_cost_breakdown.customer_paid_shipping_fee_amount |
sku_transactions.shipping_cost_breakdown.customer_paid_shipping_fee_amount |
The amount of shipping fee paid by the customer for the SKU, combining initial and refunded amounts. |
metric |
sku_transactions.shipping_cost_breakdown.exchange_shipping_fee_amount |
sku_transactions.shipping_cost_breakdown.exchange_shipping_fee_amount |
The shipping fee amount for an exchange order involving the SKU. |
metric |
sku_transactions.shipping_cost_breakdown.fbt_fulfillment_fee_reimbursement_amount |
sku_transactions.shipping_cost_breakdown.fbt_fulfillment_fee_reimbursement_amount |
The reimbursement amount for Fulfilled by TikTok (FBT) fulfillment fees for the SKU. |
metric |
sku_transactions.shipping_cost_breakdown.replacement_shipping_fee_amount |
sku_transactions.shipping_cost_breakdown.replacement_shipping_fee_amount |
The shipping fee amount for a replacement order involving the SKU. |
metric |
sku_transactions.shipping_cost_breakdown.return_shipping_fee_amount |
sku_transactions.shipping_cost_breakdown.return_shipping_fee_amount |
The shipping fee amount for returning the SKU. |
metric |
sku_transactions.shipping_cost_breakdown.return_shipping_label_fee_amount |
sku_transactions.shipping_cost_breakdown.return_shipping_label_fee_amount |
The fee amount for the return shipping label for the SKU. |
metric |
sku_transactions.shipping_cost_breakdown.seller_self_shipping_service_fee_amount |
sku_transactions.shipping_cost_breakdown.seller_self_shipping_service_fee_amount |
The service fee amount for seller self-shipping for the SKU. |
metric |
sku_transactions.shipping_cost_breakdown.shipping_fee_discount_amount |
sku_transactions.shipping_cost_breakdown.shipping_fee_discount_amount |
The discount amount applied to the shipping fee for the SKU. |
metric |
sku_transactions.shipping_cost_breakdown.shipping_insurance_fee_amount |
sku_transactions.shipping_cost_breakdown.shipping_insurance_fee_amount |
The fee amount for shipping insurance for the SKU. |
metric |
sku_transactions.shipping_cost_breakdown.signature_confirmation_fee_amount |
sku_transactions.shipping_cost_breakdown.signature_confirmation_fee_amount |
The fee amount for signature confirmation upon delivery of the SKU. |
metric |
sku_transactions.shipping_cost_breakdown.supplementary_component |
sku_transactions.shipping_cost_breakdown.supplementary_component |
A breakdown of supplementary components contributing to the shipping cost for the SKU. |
dimension |
sku_transactions.shipping_cost_breakdown.supplementary_component.customer_shipping_fee_offset_amount |
sku_transactions.shipping_cost_breakdown.supplementary_component.customer_shipping_fee_offset_amount |
The amount that offsets the customer’s shipping fee. |
metric |
sku_transactions.shipping_cost_breakdown.supplementary_component.fbm_shipping_cost_amount |
sku_transactions.shipping_cost_breakdown.supplementary_component.fbm_shipping_cost_amount |
The shipping cost amount for Fulfilled by Merchant (FBM) orders. |
metric |
sku_transactions.shipping_cost_breakdown.supplementary_component.fbt_fulfillment_fee_amount |
sku_transactions.shipping_cost_breakdown.supplementary_component.fbt_fulfillment_fee_amount |
The fulfillment fee amount for Fulfilled by TikTok (FBT) orders. |
metric |
sku_transactions.shipping_cost_breakdown.supplementary_component.fbt_shipping_cost_amount |
sku_transactions.shipping_cost_breakdown.supplementary_component.fbt_shipping_cost_amount |
The shipping cost amount for Fulfilled by TikTok (FBT) orders. |
metric |
sku_transactions.shipping_cost_breakdown.supplementary_component.platform_shipping_fee_discount_amount |
sku_transactions.shipping_cost_breakdown.supplementary_component.platform_shipping_fee_discount_amount |
The shipping fee discount amount provided by the platform. |
metric |
sku_transactions.shipping_cost_breakdown.supplementary_component.promo_shipping_incentive_amount |
sku_transactions.shipping_cost_breakdown.supplementary_component.promo_shipping_incentive_amount |
The shipping incentive amount offered through promotions. |
metric |
sku_transactions.shipping_cost_breakdown.supplementary_component.seller_shipping_fee_discount_amount |
sku_transactions.shipping_cost_breakdown.supplementary_component.seller_shipping_fee_discount_amount |
The shipping fee discount amount provided by the seller. |
metric |
sku_transactions.shipping_cost_breakdown.supplementary_component.shipping_fee_subsidy_amount |
sku_transactions.shipping_cost_breakdown.supplementary_component.shipping_fee_subsidy_amount |
The shipping fee subsidy amount provided. |
metric |
sku_transactions.sku_id |
sku_transactions.sku_id |
The unique identifier for the Stock Keeping Unit (SKU) involved in the transaction. |
dimension |
sku_transactions.sku_name |
sku_transactions.sku_name |
The name or description of the Stock Keeping Unit (SKU) in the transaction. |
dimension |
sku_transactions.statement_id |
sku_transactions.statement_id |
The unique identifier for the financial statement to which this SKU transaction belongs. |
dimension |
total_count |
total_count |
The total number of records or items in a collection. |
metric |