Schema · Entity relationship diagram
TikTok Shop tables and relationships
Orders and finance (statements, fee-level transactions, payouts) with full history, shop, product and SKU analytics, videos, LIVEs and bestseller leaderboards.
ordershas one row per order line (keyline_item_id). Order-level amounts repeat on every line, so filteris_order_first_line = 1before summingorder_*columns.- The
bestselling_*tables are platform-wide top-100 leaderboards across all of TikTok Shop, so every shop gets the same rows. - Affiliate orders, samples and creator tables are on the TikTok Shop Affiliate page.
- Ratio columns (rates,
ctr,ctor) are raw decimals: 0.0528 = 5.28%. Money columns carry acurrencycolumn. shop_gmv_breakdown_dailyhas one row per GMV source and day. Its threebreakdowngroups slice the same GMV in different ways, so sum within one group only.shop_performance_hourlycovers the last 30 days (TikTok serves no more). Rows withhourNULL are day totals.
Drag to pan, scroll or pinch to zoom, click a table to see what it joins to.
Table reference
23 tables · click a table for its columnsorders60 columns · Ordersshow in diagram
Primary key: line_item_id
| Column | Type | Key | Description |
|---|---|---|---|
| order identity / status | |||
| order_idTikTok Shop order id. One order has one row per line item. | varchar(64) | TikTok Shop order id. One order has one row per line item. | |
| order_status | varchar(64) | ||
| order_type | varchar(64) | ||
| Opaque TikTok buyer id. The ONLY repeat-customer key available: TikTok does not expose buyer email and masks name/phone/address. | |||
| buyer_user_id | varchar(64) | ||
| create_time_utc | timestamp | ||
| order_date_pt | date | ||
| update_time_utc | timestamp | ||
| paid_time_utc | timestamp | ||
| delivery_time_utc | timestamp | ||
| cancel_reason | varchar(512) | ||
| is_cod | smallint | ||
| is_sample_order | smallint | ||
| fulfillment | |||
| fulfillment_type | varchar(64) | ||
| delivery_option_name | varchar(256) | ||
| shipping_provider | varchar(256) | ||
| payment_method_name | varchar(128) | ||
| warehouse_id | varchar(64) | ||
| seller_note | varchar(2048) | ||
| buyer_message | varchar(2048) | ||
| order-level money: REPEATED on every line of the order. Filter is_order_first_line = 1 before summing these. | |||
| currency | varchar(8) | ||
| order_total_amount | decimal(18,4) | ||
| order_sub_total | decimal(18,4) | ||
| order_shipping_fee | decimal(18,4) | ||
| order_seller_discount | decimal(18,4) | ||
| order_platform_discount | decimal(18,4) | ||
| order_original_total_product_price | decimal(18,4) | ||
| order_original_shipping_fee | decimal(18,4) | ||
| order_shipping_fee_seller_discount | decimal(18,4) | ||
| order_shipping_fee_platform_discount | decimal(18,4) | ||
| order_tax | decimal(18,4) | ||
| address (district_info L0..L3 flattened) | |||
| recipient_name | varchar(256) | ||
| recipient_phone | varchar(64) | ||
| full_address | varchar(1024) | ||
| postal_code | varchar(32) | ||
| region_code | varchar(8) | ||
| country | varchar(128) | ||
| state | varchar(128) | ||
| county | varchar(128) | ||
| city | varchar(128) | ||
| line item: these ARE safe to sum directly | |||
| line_item_idPrimary key. | varchar(64) | PK | Primary key. |
| product_id | varchar(64) | ||
| product_name | varchar(1024) | ||
| sku_id | varchar(64) | ||
| seller_sku | varchar(256) | ||
| sku_name | varchar(512) | ||
| sku_type | varchar(64) | ||
| line_original_price | decimal(18,4) | ||
| line_sale_price | decimal(18,4) | ||
| line_seller_discount | decimal(18,4) | ||
| line_platform_discount | decimal(18,4) | ||
| package_id | varchar(64) | ||
| package_status | varchar(64) | ||
| line_display_status | varchar(64) | ||
| line_shipping_provider_name | varchar(256) | ||
| line_tracking_number | varchar(128) | ||
| grain helpers + housekeeping | |||
| order_line_count | integer | ||
| is_order_first_line1 on the first line of each order. Filter on it before summing order-level (order_*) amounts. | smallint | 1 on the first line of each order. Filter on it before summing order-level (order_*) amounts. | |
| shop_id | varchar(64) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. | |
| room_idJoins to live_performance.live_id (the LIVE session the order line was created in (US)). LIVE session id the order line was created in (US shops). NULL = not a LIVE order. | varchar(64) | FK | Joins to live_performance.live_id (the LIVE session the order line was created in (US)). LIVE session id the order line was created in (US shops). NULL = not a LIVE order. |
shop_performance_daily48 columns · Shop & product analyticsshow in diagram
Primary key: date
| Column | Type | Key | Description |
|---|---|---|---|
| datePrimary key. Redshift SORTKEY. | date | PK | Primary key. Redshift SORTKEY. |
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| orders | integer | ||
| sku_orders | integer | ||
| units_sold | integer | ||
| buyers | integer | ||
| avg_order_value | decimal(18,4) | ||
| refunds | decimal(18,4) | ||
| cancellations_and_returns | integer | ||
| product_impressions | bigint | ||
| product_page_views | bigint | ||
| avg_product_page_visitors | bigint | ||
| gmv_live | decimal(18,4) | ||
| gmv_video | decimal(18,4) | ||
| gmv_product_card | decimal(18,4) | ||
| impressions_live | bigint | ||
| impressions_video | bigint | ||
| impressions_product_card | bigint | ||
| page_views_live | bigint | ||
| page_views_video | bigint | ||
| page_views_product_card | bigint | ||
| buyers_live | integer | ||
| buyers_video | integer | ||
| buyers_product_card | integer | ||
| visitors_live | bigint | ||
| visitors_video | bigint | ||
| visitors_product_card | bigint | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. | |
| appended 2026-09-28 from Get Shop Performance 202609 (TikTok's names). live_/video_ gmv here are 202609 definitions: NOT the same numbers as gmv_live / gmv_video / gmv_product_card above (202405 breakdowns). | |||
| avg_sku_order_value | decimal(18,4) | ||
| unique paying customers | |||
| customers_count | integer | ||
| shipping_fees | decimal(18,4) | ||
| tax | decimal(18,4) | ||
| gmv_with_tax | decimal(18,4) | ||
| gmv_with_tiktok_co_funding | decimal(18,4) | ||
| direct LIVE GMV | |||
| live_gmv | decimal(18,4) | ||
| live_indirect_gmv | decimal(18,4) | ||
| live_attributed_gmv | decimal(18,4) | ||
| video_gmv | decimal(18,4) | ||
| video_indirect_gmv | decimal(18,4) | ||
| video_attributed_gmv | decimal(18,4) | ||
| product_card_attributed_gmv | decimal(18,4) | ||
| product_clicks | bigint | ||
| unique_clicks | bigint | ||
| unique_product_impressions | bigint | ||
| avg_page_views | bigint | ||
| avg_visitors | bigint | ||
| raw decimal ratio (0.0528 = 5.28%): paying users / product-page visitors | |||
| avg_conversation_rate | decimal(10,6) | ||
product_performance_daily30 columns · Shop & product analyticsshow in diagram
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| product_idJoins to orders.product_id. | varchar(64) | FK | Joins to orders.product_id. |
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| orders | integer | ||
| units_sold | integer | ||
| click_through_rate | decimal(10,6) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. | |
| appended 2026-09-28 from Get Shop Product Performance List 202605 (total_performance). NULL on rows the 202605 list doesn't return. | |||
| sku_orders | integer | ||
| estimated_customers | integer | ||
| aov | decimal(18,4) | ||
| product_impressions | bigint | ||
| product_clicks | bigint | ||
| add_cart_count | integer | ||
| raw decimal ratio (0.0528 = 5.28%) | |||
| add_cart_rate | decimal(10,6) | ||
| raw decimal ratio (0.0528 = 5.28%) | |||
| click_order_rate | decimal(10,6) | ||
| unique_product_impressions | bigint | ||
| unique_clicks | bigint | ||
| raw decimal ratio (0.0528 = 5.28%) | |||
| unique_ctr | decimal(10,6) | ||
| add_cart_users | integer | ||
| raw decimal ratio (0.0528 = 5.28%) | |||
| unique_atc_rate | decimal(10,6) | ||
| raw decimal ratio (0.0528 = 5.28%) | |||
| unique_click_order_rate | decimal(10,6) | ||
| gmv_incl_tax | decimal(18,4) | ||
| tax | decimal(18,4) | ||
| gross_merchandise_value | decimal(18,4) | ||
| shipping_fees | decimal(18,4) | ||
| refunds | decimal(18,4) | ||
| refunded_items | integer | ||
| refund_customers | integer | ||
shop_gmv_breakdown_daily11 columns · Shop & product analyticsshow in diagram
GMV by source per day (Get Shop Performance 202609 breakdowns + the seller/creator sales splits). One row per TikTok leaf; `breakdown` names TikTok's group (content_breakdown / product_card / shop_tab_and_search). The groups are alternative cuts of the same GMV: sum within ONE group only.
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| breakdownWhich TikTok breakdown the row belongs to (content_breakdown, product_card, shop_tab_and_search). Sum within one breakdown only. | varchar(32) | Which TikTok breakdown the row belongs to (content_breakdown, product_card, shop_tab_and_search). Sum within one breakdown only. | |
| content_type | varchar(32) | ||
| channel | varchar(32) | ||
| source | varchar(32) | ||
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| indirect_gmv | decimal(18,4) | ||
| attributed_gmv | decimal(18,4) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
shop_performance_hourly22 columns · Shop & product analyticsshow in diagram
Shop performance per hour (Get Shop Performance Per Hour 202510; TikTok serves the last 30 days only). hour 0-23 = TikTok's hour index in the shop registered timezone (same day boundary as `date` in every analytics table); hour NULL = the day total TikTok returns alongside -> filter hour IS NOT NULL before summing hours. latest_available_time: shop timezone.
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| hourHour 0-23 in the shop's timezone. NULL = TikTok's day total, so filter hour IS NOT NULL before summing hours. | smallint | Hour 0-23 in the shop's timezone. NULL = TikTok's day total, so filter hour IS NOT NULL before summing hours. | |
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| avg_order_value | decimal(18,4) | ||
| avg_sku_order_value | decimal(18,4) | ||
| customers | integer | ||
| customers_count | integer | ||
| orders_count | integer | ||
| sku_orders_count | integer | ||
| items_sold | integer | ||
| live_attributed_gmv | decimal(18,4) | ||
| video_attributed_gmv | decimal(18,4) | ||
| product_card_attributed_gmv | decimal(18,4) | ||
| product_impressions | bigint | ||
| product_clicks | bigint | ||
| unique_product_impressions | bigint | ||
| unique_clicks | bigint | ||
| visitors | bigint | ||
| latest_available_time | timestamp | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
product_channel_performance_daily30 columns · Shop & product analyticsshow in diagram
Product x channel per day (Get Shop Product Performance List 202605: the seller_live / seller_video / seller_product_card / affiliate_total / affiliate_live / affiliate_video / shop_tab objects). affiliate_total overlaps affiliate_live + affiliate_video: don't add it to them. attributed_gmv = TikTok's attributed_gmv (affiliate_live: live_attributed_gmv, affiliate_video: attributed_video_gmv); gmv / sold_items / ctor_sku are shop_tab only (shop_tab_* fields). Ratios are raw decimals (0.0528 = 5.28%).
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateJoins to product_performance_daily.product_id,date. Redshift SORTKEY. | date | FK | Joins to product_performance_daily.product_id,date. Redshift SORTKEY. |
| product_idJoins to product_performance_daily.product_id,date. | varchar(64) | FK | Joins to product_performance_daily.product_id,date. |
| channel | varchar(32) | ||
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| attributed_gmv | decimal(18,4) | ||
| attributed_orders | integer | ||
| attributed_sku_orders | integer | ||
| attributed_sold_items | integer | ||
| sold_items | integer | ||
| estimated_customers | integer | ||
| aov | decimal(18,4) | ||
| new_live_count | integer | ||
| new_video_count | integer | ||
| avg_daily_creator_posted_content | integer | ||
| product_impressions | bigint | ||
| product_clicks | bigint | ||
| ctr | decimal(10,6) | ||
| ctor_sku | decimal(10,6) | ||
| add_cart_count | integer | ||
| add_cart_rate | decimal(10,6) | ||
| click_order_rate | decimal(10,6) | ||
| unique_product_impressions | bigint | ||
| unique_clicks | bigint | ||
| unique_ctr | decimal(10,6) | ||
| add_cart_users | integer | ||
| unique_atc_rate | decimal(10,6) | ||
| unique_click_order_rate | decimal(10,6) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
sku_performance_daily9 columns · Shop & product analyticsshow in diagram
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateJoins to product_performance_daily.product_id,date. Redshift SORTKEY. | date | FK | Joins to product_performance_daily.product_id,date. Redshift SORTKEY. |
| sku_idJoins to orders.sku_id. | varchar(64) | FK | Joins to orders.sku_id. |
| product_idJoins to product_performance_daily.product_id,date. | varchar(64) | FK | Joins to product_performance_daily.product_id,date. |
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| sku_orders | integer | ||
| units_sold | integer | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
video_performance_daily18 columns · Videos & LIVEshow in diagram
Video & photo overview, daily (202509 shop_videos/overview_performance). Matches Seller Center's "Video & photo" view (photo-inclusive scope).
Primary key: date
| Column | Type | Key | Description |
|---|---|---|---|
| datePrimary key. Redshift SORTKEY. | date | PK | Primary key. Redshift SORTKEY. |
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| sku_orders | integer | ||
| avg_customers | integer | ||
| product_impressions | bigint | ||
| product_clicks | bigint | ||
| click_through_rate | decimal(10,6) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. | |
| appended 2026-09-28 from Get Shop Video Performance Overview 202609. gpm, shoppable_video_attributed_gmv, video_views, video_product_viewers are offline-only at TikTok: NULL = not available (not zero). | |||
| video_gmv | decimal(18,4) | ||
| video_indirect_gmv | decimal(18,4) | ||
| video_attributed_gmv | decimal(18,4) | ||
| video_attributed_sku_orders | integer | ||
| raw decimal ratio (0.0528 = 5.28%): attributed SKU orders / product clicks | |||
| ctor_sku_order | decimal(10,6) | ||
| GMV per 1,000 video views | |||
| gpm | decimal(18,4) | ||
| shoppable_video_attributed_gmv | decimal(18,4) | ||
| video_views | bigint | ||
| video_product_viewers | bigint | ||
videos13 columns · Videos & LIVEshow in diagram
Every video ever posted (identity only; the date window on the source endpoint scopes metrics, not membership — so this is complete history). "Video posts per day/week" = COUNT(*) grouped on video_post_time.
Primary key: video_id
| Column | Type | Key | Description |
|---|---|---|---|
| video_idPrimary key. | varchar(64) | PK | Primary key. |
| username | varchar(256) | ||
| title | varchar(1000) | ||
| video_post_timeRedshift SORTKEY. | timestamp | Redshift SORTKEY. | |
| duration_seconds | integer | ||
| product_ids | varchar(2000) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. | |
| appended 2026-09-28 (video list 202605) | |||
| hash_tags | varchar(1000) | ||
| advertisable | boolean | ||
| creator_open_id | varchar(128) | ||
| creator_nick_name | varchar(256) | ||
| creator_author_type | varchar(32) | ||
| creator_country | varchar(8) | ||
video_performance_by_video30 columns · Videos & LIVEshow in diagram
Sales-active videos only, day x video grain (creator attribution).
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| date | date | ||
| video_idReferences videos.video_id. | varchar(64) | FK | References videos.video_id. |
| username | varchar(256) | ||
| video_post_time | timestamp | ||
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| gpm | decimal(18,4) | ||
| sku_orders | integer | ||
| items_sold | integer | ||
| avg_customers | integer | ||
| views | bigint | ||
| click_through_rate | decimal(10,6) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. | |
| attributed_gmv | decimal(18,4) | ||
| indirect_gmv | decimal(18,4) | ||
| ctor | decimal(10,6) | ||
| likes | bigint | ||
| comments | bigint | ||
| shares | bigint | ||
| new_followers | bigint | ||
| product_impressions | bigint | ||
| product_clicks | bigint | ||
| v_to_l_clicks | bigint | ||
| v_to_l_rate | decimal(10,6) | ||
| video_finish_rate | decimal(10,6) | ||
| advertisable | boolean | ||
| review_type | varchar(64) | ||
| creator_open_id | varchar(128) | ||
| creator_author_type | varchar(32) |
live_performance40 columns · Videos & LIVEshow in diagram
One row per LIVE stream session (zero-sale sessions kept — session counts are a metric). Rates stored as fractions (0.0571 = 5.71%).
Primary key: live_id
| Column | Type | Key | Description |
|---|---|---|---|
| live_idPrimary key. | varchar(64) | PK | Primary key. |
| username | varchar(256) | ||
| title | varchar(500) | ||
| start_time | timestamp | ||
| end_time | timestamp | ||
| currency | varchar(8) | ||
| gmv | decimal(18,4) | ||
| gmv_24h | decimal(18,4) | ||
| sku_orders | integer | ||
| created_sku_orders | integer | ||
| items_sold | integer | ||
| customers | integer | ||
| avg_price | decimal(18,4) | ||
| click_to_order_rate | decimal(10,6) | ||
| products_added | integer | ||
| different_products_sold | integer | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. | |
| account_type | varchar(32) | ||
| creator_open_id | varchar(128) | ||
| creator_nick_name | varchar(256) | ||
| creator_author_type | varchar(32) | ||
| creator_country | varchar(8) | ||
| live_gmv | decimal(18,4) | ||
| live_indirect_gmv | decimal(18,4) | ||
| live_attributed_gmv | decimal(18,4) | ||
| live_attributed_orders | integer | ||
| live_attributed_sku_orders | integer | ||
| live_attributed_items_sold | integer | ||
| attributed_customers | integer | ||
| aov | decimal(18,4) | ||
| payment_rate | decimal(10,6) | ||
| products_sold | integer | ||
| gmv_with_tiktok_coupons | decimal(18,4) | ||
| live_auction_gmv | decimal(18,4) | ||
| live_auction_indirect_gmv | decimal(18,4) | ||
| live_auction_attributed_gmv | decimal(18,4) | ||
| live_auction_attributed_sku_orders | integer | ||
| live_auction_attributed_items_sold | integer | ||
| avg_live_auction_price | decimal(18,4) | ||
| data_updated_at | timestamp |
live_session_traffic35 columns · Videos & LIVEshow in diagram
LIVE traffic + engagement per session (Get Shop LIVE Performance List 202609 traffic / interaction_performance). Join live_id to live_performance for the session's times and sales. Ratio columns (ctr ... follow_rate) are raw decimals (0.0528 = 5.28%): ctr = product clicks / views, live_ctr = product clicks / product impressions. Engagement counts come back only for some account types (TikTok's rule).
Primary key: live_id
| Column | Type | Key | Description |
|---|---|---|---|
| live_idPrimary key. References live_performance.live_id. Redshift SORTKEY. | varchar(64) | PK FK | Primary key. References live_performance.live_id. Redshift SORTKEY. |
| account_type | varchar(32) | ||
| currency | varchar(8) | ||
| acu | integer | ||
| pcu | integer | ||
| viewers | bigint | ||
| views | bigint | ||
| impressions | bigint | ||
| impressions_per_hour | bigint | ||
| seconds per view | |||
| avg_viewing_duration | integer | ||
| seconds per viewer | |||
| avg_viewing_duration_per_viewer | integer | ||
| over_1m_views | bigint | ||
| over_1m_live_viewing_rate | decimal(10,6) | ||
| tap_through_rate | decimal(10,6) | ||
| product_impressions | bigint | ||
| product_clicks | bigint | ||
| products_added | integer | ||
| ctr | decimal(10,6) | ||
| live_ctr | decimal(10,6) | ||
| ctor | decimal(10,6) | ||
| ctor_sku_order | decimal(10,6) | ||
| order_rate_sku_orders | decimal(10,6) | ||
| gmv_per_hour | decimal(18,4) | ||
| LIVE-attributed GMV per 1,000 impressions | |||
| show_gpm | decimal(18,4) | ||
| watch_gpm | decimal(18,4) | ||
| comments | bigint | ||
| likes | bigint | ||
| shares | bigint | ||
| new_followers | bigint | ||
| comment_rate | decimal(10,6) | ||
| like_rate | decimal(10,6) | ||
| share_rate | decimal(10,6) | ||
| follow_rate | decimal(10,6) | ||
| TikTok's data update time, as returned (shop registered timezone, fixed offset without DST: UTC-8 for US shops) | |||
| data_updated_at | timestamp | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. | |
live_performance_daily18 columns · Videos & LIVEshow in diagram
LIVE totals per day, all accounts (Get Shop LIVE Performance Overview 202609). live_ctr = product clicks / product impressions, ctor_sku_order = attributed SKU orders / product clicks: raw decimals (0.0528 = 5.28%).
Primary key: date
| Column | Type | Key | Description |
|---|---|---|---|
| datePrimary key. Redshift SORTKEY. | date | PK | Primary key. Redshift SORTKEY. |
| currency | varchar(8) | ||
| live_gmv | decimal(18,4) | ||
| live_indirect_gmv | decimal(18,4) | ||
| live_attributed_gmv | decimal(18,4) | ||
| live_attributed_sku_orders | integer | ||
| live_attributed_items_sold | integer | ||
| live_auction_attributed_gmv | decimal(18,4) | ||
| live_auction_attributed_sku_orders | integer | ||
| live_auction_attributed_items_sold | integer | ||
| avg_live_auction_price | decimal(18,4) | ||
| views | bigint | ||
| seconds | |||
| avg_viewing_duration | integer | ||
| live_ctr | decimal(10,6) | ||
| ctor_sku_order | decimal(10,6) | ||
| show_gpm | decimal(18,4) | ||
| data_updated_at | timestamp | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. | |
live_product_performance21 columns · Videos & LIVEshow in diagram
Per-LIVE product breakdown (202512). Only the shop's OWN official/ marketing account lives have rows — affiliate creator lives return no data from TikTok. Join live_id to live_performance for session context.
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| live_idReferences live_performance.live_id. Redshift SORTKEY. | varchar(64) | FK | References live_performance.live_id. Redshift SORTKEY. |
| product_id | varchar(64) | ||
| product_name | varchar(1000) | ||
| currency | varchar(8) | ||
| direct_gmv | decimal(18,4) | ||
| avg_price | decimal(18,4) | ||
| sku_orders | integer | ||
| created_sku_orders | integer | ||
| main_orders | integer | ||
| customers | integer | ||
| items_sold | integer | ||
| payment_rate | decimal(10,6) | ||
| add_to_cart_count | integer | ||
| product_impressions | bigint | ||
| product_clicks | bigint | ||
| ctr | decimal(10,6) | ||
| main_order_ctor | decimal(10,6) | ||
| sku_order_ctor | decimal(10,6) | ||
| watch_gpm | decimal(18,4) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
bestselling_products10 columns · Bestsellers (platform-wide)show in diagram
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| time_slot | varchar(4) | ||
| rank | integer | ||
| product_id | varchar(64) | ||
| product_name | varchar(1000) | ||
| currency | varchar(8) | ||
| gmv_low | decimal(18,4) | ||
| gmv_high | decimal(18,4) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
bestselling_creators13 columns · Bestsellers (platform-wide)show in diagram
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| time_slot | varchar(4) | ||
| rank | integer | ||
| username | varchar(256) | ||
| nick_name | varchar(256) | ||
| open_id | varchar(128) | ||
| followers_count | bigint | ||
| likes_count | bigint | ||
| currency | varchar(8) | ||
| gmv_low | decimal(18,4) | ||
| gmv_high | decimal(18,4) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
bestselling_videos16 columns · Bestsellers (platform-wide)show in diagram
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| time_slot | varchar(4) | ||
| rank | integer | ||
| video_id | varchar(64) | ||
| nick_name | varchar(256) | ||
| duration_seconds | integer | ||
| likes | bigint | ||
| comments | bigint | ||
| publish_time | timestamp | ||
| top_product_id | varchar(64) | ||
| top_product_name | varchar(500) | ||
| currency | varchar(8) | ||
| gmv_low | decimal(18,4) | ||
| gmv_high | decimal(18,4) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
bestselling_lives15 columns · Bestsellers (platform-wide)show in diagram
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| time_slot | varchar(4) | ||
| rank | integer | ||
| live_id | varchar(64) | ||
| creator_name | varchar(256) | ||
| creator_nick_name | varchar(256) | ||
| open_id | varchar(128) | ||
| title | varchar(500) | ||
| start_time | timestamp | ||
| duration_seconds | integer | ||
| currency | varchar(8) | ||
| gmv_low | decimal(18,4) | ||
| gmv_high | decimal(18,4) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
finance_statements15 columns · Financeshow in diagram
One row per statement (a shop can get 2+ per day: orders + adjustments). Upsert key statement_id; re-pulled over a trailing window so payment status/payment_id updates land.
Primary key: statement_id
| Column | Type | Key | Description |
|---|---|---|---|
| statement_idPrimary key. | varchar(64) | PK | Primary key. |
| statement_time_utc | timestamp | ||
| statement_dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| currency | varchar(8) | ||
| settlement_amount | decimal(18,4) | ||
| revenue_amount | decimal(18,4) | ||
| net_sales_amount | decimal(18,4) | ||
| fee_amount | decimal(18,4) | ||
| shipping_cost_amount | decimal(18,4) | ||
| adjustment_amount | decimal(18,4) | ||
| payment_status | varchar(32) | ||
| payment_idReferences finance_payments.payment_id. | varchar(64) | FK | References finance_payments.payment_id. |
| payment_time_utc | timestamp | ||
| shop_id | varchar(64) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
finance_statement_transactions87 columns · Financeshow in diagram
One row per transaction in a statement: an ORDER settlement, an adjustment (type = the adjustment policy, e.g. CHARGE_BACK) or a RESERVE movement. Upsert key pk = md5(statement_id|transaction_id). Breakdown groups each sum to their parent amount: revenue_amount = gross_sales .. other_revenue_amount shipping_cost_amount = actual_shipping_fee .. other_shipping_amount fee_tax_amount = platform_commission .. other_tax_amount The "supplementary" columns are informational (TikTok reports them but they do not add into the settlement). breakdown_json keeps every non-zero breakdown value as returned, so new TikTok fee lines are never lost.
Primary key: pk
| Column | Type | Key | Description |
|---|---|---|---|
| pkPrimary key. | varchar(32) | PK | Primary key. |
| statement_idReferences finance_statements.statement_id. | varchar(64) | FK | References finance_statements.statement_id. |
| statement_time_utc | timestamp | ||
| statement_dateRedshift SORTKEY. | date | Redshift SORTKEY. | |
| transaction_id | varchar(64) | ||
| transaction_type | varchar(64) | ||
| order_idJoins to orders.order_id. Redshift DISTKEY. | varchar(64) | FK | Joins to orders.order_id. Redshift DISTKEY. |
| order_create_time_utc | timestamp | ||
| adjustment_id | varchar(64) | ||
| adjustment_order_id | varchar(64) | ||
| reserve_id | varchar(64) | ||
| reserve_status | varchar(32) | ||
| associated_order_id | varchar(64) | ||
| estimated_release_time_utc | timestamp | ||
| currency | varchar(8) | ||
| totals | |||
| settlement_amount | decimal(18,4) | ||
| revenue_amount | decimal(18,4) | ||
| shipping_cost_amount | decimal(18,4) | ||
| fee_tax_amount | decimal(18,4) | ||
| adjustment_amount | decimal(18,4) | ||
| reserve_amount | decimal(18,4) | ||
| revenue breakdown (sums to revenue_amount) | |||
| gross_sales_amount | decimal(18,4) | ||
| gross_sales_refund_amount | decimal(18,4) | ||
| seller_discount_amount | decimal(18,4) | ||
| seller_discount_refund_amount | decimal(18,4) | ||
| other_revenue_amount | decimal(18,4) | ||
| shipping breakdown (sums to shipping_cost_amount) | |||
| actual_shipping_fee_amount | decimal(18,4) | ||
| shipping_fee_discount_amount | decimal(18,4) | ||
| customer_paid_shipping_fee_amount | decimal(18,4) | ||
| return_shipping_fee_amount | decimal(18,4) | ||
| fbt_free_shipping_fee_amount | decimal(18,4) | ||
| fbt_fulfillment_fee_reimbursement_amount | decimal(18,4) | ||
| shipping_insurance_fee_amount | decimal(18,4) | ||
| signature_confirmation_fee_amount | decimal(18,4) | ||
| logistics_service_fee_amount | decimal(18,4) | ||
| other_shipping_amount | decimal(18,4) | ||
| shipping, informational (not addends): the TikTok Shop shipping incentive is part of shipping_fee_discount_amount | |||
| tts_shipping_incentive_amount | decimal(18,4) | ||
| fbt_fulfillment_fee_amount | decimal(18,4) | ||
| fbt_shipping_cost_amount | decimal(18,4) | ||
| fbm_shipping_cost_amount | decimal(18,4) | ||
| platform_shipping_fee_discount_amount | decimal(18,4) | ||
| seller_shipping_fee_discount_amount | decimal(18,4) | ||
| customer_shipping_fee_offset_amount | decimal(18,4) | ||
| fees + taxes (sum to fee_tax_amount) | |||
| platform_commission_amount | decimal(18,4) | ||
| referral_fee_amount | decimal(18,4) | ||
| refund_administration_fee_amount | decimal(18,4) | ||
| transaction_fee_amount | decimal(18,4) | ||
| credit_card_handling_fee_amount | decimal(18,4) | ||
| affiliate_commission_amount | decimal(18,4) | ||
| affiliate_partner_commission_amount | decimal(18,4) | ||
| affiliate_ads_commission_amount | decimal(18,4) | ||
| affiliate_commission_deposit_amount | decimal(18,4) | ||
| affiliate_commission_release_amount | decimal(18,4) | ||
| cofunded_creator_bonus_amount | decimal(18,4) | ||
| tap_shop_ads_commission_amount | decimal(18,4) | ||
| external_affiliate_marketing_fee_amount | decimal(18,4) | ||
| gmv_max_ad_fee_amount | decimal(18,4) | ||
| gmv_max_coupon_fee_amount | decimal(18,4) | ||
| smart_promotion_fee_amount | decimal(18,4) | ||
| campaign_period_fee_amount | decimal(18,4) | ||
| flash_sales_service_fee_amount | decimal(18,4) | ||
| sfp_service_fee_amount | decimal(18,4) | ||
| live_specials_fee_amount | decimal(18,4) | ||
| bonus_cashback_service_fee_amount | decimal(18,4) | ||
| voucher_xtra_service_fee_amount | decimal(18,4) | ||
| cofunded_promotion_service_fee_amount | decimal(18,4) | ||
| seller_growth_fee_amount | decimal(18,4) | ||
| epr_pob_service_fee_amount | decimal(18,4) | ||
| other_fee_amount | decimal(18,4) | ||
| sales_tax_on_fees_amount | decimal(18,4) | ||
| vat_amount | decimal(18,4) | ||
| import_vat_amount | decimal(18,4) | ||
| customs_duty_amount | decimal(18,4) | ||
| other_tax_amount | decimal(18,4) | ||
| supplementary (informational) | |||
| customer_payment_amount | decimal(18,4) | ||
| customer_refund_amount | decimal(18,4) | ||
| platform_discount_amount | decimal(18,4) | ||
| platform_discount_refund_amount | decimal(18,4) | ||
| seller_cofunded_discount_amount | decimal(18,4) | ||
| seller_cofunded_discount_refund_amount | decimal(18,4) | ||
| platform_cofunded_discount_amount | decimal(18,4) | ||
| platform_cofunded_discount_refund_amount | decimal(18,4) | ||
| sales_tax_amount | decimal(18,4) | ||
| retail_delivery_fee_amount | decimal(18,4) | ||
| breakdown_json | varchar(8000) | ||
| shop_id | varchar(64) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. | |
finance_payments14 columns · Financeshow in diagram
Payouts to the seller's bank account. Upsert key payment_id.
Primary key: payment_id
| Column | Type | Key | Description |
|---|---|---|---|
| payment_idPrimary key. | varchar(64) | PK | Primary key. |
| create_time_utcRedshift SORTKEY. | timestamp | Redshift SORTKEY. | |
| paid_time_utc | timestamp | ||
| status | varchar(32) | ||
| amount | decimal(18,4) | ||
| currency | varchar(8) | ||
| settlement_amount | decimal(18,4) | ||
| settlement_currency | varchar(8) | ||
| amount_before_exchange | decimal(18,4) | ||
| currency_before_exchange | varchar(8) | ||
| exchange_rate | decimal(18,6) | ||
| bank_account_last4 | varchar(4) | ||
| shop_id | varchar(64) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
finance_withdrawals8 columns · Financeshow in diagram
Seller balance movements: SETTLE (statement credited), WITHDRAW (payout), TRANSFER (platform subsidy/deduction), REVERSE (failed payout). Upsert key withdrawal_id.
Primary key: withdrawal_id
| Column | Type | Key | Description |
|---|---|---|---|
| withdrawal_idPrimary key. | varchar(64) | PK | Primary key. |
| withdrawal_type | varchar(32) | ||
| status | varchar(32) | ||
| amount | decimal(18,4) | ||
| currency | varchar(8) | ||
| create_time_utcRedshift SORTKEY. | timestamp | Redshift SORTKEY. | |
| shop_id | varchar(64) | ||
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
finance_unsettled_transactions32 columns · Financeshow in diagram
SNAPSHOT of transactions not yet settled (orders created since 2025-01-01), with TikTok's ESTIMATED amounts. Each run replaces the shop's rows (upsert key shop_id); once a transaction settles it leaves this table and appears in finance_statement_transactions with final amounts.
Primary key: shop_id, order_id
| Column | Type | Key | Description |
|---|---|---|---|
| transaction_id | varchar(64) | ||
| transaction_type | varchar(64) | ||
| status | varchar(32) | ||
| order_idPrimary key (with shop_id). Joins to orders.order_id. | varchar(64) | PK FK | Primary key (with shop_id). Joins to orders.order_id. |
| adjustment_id | varchar(64) | ||
| adjustment_order_id | varchar(64) | ||
| order_create_time_utcRedshift SORTKEY. | timestamp | Redshift SORTKEY. | |
| order_delivery_time_utc | timestamp | ||
| estimated_settlement_time_utc | timestamp | ||
| estimated_settlement_note | varchar(256) | ||
| unsettled_reason | varchar(512) | ||
| currency | varchar(8) | ||
| est_settlement_amount | decimal(18,4) | ||
| est_revenue_amount | decimal(18,4) | ||
| est_shipping_cost_amount | decimal(18,4) | ||
| est_fee_tax_amount | decimal(18,4) | ||
| est_adjustment_amount | decimal(18,4) | ||
| gross_sales_amount | decimal(18,4) | ||
| gross_sales_refund_amount | decimal(18,4) | ||
| seller_discount_amount | decimal(18,4) | ||
| seller_discount_refund_amount | decimal(18,4) | ||
| actual_shipping_fee_amount | decimal(18,4) | ||
| shipping_fee_discount_amount | decimal(18,4) | ||
| customer_paid_shipping_fee_amount | decimal(18,4) | ||
| platform_commission_amount | decimal(18,4) | ||
| referral_fee_amount | decimal(18,4) | ||
| affiliate_commission_amount | decimal(18,4) | ||
| affiliate_partner_commission_amount | decimal(18,4) | ||
| affiliate_ads_commission_amount | decimal(18,4) | ||
| breakdown_json | varchar(8000) | ||
| shop_idPrimary key (with order_id). | varchar(64) | PK | Primary key (with order_id). |
| _synced_atWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |