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 |
|---|---|---|---|
amount.value |
amount.value |
The numeric value of a monetary amount. |
metric |
create_time |
create_time |
The timestamp when a record or entity was created. |
dimension |
create_time_date |
create_time_date |
The date when a record or entity was created. |
dimension |
currency |
currency |
The currency code used for all monetary values related to the order or transaction. |
dimension |
fee_amount |
fee_amount |
The total amount of fees associated with a financial transaction or statement. |
metric |
fee_and_tax_amount |
fee_and_tax_amount |
The total amount of fees and taxes applied to an order transaction. |
metric |
id |
id |
A unique identifier for the specific entity, such as an order, payment, or statement. |
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 that initiated the cancellation of the line item. |
dimension |
line_items.currency |
line_items.currency |
The currency code for the prices and amounts related to the line item (e.g., USD, EUR). |
dimension |
line_items.display_status |
line_items.display_status |
The human-readable display status of the line item within the order. |
dimension |
line_items.id |
line_items.id |
A unique identifier for a specific line item within an order. |
metric |
line_items.is_gift |
line_items.is_gift |
Indicates whether the line item is marked as a gift. |
dimension |
line_items.item_tax |
line_items.item_tax |
The amount of tax applied to the individual line item. |
dimension |
line_items.original_price |
line_items.original_price |
The original selling 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 containing this line item. |
dimension |
line_items.platform_discount |
line_items.platform_discount |
The discount amount applied by the platform (TikTok Shop) to the line item. |
metric |
line_items.product_id |
line_items.product_id |
A unique identifier for the product associated with the line item. |
metric |
line_items.product_name |
line_items.product_name |
The name of the product associated with the line item. |
dimension |
line_items.rts_time |
line_items.rts_time |
The timestamp when the line item was marked as ready to ship (RTS). |
dimension |
line_items.sale_price |
line_items.sale_price |
The final selling price of the product in the line item after all discounts. |
metric |
line_items.seller_discount |
line_items.seller_discount |
The discount amount applied by the seller to the line item. |
metric |
line_items.seller_sku |
line_items.seller_sku |
The seller’s unique identifier for the Stock Keeping Unit (SKU) of the product in the line item. |
dimension |
line_items.shipping_provider_id |
line_items.shipping_provider_id |
A unique identifier for the shipping provider handling the line item. |
metric |
line_items.shipping_provider_name |
line_items.shipping_provider_name |
The name of the shipping provider handling the line item. |
dimension |
line_items.sku_id |
line_items.sku_id |
A unique identifier for the Stock Keeping Unit (SKU) of the product in the line item. |
metric |
line_items.sku_image |
line_items.sku_image |
The URL of the image associated with the SKU in the line item. |
dimension |
line_items.sku_name |
line_items.sku_name |
The name of the Stock Keeping Unit (SKU) of the product in the line item. |
dimension |
line_items.sku_type |
line_items.sku_type |
The type of Stock Keeping Unit (SKU) for the product in the line item. |
dimension |
line_items.tracking_number |
line_items.tracking_number |
The tracking number associated with the shipment of the 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 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) timestamp by which an order must be canceled. |
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 entity (e.g., buyer, seller, platform) that initiated the order cancellation. |
dimension |
orders.collection_due_time |
orders.collection_due_time |
The timestamp by which the order is due for collection by the shipping provider. |
dimension |
orders.collection_time |
orders.collection_time |
The timestamp when the order was collected by the shipping provider. |
dimension |
orders.commerce_platform |
orders.commerce_platform |
The commerce platform where the order was placed, typically ‘TikTok Shop’. |
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 for the order. |
metric |
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 |
The Service Level Agreement (SLA) timestamp by which the order is expected to be delivered. |
dimension |
orders.delivery_time |
orders.delivery_time |
The timestamp when the order was delivered. |
dimension |
orders.delivery_type |
orders.delivery_type |
The type of delivery chosen for the order (e.g., standard, express). |
dimension |
orders.fulfillment_type |
orders.fulfillment_type |
The method of fulfillment for the order (e.g., seller-fulfilled, platform-fulfilled). |
dimension |
orders.has_updated_recipient_address |
orders.has_updated_recipient_address |
Indicates whether the recipient’s address for the order has been updated. |
dimension |
orders.id |
orders.id |
A unique identifier for the order. |
metric |
orders.is_cod |
orders.is_cod |
Indicates whether the order is a Cash on Delivery (COD) order. |
dimension |
orders.is_on_hold_order |
orders.is_on_hold_order |
Indicates whether the order is currently on hold. |
dimension |
orders.order_type |
orders.order_type |
The type of order (e.g., standard order, sample order). |
dimension |
orders.packages |
orders.packages |
A list of packages associated with the order. |
dimension |
orders.paid_time |
orders.paid_time |
The timestamp when the order payment was successfully processed. |
dimension |
orders.payment_card_type |
orders.payment_card_type |
The type of payment card used for the order (e.g., Visa, Mastercard). |
dimension |
orders.payment_method_code |
orders.payment_method_code |
The code identifying the payment method used for the order. |
dimension |
orders.payment_method_name |
orders.payment_method_name |
The human-readable name of the payment method used for the order. |
dimension |
orders.rts_sla_time |
orders.rts_sla_time |
The Service Level Agreement (SLA) timestamp by which the order must be marked as ready to ship (RTS). |
dimension |
orders.rts_time |
orders.rts_time |
The 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 |
A unique identifier for the shipping provider handling the order. |
metric |
orders.shipping_type |
orders.shipping_type |
The type of shipping selected for the order (e.g., standard, economy). |
dimension |
orders.status |
orders.status |
The current status of the order (e.g., unpaid, awaiting shipment, shipped, delivered, cancelled). |
dimension |
orders.tracking_number |
orders.tracking_number |
The tracking number associated with the order’s shipment. |
metric |
orders.tts_sla_time |
orders.tts_sla_time |
The Service Level Agreement (SLA) timestamp for ‘Time to Ship’ for the order. |
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 (buyer) who placed the order. |
metric |
orders.warehouse_id |
orders.warehouse_id |
A unique identifier for the warehouse from which the order is fulfilled. |
metric |
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. |
metric |
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 |
Indicates whether the package contains multiple Stock Keeping Units (SKUs). |
dimension |
package.last_mile_tracking_number |
package.last_mile_tracking_number |
The tracking number for the last mile delivery segment of the package’s journey. |
metric |
package.order_line_item_ids |
package.order_line_item_ids |
A list of unique identifiers for the order line items contained within the package. |
dimension |
package.orders |
package.orders |
Details of the orders associated with this package. |
dimension |
package.package_id |
package.package_id |
A unique identifier for the package. |
metric |
package.package_status |
package.package_status |
The current status of the package (e.g., preparing, shipped, delivered). |
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, concatenated recipient’s address for the package. |
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 address for the package. |
metric |
package.recipient_address.region_code |
package.recipient_address.region_code |
The geographical region 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 full address of the package sender. |
dimension |
package.sender_address.name |
package.sender_address.name |
The name of the package sender. |
dimension |
package.sender_address.phone_number |
package.sender_address.phone_number |
The phone number of the package sender. |
dimension |
package.sender_address.postal_code |
package.sender_address.postal_code |
The postal code of the package sender’s address. |
dimension |
package.sender_address.region_code |
package.sender_address.region_code |
The region code of the package sender’s address (e.g., country code). |
dimension |
package.shipping_provider_id |
package.shipping_provider_id |
A unique identifier for the shipping provider handling the package. |
metric |
package.shipping_provider_name |
package.shipping_provider_name |
The name of the shipping provider handling the package. |
dimension |
package.shipping_type |
package.shipping_type |
dimension |
|
package.tracking_number |
package.tracking_number |
metric |
|
package.update_time |
package.update_time |
dimension |
|
payable_amount |
payable_amount |
The total amount due or payable for an order or transaction. |
metric |
payment.currency |
payment.currency |
The currency in which the payment amounts are expressed. |
dimension |
payment.original_shipping_fee |
payment.original_shipping_fee |
The initial or original shipping fee before any discounts or adjustments. |
metric |
payment.original_total_product_price |
payment.original_total_product_price |
The total price of the products in the order before any discounts or other charges. |
metric |
payment.platform_discount |
payment.platform_discount |
The discount amount applied by the TikTok Shop platform. |
metric |
payment.product_tax |
payment.product_tax |
The tax amount applied specifically to the products in the order. |
metric |
payment.seller_discount |
payment.seller_discount |
The discount amount provided by the seller. |
metric |
payment.shipping_fee |
payment.shipping_fee |
The shipping fee charged for the order after any applicable discounts. |
metric |
payment.shipping_fee_cofunded_discount |
payment.shipping_fee_cofunded_discount |
metric |
|
payment.shipping_fee_platform_discount |
payment.shipping_fee_platform_discount |
The discount applied to the shipping fee by the TikTok Shop platform. |
metric |
payment.shipping_fee_seller_discount |
payment.shipping_fee_seller_discount |
metric |
|
payment.shipping_fee_tax |
payment.shipping_fee_tax |
The tax amount applied specifically 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 grand total amount for the order, including products, shipping, and taxes, after all discounts. |
metric |
payment_id |
payment_id |
A unique identifier for a payment record, retrieved from payment data. |
dimension |
payment_status |
payment_status |
The current status of a payment (e.g., pending, paid, failed). |
dimension |
recipient_address.address_detail |
recipient_address.address_detail |
Detailed information about the recipient’s 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 |
Information about the district or area within 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 a local script or language. |
dimension |
recipient_address.full_address |
recipient_address.full_address |
The complete 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 in a local script or language. |
dimension |
recipient_address.name |
recipient_address.name |
The full name of the package recipient. |
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 address. |
metric |
recipient_address.region_code |
recipient_address.region_code |
The region code of the recipient’s address (e.g., country code). |
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 monetary amount charged for shipping the order. |
metric |
sku_transactions.fee_tax_amount |
sku_transactions.fee_tax_amount |
The total amount of fees and taxes associated with 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 specifically related to affiliate advertisements for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.affiliate_commission_amount |
sku_transactions.fee_tax_breakdown.fee.affiliate_commission_amount |
The total commission amount earned by 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 for the SKU transaction before any personal income tax (PIT) deductions. |
metric |
sku_transactions.fee_tax_breakdown.fee.affiliate_partner_commission_amount |
sku_transactions.fee_tax_breakdown.fee.affiliate_partner_commission_amount |
The commission amount earned by 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 amount of bonus 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 promotions co-funded by TikTok Shop 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 charged for processing 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 variable commission amount applied to 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 |
The service fee amount related to Extended Producer Responsibility (EPR) or Point of Business (POB) for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.external_affiliate_marketing_fee_amount |
sku_transactions.fee_tax_breakdown.fee.external_affiliate_marketing_fee_amount |
The marketing fee amount for external affiliate programs 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 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 participating in flash sales events for 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 promotions or special offers during live events 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 selling products through the TikTok Shop Mall for 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 platform for a 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 within 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 a referral that led to 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 charged for processing a refund for 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 for transactions where the seller offers a ‘pay later’ option for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.sfp_service_fee_amount |
sku_transactions.fee_tax_breakdown.fee.sfp_service_fee_amount |
The service fee amount related to the Seller Fulfilled Prime (SFP) program or similar fulfillment services for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.transaction_fee_amount |
sku_transactions.fee_tax_breakdown.fee.transaction_fee_amount |
The general fee charged for a SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.fee.tsp_commission_amount |
sku_transactions.fee_tax_breakdown.fee.tsp_commission_amount |
The commission amount related to a Third-Party Service Provider (TSP) for the SKU transaction. |
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 voucher programs or incentives applied to 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 for anti-dumping duties applicable to 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 tax amount for customs duties applicable to 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 applied to a 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 applied to a SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.tax.isr_amount |
sku_transactions.fee_tax_breakdown.tax.isr_amount |
The amount of Income Tax on Salaries (ISR) or similar income-related tax for the SKU transaction. |
metric |
sku_transactions.fee_tax_breakdown.tax.iva_amount |
sku_transactions.fee_tax_breakdown.tax.iva_amount |
The Impuesto al Valor Agregado (IVA) tax amount applied to a 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 applied to a 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 applied to a 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 applied to a 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 involved in the transaction. |
metric |
sku_transactions.revenue_amount |
sku_transactions.revenue_amount |
The revenue 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) transactions within the revenue breakdown of 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 Cash on Delivery (COD) service fees within the revenue breakdown of the SKU transaction. |
metric |
sku_transactions.revenue_breakdown.refund_subtotal_before_discount_amount |
sku_transactions.revenue_breakdown.refund_subtotal_before_discount_amount |
The subtotal amount of the refund for a SKU transaction before any discounts are applied. |
metric |
sku_transactions.revenue_breakdown.seller_discount_amount |
sku_transactions.revenue_breakdown.seller_discount_amount |
The discount amount provided by the seller for a SKU transaction. |
metric |
sku_transactions.revenue_breakdown.seller_discount_refund_amount |
sku_transactions.revenue_breakdown.seller_discount_refund_amount |
The refund amount specifically for seller-provided discounts on a SKU transaction. |
metric |
sku_transactions.revenue_breakdown.subtotal_before_discount_amount |
sku_transactions.revenue_breakdown.subtotal_before_discount_amount |
The subtotal amount for a SKU transaction before any discounts are applied. |
metric |
sku_transactions.settlement_amount |
sku_transactions.settlement_amount |
The net amount settled for a specific SKU transaction, after all fees, taxes, and adjustments. |
metric |
sku_transactions.shipping_cost_amount |
sku_transactions.shipping_cost_amount |
The total shipping cost associated with a 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 a SKU transaction. |
metric |
sku_transactions.shipping_cost_breakdown.customer_paid_shipping_fee_amount |
sku_transactions.shipping_cost_breakdown.customer_paid_shipping_fee_amount |
The shipping fee amount paid by the customer for a SKU transaction. |
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 related to the SKU transaction. |
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 Fulfillment by TikTok (FBT) fulfillment fees within the SKU transaction’s shipping cost breakdown. |
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 item related to the SKU transaction. |
metric |
sku_transactions.shipping_cost_breakdown.return_shipping_fee_amount |
sku_transactions.shipping_cost_breakdown.return_shipping_fee_amount |
The shipping fee amount charged for returning an item from a SKU transaction. |
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 a return shipping label related to the SKU transaction. |
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 when the seller handles their own shipping for the SKU transaction. |
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 a SKU transaction. |
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 transaction. |
metric |
sku_transactions.shipping_cost_breakdown.signature_confirmation_fee_amount |
sku_transactions.shipping_cost_breakdown.signature_confirmation_fee_amount |
The fee amount for requiring a signature confirmation upon delivery of the SKU transaction. |
metric |
sku_transactions.shipping_cost_breakdown.supplementary_component |
sku_transactions.shipping_cost_breakdown.supplementary_component |
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 by which the customer’s shipping fee is offset as a supplementary component for the SKU transaction. |
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 Fulfillment by Merchant (FBM) as a supplementary component for the SKU transaction. |
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 Fulfillment by TikTok (FBT) as a supplementary component for the SKU transaction. |
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 Fulfillment by TikTok (FBT) as a supplementary component for the SKU transaction. |
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 for a SKU transaction. |
metric |
sku_transactions.shipping_cost_breakdown.supplementary_component.promo_shipping_incentive_amount |
sku_transactions.shipping_cost_breakdown.supplementary_component.promo_shipping_incentive_amount |
The amount of promotional shipping incentive as a supplementary component for the SKU transaction. |
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 discount amount applied by the seller to the shipping fee as a supplementary component for the SKU transaction. |
metric |
sku_transactions.shipping_cost_breakdown.supplementary_component.shipping_fee_subsidy_amount |
sku_transactions.shipping_cost_breakdown.supplementary_component.shipping_fee_subsidy_amount |
The amount of subsidy provided for shipping fees for a SKU transaction. |
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 |
statement_time |
statement_time |
The timestamp when a financial statement was generated or finalized. |
dimension |
statement_time_date |
statement_time_date |
The date when a financial statement was generated or finalized. |
dimension |
status |
status |
The current status of the order (e.g., UNPAID, PAID, SHIPPED, DELIVERED). |
dimension |
total_count |
total_count |
The total number of records or items matching a given query. |
metric |
total_settlement_amount |
total_settlement_amount |
The total amount settled for an order or a collection of orders within a statement, after all deductions and compensations. |
metric |
transactions.id |
transactions.id |
A unique identifier for a financial transaction. |
metric |
transactions.order_create_time |
transactions.order_create_time |
The timestamp when the order associated with the transaction was created. |
dimension |
transactions.order_create_time_date |
transactions.order_create_time_date |
The date when the order associated with the transaction was created. |
dimension |
transactions.revenue_amount |
transactions.revenue_amount |
The revenue amount generated from the transaction. |
metric |
transactions.settlement_amount |
transactions.settlement_amount |
The amount of funds settled for a specific transaction. |
metric |
transactions.shipping_cost_amount |
transactions.shipping_cost_amount |
The cost associated with shipping for the transaction. |
metric |
transactions.type |
transactions.type |
The type of the financial transaction or adjustment (e.g., Shipping fee adjustment, Chargeback, Promotion adjustment). |
dimension |