Automating a Weekly Marketing-Analytics Pull Across 7 Platforms (and What Broke Immediately)

Описание и применение

Автоматизированный скрипт собирает недельные данные маркетинга с четырёх платформ без проблем, но Pinterest и Instagram требуют дополнительной настройки. Полученный отчёт в формате Markdown помогает быстро принимать решения.

Задача

Need a single script to pull a week’s marketing data from seven platforms and generate a markdown report, avoiding manual dashboard checks.

Результат

Script successfully pulls data from four platforms immediately; Pinterest and Instagram require additional setup and fail initially. The report provides actionable insights, such as video content performance differences.

Рабочий процесс

• 1. Generate or retrieve API tokens for Gumroad, YouTube, Dev.to, and Hacker News.
• 2. Call each platform’s API to fetch a week’s worth of data.
• 3. Wrap each API call in a try/catch to log failures and continue.
• 4. Aggregate successful responses into a markdown report.
• 5. Output the report for review each Monday.
• 6. Monitor logs for Pinterest/Instagram failures and address credential issues separately.

Доказательства

What worked with almost no friction: Gumroad's sales API, YouTube Data API v3, Dev.to's own API, and the Algolia-powered Hacker News search API.

Источник

What broke immediately: Pinterest and Instagram. Pinterest's v5 API gated most useful endpoints behind an approved "Standard Access" application tier… Instagram's Graph API needs a long-lived token…

Источник