Fields Reference · TikTok Shop
TikTok Shop Fields List
148 fields · 69 dimensions · 79 metrics · 8 groups
| Field name | Label | Category | Description |
|---|---|---|---|
tiktok_shop_buyer_post_town | Buyer post town | Buyers & delivery | UK market only. |
tiktok_shop_buyer_postal_code | Buyer postal code | Buyers & delivery | |
tiktok_shop_buyer_region | Buyer region | Buyers & delivery | Region code of the delivery address. Unavailable while the order is UNPAID or ON_HOLD. |
tiktok_shop_buyer_service_fee | Buyer service fee | Buyers & delivery | Indonesia market only. |
tiktok_shop_buyer_user_id | Buyer user ID | Buyers & delivery | |
tiktok_shop_delivered_date | Delivered date | Buyers & delivery | |
tiktok_shop_delivery_option_name | Delivery option | Buyers & delivery | |
tiktok_shop_delivery_type | Delivery type | Buyers & delivery | HOME_DELIVERY, or COLLECTION_POINT for a pick-up/drop-off location. |
tiktok_shop_fulfillment_type | Fulfillment type | Buyers & delivery | Whether the seller, TikTok or Tokopedia fulfils the order. |
tiktok_shop_package_id | Package ID | Buyers & delivery | |
tiktok_shop_package_status | Package status | Buyers & delivery | |
tiktok_shop_shipping_fee | Shipping fee | Buyers & delivery | Buyer-paid shipping after discounts. Pre-tax in the US market. |
tiktok_shop_shipping_provider | Shipping provider | Buyers & delivery | |
tiktok_shop_shipping_type | Shipping type | Buyers & delivery | |
tiktok_shop_tracking_number | Tracking number | Buyers & delivery | |
tiktok_shop_warehouse_id | Warehouse ID | Buyers & delivery | |
tiktok_shop_live_acu | LIVE average concurrent viewers | LIVE | |
tiktok_shop_live_avg_price | LIVE average price | LIVE | |
tiktok_shop_live_avg_viewing_duration | LIVE average viewing duration | LIVE | Seconds. |
tiktok_shop_live_comments | LIVE comments | LIVE | |
tiktok_shop_live_ctr | LIVE CTR | LIVE | |
tiktok_shop_live_currency | Currency | LIVE | |
tiktok_shop_live_customers | LIVE customers | LIVE | |
tiktok_shop_live_duration_minutes | LIVE duration | LIVE | Minutes between the session's start and end. |
tiktok_shop_live_gmv | LIVE GMV | LIVE | Revenue attributed to this LIVE session. |
tiktok_shop_live_host | LIVE host | LIVE | |
tiktok_shop_live_id | LIVE session ID | LIVE | Joins to the order items' live_room_id. |
tiktok_shop_live_items_sold | LIVE items sold | LIVE | |
tiktok_shop_live_likes | LIVE likes | LIVE | |
tiktok_shop_live_new_followers | LIVE new followers | LIVE | |
tiktok_shop_live_pcu | LIVE peak concurrent viewers | LIVE | |
tiktok_shop_live_product_clicks | LIVE product clicks | LIVE | |
tiktok_shop_live_product_impressions | LIVE product impressions | LIVE | |
tiktok_shop_live_products_added | LIVE products added | LIVE | |
tiktok_shop_live_products_sold | LIVE distinct products sold | LIVE | |
tiktok_shop_live_room_id | LIVE room ID | LIVE | The LIVE session this unit was bought in. Empty when the sale did not come from a LIVE. |
tiktok_shop_live_shares | LIVE shares | LIVE | |
tiktok_shop_live_sku_orders | LIVE SKU orders | LIVE | |
tiktok_shop_live_start_date | LIVE date | LIVE | |
tiktok_shop_live_title | LIVE title | LIVE | |
tiktok_shop_live_viewers | LIVE viewers | LIVE | |
tiktok_shop_live_views | LIVE views | LIVE | |
tiktok_shop_item_cancel_reason | Item cancellation reason | Order line items | |
tiktok_shop_item_cancelled_by | Item cancelled by | Order line items | |
tiktok_shop_item_platform_discount | Item platform discount | Order line items | |
tiktok_shop_item_seller_discount | Item seller discount | Order line items | |
tiktok_shop_item_shipping_provider | Item shipping provider | Order line items | |
tiktok_shop_item_status | Item status | Order line items | Display status of this line item, which can differ from the order's when an order ships partially. |
tiktok_shop_item_tracking_number | Item tracking number | Order line items | |
tiktok_shop_items_sold | Items sold | Order line items | |
tiktok_shop_line_item_id | Line item ID | Order line items | |
tiktok_shop_product_aov | Product AOV | Order line items | Already an average — average it across products, do not sum it. |
tiktok_shop_product_clicks | Product clicks | Order line items | |
tiktok_shop_product_id | Product ID | Order line items | |
tiktok_shop_product_items_sold | Product items sold | Order line items | |
tiktok_shop_product_name | Product name | Order line items | |
tiktok_shop_product_refunded_items | Product refunded items | Order line items | |
tiktok_shop_product_refunds | Product refunds | Order line items | |
tiktok_shop_product_sku_orders | Product SKU orders | Order line items | |
tiktok_shop_seller_sku | Seller SKU | Order line items | |
tiktok_shop_sku_id | SKU ID | Order line items | |
tiktok_shop_sku_image | SKU image | Order line items | |
tiktok_shop_sku_name | SKU name | Order line items | |
tiktok_shop_sku_orders_count | SKU orders | Order line items | |
tiktok_shop_cancel_reason | Cancellation reason | Orders | |
tiktok_shop_cancellation_initiator | Cancelled by | Orders | |
tiktok_shop_cancelled_date | Cancelled date | Orders | |
tiktok_shop_commerce_platform | Commerce platform | Orders | TIKTOK_SHOP or TOKOPEDIA. Indonesia only. |
tiktok_shop_currency | Currency | Orders | Currency of every money field on the row. A shop selling in more than one currency must be grouped by it before summing. |
tiktok_shop_gross_revenue | Gross revenue | Orders | Customer payments plus platform product subsidies, minus taxes. |
tiktok_shop_handling_fee | Handling fee | Orders | |
tiktok_shop_is_buyer_request_cancel | Buyer requested cancellation | Orders | |
tiktok_shop_is_cod | Cash on delivery | Orders | |
tiktok_shop_is_exchange_order | Exchange order | Orders | |
tiktok_shop_is_gift | Gift | Orders | |
tiktok_shop_is_replacement_order | Replacement order | Orders | |
tiktok_shop_is_sample_order | Sample order | Orders | |
tiktok_shop_is_subscription_order | Subscription order | Orders | |
tiktok_shop_order_date | Order date | Orders | The date the order was created, in the shop's reporting timezone. |
tiktok_shop_order_id | Order ID | Orders | |
tiktok_shop_order_status | Order status | Orders | UNPAID, ON_HOLD, AWAITING_SHIPMENT, PARTIALLY_SHIPPING, AWAITING_COLLECTION, IN_TRANSIT, DELIVERED, COMPLETED or CANCELL… |
tiktok_shop_order_type | Order type | Orders | NORMAL, ZERO_LOTTERY, PRE_ORDER, MADE_TO_ORDER, BACK_ORDER or VIRTUAL_ORDER. Empty for standard orders. |
tiktok_shop_orders_count | Orders | Orders | Always 1 per row; sum it to count orders. |
tiktok_shop_original_price | Original price | Orders | |
tiktok_shop_original_shipping_fee | Original shipping fee | Orders | |
tiktok_shop_original_total_product_price | Original product price | Orders | Product total before any discount. |
tiktok_shop_paid_date | Paid date | Orders | |
tiktok_shop_paid_orders_count | Paid orders | Orders | |
tiktok_shop_payment_date | Payment date | Orders | |
tiktok_shop_payment_id | Payment ID | Orders | |
tiktok_shop_payment_method_name | Payment method | Orders | |
tiktok_shop_payment_status | Payment status | Orders | PAID, FAILED or PROCESSING. |
tiktok_shop_refunds | Refunds | Orders | |
tiktok_shop_retail_delivery_fee | Retail delivery fee | Orders | US market only. |
tiktok_shop_sale_price | Sale price | Orders | What this unit sold for. |
tiktok_shop_seller_discount | Seller discount | Orders | |
tiktok_shop_sub_total | Sub total | Orders | Product total after discounts. PRE-TAX in the US market, so it is not revenue there. |
tiktok_shop_tax | Tax | Orders | |
tiktok_shop_total_amount | Total amount | Orders | What the buyer paid: sub total + shipping fee + taxes + retail delivery fee. |
tiktok_shop_units | Units | Orders | Always 1 per row: TikTok models each unit as its own line item, so summing this counts units sold. |
tiktok_shop_updated_date | Updated date | Orders | |
tiktok_shop_shop_id | Shop ID | Shop | |
tiktok_shop_shop_name | Shop name | Shop | |
tiktok_shop_avg_conversion_rate | Average conversion rate | Shop performance | Daily average share of visitors who paid. Already a rate — average it, do not sum it. |
tiktok_shop_avg_customers_count | Average customers | Shop performance | Daily average of unique paying users. It is already an average, so summing it across days is meaningless. |
tiktok_shop_avg_page_views | Average page views | Shop performance | |
tiktok_shop_avg_visitors | Average visitors | Shop performance | |
tiktok_shop_gmv | GMV | Shop performance | Total paid for orders in the period, INCLUDING cancelled and refunded ones. It is therefore always at or above the order… |
tiktok_shop_gmv_live | GMV from LIVE | Shop performance | GMV attributed to LIVE streams. |
tiktok_shop_gmv_product_card | GMV from product card | Shop performance | |
tiktok_shop_gmv_video | GMV from video | Shop performance | GMV attributed to video content. |
tiktok_shop_perf_currency | Currency | Shop performance | |
tiktok_shop_perf_product_id | Product ID | Shop performance | Joins to the orders' product_id. |
tiktok_shop_performance_currency | Currency | Shop performance | |
tiktok_shop_performance_date | Date | Shop performance | The analytics day, in the SHOP'S REGISTERED timezone — not the report's. It will not always align with order dates. |
tiktok_shop_product_ctr | Product CTR | Shop performance | Already a rate — average it, do not sum it. |
tiktok_shop_product_gmv | Product GMV | Shop performance | |
tiktok_shop_product_gmv_affiliate | Product GMV from affiliates | Shop performance | |
tiktok_shop_product_gmv_product_card | Product GMV from product card | Shop performance | |
tiktok_shop_product_gmv_seller_live | Product GMV from seller LIVE | Shop performance | |
tiktok_shop_product_gmv_seller_video | Product GMV from seller video | Shop performance | |
tiktok_shop_product_impressions | Product impressions | Shop performance | |
tiktok_shop_product_orders | Product orders | Shop performance | |
tiktok_shop_adjustment_amount | Adjustment amount | Statements & settlements | Chargebacks, compensations, penalties and other corrections. |
tiktok_shop_fee_amount | Fee amount | Statements & settlements | Fees charged by TikTok Shop. Arrives NEGATIVE, so it sums with revenue rather than subtracting from it. |
tiktok_shop_net_sales_amount | Net sales amount | Statements & settlements | Revenue after seller discounts. Local sellers outside SEA only. |
tiktok_shop_platform_discount | Platform discount | Statements & settlements | |
tiktok_shop_revenue_amount | Revenue amount | Statements & settlements | Final revenue at settlement. Not returned for UK and US shops. |
tiktok_shop_settlement_amount | Settlement amount | Statements & settlements | What this statement settles to. |
tiktok_shop_shipping_cost_amount | Shipping cost | Statements & settlements | Local sellers outside SEA only. |
tiktok_shop_statement_currency | Statement currency | Statements & settlements | |
tiktok_shop_statement_date | Statement date | Statements & settlements | Statements are generated daily at 00:00 UTC covering the previous day, so this is a UTC day and will not align exactly w… |
tiktok_shop_statement_id | Statement ID | Statements & settlements | |
tiktok_shop_statements_count | Statements | Statements & settlements | Always 1 per row; sum it to count statements. |
tiktok_shop_video_avg_customers | Video average customers | Video | |
tiktok_shop_video_creator | Creator | Video | |
tiktok_shop_video_creator_type | Creator type | Video | Whether the video came from the seller's own account or an affiliate creator. |
tiktok_shop_video_ctr | Video CTR | Video | |
tiktok_shop_video_currency | Currency | Video | |
tiktok_shop_video_duration | Video duration | Video | Seconds. |
tiktok_shop_video_gmv | Video GMV | Video | Revenue attributed to this video. |
tiktok_shop_video_gpm | Video GPM | Video | GMV per thousand views: whether the video sold well relative to its reach, rather than merely being popular. Already a r… |
tiktok_shop_video_id | Video ID | Video | |
tiktok_shop_video_items_sold | Video items sold | Video | |
tiktok_shop_video_posted_date | Video posted date | Video | |
tiktok_shop_video_sku_orders | Video SKU orders | Video | |
tiktok_shop_video_title | Video title | Video | |
tiktok_shop_video_views | Video views | Video |