Your agent office · Ep. 2, the metrics agent
Three prompts to set up Leo, the agent that crosses the metrics from all your channels and tells you which videos work.
- Keyword
- LEO
- Type
- Agents and business
- Published
- Contents
- 3 pieces
Leo looks at all your videos at once, across every channel. Three prompts for Claude Code, in this order.
- Use the median. One video that takes off inflates the average.
- If more than half the viewers leave in the first 3 seconds, the opening is the problem.
Gather the data
Export each channel's stats as CSV and put them in a folder.
In this folder I've left my channel stats: [tiktok.csv], [instagram.csv] and [youtube.csv]. Each row is a video. 1. Open them and tell me which columns each one has and what period they cover. 2. Merge them into a single table with these columns: date and time, channel, short title, views, likes, comments, shares, saves, duration and, if it exists, the percentage that leaves before 3 seconds and the average watch time. 3. Flag anything missing or odd: duplicated videos, channels with fewer days than the others, zero figures that look like an export error. 4. Don't change the original files.
Find the pattern
Analyse my videos like a social media analyst would and tell me the truth, even if I don't like it. Write the analysis as a script so I can rerun it every week. 1. Totals: posts and views, overall and per channel. 2. Per channel, sort the videos by date and check whether there is a point where views change level. If there is, give me the date, the median views before and after, and what the videos on each side have in common (format, topic, first line, duration). 3. The 3 best and 3 worst on each channel, with one sentence on why you think they performed that way. 4. Opening: what percentage leaves before 3 seconds on each video, the average, and which videos hold people best and worst. 5. Separate what you know from what you assume. With fewer than 10 videos per group, say so: it's a hint, not a conclusion.
Decide what changes in the next video
With what you've found: 1. Make me a report as an HTML page: the totals at the top, one bar per video sorted by date with the before and after marked, and the 3-second drop-off for each video. 2. Tell me three things to repeat and three to stop doing, each with the figure that backs it up. 3. Rewrite the first 3 seconds of my next video: the script is in [guion.txt]. Give me three versions of the opening, each with what you see and what you hear in the first second. 4. Note which figure we'll check next week to know whether it worked.
From the Reel “A day at our agent office · Ep. 2”
The figures in the video are ours, from 1 to 11 November 2026. YouTube only includes Shorts published up to the 7th.
Watch the Reels on Instagram