# TikTok Analytics Dashboard Configuration Guide
## Overview
This document provides step-by-step instructions to create a comprehensive TikTok analytics dashboard in Lark Bitable.
## Database Information
- **App Token**: `C8kmbTsqoa6rBesTKRpl8nV8gHd`
- **Table ID**: `tblG4uuUvbwfvI9Z` (TikTok L'AURA - Candle)
- **Existing Dashboard**: `blkxYx6MmEeujy0v`
- **Records**: 150 TikTok videos
## Field Names Reference
Based on the TikTok data structure, the table contains these key fields:
- `Unique identifier of the video` - Video ID
- `Date and time the video was published` - Publication date
- `Total video views` - View count
- `Total number of likes the video received` - Like count
- `Total number of comments the video received` - Comment count
- `Total number of times the video was shared` - Share count
- `Percentage of video watched completely` - Watch completion rate
- `Video description` - Description text
- `Duration of the video in seconds` - Video length
---
## Dashboard Layout
### Section 1: KPI Overview Cards (Top Row)
#### Card 1: Total Views
**Block Type**: Metrics Card
- **Title**: "Total Views"
- **Data Source**: Table `tblG4uuUvbwfvI9Z`
- **Field**: `Total video views`
- **Aggregation**: SUM
- **Number Format**:
- Show thousands separator
- No decimals
- Suffix: " views"
- **Icon**: Eye or chart icon
- **Position**: Top-left
- **Size**: 1x1 grid cell
#### Card 2: Total Likes
**Block Type**: Metrics Card
- **Title**: "Total Engagement"
- **Data Source**: Table `tblG4uuUvbwfvI9Z`
- **Field**: `Total number of likes the video received`
- **Aggregation**: SUM
- **Number Format**:
- Show thousands separator
- No decimals
- Icon: Heart
- **Position**: Top, second from left
- **Size**: 1x1 grid cell
#### Card 3: Total Videos
**Block Type**: Metrics Card
- **Title**: "Total Videos"
- **Data Source**: Table `tblG4uuUvbwfvI9Z`
- **Field**: Any field (use record count)
- **Aggregation**: COUNT
- **Number Format**:
- No decimals
- Suffix: " videos"
- **Position**: Top, third from left
- **Size**: 1x1 grid cell
#### Card 4: Average Watch Rate
**Block Type**: Metrics Card
- **Title**: "Avg Watch Rate"
- **Data Source**: Table `tblG4uuUvbwfvI9Z`
- **Field**: `Percentage of video watched completely`
- **Aggregation**: AVERAGE
- **Number Format**:
- 1 decimal place
- Suffix: "%"
- **Position**: Top-right
- **Size**: 1x1 grid cell
---
### Section 2: Performance Trend (Second Row)
#### Chart 1: Video Performance Over Time
**Block Type**: Line Chart
- **Title**: "Views & Engagement Over Time"
- **Data Source**: Table `tblG4uuUvbwfvI9Z`
- **X-Axis Configuration**:
- Field: `Date and time the video was published`
- Type: Date/Time
- Group by: Day or Week (depending on data range)
- Sort: Ascending (oldest to newest)
- **Y-Axis Configuration** (Primary):
- Field: `Total video views`
- Aggregation: SUM
- Label: "Total Views"
- Color: Blue (#1890ff)
- **Y-Axis Configuration** (Secondary - Optional):
- Field: `Total number of likes the video received`
- Aggregation: SUM
- Label: "Total Likes"
- Color: Red (#ff4d4f)
- **Chart Options**:
- Show data labels: No (too crowded)
- Show grid lines: Yes
- Show legend: Yes
- Line style: Smooth curve
- Fill area under line: Optional (light transparency)
- **Position**: Below KPI cards
- **Size**: Full width, 2 rows height
---
### Section 3: Top Performers (Third Row)
#### Chart 2: Top 10 Videos by Views
**Block Type**: Horizontal Bar Chart
- **Title**: "Top 10 Videos by Views"
- **Data Source**: Table `tblG4uuUvbwfvI9Z`
- **X-Axis Configuration**:
- Field: `Total video views`
- Aggregation: SUM (or use raw value if showing individual videos)
- Label: "Views"
- **Y-Axis Configuration**:
- Field: `Video description` OR `Unique identifier of the video`
- Type: Text
- Note: Truncate long descriptions to 50 characters
- **Chart Options**:
- Sort: Descending by views
- Limit: Top 10 records
- Bar color: Gradient from light to dark blue
- Show values on bars: Yes
- Show grid lines: Yes
- **Position**: Left side of third row
- **Size**: Half width, 2-3 rows height
#### Chart 3: Engagement Distribution
**Block Type**: Pie Chart or Donut Chart
- **Title**: "Engagement Breakdown"
- **Data Source**: Table `tblG4uuUvbwfvI9Z`
- **Segments Configuration**:
- Segment 1:
- Field: `Total number of likes the video received`
- Aggregation: SUM
- Label: "Likes"
- Color: Red (#ff4d4f)
- Segment 2:
- Field: `Total number of comments the video received`
- Aggregation: SUM
- Label: "Comments"
- Color: Blue (#1890ff)
- Segment 3:
- Field: `Total number of times the video was shared`
- Aggregation: SUM
- Label: "Shares"
- Color: Green (#52c41a)
- **Chart Options**:
- Show percentages: Yes
- Show legend: Yes, positioned on the right
- Show labels: Yes (with values)
- Donut hole size: 40% (if using donut)
- **Position**: Right side of third row
- **Size**: Half width, 2-3 rows height
---
### Section 4: Content Analysis (Fourth Row)
#### Chart 4: Watch Rate vs Views Scatter Plot
**Block Type**: Scatter Plot
- **Title**: "Watch Rate vs Video Performance"
- **Data Source**: Table `tblG4uuUvbwfvI9Z`
- **X-Axis Configuration**:
- Field: `Total video views`
- Type: Number
- Label: "Total Views"
- **Y-Axis Configuration**:
- Field: `Percentage of video watched completely`
- Type: Number
- Label: "Watch Rate (%)"
- **Point Configuration**:
- Size: Based on `Total number of likes the video received` (optional)
- Color: Single color or by engagement level
- **Chart Options**:
- Show trend line: Yes (linear regression)
- Point size: Medium
- Show grid lines: Yes
- **Position**: Left side of fourth row
- **Size**: Half width, 2 rows height
#### Chart 5: Video Duration Distribution
**Block Type**: Histogram or Column Chart
- **Title**: "Video Duration Distribution"
- **Data Source**: Table `tblG4uuUvbwfvI9Z`
- **X-Axis Configuration**:
- Field: `Duration of the video in seconds`
- Type: Number
- Bins: Group into ranges (e.g., 0-15s, 15-30s, 30-60s, 60-120s, 120s+)
- **Y-Axis Configuration**:
- Field: Record count
- Aggregation: COUNT
- Label: "Number of Videos"
- **Chart Options**:
- Bar color: Purple (#722ed1)
- Show values on bars: Yes
- Bar spacing: Minimal (histogram style)
- **Position**: Right side of fourth row
- **Size**: Half width, 2 rows height
---
### Section 5: Detailed Data Table (Bottom Row)
#### Table 1: Full Video Performance Table
**Block Type**: Table/Grid View
- **Title**: "All Videos - Detailed View"
- **Data Source**: Table `tblG4uuUvbwfvI9Z`
- **Columns to Display** (in order):
1. `Unique identifier of the video` - Width: 150px
2. `Video description` - Width: 300px (truncated with tooltip)
3. `Date and time the video was published` - Width: 150px, Format: YYYY-MM-DD
4. `Total video views` - Width: 120px, Number format with separator
5. `Total number of likes the video received` - Width: 100px
6. `Total number of comments the video received` - Width: 100px
7. `Total number of times the video was shared` - Width: 100px
8. `Percentage of video watched completely` - Width: 120px, Format: X.X%
9. `Duration of the video in seconds` - Width: 100px
- **Table Options**:
- Enable sorting: Yes (all columns)
- Enable filtering: Yes
- Enable search: Yes
- Rows per page: 20
- Default sort: `Total video views` descending
- Row height: Compact
- Show row numbers: Yes
- Enable row selection: Yes
- Freeze header row: Yes
- **Position**: Bottom of dashboard
- **Size**: Full width, 3-4 rows height
---
## Additional Dashboard Features
### Filters (Optional)
Add dashboard-level filters that apply to all blocks:
1. **Date Range Filter**
- Field: `Date and time the video was published`
- Type: Date range picker
- Default: Last 90 days
- Position: Top of dashboard
2. **Engagement Level Filter**
- Field: `Total video views`
- Type: Range slider or dropdown
- Options:
- High (>10k views)
- Medium (1k-10k views)
- Low (<1k views)
3. **Watch Rate Filter**
- Field: `Percentage of video watched completely`
- Type: Range slider
- Range: 0-100%
---
## Step-by-Step Creation Guide
### Step 1: Access the Dashboard
1. Navigate to: `https://hypelive.sg.larksuite.com/base/C8kmbTsqoa6rBesTKRpl8nV8gHd`
2. Open the table: `tblG4uuUvbwfvI9Z`
3. Click on the "Dashboard" tab or create a new dashboard
### Step 2: Create KPI Cards
1. Click "Add Block" button
2. Select "Metrics Card" from block types
3. Configure each KPI card following the specifications above
4. Arrange them in a single row at the top
### Step 3: Add Line Chart
1. Click "Add Block"
2. Select "Line Chart"
3. Configure data source and axes as specified
4. Position below the KPI cards
5. Adjust height to show trends clearly
### Step 4: Create Top 10 Bar Chart
1. Click "Add Block"
2. Select "Bar Chart" (Horizontal)
3. Configure field mappings
4. Add sorting rule: Sort by views, descending
5. Add limit: Top 10 records
### Step 5: Add Pie Chart
1. Click "Add Block"
2. Select "Pie Chart" or "Donut Chart"
3. Add three segments for Likes, Comments, Shares
4. Configure colors and labels
### Step 6: Create Scatter Plot
1. Click "Add Block"
2. Select "Scatter Plot"
3. Map X-axis to views, Y-axis to watch rate
4. Enable trend line
### Step 7: Add Duration Histogram
1. Click "Add Block"
2. Select "Column Chart"
3. Configure duration field with bins
4. Show record count
### Step 8: Insert Data Table
1. Click "Add Block"
2. Select "Table View"
3. Choose the table view or create a new one
4. Configure column visibility and order
5. Enable sorting and filtering options
### Step 9: Add Filters (Optional)
1. Click "Add Filter" at dashboard level
2. Configure date range, engagement, and watch rate filters
3. Test that filters apply to all visualizations
### Step 10: Layout Optimization
1. Arrange blocks in the recommended grid layout
2. Ensure consistent spacing and alignment
3. Test responsive behavior (if applicable)
4. Save the dashboard
---
## Color Palette Recommendations
Use a consistent color scheme across all charts:
- **Primary Blue**: #1890ff (Views, primary metrics)
- **Success Green**: #52c41a (Shares, positive metrics)
- **Error Red**: #ff4d4f (Likes, engagement)
- **Warning Orange**: #fa8c16 (Comments, alerts)
- **Purple**: #722ed1 (Duration, special metrics)
- **Gradient**: Use gradients for bar charts to show magnitude
---
## Best Practices
1. **Data Refresh**: Set dashboard to auto-refresh every 1 hour
2. **Performance**: If dashboard loads slowly, consider:
- Limiting time range with default filters
- Using aggregated views instead of raw data
- Reducing the number of blocks displayed at once
3. **Mobile View**: Test dashboard on mobile devices and adjust layout if needed
4. **Permissions**: Set appropriate view/edit permissions for stakeholders
5. **Documentation**: Add text blocks to explain key insights or methodologies
---
## Troubleshooting
### Issue: Charts show no data
- Verify field names match exactly (case-sensitive)
- Check that aggregation type is appropriate for the field type
- Ensure date filters aren't excluding all data
### Issue: Performance is slow
- Reduce the number of records displayed in table view
- Use filters to limit data range
- Consider creating summary tables for aggregations
### Issue: Colors don't match
- Check the color codes in each chart configuration
- Use the exact hex codes provided in the color palette section
---
## Next Steps After Dashboard Creation
1. **Share Dashboard**: Share link with stakeholders
2. **Schedule Reports**: Set up automated weekly/monthly reports
3. **Create Alerts**: Configure alerts for significant metric changes
4. **Iterate**: Gather feedback and refine visualizations
5. **Documentation**: Update this guide with any custom modifications
---
## Resources
- Lark Bitable Documentation: https://www.larksuite.com/hc/en-US/articles/360048487776
- Dashboard Best Practices: https://www.larksuite.com/hc/en-US/articles/dashboard-tips
- API Integration: Use the `analyze-tiktok-data.ts` script for programmatic access
---
**Last Updated**: 2025-12-09
**Version**: 1.0
**Maintained By**: Analytics Team
