Find competitors' outlier videos

The scenario collects competitors' videos from видеоплощадка, keeps history in QuestDB and flags videos that gained far more than usual.

  • Competitors' view spikes — visible at once
  • Channel history builds up in QuestDB
  • Shorts are filtered out
  • A ready list of ideas on what to film
YouTubeGoogle
Set it upScriptera

How it works

To connect QuestDB and YouTube, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: When clicking ‘Test workflow’
  2. Check: Loop Over Items
  3. Then: fetch_last_registered
  4. Then: get_videos
  5. Check: if_is_empty
  6. If yes: find_video_data1
  7. Then: remove_shorts
  8. Check: if_empty
  9. If yes: map_data
  10. Then: structure_data
  11. Then: create_query
  12. Then: insert_items
  13. If no: already_populated
  14. Starts when: Execute Workflow Trigger
  15. Then: Postgres
  16. Then: sanitize_data
  17. Then: create_table
  18. Then: see table
  19. Then: drop table

You can launch this QuestDB + YouTube integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios