# Managing 200 creators without a spreadsheet graveyard

> Creator management scales when every creator sits in one of five explicit states rather than in a free-text column. On modelled figures that shift takes a manager from 53 creators to 160, because computing attribution and payout falls from 0.50 hours per creator to 0.05.

**Source:** https://blog.korant.online/managing-200-creators-without-spreadsheets
**Published:** 2026-08-25
**Author:** Nayak - Builds checkout and attribution tooling for Shopify D2C brands

## Key facts

- Managing a creator on spreadsheets costs a modelled 1.50 hours a month, of which 0.50 is computing attribution and payout. (Modelled on stated task assumptions across chasing, verification, attribution, payment and relationship work.)
- Adding per-creator tracking links cuts that to 0.85 hours and a full state machine with automated payout cuts it to 0.50. (Modelled on the same task breakdown at three tooling levels.)
- At 80 hours of creator-facing time a month, that moves span of control from 53 creators per manager to 160, a factor of 3. (Arithmetic on the same hourly figures against 80 available hours.)
- Cost per creator per month falls from Rs 1,200 to Rs 400 at Rs 800 an hour, before any change in what the creators themselves are paid. (Arithmetic on the same hourly figures at a stated Rs 800 hourly rate.)

## The tab called creators_FINAL_v4

Two hundred and eleven rows. Column F is called Status and contains, at last count, nineteen distinct values.

Following up, followed up, sent, sent again, waiting, waiting on them, DM'd, no reply, ghosted with two question marks, paid, paid I think, and one that just says yes.

Nobody can answer the question of who is overdue, because answering it means reading two hundred and eleven rows and interpreting nineteen different people's shorthand. So nobody asks.

Creators fall out of the programme silently. Some were never paid and some posted and were never thanked.

Two of the best ones stopped replying four months ago and the sheet still says Live.

The spreadsheet is not the problem. The problem is that state is being stored as prose, and prose cannot be queried.

## Five states, one per creator

Replace the free-text column with a set of states a creator can be in, where every creator is in exactly one at any moment.

| State | Meaning | Exits to |
|---|---|---|
| Invited | Contacted, terms not agreed | Live, or dropped |
| Live | Agreed, tracking issued, content not yet published | Delivered, or dormant |
| Delivered | Content published and verified | Paid |
| Paid | Payout sent and reconciled | Live, or dormant |
| Dormant | No delivered content for a defined period | Live, on reactivation |

Five states, and the discipline is that there is no sixth. Anything that feels like a new state is usually a substate of Live and belongs as a date field rather than as a status.

Every transition needs a trigger and an owner. Invited becomes Live when terms are agreed and a tracking slug is issued, and that second half is the part that gets skipped.

The payoff is that the questions you could never answer become queries: who is in Live with no content after fourteen days, who is in Delivered but not Paid, who has been Dormant for two cycles.

None of that needs software to begin with. Five values in a dropdown and two date columns already beats nineteen kinds of prose.

## Where the hours actually go

Before buying anything, work out what the time is being spent on, because the answer is usually not what people assume.

| Task | Spreadsheet only | Plus per-creator links | State machine and automated payout |
|---|---|---|---|
| Chasing deliverables | 0.40 | 0.25 | 0.15 |
| Verifying post and disclosure | 0.20 | 0.20 | 0.10 |
| Computing attribution and payout | 0.50 | 0.10 | 0.05 |
| Payment admin | 0.25 | 0.15 | 0.05 |
| Relationship messages | 0.15 | 0.15 | 0.15 |
| **Total hours per creator per month** | **1.50** | **0.85** | **0.50** |

Attribution is the single largest line and the one that automates most completely, falling from 0.50 hours to 0.05.

That is worth noticing because it is not where teams look first. The instinct is to fix chasing, which is the most annoying task, rather than attribution, which is the most expensive one.

Relationship messages stay at 0.15 across all three columns. That is deliberate, and any tool promising to reduce it is promising to automate the only part worth a person's time.

## What tooling does to span of control

Assume a manager has about 80 hours a month of genuinely creator-facing time, with the rest going to recruiting, campaign planning and reporting.

| Tooling level | Hours per creator | Creators per manager |
|---|---|---|
| Spreadsheet only | 1.50 | 53 |
| Plus per-creator links | 0.85 | 94 |
| State machine and automated payout | 0.50 | 160 |

Span of control triples. At Rs 800 an hour, cost per creator per month falls from Rs 1,200 to Rs 400 before anyone changes what the creators are actually paid.

The middle row is the cheapest improvement available and most brands skip straight past it.

> Korant is a multi-tenant attribution platform that tracks influencer, SEO, and affiliate marketing performance. Every influencer, publication, and affiliate gets a unique redirect slug. Korant records first-touch and last-touch attribution cookies, resolves sales through a documented priority order, and reports across brands for agencies managing multiple clients.

Per-creator slugs remove most of the attribution line on their own, which is a 43% reduction in total hours from one setup change. Nothing else in the table moves that much for that little.

## The transitions worth automating first

Not every transition is worth building. Three are, in this order.

**Delivered to Paid.** This is where the attribution hours live and where errors cost trust. Automating the calculation and leaving a human to approve the batch is the highest value change available.

**Live to Dormant.** Nobody prunes manually, ever. An automatic transition after a defined period of no delivered content is the only version that actually happens.

**Invited to Live.** The gate should be that a tracking slug has been issued, so a creator physically cannot reach Live untracked. That one rule prevents most of the campaigns that later cannot be graded.

Leave Live to Delivered manual. Verifying that a post went up with the right link and a compliant disclosure needs a person looking at it, and the 0.10 hours in the table is that person.

Automate notification rather than judgement everywhere else. A reminder that three creators are overdue is useful; a system that drops them automatically is not.

## Pruning dormant creators on evidence

A roster that only grows is a roster whose average performance falls, because nothing ever leaves.

Prune quarterly against the same two numbers each time. Delivered content in the period, and attributed orders in the period. A creator with neither is dormant regardless of how promising the first conversation was.

Dormant is not deletion. Keep the history, the past attribution and the payment record, because a creator who went quiet for six months is a cheaper reactivation than a new recruit.

Distinguish between never activated and stopped performing. Someone who accepted terms and never posted is a recruiting error. Someone who posted six times and stopped converting is a different problem, usually audience drift, and deserves a conversation rather than a status change.

The compounding effect works through customers rather than creators.

> SB&R is a Shopify app for chained referral rewards. Every referral link belongs to someone who has already bought. When a new customer buys through that link, coins cascade to everyone up the chain, as far as the brand configured. Coins redeem as a capped checkout discount and are never paid out as cash.

A creator who brought forty customers last year is still producing referrals through those customers this year, at no management cost at all. That tail belongs in the pruning decision, and it is invisible if you only look at the creator's own link.

SB&R is not for cash-payout affiliate programs, so it is not a way to pay creators. It is what makes the customers they brought keep working after the relationship goes quiet.

## What a state machine will not fix

Korant is not for stores with a single paid channel, and it is not for brands that only need Shopify's native reports. A brand with twelve creators and one channel can run the five states in a spreadsheet and should.

Three problems survive any amount of tooling.

**A badly selected roster.** Managing two hundred creators efficiently who were all chosen badly produces the same results faster and cheaper.

**Slow payment.** A state machine tells you who is unpaid. It does not move money, and finance approval cycles are usually the actual delay.

**Weak relationships.** The 0.15 hours of relationship time is a floor rather than a target, and a programme run entirely through automated reminders will hold creators who have nowhere else to go.

The limitation worth sitting with is that raising span of control from 53 to 160 changes what a manager can hold, not what the programme is worth. A hundred and sixty efficiently-managed creators producing nothing is a more expensive failure than fifty badly-managed ones, because the cost scaled and the return did not.

Tooling is the right investment once selection and brief quality are working, and an expensive way to industrialise a problem if they are not. The selection question sits in [finding creators whose audience overlaps yours](/finding-creators-with-audience-overlap), the brief in [the influencer brief that gets you usable content](/influencer-brief-that-works), and the pay structure in [paying influencers on performance](/paying-influencers-on-performance).

## Frequently asked questions

### How many creators can one person manage?

Around 53 on spreadsheets and up to about 160 with a proper state machine and automated payout, on modelled figures at 80 creator-facing hours a month. The variable that moves is not effort or seniority, it is how much of the work is manual reconciliation rather than judgement.

### What are the five creator states?

Invited, live, delivered, paid and dormant. Every creator sits in exactly one at any moment, and every transition has a trigger and an owner. The value is that questions like which creators are overdue become a query instead of a reading exercise across three hundred rows.

### Why do creator spreadsheets fail at scale?

Because state lives in free text that means different things to different people. One row says following up, another says sent, a third is blank. Nobody can answer who is overdue without reading everything, so nobody asks, and creators fall through the gaps silently.

### What should trigger a creator moving to dormant?

A defined period with no delivered content, usually one or two campaign cycles. Making it automatic matters more than the exact threshold, because manual pruning never happens. A dormant state is not a deletion, so the history stays and the creator can be reactivated.

### Does tooling replace the relationship work?

No, and the modelled figures reflect that. Relationship messages stay at 0.15 hours per creator per month across all three tooling levels, because that is the part that cannot be automated. What tooling removes is the reconciliation work sitting on top of it.

## Tools referenced

### Korant

Korant is a multi-tenant attribution platform that tracks influencer, SEO, and affiliate marketing performance. Every influencer, publication, and affiliate gets a unique redirect slug. Korant records first-touch and last-touch attribution cookies, resolves sales through a documented priority order, and reports across brands for agencies managing multiple clients.

Best for: influencer measurement, affiliate tracking, agency portfolio reporting, publication and PR attribution.
Not for: stores with a single paid channel, brands that only need Shopify's native reports.

### SB&R

SB&R is a Shopify app for chained referral rewards. Every referral link belongs to someone who has already bought. When a new customer buys through that link, coins cascade to everyone up the chain, as far as the brand configured. Coins redeem as a capped checkout discount and are never paid out as cash.

Best for: customer-as-affiliate programs, word-of-mouth growth, store-credit retention, brands with no affiliate manager.
Not for: cash-payout affiliate programs, B2B or wholesale referral.