> For the complete documentation index, see [llms.txt](https://docs.intentwise.com/iac-source-data/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.intentwise.com/iac-source-data/tiktok-source-data/tiktok-shop-reports/performance-reports.md). # Performance reports ## Performance reports Schema Name - tiktok\_source\_data ### Product performance Table Name: `tiktok_shop_product_performance` | Column Name | Data type | Description | | -------------------- | --------- | ----------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `product_id` | String | Product identifier | | `downloaded_date` | Date | Date the data was downloaded | | `gmv_amount` | Numeric | Gross merchandise value for this product | | `gmv_currency` | String | Currency code for GMV | | `orders` | Integer | Orders containing this product | | `units_sold` | Integer | Units sold | | `click_through_rate` | Numeric | Product click-through rate | | `report_date` | Date | Date of the performance data | | `download_time` | DateTime | Timestamp when the record was ingested | ### SKU performance Table Name: `tiktok_shop_sku_performance` | Column Name | Data type | Description | | ----------------- | --------- | ----------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `sku_id` | String | SKU identifier | | `product_id` | String | Product identifier for this SKU | | `downloaded_date` | Date | Date the data was downloaded | | `gmv_amount` | Numeric | Gross merchandise value for this SKU | | `gmv_currency` | String | Currency code for GMV | | `sku_orders` | Integer | Number of SKU orders | | `units_sold` | Integer | Units sold | | `report_date` | Date | Date of the performance data | | `download_time` | DateTime | Timestamp when the record was ingested | ### Live overview Table Name: `tiktok_shop_live_overview` | Column Name | Data type | Description | | ----------------------- | --------- | ------------------------------------------ | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `downloaded_date` | Date | Date the data was downloaded | | `report_date` | Date | Date of the live shopping summary | | `gmv_amount` | Numeric | GMV from live streams | | `gmv_currency` | String | Currency code for GMV | | `sku_orders` | Integer | SKU orders from live streams | | `customers` | Integer | Unique customers from live streams | | `units_sold` | Integer | Units sold through live streams | | `click_to_order_rate` | Numeric | Click-to-order conversion rate | | `click_through_rate` | Numeric | Product click-through rate in live streams | | `latest_available_date` | Date | Latest available live-data date | | `download_time` | DateTime | Timestamp when the record was ingested | ### Video overview Table Name: `tiktok_shop_video_overview` | Column Name | Data type | Description | | ----------------------- | --------- | -------------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `downloaded_date` | Date | Date the data was downloaded | | `report_date` | Date | Date of the video shopping summary | | `gmv_amount` | Numeric | GMV from shoppable videos | | `gmv_currency` | String | Currency code for GMV | | `click_through_rate` | Numeric | Average product click-through rate in videos | | `sku_orders` | Integer | SKU orders from shoppable videos | | `units_sold` | Integer | Units sold through shoppable videos | | `latest_available_date` | Date | Latest available video-data date | | `download_time` | DateTime | Timestamp when the record was ingested | ### Customer service performance Table Name: `tiktok_shop_customer_service_performance` | Column Name | Data type | Description | | ------------------------- | --------- | ----------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `downloaded_date` | Date | Date the data was downloaded | | `support_session_count` | Integer | Number of customer support sessions | | `response_percentage` | Numeric | Messages responded to within SLA | | `satisfaction_percentage` | Numeric | Customer satisfaction rate | | `response_time_mins` | Numeric | Average first-response time in minutes | | `report_date` | Date | Date of the performance report | | `download_time` | DateTime | Timestamp when the record was ingested | ### Live performance Table Name: `tiktok_shop_live_performance` | Column Name | Data type | Description | | ------------------------- | --------- | ----------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `live_id` | String | Live stream session identifier | | `downloaded_date` | Date | Date the data was downloaded | | `title` | String | Live stream title | | `username` | String | Streamer's TikTok username | | `start_time` | DateTime | Live stream start time | | `end_time` | DateTime | Live stream end time | | `gmv_amount` | Numeric | Gross merchandise value | | `gmv_currency` | String | Currency code for GMV | | `products_added` | Integer | Products added to the live stream | | `different_products_sold` | Integer | Distinct products sold | | `created_sku_orders` | Integer | SKU orders created during the stream | | `sku_orders` | Integer | Total SKU orders | | `unit_sold` | Integer | Units sold | | `customers` | Integer | Unique purchasing customers | | `avg_price_amount` | Numeric | Average selling price | | `avg_price_currency` | String | Currency code for average price | | `click_to_order_rate` | Numeric | Click-to-order conversion rate | | `live_gmv_24h_amount` | Numeric | GMV attributed within 24 hours | | `live_gmv_24h_currency` | String | Currency code for 24-hour GMV | | `acu` | Integer | Average concurrent users | | `pcu` | Integer | Peak concurrent users | | `viewers` | Integer | Unique viewers | | `views` | Integer | Total views | | `avg_viewing_duration` | Integer | Average viewing duration in seconds | | `comments` | Integer | Comments | | `shares` | Integer | Shares | | `likes` | Integer | Likes | | `new_followers` | Integer | New followers | | `product_impressions` | Integer | Product impressions | | `product_clicks` | Integer | Product clicks | | `click_through_rate` | Numeric | Product click-through rate | | `report_date` | Date | Date of the performance data | | `download_time` | DateTime | Timestamp when the record was ingested | ### Global warehouses Table Name: `tiktok_shop_logistics_global_warehouses` | Column Name | Data type | Description | | --------------------- | --------- | ----------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `global_warehouse_id` | String | Global warehouse identifier | | `downloaded_date` | Date | Date the data was downloaded | | `name` | String | Global warehouse name | | `ownership` | String | Warehouse ownership type | | `download_time` | DateTime | Timestamp when the record was ingested | ### Performance intervals Table Name: `tiktok_shop_performance_intervals` | Column Name | Data type | Description | | --------------------------- | --------- | ----------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `downloaded_date` | Date | Date the data was downloaded | | `report_date` | Date | Date of the performance interval | | `gmv_amount` | Numeric | Gross merchandise value | | `gmv_currency` | String | Currency code for GMV | | `sku_orders` | Integer | SKU orders | | `orders` | Integer | Orders | | `avg_order_value_amount` | Numeric | Average order value | | `avg_order_value_currency` | String | Currency code for average order value | | `units_sold` | Integer | Units sold | | `buyers` | Integer | Unique buyers | | `product_impressions` | Integer | Product impressions | | `product_page_views` | Integer | Product page views | | `avg_product_page_visitors` | Integer | Average daily visitors | | `cancellations_and_returns` | Integer | Cancellations and returns | | `refunds_amount` | Numeric | Total refund amount | | `refunds_currency` | String | Currency code for refunds | | `latest_available_date` | Date | Latest available data date | | `download_time` | DateTime | Timestamp when the record was ingested | ### Average product page visitor breakdowns Table Name: `tiktok_shop_performance_avg_product_page_visitor_breakdowns` | Column Name | Data type | Description | | ----------------- | --------- | ----------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `downloaded_date` | Date | Date the data was downloaded | | `report_date` | Date | Date of the performance data | | `breakdown_type` | String | Traffic source breakdown type | | `amount` | Integer | Average product page visitors | | `download_time` | DateTime | Timestamp when the record was ingested | ### Buyer breakdowns Table Name: `tiktok_shop_performance_buyer_breakdowns` | Column Name | Data type | Description | | ----------------- | --------- | ----------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `downloaded_date` | Date | Date the data was downloaded | | `report_date` | Date | Date of the performance data | | `breakdown_type` | String | Buyer segment | | `amount` | Integer | Buyers in this segment | | `download_time` | DateTime | Timestamp when the record was ingested | ### GMV breakdowns Table Name: `tiktok_shop_performance_gmv_breakdowns` | Column Name | Data type | Description | | ----------------- | --------- | ----------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `downloaded_date` | Date | Date the data was downloaded | | `report_date` | Date | Date of the performance data | | `breakdown_type` | String | GMV channel | | `amount` | Numeric | GMV for this channel | | `currency` | String | Currency code | | `download_time` | DateTime | Timestamp when the record was ingested | ### Product impression breakdowns Table Name: `tiktok_shop_performance_product_impression_breakdowns` | Column Name | Data type | Description | | ----------------- | --------- | ----------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `downloaded_date` | Date | Date the data was downloaded | | `report_date` | Date | Date of the performance data | | `breakdown_type` | String | Impression source | | `amount` | Integer | Product impressions | | `download_time` | DateTime | Timestamp when the record was ingested | ### Product page view breakdowns Table Name: `tiktok_shop_performance_product_page_view_breakdowns` | Column Name | Data type | Description | | ----------------- | --------- | ----------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `downloaded_date` | Date | Date the data was downloaded | | `report_date` | Date | Date of the performance data | | `breakdown_type` | String | Page-view source | | `amount` | Integer | Product page views | | `download_time` | DateTime | Timestamp when the record was ingested | ### Warehouses Table Name: `tiktok_shop_logistics_warehouses` | Column Name | Data type | Description | | --------------------------------- | --------- | ----------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier (distribution key) | | `open_id` | String | TikTok user open ID | | `warehouse_id` | String | Warehouse identifier | | `downloaded_date` | Date | Date the data was downloaded | | `entity_id` | String | Business entity identifier | | `name` | String | Warehouse name | | `effect_status` | String | Warehouse effective status | | `type` | String | Warehouse type | | `sub_type` | String | Warehouse sub-type | | `is_default` | Boolean | Whether this is the default warehouse | | `address_region` | String | Country or region | | `address_state` | String | State or province | | `address_city` | String | City | | `address_district` | String | District | | `address_town` | String | Town | | `address_contact_person` | String | Contact person | | `address_first_name` | String | Contact first name | | `address_last_name` | String | Contact last name | | `address_first_name_local_script` | String | Contact first name in local script | | `address_last_name_local_script` | String | Contact last name in local script | | `address_postal_code` | String | Postal code | | `address_full_address` | String | Full warehouse address | | `address_region_code` | String | Country or region code | | `address_phone_number` | String | Contact phone number | | `address_address_line1` | String | Address line 1 | | `address_address_line2` | String | Address line 2 | | `address_address_line3` | String | Address line 3 | | `address_address_line4` | String | Address line 4 | | `address_geolocation_latitude` | Numeric | GPS latitude | | `address_geolocation_longitude` | Numeric | GPS longitude | | `download_time` | DateTime | Timestamp when the record was ingested | ### Performance summary Table Name: `tiktok_shop_performance_summary` | Column Name | Data type | Description | | ------------------------------------------------- | --------- | --------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier | | `open_id` | String | TikTok user open ID | | `start_date_ge` | Date | Inclusive summary start date | | `end_date_lt` | Date | Exclusive summary end date | | `granularity` | String | Summary granularity | | `with_comparison` | Boolean | Whether comparison data is included | | `currency` | String | Currency code for monetary values | | `latest_available_date` | Date | Latest available data date | | `performance_gmv_amount` | Numeric | Gross merchandise value | | `performance_gmv_currency` | String | Currency code for GMV | | `performance_gmv_breakdowns` | String | GMV breakdown by channel | | `performance_sku_orders` | Integer | Number of SKU orders | | `performance_orders` | Integer | Number of orders | | `performance_avg_order_value_amount` | Numeric | Average order value | | `performance_avg_order_value_currency` | String | Currency code for average order value | | `performance_units_sold` | Integer | Total units sold | | `performance_buyers` | Integer | Number of unique buyers | | `performance_buyer_breakdowns` | String | Buyer breakdown by type | | `performance_product_impressions` | Integer | Number of product impressions | | `performance_product_impression_breakdowns` | String | Impression breakdown by channel | | `performance_product_page_views` | Integer | Number of product page views | | `performance_product_page_view_breakdowns` | String | Page-view breakdown by channel | | `performance_avg_product_page_visitors` | Integer | Average daily product page visitors | | `performance_avg_product_page_visitor_breakdowns` | String | Visitor breakdown by channel | | `performance_refunds_amount` | Numeric | Total refund amount | | `performance_refunds_currency` | String | Currency code for refunds | | `performance_cancellations_and_returns` | Integer | Total cancellations and returns | | `performance_raw` | String | Full raw API response | | `downloaded_date` | Date | Date the data was downloaded | | `download_time` | DateTime | Timestamp when the record was ingested | ### Video performance Table Name: `tiktok_shop_video_performance` | Column Name | Data type | Description | | -------------------- | --------- | ----------------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier | | `open_id` | String | TikTok user open ID | | `video_id` | String | TikTok video identifier | | `downloaded_date` | Date | Date the data was downloaded | | `title` | String | Video title or caption | | `username` | String | Video creator's TikTok username | | `video_post_time` | String | Timestamp when the video was posted | | `gmv_amount` | Numeric | Gross merchandise value attributed to the video | | `gmv_currency` | String | Currency code for GMV | | `sku_orders` | Integer | Number of SKU orders | | `units_sold` | Integer | Units sold | | `views` | Integer | Total video views | | `click_through_rate` | Numeric | Product click-through rate | | `report_date` | Date | Date of the performance data | | `download_time` | DateTime | Timestamp when the record was ingested | ### Video performance products Table Name: `tiktok_shop_video_performance_products` | Column Name | Data type | Description | | ----------------- | --------- | --------------------------------------- | | `account_id` | Integer | Intentwise Account Identifier | | `account_name` | String | Intentwise Display Name for the account | | `shop_id` | String | TikTok Shop identifier | | `open_id` | String | TikTok user open ID | | `video_id` | String | TikTok video identifier | | `downloaded_date` | Date | Date the data was downloaded | | `product_id` | String | Tagged product identifier | | `product_name` | String | Tagged product name | | `download_time` | DateTime | Timestamp when the record was ingested |