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