TikTok Shop: Most-used fields

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