Your Shorts song join is picking the wrong creator

说明与用途

通过使用 trackId 而非 videoId 并验证必需字段，自动化处理 YouTube Shorts 图表可防止错误的创作者分配。

问题

Campaign shortlist changes creators after a re-run because the join key uses videoId instead of trackId, causing linked uploads to become campaign targets.

结果

By separating track identity from video details and validating required fields, the automation prevents incorrect creator assignments and ensures reliable campaign data.

工作流

• 1. Request the song chart without video details using ApifyClient with includeVideoDetails:false.
• 2. Keep onlyNew off for warehouse ingestion and let Postgres handle deduplication.
• 3. Store chart entries with trackId, chart observation, optional linked video, and separate creator research.
• 4. Wait for run completion and retain run ID for recovery.
• 5. Validate fields with Zod schemas (StatusRow, TrackRow) to quarantine identity failures.
• 6. Preserve valid rows from failed runs and delay campaign export until run passes release checks.

证据

Your campaign shortlist changes creators after a re-run. The song hasn’t changed. Your join key has.

来源

If you joined videoId straight into your creator table, a linked upload quietly became the campaign target.

来源

Start with a narrow research slice. Leave video enrichment out until you’ve a reason to investigate an attached upload.

来源

Keep the returned ID in your job history. If database ingestion stops halfway through, resume that run instead of asking “latest” for another snapshot.

来源