Campaign operations

Influencer Tracking Spreadsheet Template: Columns, Rules and Alerts

A good influencer tracking spreadsheet is small: one row per booking, a fixed list of statuses, and a few formulas that flag anything late. This guide shows the three tabs, the columns, the dropdown rules and the alert formulas we use to run KOC bookings in Vietnam, so you can build the same sheet in Google Sheets or Excel in about fifteen minutes. It also says honestly when a sheet stops being enough.

Published October 17, 20267 min readDaisyLexi Insights

Short answer

What should an influencer tracking spreadsheet contain?

Use three tabs: Creators for who people are, Bookings with one row per collaboration, and Lists for the allowed status values. Give every booking an ID, a status chosen from a dropdown, an owner, a draft due date, a post date and a next action. Add formulas that flag late drafts, late posts and stale outreach.

Tab 1 Creators: one row per person, never duplicated
Tab 2 Bookings: one row per collaboration, with a unique ID
Tab 3 Lists: the seven pipeline stages used by the dropdown
Status comes from a dropdown, never free text
Every row has an owner and a dated next action
Alert columns flag late drafts, late posts and silent outreach

1. What is an influencer tracking spreadsheet, and when is it the right tool?

An influencer tracking spreadsheet is a shared sheet where every creator booking has one row, one status and one owner. It is the right tool when one or two people run a few campaigns at a time and the main risk is forgetting a follow-up, not coordinating a large team.

Vietnamese search results are full of paid templates, but the structure that matters is simple enough to build yourself. The value is not the file; it is the discipline of one row per booking, a closed list of statuses and dates that someone checks every morning.

2. How should the workbook be organised?

Use three tabs. Keeping people and bookings apart stops the most common spreadsheet failure: the same creator typed three different ways, with three different fees.

Name the tabs exactly so formulas stay readable.

Creators: one row per person, with handle, platform links, niche, contact, city and a note on past work
Bookings: one row per collaboration, linked to a creator by handle or ID
Lists: the allowed status values and any other dropdown lists, such as platforms and deliverable types

3. Which columns does the Bookings tab need?

Start with the fields below and add nothing until a real question demands it. Every extra column is a cell someone must keep current, and stale cells are worse than missing ones.

The columns follow the same record shape as the seven-stage pipeline, so the sheet can later be moved into a booking tool without redesign.

A Booking ID: a short unique code such as K-0001
B Creator handle and C Platform
D Deliverable: for example one TikTok video, 30 to 45 seconds
E Agreed fee in VND, entered only once the fee is agreed
F Status: dropdown from the Lists tab
G Draft due date and H Post date
I Live URL, filled in when published
J Owner: the one person responsible
K Next action and L Next action date
M Last contact date
N Stage number, O Late draft, P Late post, Q Silent outreach: helper columns made by formulas

KOC booking pipeline: the 7 stages

4. Which statuses should the dropdown allow?

Seven statuses are enough for most teams, and a closed list is what makes filtering and counting reliable. Put them in cells A2 to A8 of the Lists tab, in this order: Outreach, Negotiating, Booked, Shipping, Review, Published, Paid.

Select the Status column, open Data validation, choose a dropdown from a range and point it at Lists!A2:A8. Set invalid entries to be rejected. Now nobody can type approx booked or done, and every count you build later is clean.

5. How do you turn a status into a number the sheet can use?

Give each row a stage number. In column N, enter this formula in row 2 and fill it down: =IFERROR(MATCH(F2,Lists!$A$2:$A$8,0),0). Outreach becomes 1, Negotiating 2, Booked 3, Shipping 4, Review 5, Published 6, Paid 7, and a blank status becomes 0.

Comparing numbers is what lets the alert formulas below work without any quoted text, so they paste cleanly into Google Sheets or Excel. If your regional settings use semicolons as separators, swap the commas for semicolons.

6. Which alert formulas catch late work?

Three formulas cover most problems. They return TRUE when a row needs attention, and a conditional-format rule can then colour the whole row.

Late draft in column O: =AND(N2>0,G2<>0,G2<TODAY(),N2<5). The draft date has passed and the booking has not reached Review.

Late post in column P: =AND(N2>0,H2<>0,H2<TODAY(),N2<6). The post date has passed and the content is not yet Published.

Silent outreach in column Q: =AND(N2=1,M2<>0,TODAY()-M2>3). The creator has been contacted but nobody has followed up for more than three days. Change 3 to your own follow-up rule.

7. How do you highlight problems and see totals at a glance?

Select the Bookings rows, add a conditional-format rule with a custom formula, and use =OR($O2,$P2,$Q2). Pick a yellow fill. Any row with a late draft, late post or silent outreach lights up, and a filter on the colour gives you the morning to-do list.

For a small dashboard on a fourth tab, count bookings per stage with =COUNTIF(Bookings!F:F,Lists!A2) beside each status, and total committed spend with =SUMPRODUCT((Bookings!N2:N500>=3)*Bookings!E2:E500). That sums the agreed fees of every booking that has reached Booked or beyond.

8. What daily and weekly routine keeps the sheet honest?

A tracker only works if it is current. Fix a short routine and write it at the top of the sheet.

Daily, the owner of each booking updates status and next action before closing the sheet. Weekly, one person filters the highlighted rows, chases each one and clears the flags.

Daily, 5 minutes: filter by your name, update status, set the next action date
Monday: review every highlighted row and decide to chase, replace or cancel
Friday: check that every Published row has a live URL and that finished work moves toward Paid
Month end: duplicate the tab as an archive and start the next period clean

Content approval workflow

9. What mistakes break influencer spreadsheets?

Most broken sheets fail in the same few ways, and all of them are avoidable with the rules above.

Merged cells and colour-only status are the worst, because neither can be filtered or counted.

Free-text statuses, so no two people spell them alike
A creator pasted into the sheet twice with two different fees
Money and notes mixed in the same cell, which breaks totals
Everyone editing the Lists tab; lock it so only one person can change it
No owner, so everyone assumes someone else is chasing
Payment tracked in the same column as content status, hiding unpaid finished work

10. When should you move from a spreadsheet to a tool?

Move when the sheet starts costing more time than the work it tracks. Typical signs are several people editing at once, more than one campaign or client in parallel, creators asking for status updates you cannot answer quickly, and payments that no longer reconcile with deliverables.

At that point a creator CRM with a booking pipeline gives you the same record shape with permissions, history and reminders built in. Our comparison of influencer CRM software explains what to look for and when a sheet is still enough, and the operations guide shows the wider system around bookings.

If you want to try the pipeline in a tool, DaisyLexi Roster is a creator CRM and booking pipeline you can sign up for at roster.daisylexi.com. Keep the spreadsheet as your export format either way.

Influencer CRM software: what to look for Influencer campaign management: an operations system Influencer payment reconciliation

FAQ

Frequently asked questions

Can I use Google Sheets to manage influencers?

Yes. Google Sheets handles dropdown validation, conditional formatting and the formulas in this guide, and several people can edit at once. It is a good fit for a small team running a few campaigns, as long as statuses come from a closed list and every row has an owner.

What columns do I need in an influencer tracker?

At minimum: booking ID, creator handle, platform, deliverable, agreed fee, status, draft due date, post date, live URL, owner and next action with its date. Add helper columns for the stage number and the late-work alerts.

How do I stop the sheet getting messy?

Use a dropdown for status, keep creators on their own tab, give every booking a unique ID and one owner, and archive finished campaigns each month. Lock the Lists tab so statuses cannot drift.

Do these formulas work in Excel?

Yes. IFERROR, MATCH, AND, OR, TODAY, COUNTIF and SUMPRODUCT all exist in Excel with the same behaviour. Only the way you set up the dropdown differs slightly: it is under Data, then Data Validation.

When is a spreadsheet no longer enough?

When several people edit at once, you run more than one client or campaign, or payments stop matching deliverables. Those are the moments a CRM with a booking pipeline starts to pay for itself.