TIKTOK SHOP · SEP 27, 2026 · 5 MIN
What KPIs Should a Weekly TikTok Shop Affiliate Report Include?
Nine KPIs for a weekly TikTok Shop affiliate report, each with its formula, the question it answers, and what to compare it against so the number means something.
A weekly TikTok Shop affiliate report should include nine KPIs: affiliate GMV, active posting creators, new versus returning creators, sample-to-post rate, posts per creator, GMV per post, top creator concentration, follow-up reply rate, and GMV Max creative verdicts. Each one should sit next to last week and your trailing four-week average. Your own trailing weeks are the benchmark, because published averages rarely match your category or commission.
Here is how to define each one so the numbers are consistent every week.
Why does a weekly affiliate report need fixed definitions?
Most weekly reports fail the same way. The window shifts, a metric gets defined differently by whoever pulled it, and nobody can say whether a change is real. Fix three rules before any KPI:
- One window. Monday to Sunday, stated at the top of the report. Every number states its window.
- One baseline. This week versus last week and versus the trailing four weeks. Add trailing twelve weeks for slow-moving metrics.
- One source. Pull from the same system every week. If two tools disagree, pick one and write down which.
What are the nine KPIs and how do you calculate them?
1. Affiliate GMV
Formula: sum of GMV from orders attributed to affiliate content (videos, LIVEs, and affiliate links) in the window.
It answers: did creator-driven sales move? Report it net of refunds if your source allows, and say which you used. Split out ad-boosted affiliate videos if you can, so paid spend does not hide an organic slowdown.
2. Active posting creators
Formula: count of distinct creators who published at least one shoppable post for your products in the window.
This is the size of your working roster, not your affiliate list. A list of hundreds with a small active count is the most common gap we see in an audit.
3. New versus returning creators
Formula: new = active posting creators whose first post for you fell in the window. Returning = active posting creators who had posted for you before the window.
It answers: is the program growing through recruitment, retention, or neither? A week of flat GMV can hide heavy recruitment covering for creators who went quiet. Our affiliate health score tracks the retention side as its own pillar.
4. Sample-to-post rate
Formula: samples shipped in a cohort that produced at least one post, divided by total samples shipped in that cohort.
Measure by ship-date cohort, and only once the cohort has had time to post. Pick a lag (for example, samples shipped three to four weeks ago) and keep it fixed. Reporting "posts this week divided by samples this week" mixes cohorts and swings with shipping volume.
5. Posts per creator
Formula: total shoppable posts in the window divided by active posting creators.
It separates "more creators" from "more content from the creators you have." A drop here with a steady creator count usually means your regulars are slowing down.
6. GMV per post
Formula: affiliate GMV in the window divided by shoppable posts in the window.
It is a rough quality signal. Because posts keep selling after the week ends, compare it only against the same calculation in prior weeks, never against a lifetime figure.
7. Top creator concentration
Formula: affiliate GMV from your top five creators divided by total affiliate GMV, for the window.
It answers: how much of the week depends on a handful of people? Rising concentration is a risk flag even when total GMV is up. Pair it with the names, so the team knows who to protect.
8. Follow-up reply rate
Formula: creators who replied to any message in a follow-up sequence, divided by creators who received at least one follow-up, in the window.
Track it per sequence step if your tool allows. If replies come almost entirely from the first message, the later steps are not working, or they are not being sent. Our audits often find outreach that stops after one message.
9. GMV Max creative verdicts
Formula: for each creative with spend in the window, compare cost per order (spend divided by orders) against your breakeven, and against its own trailing weeks. Assign one verdict: scale, replace, maintain, or cut.
The KPI is the count in each bucket plus the spend sitting in "cut." Written as a rule, not an opinion, the verdict is the same no matter who runs the report.
What should the report compare each KPI against?
Your own history. For each KPI show three columns: this week, last week, and the trailing four-week average, with the change as a percent. Flag anything that moved beyond a threshold you set once and leave alone, rather than eyeballing it fresh each Monday.
We deliberately avoid industry benchmarks here. Published "average sample-to-post rates" or "good GMV per post" figures rarely state their category, price point, or commission, so comparing against them tells you little. A drop against your own trailing month is a real signal every time.
What should the report do besides list numbers?
End with actions. For each KPI that moved past its threshold, name the likely cause and one next move with an owner:
- Sample-to-post rate down: check which sample cohort stalled and whether follow-ups went out.
- Returning creators down: pull the list of creators who posted last month and not this month.
- Concentration up: brief two or three mid-tier creators on what the top creators are doing.
- Spend in "cut": pause those creatives this week.
A report that ends in three actions gets read. A report that ends in a table gets skimmed.
How do you stop building this report by hand?
Every number above comes from data your shop or affiliate tool already stores. That makes it a good first automation: a scheduled workflow pulls the window, computes each formula against the trailing baseline, and posts the report to Slack before the week starts. We walk through that build in how to automate TikTok Shop weekly reporting.
The weekly report is also the easiest place to see the leaks from the affiliate leak ledger: samples that never became posts, creators who went quiet, and outreach that stopped early.
Want this running for your shop?
Clankers audits your TikTok Shop for free, ranks each gap by the revenue behind it, and builds one custom workflow that closes the biggest one, installed in your stack and owned by your team. For many brands that first workflow is this report. Request your free audit.