Monday morning Wistia engagement digest, posted in Slack
Every Monday at 9am, post a one-glance Slack summary of last week's top videos, rising stars, drop-off points, and a smart fix for each.
Build me an agent workflow that posts a weekly Wistia engagement digest to a Slack channel I pick, so my marketing team starts the week knowing what video content is working.
Trigger: cron, every Monday at 9:00 AM in my local time zone.
Inputs the workflow should ask me for at setup: the Slack channel (name or ID) where the digest should be posted, and optionally a Wistia project or folder to scope the digest to (default to the whole account if I leave it blank).
Steps the agent should run each week:
1. Call the Wistia "List Medias" operation to pull the candidate videos in my account (or in the scoped project/folder if I set one). Focus on videos likely to have activity in the last 7 days; you can sort by updated date or fall back to the most recent uploads if needed.
2. For each candidate, call Wistia "Get Media Analytics" for the last 7 days and pull plays, loads, engagement rate (play rate / average percent watched), and conversions. Skip videos with zero plays for the week so the digest only highlights active content.
3. Rank the remaining videos by plays and pick the top 5. Then call Wistia "Get Media Engagement" on the top 2 of those videos to read the second-by-second heatmap and identify specific drop-off points (for example "viewers consistently abandon around 0:45") and any replay spikes.
4. To find rising and declining performers, also call "Get Media Analytics" for the prior 7 days on the top candidates and compare plays week over week. Pick one rising performer (biggest week-over-week increase in plays) and one declining performer (biggest decrease).
5. Post a single formatted Slack message to my chosen channel using the Slack Bot "Send a Message" operation. Use Slack mrkdwn (bold with *asterisks*, links as <url|text>, no Markdown stars-stars). Do not use em dashes anywhere in the message; use commas or periods instead.
Message format I want:
- One-line header with the week range, e.g. *Wistia weekly digest, Jun 9 to Jun 15*.
- *Top 5 videos*: a numbered list. For each entry, link the video title back to its Wistia stats page and show the key numbers inline (plays, engagement rate, and conversions if non-zero).
- *Rising this week*: one video with the week-over-week delta and a one-line concrete suggestion (e.g. "plays up 47%, repurpose the intro into a LinkedIn clip").
- *Watch out*: one declining video with the delta and a one-line suggestion (e.g. "plays down 38%, swap the thumbnail or test a shorter cut").
- *Drop-off insights*: one bullet per top-2 video flagging the specific timestamp where viewers leave or replay, with one concrete edit suggestion (re-cut intro, add a CTA at the drop point, tighten the middle, move the hook earlier, etc.).
Keep the tone tight, skimmable, and confident. No filler intro paragraph. The whole message must fit in a single Slack post without truncation. If there are fewer than 5 active videos in the week, just include what exists and skip the rising/declining sections if there is not enough comparison data.
Error handling: if Wistia returns no active videos for the week, post a short message saying the account had no measurable video activity in the last 7 days, instead of an empty digest. If the Slack post fails, log the error so I can fix the channel or permissions.
Additional information
What does this prompt do?
- Posts a single clean summary in the Slack channel you pick every Monday at 9am so the marketing team starts the week aligned on what is working.
- Ranks last week's top five videos by plays and shows engagement and conversion numbers for each, with the title linked back to Wistia.
- Calls out one rising and one declining video week over week so the team can see momentum and trouble spots at a glance.
- Reads the heatmap on your top two videos and flags the exact timestamps where people drop off or replay, paired with one concrete edit suggestion.
What do I need to use this?
- A Wistia account where you can create an API token with read access to videos and stats.
- A Slack workspace and permission to add a bot that can post in the channel you choose.
- The name of the Slack channel where the weekly digest should land.
How can I customize it?
- Change the day or time the digest fires, for example Friday end-of-week or a daily recap instead of weekly.
- Pick a different Slack channel, or send it to a private channel for just the marketing leads.
- Adjust how many videos are highlighted, or change the ranking metric to engagement rate or conversions instead of plays.
- Scope the digest to a specific Wistia project or folder so library videos and tests do not clutter the list.
Frequently asked questions
Do I need a paid Wistia plan to use this?
Will the digest post as a person or as a bot?
Can I send the digest to a private channel?
How does it decide which videos are rising or declining?
Where do the drop-off suggestions come from?
Stop digging through Wistia every Monday morning.
Connect Wistia and Slack once, and your team gets a sharp video performance recap delivered automatically every week.