Why manual YouTube creator tracking fails for Indian D2C brands, and how PulseROI automated it

Spreadsheet-based tracking of YouTube influencer campaigns breaks down once an Indian D2C brand runs more than about three creator partnerships at once. Manual links and screenshots leave data fragmented, with UTM errors and outdated view counts making it hard to tell whether a campaign drove real conversions. PulseROI's first attempt, a daily Node.js script that queried the YouTube Data API per video and wrote results to a Neon PostgreSQL database, failed in production due to exhausted API quotas and Vercel function timeouts. The team fixed this by batching up to 50 video IDs per request and capping each fetch with a 25-second timeout to stay within serverless limits. The account is a technical write-up from the company's engineering perspective, not an independent report.