The Manual Way (Spreadsheet)

You can score content performance in a free spreadsheet. One row per post, focused on quality signals. It's the right call when you're running just a handful of collabs.

Each row is one creator post. Track the creative choice up front so you can tie performance back to it later, then fill in the numbers once the post has had time to breathe.

A copyable header row to start from:

Creator | Platform | Content URL | Format | Hook/Angle | Likes | Comments | Saves | Shares | Save+Share % of Eng. | Watch-through % | Avg Watch Time | Replays | Follower Lift | vs Creator Baseline | Comment Sentiment | Notes

1. Before posting: fill Creator, Platform, Format, and the Hook/Angle from the brief. This is what lets you tie performance back to a creative choice later.
2. 48–72 hours after posting: pull Likes, Comments, Saves, Shares, and the video stats (watch-through, average watch time, replays) from the creator's insights. Ask them to screenshot their analytics — most will.
3. Read the comments and note the sentiment in a word or two (curious, excited, confused, flat).
4. Compute the mix: Save+Share % = (Saves + Shares) ÷ total engagements. Higher means stronger content.
5. Compare to baseline: mark each post as above, at, or below that creator's usual numbers.
6. Rank by content quality (save+share % and watch-through), not by size.

If a post is meant to drive clicks or sales, you can't read that from engagement alone — you need a way to attribute the traffic. Two simple tools:

• UTM parameters — append tracking tags to any link a creator shares, so your analytics know exactly which post sent the visit. Give each creator their own utm_source and utm_campaign so traffic is attributable per creator.

https://yourstore.com/landing?utm_source=creatorname&utm_medium=influencer&utm_campaign=summer_ugc

• Discount / promo codes — give each creator a unique code (e.g. JAMIE15). Redemptions tell you which creator actually drove sales, and the code doubles as an incentive for their audience.

The spreadsheet works but has two costs: creators must send you their insights, and you're copy-pasting for hours. Fine for 3–5 posts. Past that, it stops scaling.

Next up: The Automated Way (Impulze) — how to pull the same numbers without chasing a single screenshot.