Description
Follower count is not a return on investment
It’s easy to know how many followers a partner has and surprisingly hard to know what they actually generated — because that number usually lives in a different spreadsheet, if it’s tracked at all.
This kit puts reach, cost, and revenue next to each other for every partner and every post, so ROI stops being a guess and becomes a number you can rank partners by.
What you get
1. A 10-sheet Excel workbook
- Start Here — how the sheets connect
- Partner Directory — every partner, with platform, type, follower count, and commission rate
- Campaign & Post Log — every sponsored post, with reach, engagement, revenue, and cost
- Payout Tracker — what you owe each partner, what’s been paid, and what’s overdue
- Affiliate Link Performance — dedicated affiliate links and codes, tracked separately
- Partner Performance Ranking — every partner’s totals and ROI, pulled in automatically
- Content Type Breakdown — which content format — post, story, video, review — performs best
- Monthly Performance Summary — reach and revenue trend by month, with a chart
- Partner Lookup — type a partner, see their full record instantly
- Dashboard — active partners, total reach and revenue, overall ROI, and your best partner, live
2. An 11-page companion guide (PDF)
How to log a campaign so ROI calculates correctly even for “free” organic posts, how to read Partner Performance Ranking without over-trusting a small sample, what the Payout Tracker prevents, and a simple monthly partnership review routine.
3. A Notion template
An importable Notion workspace mirroring the key tracking tables, with a quick-reference section and a next-actions checklist.
Built for
- Brands running influencer or affiliate programs with more than a handful of partners
- Anyone who has paid a partner late, or twice, because there was no central payout record
- Marketers who want to rank partners by actual ROI instead of follower count
- Teams managing both influencer posts and affiliate codes who want them in one place
What’s in the file
- 1 x Excel workbook (.xlsx) — formulas live and editable
- 1 x PDF companion guide, 11 pages
- 1 x Notion import file (Markdown) — key tables ready to import
- Delivered as a single ZIP, available immediately after payment
Compatibility
Microsoft Excel 2016 and later, Microsoft 365, Google Sheets, and LibreOffice Calc. Works with any currency, any channel, and any naming convention — you enter your own data rather than being locked into a fixed list of platforms or categories.
This is a planning and organization tool. It does not constitute tax, accounting, legal, or financial advice. Results depend on the accuracy of the figures you enter.
Frequently asked questions
Does this track influencer analytics automatically?
No — you log reach and engagement from whatever the partner or platform reports, which keeps it accurate and works with any platform or partner type.
How should I log a free or organic post?
Log it with $0 cost — this is what lets ROI calculate correctly and fairly across every partner, paid or unpaid.
How many partners and campaigns can I track?
The Partner Directory holds 30 partners and the Campaign & Post Log holds 40 entries — copy a row down to add more of either.
Can I track affiliate codes separately from sponsored posts?
Yes — the Affiliate Link Performance tab is built exactly for that, tracking clicks, conversions, and revenue per code.
Will this work in Google Sheets?
Yes. Upload to Google Drive and open with Google Sheets — formulas, dropdowns, and the chart all carry over.
Reviews
There are no reviews yet.