Schema · Entity relationship diagram
Cruva tables and relationships
TikTok Shop affiliate performance from Cruva: daily shop stats (GMV, units, videos, views, commission) plus daily snapshots of creator, video and product performance.
ConnectPaste an API key
Default schema
cruvaSource API docscruva.com
DestinationsAmazon Redshift, Google BigQuery, Snowflake, PostgreSQL, Amazon S3
shop_stats_dailyis long format: one row per shop, day and metric.- Creator, video and product tables are daily snapshots of Cruva's rolling 7-day window (one per
load_date).
Primary keyForeign keyReferencesJoins on (not a key)
Drag to pan, scroll or pinch to zoom, click a table to see what it joins to.
Table reference
4 tables · click a table for its columnsshop_stats_daily11 columnsshow in diagram
Primary key: _jsdata_key
| Column | Type | Key | Description |
|---|---|---|---|
| _jsdata_keyPrimary key. | varchar(32) | PK | Primary key. |
| shop_id | varchar(64) | ||
| stat_date | date | ||
| metric_key | varchar(64) | ||
| metric_title | varchar(256) | ||
| count | decimal(20,4) | ||
| total_count | decimal(20,4) | ||
| window_from | date | ||
| window_to | date | ||
| load_date | date | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
creator_performance43 columnsshow in diagram
Primary key: _jsdata_key
| Column | Type | Key | Description |
|---|---|---|---|
| _jsdata_keyPrimary key. | varchar(32) | PK | Primary key. |
| shop_id | varchar(64) | ||
| load_date | date | ||
| window_from | date | ||
| window_to | date | ||
| creator_oecuid | varchar(128) | ||
| handle | varchar(256) | ||
| nickname | varchar(512) | ||
| msg_name | varchar(256) | ||
| gmv | decimal(20,4) | ||
| commission | decimal(20,4) | ||
| units_sold | bigint | ||
| units_sold_range | varchar(64) | ||
| views | bigint | ||
| likes | bigint | ||
| comments | bigint | ||
| video_count | bigint | ||
| live_count | bigint | ||
| video_avg_view_cnt | decimal(20,4) | ||
| video_engagement | decimal(20,4) | ||
| engagement_rate | decimal(20,6) | ||
| conversion_rate | decimal(20,6) | ||
| avg_gmv_per_view | decimal(20,6) | ||
| avg_order_value | decimal(20,4) | ||
| post_rate | decimal(20,6) | ||
| follower_cnt | bigint | ||
| med_gmv_revenue | decimal(20,4) | ||
| med_gmv_revenue_range | varchar(64) | ||
| is_fast_growing | boolean | ||
| age | varchar(64) | ||
| gender | varchar(64) | ||
| race | varchar(64) | ||
| language | varchar(64) | ||
| economic_status | varchar(64) | ||
| body_type | varchar(64) | ||
| face_visibility | varchar(64) | ||
| tone | varchar(64) | ||
| top_follower_gender | varchar(64) | ||
| top_follower_ages | varchar(1024) | ||
| category | varchar(2048) | ||
| tags | varchar(4096) | ||
| bio | varchar(4096) | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
video_performance33 columnsshow in diagram
Primary key: _jsdata_key
| Column | Type | Key | Description |
|---|---|---|---|
| _jsdata_keyPrimary key. | varchar(32) | PK | Primary key. |
| shop_id | varchar(64) | ||
| load_dateJoins to product_performance.product_id,load_date. Joins to creator_performance.handle,load_date. | date | FK | Joins to product_performance.product_id,load_date. Joins to creator_performance.handle,load_date. |
| window_from | date | ||
| window_to | date | ||
| video_id | varchar(64) | ||
| handleJoins to creator_performance.handle,load_date. | varchar(256) | FK | Joins to creator_performance.handle,load_date. |
| title | varchar(4096) | ||
| post_time | date | ||
| product_idJoins to product_performance.product_id,load_date. | varchar(64) | FK | Joins to product_performance.product_id,load_date. |
| products | varchar(65535) | ||
| campaign_id | varchar(64) | ||
| gmv | decimal(20,4) | ||
| commission | decimal(20,4) | ||
| units_sold | bigint | ||
| views | bigint | ||
| likes | bigint | ||
| comments | bigint | ||
| ctr | decimal(20,6) | ||
| roi | decimal(20,6) | ||
| cpa | decimal(20,4) | ||
| ad_spend | decimal(20,4) | ||
| engagement_rate | decimal(20,6) | ||
| conversion_rate | decimal(20,6) | ||
| avg_gmv_per_view | decimal(20,6) | ||
| avg_order_value | decimal(20,4) | ||
| video_link | varchar(1024) | ||
| expiration_date | varchar(64) | ||
| usage_rights_id | varchar(64) | ||
| content_overview | varchar(65535) | ||
| transcript | varchar(65535) | ||
| hooks | varchar(65535) | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
product_performance18 columnsshow in diagram
Primary key: _jsdata_key
| Column | Type | Key | Description |
|---|---|---|---|
| _jsdata_keyPrimary key. | varchar(32) | PK | Primary key. |
| shop_id | varchar(64) | ||
| load_date | date | ||
| window_from | date | ||
| window_to | date | ||
| product_id | varchar(64) | ||
| product_name | varchar(2048) | ||
| price | decimal(20,4) | ||
| status | integer | ||
| is_open_plan | boolean | ||
| total_gmv | decimal(20,4) | ||
| affiliate_gmv | decimal(20,4) | ||
| video_gmv | decimal(20,4) | ||
| live_gmv | decimal(20,4) | ||
| shop_tab_gmv | decimal(20,4) | ||
| shop_tab_impressions | bigint | ||
| units_sold | bigint | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |