# Field Reference for TikTok Dashboard
## Base Information
- **App Token:** C8kmbTsqoa6rBesTKRpl8nV8gHd
- **Table Name:** TikTok L'AURA - Candle
- **Table ID:** tblG4uuUvbwfvI9Z
- **Total Records:** 150 videos
---
## All Available Fields
### Core Identification
| Field Name | Field ID | Type | Description |
|------------|----------|------|-------------|
| Unique identifier of the video | fldWR2MPmy | Text | Video ID (Primary Key) |
| Video description | fldTYPTyrE | Text | Title/Caption of video |
| SourceID | fldx9EPXGe | Text | Internal source tracking |
### Visual Content
| Field Name | Field ID | Type | Description |
|------------|----------|------|-------------|
| Thumb | fld7Kfj5sJ | Attachment | Video thumbnail image |
| Temporary URL for video content thumbnail | fld0EIaZ4W | URL | Thumbnail download link |
| Temporary URL for video content thumbnail Copy 2 | fldDINlthD | Text | Alternative thumbnail URL |
| Embeddable link for this TikTok video | fldiCU048H | URL | Embed URL |
| Shareable URL for this TikTok video | fldZSRhihy | URL | Share link |
### Engagement Metrics
| Field Name | Field ID | Type | Description |
|------------|----------|------|-------------|
| Total video views | fldeoEgncF | Number | Total view count |
| Total number of likes the video received | fld9Ia5NyA | Number | Like count |
| Total number of comments the video received | fldA7KsvS0 | Number | Comment count |
| Total number of times the video was shared | fldCHRC0zF | Number | Share count |
### Watch Time Metrics
| Field Name | Field ID | Type | Description |
|------------|----------|------|-------------|
| Video duration in seconds, rounded to three decimal places | fld7mOVtsw | Number | Video length in seconds |
| Average video play duration based on all views | fld6ZCGoyZ | Number | Avg watch time per view |
| Total video play duration based on all views | flda0kSAp9 | Number | Total watch time across all views |
| Percentage of video watched completely | fldk3ras90 | Number (%) | Completion rate |
| Total number of viewers who watched the video (deduplicated) | fldlEzIJGW | Number | Unique viewer count |
### Temporal & Geographic
| Field Name | Field ID | Type | Description |
|------------|----------|------|-------------|
| Date and time the video was published | fld2CwiQ2Z | DateTime | Publication timestamp |
| Different sources of video exposure, arranged by exposure percentage from high to low | fldhmbTyvi | Text | Traffic sources breakdown |
| Breakdown percentage data of audience country/region | fldPK8hwmN | Text | Geographic distribution |
---
## Key Metrics for Dashboard
### Primary KPIs (Show as Metric Cards)
```
1. Total Views: SUM(fldeoEgncF)
2. Total Likes: SUM(fld9Ia5NyA)
3. Total Comments: SUM(fldA7KsvS0)
4. Total Shares: SUM(fldCHRC0zF)
5. Average Watch %: AVG(fldk3ras90)
```
### Calculated Metrics (Create in Dashboard)
```
Engagement Rate = (Likes + Comments + Shares) / Views * 100
Virality Score = (Shares / Views) * 100
Like Rate = (Likes / Views) * 100
Comment Rate = (Comments / Views) * 100
Watch Time per View = Total Watch Time / Total Views
```
### Time-based Analysis
```
X-Axis: Date and time the video was published (fld2CwiQ2Z)
Group by: Day, Week, or Month
Useful for trend charts
```
### Performance Segmentation
```
High Performers: Views > 10,000
Medium Performers: 1,000 ≤ Views ≤ 10,000
Low Performers: Views < 1,000
```
---
## Dashboard Chart Field Mappings
### Chart 1: Performance Summary Cards
```yaml
Card 1 - Total Views:
Field: fldeoEgncF
Aggregation: SUM
Format: #,##0
Card 2 - Total Likes:
Field: fld9Ia5NyA
Aggregation: SUM
Format: #,##0
Card 3 - Total Comments:
Field: fldA7KsvS0
Aggregation: SUM
Format: #,##0
Card 4 - Total Shares:
Field: fldCHRC0zF
Aggregation: SUM
Format: #,##0
Card 5 - Avg Watch %:
Field: fldk3ras90
Aggregation: AVERAGE
Format: 0.00%
```
### Chart 2: Views & Engagement Trends
```yaml
Type: Line Chart
X-Axis:
Field: fld2CwiQ2Z (Date and time the video was published)
Group: Daily or Weekly
Y-Axis (Primary):
Field: fldeoEgncF (Total video views)
Aggregation: SUM
Y-Axis (Secondary):
Field: fld9Ia5NyA (Likes)
Aggregation: SUM
```
### Chart 3: Top 10 Videos
```yaml
Type: Horizontal Bar Chart
X-Axis:
Field: fldTYPTyrE (Video description)
Limit: 10
Sort: By total views DESC
Y-Axis:
Field: fldeoEgncF (Total video views)
Aggregation: SUM
Color:
Field: fldk3ras90 (Watch %)
Scale: Gradient (red to green)
```
### Chart 4: Duration vs Completion
```yaml
Type: Scatter Plot
X-Axis:
Field: fld7mOVtsw (Duration in seconds)
Y-Axis:
Field: fldk3ras90 (Watch % complete)
Bubble Size:
Field: fldeoEgncF (Total views)
Color:
Field: fld9Ia5NyA (Likes)
Scale: Intensity
```
### Chart 5: Engagement Breakdown
```yaml
Type: Stacked Bar Chart
X-Axis:
Field: fldTYPTyrE (Video description)
Limit: 15
Sort: By views DESC
Y-Axis (Stacked):
- Field: fld9Ia5NyA (Likes)
- Field: fldA7KsvS0 (Comments)
- Field: fldCHRC0zF (Shares)
Legend: Show each metric type
```
### Chart 6: Watch Time Analysis
```yaml
Type: Column Chart
X-Axis:
Field: fld2CwiQ2Z (Date)
Group: Weekly
Y-Axis:
Field: flda0kSAp9 (Total watch time)
Aggregation: SUM
Format: Hours (divide by 3600)
```
### Chart 7: Performance Distribution
```yaml
Type: Pie Chart
Segments:
- High (Views > 10,000)
- Medium (1,000-10,000)
- Low (< 1,000)
Value: COUNT of videos
Labels: Show percentage and count
```
### Chart 8: Recent Performance Table
```yaml
Type: Table
Columns:
1. fldTYPTyrE (Description) - 50 char max
2. fld2CwiQ2Z (Published Date)
3. fldeoEgncF (Views)
4. fld9Ia5NyA (Likes)
5. fldA7KsvS0 (Comments)
6. fldk3ras90 (Watch %)
Filter: Last 30 days
Sort: Date DESC
Limit: 20 rows
```
---
## Field Format Guide
### Number Fields (Apply in Lark)
```
Views: #,##0 (e.g., 12,345)
Likes: #,##0 (e.g., 1,234)
Comments: #,##0 (e.g., 567)
Shares: #,##0 (e.g., 89)
Duration: 0.000 (e.g., 45.678 seconds)
Watch %: 0.00% (e.g., 75.32%)
Watch Time: #,##0.00 (e.g., 1,234.56)
```
### DateTime Format
```
Format: yyyy-MM-dd HH:mm
Example: 2024-12-09 14:30
For charts: Group by Day, Week, or Month
```
### Text Fields
```
Video ID: Full text (no truncation)
Description: Truncate to 50-100 chars for charts
URLs: Display as clickable links
```
---
## Data Quality Notes
### Current Data (150 Videos)
- All numeric fields are properly formatted
- DateTime field uses: yyyy-MM-dd HH:mm format
- Percentage field (Watch %) already formatted as percentage
- No missing primary keys (all videos have unique IDs)
### Recommendations
1. **Thumbnail field (Thumb):** Can be used in gallery view or tooltips
2. **URL fields:** Use for drill-through to actual videos
3. **Geographic data:** Parse text field for country-level analytics
4. **Traffic sources:** Parse text field for source attribution
---
## API Access (For Advanced Users)
### Fetch All Records
```bash
GET /open-apis/bitable/v1/apps/C8kmbTsqoa6rBesTKRpl8nV8gHd/tables/tblG4uuUvbwfvI9Z/records
```
### Search with Filters
```bash
POST /open-apis/bitable/v1/apps/C8kmbTsqoa6rBesTKRpl8nV8gHd/tables/tblG4uuUvbwfvI9Z/records/search
Body:
{
"field_names": ["fldeoEgncF", "fld9Ia5NyA", "fldTYPTyrE"],
"filter": {
"conjunction": "and",
"conditions": [{
"field_name": "Total video views",
"operator": "isGreater",
"value": [10000]
}]
}
}
```
---
## Quick Copy-Paste Field Names
For quick dashboard creation, copy these exact field names:
```
Unique identifier of the video
Video description
Total video views
Total number of likes the video received
Total number of comments the video received
Total number of times the video was shared
Video duration in seconds, rounded to three decimal places
Date and time the video was published
Percentage of video watched completely
Average video play duration based on all views
Total video play duration based on all views
Total number of viewers who watched the video (deduplicated)
```
---
## Color Scheme Recommendations
### Performance Indicators
- High Performance (>10k views): #10B981 (Green)
- Medium Performance (1k-10k): #F59E0B (Amber)
- Low Performance (<1k): #EF4444 (Red)
### Engagement Metrics
- Views: #3B82F6 (Blue)
- Likes: #EC4899 (Pink)
- Comments: #8B5CF6 (Purple)
- Shares: #14B8A6 (Teal)
### Watch Metrics
- High Watch % (>75%): #10B981 (Green)
- Medium Watch % (50-75%): #F59E0B (Amber)
- Low Watch % (<50%): #EF4444 (Red)
---
This reference guide contains all the field mappings you need to create a comprehensive TikTok analytics dashboard in Lark Base.
