finding-youtube-sponsorship-candidates
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseFinding YouTube Sponsorship Candidates
寻找YouTube赞助候选频道
Discovers YouTube channels that are good fits for brand integrations. Channels with existing sponsor history are the most efficient outreach targets — they've already proven willingness to accept sponsorships.
发现适合品牌植入的YouTube频道。有赞助合作历史的频道是最高效的 outreach 目标——他们已经证明了接受赞助的意愿。
Prerequisites
前提条件
- environment variable set
APIFY_TOKEN - Optional: Apify MCP server installed
- 已设置环境变量
APIFY_TOKEN - 可选:已安装Apify MCP服务器
Inputs
输入参数
| Parameter | Type | Required | Default | Notes |
|---|---|---|---|---|
| array | Optional | | YouTube URLs — channels, playlists, Shorts, search results |
| array | Optional | | YouTube channel handles (e.g. |
| boolean | Optional | | Retrieve trending videos |
| array | Optional | | Search keywords |
| string | Optional | | Country code for results (e.g. |
| string | Optional | | Language code (e.g. |
| string | Optional | | Upload date filter: |
| string | Optional | | Duration filter: |
| string | Optional | | Feature filter: |
| string | Optional | | Sort order for search results |
| number | Optional | Unlimited | Maximum videos to return |
| string | Optional | — | JavaScript function to transform each output object |
| 参数 | 类型 | 是否必填 | 默认值 | 说明 |
|---|---|---|---|---|
| 数组 | 可选 | | YouTube链接——频道、播放列表、Shorts、搜索结果 |
| 数组 | 可选 | | YouTube频道标识(例如 |
| 布尔值 | 可选 | | 获取热门视频 |
| 数组 | 可选 | | 搜索关键词 |
| 字符串 | 可选 | | 结果对应的国家代码(例如 |
| 字符串 | 可选 | | 语言代码(例如 |
| 字符串 | 可选 | | 上传时间筛选: |
| 字符串 | 可选 | | 时长筛选: |
| 字符串 | 可选 | | 功能筛选: |
| 字符串 | 可选 | | 搜索结果的排序方式 |
| 数字 | 可选 | 无限制 | 返回的最大视频数量 |
| 字符串 | 可选 | — | 用于转换每个输出对象的JavaScript函数 |
Workflow
工作流程
Progress:
- [ ] Step 1: Search YouTube for niche channel content
- [ ] Step 2: Collect channel handles from results
- [ ] Step 3: Enrich channel data
- [ ] Step 4: Score sponsorship fit
- [ ] Step 5: Deliver ranked outreach list进度:
- [ ] 步骤1:搜索YouTube上的细分领域频道内容
- [ ] 步骤2:从结果中收集频道标识
- [ ] 步骤3:丰富频道数据
- [ ] 步骤4:为赞助适配度打分
- [ ] 步骤5:交付排序后的 outreach 名单Step 1: Search for Niche Content
步骤1:搜索细分领域内容
Recommended — run_actor.js (handles waiting, output, and file saving automatically):
bash
undefined推荐使用 — run_actor.js(自动处理等待、输出和文件保存):
bash
undefinedQuick answer (prints table to chat)
快速输出(在聊天窗口打印表格)
node scripts/run_actor.js
--actor "apidojo~youtube-scraper"
--input '{"param": "value"}'
--actor "apidojo~youtube-scraper"
--input '{"param": "value"}'
node scripts/run_actor.js
--actor "apidojo~youtube-scraper"
--input '{"param": "value"}'
--actor "apidojo~youtube-scraper"
--input '{"param": "value"}'
Save as CSV
保存为CSV文件
node scripts/run_actor.js
--actor "apidojo~youtube-scraper"
--input '{"param": "value"}'
--output YYYY-MM-DD_results.csv --format csv
--actor "apidojo~youtube-scraper"
--input '{"param": "value"}'
--output YYYY-MM-DD_results.csv --format csv
node scripts/run_actor.js
--actor "apidojo~youtube-scraper"
--input '{"param": "value"}'
--output YYYY-MM-DD_results.csv --format csv
--actor "apidojo~youtube-scraper"
--input '{"param": "value"}'
--output YYYY-MM-DD_results.csv --format csv
Save as JSON
保存为JSON文件
node scripts/run_actor.js
--actor "apidojo~youtube-scraper"
--input '{"param": "value"}'
--output YYYY-MM-DD_results.json --format json
--actor "apidojo~youtube-scraper"
--input '{"param": "value"}'
--output YYYY-MM-DD_results.json --format json
> `APIFY_TOKEN` must be set in environment or `.env` file.
**If Apify MCP is available:**Tool: apify:run-actor
Actor: "apidojo~youtube-scraper"
Input:
{
"searchKeywords": ["best [NICHE] tools", "[NICHE] review", "[NICHE] for beginners", "top [NICHE]"],
"maxResults": 50,
"type": "video"
}
**REST API fallback:**
```bash
curl -X POST "https://api.apify.com/v2/acts/apidojo~youtube-scraper/runs?token=$APIFY_TOKEN" -H "Content-Type: application/json" -d '{
"searchKeywords": ["best personal finance tools", "personal finance review"],
"maxResults": 50,
"type": "video"
}'Collect unique and values.
channelIdchannelNamenode scripts/run_actor.js
--actor "apidojo~youtube-scraper"
--input '{"param": "value"}'
--output YYYY-MM-DD_results.json --format json
--actor "apidojo~youtube-scraper"
--input '{"param": "value"}'
--output YYYY-MM-DD_results.json --format json
> 必须在环境变量或`.env`文件中设置`APIFY_TOKEN`。
**若Apify MCP可用:**工具: apify:run-actor
Actor: "apidojo~youtube-scraper"
Input:
{
"searchKeywords": ["best [NICHE] tools", "[NICHE] review", "[NICHE] for beginners", "top [NICHE]"],
"maxResults": 50,
"type": "video"
}
**REST API备选方案:**
```bash
curl -X POST "https://api.apify.com/v2/acts/apidojo~youtube-scraper/runs?token=$APIFY_TOKEN" -H "Content-Type: application/json" -d '{
"searchKeywords": ["best personal finance tools", "personal finance review"],
"maxResults": 50,
"type": "video"
}'收集唯一的和值。
channelIdchannelNameStep 2: Enrich Channel Data
步骤2:丰富频道数据
If Apify MCP is available:
Tool: apify:run-actor
Actor: "apidojo~youtube-scraper"
Input:
{
"startUrls": [{"url": "https://www.youtube.com/channel/[CHANNEL_ID]"}],
"maxResults": 10,
"type": "video"
}若Apify MCP可用:
工具: apify:run-actor
Actor: "apidojo~youtube-scraper"
Input:
{
"startUrls": [{"url": "https://www.youtube.com/channel/[CHANNEL_ID]"}],
"maxResults": 10,
"type": "video"
}Step 3: Score Sponsorship Fit
步骤3:为赞助适配度打分
view_ratio = avg_views / subscriber_count
sponsorship_score = (view_ratio > 0.1 ? 1 : view_ratio / 0.1) * 0.30
+ (subscriber_count in 10000..200000 ? 1 : 0.6) * 0.20
+ (avg_comments / avg_views > 0.005 ? 1 : (avg_comments/avg_views)/0.005) * 0.20
+ (has_sponsor_history ? 1 : 0) * 0.30Sponsorship signal detection (in last 10 video titles/descriptions):
sponsor_count = count(videos where description contains ["sponsored by", "use code", "thanks to", "partner"])
has_sponsor_history = sponsor_count >= 1
repeat_sponsor = sponsor_count >= 3Tier: TIER A ≥ 0.70 | TIER B 0.45–0.69 | TIER C < 0.45
view_ratio = avg_views / subscriber_count
sponsorship_score = (view_ratio > 0.1 ? 1 : view_ratio / 0.1) * 0.30
+ (subscriber_count in 10000..200000 ? 1 : 0.6) * 0.20
+ (avg_comments / avg_views > 0.005 ? 1 : (avg_comments/avg_views)/0.005) * 0.20
+ (has_sponsor_history ? 1 : 0) * 0.30赞助信号检测(最近10个视频的标题/描述):
sponsor_count = count(videos where description contains ["sponsored by", "use code", "thanks to", "partner"])
has_sponsor_history = sponsor_count >= 1
repeat_sponsor = sponsor_count >= 3等级划分:TIER A ≥ 0.70 | TIER B 0.45–0.69 | TIER C < 0.45
Step 4: Edge Cases
步骤4:特殊情况处理
- View count spike from one viral video: Use median views from last 10 videos, not mean; flag channels where
max_views > 10× median - Channel in adjacent but not target niche: Score niche alignment — percentage of last 20 videos in target niche
- Subscriber count stale: YouTube counts lag; use as the true reach proxy
avg_views - No description available: Skip sponsorship history check; score at 0.5 for that component
- 单个爆款视频导致浏览量激增:使用最近10个视频的中位数浏览量而非平均值;标记的频道
max_views > 10× median - 频道属于相邻但非目标细分领域:对细分领域匹配度打分——最近20个视频中属于目标领域的比例
- 订阅量数据过时:YouTube的订阅计数存在延迟;使用作为真实受众覆盖的指标
avg_views - 无视频描述可用:跳过赞助历史检查;该部分打分设为0.5
Output Format
输出格式
undefinedundefinedYouTube Sponsorship Candidates: [NICHE]
YouTube赞助候选频道: [NICHE]
Channels evaluated: [N] | TIER A: [N] | TIER B: [N] | Date: [DATE]
评估的频道数量: [N] | TIER A: [N] | TIER B: [N] | 日期: [DATE]
TIER A — Strong Sponsorship Candidates
TIER A — 高适配度赞助候选
| Channel | Subscribers | Avg Views | View Ratio | Sponsor History | Niche Fit | Score |
|---|---|---|---|---|---|---|
| [name] | [N] | [N] | [X.XX] | [Yes/No/Repeat] | [%] | [0.XX] |
| 频道 | 订阅量 | 平均浏览量 | 浏览量占比 | 赞助历史 | 领域匹配度 | 得分 |
|---|---|---|---|---|---|---|
| [名称] | [N] | [N] | [X.XX] | [是/否/多次合作] | [%] | [0.XX] |
TIER B — Secondary Candidates
TIER B — 次选候选
| Channel | Subscribers | Avg Views | View Ratio | Last Sponsor |
|---|
| 频道 | 订阅量 | 平均浏览量 | 浏览量占比 | 最近一次赞助 |
|---|
Sponsorship Landscape in [NICHE]
[NICHE]领域赞助现状
- Channels already running sponsors: [N]/[N] evaluated ([X%])
- Most common sponsor in category: [brand name] (seen on [N] channels)
- Typical viewer demographic signal (from video titles): [description]
undefined- 已有赞助合作的频道数量: [N]/[N] 个评估频道 ([X%])
- 该领域最常见的赞助商: [品牌名称](出现在[N]个频道)
- 典型观众群体特征(来自视频标题): [描述]
undefinedTroubleshooting
常见问题排查
Results are all mega-channels (> 1M subs): Narrow the search query with "beginner" or "indie" qualifiers; or filter post-scrape by subscriber count.
Niche too broad: Narrow to a sub-niche (e.g. "personal finance" → "fire movement", "crypto" → "Bitcoin long-term investing").
Can't detect sponsor history from descriptions: Sponsor language is sometimes hidden in video captions (not descriptions). This is a known limitation — supplement with manual check of top 5 candidates.
结果全是百万级订阅的大频道:在搜索词中加入“beginner”或“indie”等限定词缩小范围;或在爬取后按订阅量过滤。
细分领域过宽:缩小到子领域(例如“个人理财”→“FIRE运动”,“加密货币”→“比特币长期投资”)。
无法从描述中检测到赞助历史:赞助相关内容有时隐藏在视频字幕(而非描述)中。这是已知限制——可手动检查排名前5的候选频道作为补充。