Hype Dash

# Create TikTok Analytics Dashboard in Lark Base ## Quick Access **Direct URL:** https://hypelive.sg.larksuite.com/base/C8kmbTsqoa6rBesTKRpl8nV8gHd ## Important Discovery The Lark API does not support creating Dashboard views programmatically. Dashboards must be created through the Lark UI. However, I'll guide you through the exact steps to create a powerful TikTok analytics dashboard. --- ## Step-by-Step Dashboard Creation Guide ### Step 1: Access the Table 1. Click the link above to open your Lark Base 2. Navigate to the table: **"TikTok L'AURA - Candle"** (currently has 150 videos) 3. The table ID is: `tblG4uuUvbwfvI9Z` ### Step 2: Create New Dashboard View 1. At the top of the table, click the **view dropdown** (currently showing "TikTok For Creator TikTok Account Video Data") 2. Click the **"+"** button to add a new view 3. Select **"Dashboard"** from the view type options 4. Name it: **"TikTok Analytics Dashboard"** 5. Click **"Create"** ### Step 3: Configure Dashboard Charts Now you'll add various chart widgets to analyze your TikTok data. Click **"+ Add Chart"** for each of the following: --- #### Chart 1: Total Performance Summary (Metric Cards) **Type:** Metric/Number Cards **Configuration:** - **Chart Type:** Select "Metric" or "Number" - **Metrics to Add:** 1. Total Views - Field: `Total video views` - Aggregation: SUM 2. Total Likes - Field: `Total number of likes the video received` - Aggregation: SUM 3. Total Comments - Field: `Total number of comments the video received` - Aggregation: SUM 4. Total Shares - Field: `Total number of times the video was shared` - Aggregation: SUM 5. Average Watch % - Field: `Percentage of video watched completely` - Aggregation: AVERAGE **Layout:** Arrange these 5 cards horizontally at the top of your dashboard --- #### Chart 2: Video Performance Over Time (Line/Area Chart) **Type:** Line Chart or Area Chart **Configuration:** - **X-Axis:** `Date and time the video was published` - Group by: Day or Week (depending on your date range) - **Y-Axis Metrics:** - `Total video views` (SUM) - Primary line - `Total number of likes the video received` (SUM) - Secondary line - **Optional:** Enable dual Y-axis to show views and engagement separately - **Title:** "Views & Engagement Trends" --- #### Chart 3: Engagement Rate Analysis (Bar Chart) **Type:** Horizontal Bar Chart **Configuration:** - **X-Axis:** Top 10 videos - Sort by: `Total video views` (Descending) - Limit: 10 records - **Y-Axis:** - `Total number of likes the video received` / `Total video views` * 100 (Engagement Rate) - Alternative: Show likes, comments, shares as stacked bars - **Labels:** Show `Video description` (truncated to first 50 characters) - **Title:** "Top 10 Videos by Engagement" --- #### Chart 4: Watch Completion Analysis (Scatter Plot or Bar Chart) **Type:** Scatter Plot or Column Chart **Configuration:** - **X-Axis:** `Video duration in seconds, rounded to three decimal places` - Group into buckets: 0-15s, 15-30s, 30-60s, 60-90s, 90s+ - **Y-Axis:** `Percentage of video watched completely` (AVERAGE) - **Size/Color:** `Total video views` (SUM) - **Title:** "Watch Completion % by Video Duration" - **Insight:** This shows optimal video length for your audience --- #### Chart 5: Content Performance Distribution (Pie/Donut Chart) **Type:** Pie Chart or Donut Chart **Configuration:** - **Segments:** Video performance categories - Create categories based on views: - High performers: >10,000 views - Medium: 1,000-10,000 views - Low: <1,000 views - **Value:** COUNT of videos in each category - **Title:** "Video Performance Distribution" --- #### Chart 6: Daily Upload & Performance (Combo Chart) **Type:** Combo Chart (Bar + Line) **Configuration:** - **X-Axis:** `Date and time the video was published` (Group by Day) - **Primary Y-Axis (Bar):** COUNT of videos posted per day - **Secondary Y-Axis (Line):** AVERAGE `Total video views` per day - **Title:** "Upload Frequency vs. Average Views" - **Insight:** Shows if posting frequency affects performance --- #### Chart 7: Engagement Metrics Comparison (Grouped Bar Chart) **Type:** Grouped Bar Chart **Configuration:** - **Categories:** Top 15 videos (by views) - **Metrics (Grouped Bars):** - `Total number of likes the video received` - `Total number of comments the video received` - `Total number of times the video was shared` - **X-Axis Labels:** `Video description` (first 30 chars) - **Title:** "Engagement Breakdown - Top Videos" --- #### Chart 8: Watch Time Analysis (Calculated Metric) **Type:** Number Card or Bar Chart **Configuration:** - **Metric:** Total Watch Time - Formula: SUM(`Total video play duration based on all views`) - Display in hours (divide by 3600) - **Secondary Metric:** Average Watch Time per Video - Formula: AVERAGE(`Average video play duration based on all views`) - **Title:** "Total & Average Watch Time" --- #### Chart 9: Viewer Retention (Column Chart) **Type:** Column Chart **Configuration:** - **X-Axis:** Completion rate buckets - 0-25%, 25-50%, 50-75%, 75-100% - **Y-Axis:** COUNT of videos in each bucket - **Title:** "Video Completion Rate Distribution" - **Insight:** Shows how many videos retain viewers --- #### Chart 10: Recent Performance Table (Detailed View) **Type:** Table Widget **Configuration:** - **Columns to Display:** 1. `Video description` (first 50 chars) 2. `Date and time the video was published` 3. `Total video views` 4. `Total number of likes the video received` 5. `Total number of comments the video received` 6. `Percentage of video watched completely` - **Filter:** Last 30 days - **Sort:** By `Date and time the video was published` (Descending) - **Limit:** Show 20 most recent videos - **Title:** "Recent Video Performance" --- ## Dashboard Layout Recommendations ### Top Section (KPIs) ``` [Total Views] [Total Likes] [Total Comments] [Total Shares] [Avg Watch %] ``` ### Middle Section (Trends) ``` [Video Performance Over Time - Full Width] ``` ``` [Top 10 Videos by Engagement - 50%] [Watch Completion by Duration - 50%] ``` ### Lower Section (Distribution & Details) ``` [Performance Distribution - 33%] [Upload Frequency - 33%] [Engagement Comparison - 33%] ``` ``` [Total Watch Time - 33%] [Completion Rate Distribution - 67%] ``` ### Bottom Section (Data Table) ``` [Recent Video Performance - Full Width Table] ``` --- ## Advanced Tips ### 1. Add Filters to Dashboard - Add a **Date Range Filter** at the top - Field: `Date and time the video was published` - Allow users to select: Last 7 days, Last 30 days, Last 90 days, Custom range ### 2. Add Interactive Elements - Enable **drill-down** on charts - Click on a bar/point to filter the entire dashboard - Show video thumbnails in tooltips (if supported) ### 3. Calculated Fields (Create in Table First) Before creating dashboard, add these calculated fields to your table: 1. **Engagement Rate** - Formula: `(Likes + Comments + Shares) / Views * 100` - Field Name: "Engagement Rate %" 2. **Watch Time Per View** - Formula: `Total video play duration / Total video views` - Field Name: "Avg Seconds Watched per View" 3. **Virality Score** - Formula: `(Shares / Views) * 100` - Field Name: "Virality Score" 4. **Performance Category** - Formula: IF(Views > 10000, "High", IF(Views > 1000, "Medium", "Low")) - Field Name: "Performance Tier" ### 4. Color Coding - Use **green** for high performers (>75% watch rate, high views) - Use **yellow** for medium performers - Use **red** for underperformers - Maintain consistent color scheme across all charts ### 5. Dashboard Sharing - After creation, click **"Share"** button - Set permissions: View-only for stakeholders, Edit for team - Generate shareable link: `https://hypelive.sg.larksuite.com/base/C8kmbTsqoa6rBesTKRpl8nV8gHd?view=<dashboard_view_id>` --- ## Expected Results After creating this dashboard, you will have: 1. **At-a-glance KPIs** showing total performance metrics 2. **Trend analysis** showing how your content performs over time 3. **Content insights** identifying which video lengths and styles work best 4. **Engagement patterns** showing when and how viewers interact 5. **Recent performance** table for quick access to latest data 6. **Visual analytics** making it easy to spot trends and outliers --- ## Troubleshooting ### If charts don't appear: - Ensure all 150 records are loaded - Check that numeric fields are formatted correctly - Verify date field is in proper DateTime format ### If aggregations are wrong: - Double-check field selection - Ensure you're using SUM for totals, AVERAGE for rates - Remove any filters that might be hiding data ### If dashboard is slow: - Limit charts to showing top N records (e.g., top 20) - Use date range filters to reduce data load - Avoid too many real-time calculations --- ## Quick Start Checklist - [ ] Open Lark Base URL - [ ] Navigate to "TikTok L'AURA - Candle" table - [ ] Create new Dashboard view - [ ] Add 5 KPI metric cards at top - [ ] Add performance trend line chart - [ ] Add top 10 videos bar chart - [ ] Add watch completion analysis - [ ] Add performance distribution pie chart - [ ] Add recent performance table - [ ] Apply color coding and formatting - [ ] Add date range filter - [ ] Test all interactions - [ ] Share dashboard with team --- ## Alternative: API-Based Analytics While dashboards must be created in UI, you can use the Lark API to: 1. **Fetch data programmatically** for custom analysis 2. **Create automated reports** using external tools 3. **Build custom visualizations** with libraries like Chart.js, D3.js 4. **Export data** to BI tools (Tableau, Power BI, Looker) Sample API call to fetch data: ```bash # Get recent videos with key metrics curl -X POST \ 'https://open.larksuite.com/open-apis/bitable/v1/apps/C8kmbTsqoa6rBesTKRpl8nV8gHd/tables/tblG4uuUvbwfvI9Z/records/search' \ -H 'Authorization: Bearer YOUR_ACCESS_TOKEN' \ -H 'Content-Type: application/json' \ -d '{ "field_names": [ "Video description", "Total video views", "Total number of likes the video received", "Percentage of video watched completely", "Date and time the video was published" ], "sort": [{ "field_name": "Date and time the video was published", "desc": true }], "page_size": 150 }' ``` --- ## Summary The Lark Base dashboard creation requires manual UI interaction, but following this guide will give you a comprehensive analytics dashboard in about 15-20 minutes. The dashboard will provide actionable insights into your TikTok content performance, helping you optimize your content strategy. **Start now:** https://hypelive.sg.larksuite.com/base/C8kmbTsqoa6rBesTKRpl8nV8gHd