# 数据采集输出示例 > 展示从各平台采集后的数据格式 --- ## 1. 抖音数据示例 ### 1.1 视频数据 ```json { "platform": "douyin", "video_id": "7123456789012345678", "video_title": "测试视频标题", "author_id": "user_123456", "publish_time": 1709308800, "views": 15000, "likes": 1200, "comments": 89, "shares": 45, "favorites": 234, "completion_rate": 0.65, "avg_watch_time": 28.5, "created_at": 1709400000 } ``` ### 1.2 评论数据 ```json [ { "platform": "douyin", "video_id": "7123456789012345678", "comment_id": "c_123456", "user_id": "user_789", "content": "太棒了!", "like_count": 25, "sentiment": "positive", "sentiment_score": 0.92 }, { "platform": "douyin", "video_id": "7123456789012345678", "comment_id": "c_123457", "user_id": "user_790", "content": "一般般吧", "like_count": 3, "sentiment": "neutral", "sentiment_score": 0.5 } ] ``` --- ## 2. B站数据示例 ### 2.1 视频信息 ```json { "platform": "bilibili", "video_id": "BV1xx411c7mD", "video_title": "【教程】如何入门编程", "author_id": "UID123456", "publish_time": 1709200000, "views": 52000, "likes": 2800, "coins": 450, "favorites": 1200, "shares": 180, "danmaku": 320, "reply_count": 256, "created_at": 1709400000 } ``` ### 2.2 评论数据 ```json [ { "platform": "bilibili", "video_id": "BV1xx411c7mD", "comment_id": "r_123456", "user_id": "UID789012", "content": "学到了!感谢UP主", "like_count": 56, "sentiment": "positive", "sentiment_score": 0.88 }, { "platform": "bilibili", "video_id": "BV1xx411c7mD", "comment_id": "r_123457", "user_id": "UID789013", "content": "音质可以更好", "like_count": 12, "sentiment": "neutral", "sentiment_score": 0.55 } ] ``` --- ## 3. 聚合数据看板 ### 3.1 日汇总 ```json { "date": "2024-03-01", "platforms": { "douyin": { "total_views": 45000, "total_likes": 3200, "total_comments": 280, "avg_completion_rate": 0.62 }, "bilibili": { "total_views": 78000, "total_likes": 4500, "total_comments": 420, "avg_completion_rate": 0.71 } }, "generated_at": 1709400000 } ``` ### 3.2 周趋势 ```json { "week": "2024-W13", "trend": { "douyin_views": [32000, 35000, 38000, 41000, 45000, 42000, 45000], "bilibili_views": [65000, 68000, 72000, 75000, 78000, 76000, 78000], "total_likes": [2100, 2300, 2500, 2800, 3200, 3000, 3400] } } ``` --- ## 4. 情感分析汇总 ### 4.1 每日情感分布 ```json { "date": "2024-03-01", "source": "douyin", "total_comments": 280, "sentiment": { "positive": 168, "neutral": 84, "negative": 28 }, "positive_rate": 0.60, "negative_rate": 0.10, "top_positive_comments": [ "太喜欢了", "支持UP主", "学到了很多" ], "top_negative_comments": [ "音质太差", "内容空洞" ] } ``` --- ## 5. 字段对照表 | 字段 | 抖音 | B站 | 统一字段 | |------|------|-----|----------| | 视频ID | video_id | bvid | video_id | | 标题 | video_title | title | video_title | | 作者 | author_id | owner.mid | author_id | | 播放量 | play_count | play | views | | 点赞 | like_count | like | likes | | 投币 | - | coin | shares | | 收藏 | favorite_count | favorite | favorites | | 评论 | comment_count | reply | comments | | 弹幕 | - | danmaku | danmaku | | 分享 | share_count | share | shares | | 完播率 | finish_rate | - | completion_rate | | 平均观看 | avg_time | - | avg_watch_time |