Overview
What it does
Ranks creators, formats, and channels by the performance they actually drive net of spend, with clear re-book and pause lists.
When to use it
You're deciding who to re-book and what to shoot more of, and you want it ranked by what actually performs net of spend — not by gut or by who's loudest in the room.
Pairs with MCP
Uplifted tags every asset by creator and format and links it to spend and outcomes, so the model can attribute performance across the whole library and channel mix at once — a job that's otherwise a multi-tab pivot table.
Best for
Heads of creative, performance marketers, producers.
Install
Drop this entire block into a SKILL.md file inside your Claude project’s .claude/skills/creator-format-scorecard/ folder. Claude auto-invokes it when you ask who to re-book, what format to make more of, or how creators stack up.
---
name: creator-format-scorecard
description: Use this skill when the user wants to rank creators, formats, or channels by the performance they actually drive net of spend — for re-booking decisions, format mix, or budget conversations.
---
# Creator & Format Scorecard
You rank the inputs to creative (creators, formats, channels) by the outcomes they produce, controlling for spend.
## Data you need
- Per-asset performance + Uplifted tags from MCP or CSV
- Required: ad_id, creator_type or creator_name, format, length_bucket, channel, spend, impressions, conversions, CPA, ROAS, hook_rate
## How to analyze
1. Group by each dimension separately: creator, format, length bucket, channel.
2. For each group compute: total spend, blended ROAS, median CPA, hook_rate, and a normalized "efficiency" = ROAS weighted by spend share (so a one-ad fluke doesn't top a proven creator).
3. Require a minimum threshold per group (≥3 assets and ≥50 conversions) before ranking; pool everything below it into "insufficient data."
4. Flag rising vs declining: compare the last 30 days to the prior 30.
## Output format
CREATOR SCORECARD — table: Creator | Assets | Spend | ROAS | CPA | Hook rate | Trend (▲/▼) | Verdict (scale / maintain / pause)
FORMAT SCORECARD — same columns by format and length bucket
CHANNEL SCORECARD — same columns by channel
RE-BOOK / RE-SHOOT LIST — top 3 creators and top 3 formats to invest more in, each with the number that justifies it
PAUSE LIST — who/what is underperforming with enough data to be sure
## Guidelines
- Weight by spend share — never let a single high-ROAS, low-spend asset crown a creator.
- Anything under the minimum threshold goes in "insufficient data," not the ranking.
- State the comparison window explicitly; every trend claim needs the prior-period number.Prompt
Ranks creators, formats, and channels by the performance they actually drive net of spend, with clean re-book and pause lists. Use it before your next round of bookings so budget follows what works.
Rank my creators, formats, and channels by the performance they actually drive, net of spend.
Data: per-asset performance + Uplifted tags ({{MCP / CSV}}). Columns: ad_id, creator, format, length_bucket, channel, spend, impressions, conversions, CPA, ROAS, hook_rate. Window: last 60 days (compare last 30 vs prior 30 for trend).
For each dimension (creator, format, length, channel): total spend, blended ROAS, median CPA, hook_rate, spend-weighted efficiency, and trend ▲/▼. Require ≥3 assets and ≥50 conversions to rank; pool the rest as "insufficient data."
Output: a scorecard table per dimension, a re-book / re-shoot list (top 3 creators + top 3 formats with the justifying number), and a pause list.
Weight by spend share so a single fluke can't crown anyone. State the comparison window.
EXPECTED OUTPUT:
- Three scorecards (creator, format, channel) ranked by spend-weighted performance
- A clear re-book / re-shoot shortlist with the numbers behind each call
- A pause list of what to stop funding