Weekly channel performance digest, delivered automatically

Every Monday the scenario pulls fresh video stats, ranks top and weak performers, and sends the report to Microsoft Teams, Azure Cosmos DB and Gmail.

  • Fresh channel numbers without opening analytics by hand
  • Videos rank themselves: top, average, underperformers
  • Digest to Microsoft Teams, log to Azure Cosmos DB, email to Gmail
  • Runs itself every Monday
YouTube
Set it upScriptera

How it works

To pass leads from Microsoft Teams to Azure Cosmos DB automatically, use a ready-made scenario — no manual copying, no lost leads.

  1. Starts when: Weekly Monday Trigger
  2. Then: Fetch Recent Channel Videos
  3. Then: Extract Video IDs
  4. Then: Fetch Video Statistics
  5. Then: Parse & Score Videos
  6. Then: Aggregate All Videos
  7. Then: Message a model
  8. Then: Prepare Digest Data
  9. Then: Post Digest to Slack
  10. Then: Split Videos for Logging
  11. Then: Log Videos to Sheet
  12. Then: Re-Aggregate for Email
  13. Then: Email Weekly Report

You can launch this Microsoft Teams + Azure Cosmos DB integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios