Weekly channel performance digest, delivered automatically

Every Monday the scenario pulls fresh video stats, ranks top and weak performers, and sends the report to okoCrm, Microsoft SQL and Gmail.

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

How it works

To pass leads from okoCrm to Microsoft SQL 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 okoCrm + Microsoft SQL integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios