1. Introduction
Douyin Daily Most Influential Account Ranking Tracking and Analysis Tool -- Based on the Red Fox Data API, it provides daily/weekly/monthly performance ranking queries for all categories and subcategories of Douyin accounts, supporting ranking queries, niche filtering, HTML visual report downloads, and scheduled subscription push.
Target Users: novice content creators, brands/business placement personnel, MCN agencies/content teams, industry analysts/consulting practitioners.
2. Features
Core Features：
- Ranking Query -- Check daily, weekly, and monthly TOP 50 rankings, supporting all categories and subcategories
- Niche Filtering -- Filter by category (27 niches including food, travel, technology, gaming, etc.)
- Report Download -- Generate HTML visual reports, supporting export to PDF/screenshots
- Scheduled Subscription -- Set up automated scheduled push, supporting daily/weekly/monthly frequency
Highlights：
- The daily ranking updates daily at 17:30/retroactive 7 days, the weekly ranking updates every Monday at 17:30/retroactive 3 weeks, the monthly ranking updates on the 2nd of each month at 9:00/retroactive 3 months
- Comprehensive scoring algorithm: weighted calculation based on total followers, new follower growth, new likes/shares/comments, full score 100
- Niche fuzzy matching: supports natural language input (e.g., "beauty" automatically maps to "makeup and beauty")
- Data consistency guarantee: the number of data entries displayed in the conversation is strictly consistent with the HTML report
3. One-click Installation
Authentication
Get API Key
Please go to Red Fox Hub to get the API KEY
Configure API Key
Option 1: Taking OpenClaw as an example, add REDFOX_API_KEY to ~/.openclaw/openclaw.json
{ "env": { "REDFOX_API_KEY": "ak_xxxx..." } }
Option 2: Terminal configuration: export REDFOX_API_KEY="ak_xxxx..."
export REDFOX_API_KEY="ak_xxxx..."
Dependency Installation
No third-party dependencies need to be installed; it can run using the Python standard library.
4. Usage Guide
Basic Usage
Query ranking data (displays TOP 20 by default)：
python scripts/fetch_rank.py --query "用户原始问题" --limit 20 --output /path/to/data.json
The script will automatically parse:
- Time: identify daily/weekly/monthly from the user text; if not specified, default to daily ranking
- Date: automatically calculate the latest available date (daily ranking updates at 17:30, weekly ranking updates Monday at 17:30, monthly ranking updates on the 2nd of each month at 9:00)
- Niche: supports fuzzy matching (e.g., "beauty" maps to "makeup and beauty")
Generate HTML Report：
python scripts/generate_report.py --data /path/to/data.json --limit 20
Important: The number of data entries displayed in the HTML report must be consistent with the number displayed in the conversation. Use
deliver_attachmentsto deliver the HTML file.
View all 50 data entries：
python scripts/fetch_rank.py --query "用户原始问题" --limit 50 --output /path/to/data_full.json
python scripts/generate_report.py --data /path/to/data_full.json --limit 50
Advanced Usage
Update Time and Retroactive Range：
| Ranking Type | Update Time | Retroactive Range |
|---|---|---|
| Daily Ranking | Daily 17:30 | Past 7 days |
| Weekly Ranking | Every Monday 17:30 | Past 3 weeks |
| Monthly Ranking | Every month on the 2nd at 9:00 | Past 3 months |
Time boundary handling (must be strictly followed)：
- Query for the current day and future dates: reply "We are very sorry🙏, our latest data is from yesterday/last week/last month, and we will provide you with the yesterday/last week/last month hot ranking closest to your needs."
- Query time earlier than the backtracking date: reply "We are very sorry🙏, the ranking currently supports backtracking at most 'the past 7 days/the past 3 weeks/the past 3 months', and I will query the time range closest to your needs for you~"
Subscription Service：
After the user confirms the subscription, use automation_update tool to create an automation task:
- Daily Ranking:
FREQ=DAILY;BYHOUR=19;BYMINUTE=30 - Weekly Ranking:
FREQ=WEEKLY;BYDAY=MO;BYHOUR=19;BYMINUTE=30 - Monthly Ranking:
FREQ=MONTHLY;BYMONTHDAY=1;BYHOUR=16;BYMINUTE=0
automation prompt example:查询抖音最新日榜（全品类），生成报告并推送给用户
Common Command Quick Reference
| User Intent | Typical Trigger Words | Corresponding Operation |
|---|---|---|
| Ranking Query | Douyin daily ranking, weekly ranking, monthly ranking, TOP50, hottest accounts, leaderboard, latest recommendations | Call the script to query and format the output |
| Category Query | Food/Travel/Gaming/Tech... Douyin ranking | Call the script and filter by track |
| Report Download | Download report, export ranking, generate report | Run generate_report.py to generate HTML |
Output Format
Markdown table template：
📊 抖音{period_label} · {category_label}
数据日期：{date}
共 {total} 个账号上榜（展示 TOP {displayed} 条）
💡 榜单说明：{warning}{period_update_time}，与实时数据存在差异
📐 综合评分：根据总粉丝数、新增粉丝增量、新增点赞/分享/评论加权计算，满分100
| 排名 | 账号名 | 综合评分 | 总粉丝数 | 新增粉丝 | 新增点赞 | 新增评论 | 新增分享 |
|:---:|--------|:-------:|:-------:|:-------:|:-------:|:-------:|:-------:|:-------:|
| 🥇 1 | [账号A](https://www.douyin.com/user/xxx) | 96 | 254.06w | 6919 | 24.64w | 6.68w | 13.39w |
| 🥈 2 | [账号B](https://www.douyin.com/user/xxx) | 89 | 113.55w | 1.91w | 7.90w | 4787 | 3.12w |
| 🥉 3 | [账号C](https://www.douyin.com/user/xxx) | 87 | 439.14w | 5859 | 16.51w | 993 | 687 |
After outputting the ranking, append:
⚡ 更多操作
⏺️ 本次榜单完整共 50 条数据，是否需要查看剩余 30 条？
📬 订阅服务
1️⃣ 是否需要订阅每日/周/月的抖音账号最新排名？
2️⃣ 是否需要订阅具体赛道的账号表现？我们支持：个人才艺、生活vlog、财富理财、二次元、居家装修、学习教育、小剧场、数码科技、旅行、美食、化妆美容、动物、亲子、汽车、情感、三农、健康医学、潮流风尚、舞蹈才艺、颜值造型、人文、音乐、影视、身体锻炼、体育、明星娱乐、游戏
5. Use Cases
| User Segment | Core Pain Points | Usage Method |
|---|---|---|
| Novice content creators / individual operators | Do not know which accounts are doing well, have no reference to learn from, and do not know where their own level stands within the track | Query "Food account TOP50" to obtain benchmark references |
| Brands / business placement personnel | Low efficiency in finding influencers, single data dimension, and lack of understanding of account historical performance | Query "Last week's Douyin beauty TOP50" to obtain placement candidates |
| MCN agencies / content teams | Difficult to obtain competitor account intelligence and unable to quickly grasp market dynamics | Query "Gaming accounts with the fastest follower growth in the last week" to monitor the market |
| Industry analysts / consulting practitioners | High threshold for data acquisition and lack of visualization report tools | Generate "March Douyin gaming category ranking analysis report" |
Expected Benefits: Quickly obtain track dynamics, identify high-quality accounts, reduce placement decision-making costs, and improve content operation efficiency.
6. Project Architecture
Directory Structure
douyin-top-account/
├── SKILL.md # 本文件
├── scripts/
│ ├── fetch_rank.py # 查询抖音榜单数据
│ └── generate_report.py # 生成 HTML 可视化报告
└── references/
├── category_map.md # 赛道映射表与匹配规则
├── update_rules.md # 更新规则与日期计算逻辑
├── score_rules.md # 评分算法说明
└── api_docs.md # API 接口详细文档（技术参考）
Tech Stack
| Technology | Purpose |
|---|---|
| Python Standard Library | Data query and report generation |
| Honghu API | Douyin ranking data source |
| HTML / CSS | Visualization report rendering |
Core Module Description
- fetch_rank.py: Receives user query parameters, calls the Honghu API to obtain ranking data, automatically parses time, date, and track, and outputs JSON data files.
- generate_report.py: Read the JSON data output by fetch_rank, and generate an HTML visualization report with a ranking table, statistic cards, and the ranking algorithm; all account names can be clicked to jump to the Douyin homepage.
Resource Index
| File | Purpose |
|---|---|
| scripts/fetch_rank.py | Query Douyin ranking data |
| scripts/generate_report.py | Generate an HTML visualization report |
| references/category_map.md | Track mapping table and matching rules |
| references/update_rules.md | Update rules and date calculation logic |
| references/score_rules.md | Scoring algorithm description |
| references/api_docs.md | Detailed API interface documentation (technical reference) |
7. Frequently Asked Questions
Installation
Q: What dependencies need to be installed? A: No third-party dependencies need to be installed; it can run using the Python standard library.
Q: How do I configure the API Key?
A: Please go to Red Fox Hub to obtain the API KEY, then configure it via the environment variable REDFOX_API_KEY .
Usage
Q: When is the daily ranking data updated? A: Yesterday's data is updated every day at 17:30. When the current time has not yet reached 17:30, the script will automatically retrieve the data from the day before yesterday.
Q: Which tracks are supported? A: 27 tracks are supported; see the complete list in references/category_map.md。
Q: What is the data lookback range? A: The daily ranking can query the past 7 days, the weekly ranking can query the past 3 weeks, and the monthly ranking can query the past 3 months.
Q: What should I do if track recognition fails? A: When it cannot be recognized, please list the complete track list for the user to choose from.
Q: How many entries of data are displayed by default? A: The daily ranking displays TOP 20 by default; the complete 50 entries can be viewed through the report or by follow-up questions.
Troubleshooting
Q: HTML report generation failed? A: Make sure the workspace has write permission and the JSON data file path is correct.
Q: Inconsistent data? A: However many entries are displayed in the conversation, the HTML report must display the same number; the two must be consistent. If the user requests to view all 50 entries, the complete report needs to be regenerated.