Influencer Tracking Spreadsheet: Tabs, Columns and Formulas That Scale

1. What is an influencer tracking spreadsheet, and how is it different from a booking sheet?

An influencer tracking spreadsheet follows creators after they are booked: content status, posting, results and payment, across several campaigns at once. A booking sheet answers who we are contacting and at what rate; a tracking sheet answers what was delivered, when, and what it returned.

Most teams start with one sheet that tries to do both and ends up with forty columns nobody trusts. Splitting the work into linked tabs keeps each tab short, lets different people own different stages, and makes the performance numbers traceable back to a specific post.

If you are still at the outreach and rate-negotiation stage, start with our booking template and come back to this structure once creators are confirmed.

KOC booking spreadsheet template

2. How should the workbook be structured?

Use six working tabs plus one Lists tab, and decide the grain of each tab before you add a single column. Grain means what one row represents. Mixing grains, for example putting two posts from the same creator on one row, is the most common reason trackers break.

Give every creator a permanent ID (for example CR-0142) and every deliverable an ID that includes the campaign (for example TET27-CR0142-V1). These two keys let you look up any field from any tab without copying data by hand.

• Creators: one row per creator, kept forever
• Pipeline: one row per creator per campaign
• Content: one row per draft version of a deliverable
• Posts: one row per published post
• Performance: one row per post per snapshot date
• Payments: one row per payment
• Lists: status values, platforms, campaign codes, owners

3. Which columns belong in the creator database tab?

The creator database holds facts about the person that do not change from campaign to campaign. Campaign-specific details such as the agreed fee belong in the pipeline tab, otherwise you overwrite history every time you rebook someone.

Keep follower counts as dated values rather than a single number that silently goes stale, and store contact details only to the extent your team actually needs them.

• Creator ID, display name, handle per platform (TikTok, Facebook, Instagram, YouTube)
• Profile URLs, main platform, content category and niche
• City or region, language, audience notes
• Followers and date checked
• Contact channel (Zalo, email, manager or MCN) and contact owner on your team
• TikTok Shop affiliate status: yes, no or unknown
• Past campaign IDs, internal rating, notes on reliability
• Do-not-book flag with a reason

4. What does the campaign pipeline tab track?

The pipeline tab is the control panel: one row for each creator in each campaign, showing the deal and the current stage. This is where a manager looks every morning.

Pull the creator name and handle from the database with a lookup instead of typing them, so a name change only has to be fixed once.

• Pipeline ID, campaign code, creator ID (name and handle via lookup)
• Deliverables agreed (for example 1 TikTok video plus 1 LIVE mention)
• Fee type: fixed, commission only, fixed plus commission, gifting
• Agreed fixed fee, commission rate, product value sent
• Contract status and contract link
• Sample shipped date, tracking number, received date
• Pipeline status (from the Lists tab), owner, next action and due date

5. How do you track content drafts and approvals?

Track every draft version on its own row so you can see how many rounds a deliverable took and who approved what. Overwriting a single status cell hides the delays that matter when you plan the next campaign.

Add a disclosure check column. Creators in Vietnam have advertising disclosure obligations, and a reviewer should confirm the label or caption is present before approval. Our separate guide covers what the current law requires.

• Deliverable ID, version number (V1, V2, V3)
• Draft link, submitted date
• Reviewer, review date, decision (approved, changes requested, rejected)
• Feedback summary in one line
• Claims checked (yes or no), disclosure checked (yes or no)
• Final approved date

Content approval workflowInfluencer advertising law in Vietnam

6. Which posting and link fields do you need?

The posts tab records what actually went live and how sales are tracked. Every published post gets a row with its URL, even if the creator posts more than agreed, because extra posts still drive orders you need to explain.

Record the tracking route in a column of its own. When orders are attributed through a TikTok Shop product link, a voucher code or a UTM link, the performance tab needs to know which one to read.

• Post ID, deliverable ID, platform, format (video, LIVE, story, carousel)
• Planned post date, actual post date, days late (formula)
• Post URL
• Tracking route: TikTok Shop product link, affiliate link, voucher code, UTM
• Tracking value (the code or link itself)
• Usage rights or ad authorization status, expiry date
• Post status: live, removed, edited, product link missing

KOC voucher codes

7. How should the performance tab record views, clicks, GMV and NMV?

Record performance as dated snapshots, not as one cell you keep overwriting. Views and orders keep moving for days after posting, and orders are cancelled or returned later, so a number without a date cannot be compared with anything.

Keep GMV and NMV in separate columns and write down which report each came from. GMV counts orders placed; NMV removes cancellations and returns. Paying or ranking creators on one and reporting the other is how disputes start.

• Post ID, snapshot date, days since posting (formula)
• Views, likes, comments, shares, saves
• Link clicks or product clicks, where the platform shows them
• Orders, items sold
• GMV, cancelled and returned value, NMV
• Estimated commission, source report name

GMV vs NMV for creator sales

8. What goes in the payments tab?

The payments tab answers one question for finance and for the creator: what was owed, what was paid, and when. One row per payment works better than one row per creator, because fixed fees, bonuses and commission true-ups are often paid at different times.

If you withhold personal income tax on creator payments, record the gross amount, the amount withheld and the net transferred separately. Check the current withholding rule before you set the formula.

• Payment ID, pipeline ID, creator ID
• Payment type: deposit, final fixed fee, bonus, commission true-up
• Gross amount, tax withheld, net amount
• Invoice or receipt status, bank details verified (yes or no)
• Due date, paid date, payment proof link
• Payment status (from the Lists tab)

Influencer payment reconciliationKOC tax withholding in Vietnam

9. Which status values, data validation and conditional formatting rules work best?

Statuses only work if everyone picks from the same short list. Put every list in the Lists tab and apply Data validation, dropdown from a range, to the status columns, with invalid input rejected rather than just warned.

Then use conditional formatting so problems surface without anyone filtering. Keep colours few and consistent: red for overdue, amber for at risk, green for done.

• Pipeline: Shortlisted, Confirmed, Contract sent, Contract signed, Sample shipped, Sample received, Briefed, Drafting, In review, Approved, Posted, Reporting, Closed, Dropped
• Content: Submitted, Changes requested, Approved, Rejected
• Posts: Scheduled, Live, Late, Removed, Link missing
• Payments: Not due, Due, Invoice pending, Approved, Paid, On hold
• Validation: dates as valid dates only, fees and rates as numbers above zero, IDs checked with a custom formula such as COUNTIF on the creator tab
• Formatting rule example: custom formula =AND($M2<TODAY(),$L2<>"Posted") turns the row red when a post is overdue
• Formatting rule example: =COUNTIF($A:$A,$A2)>1 highlights duplicate IDs

10. Which Google Sheets formulas calculate CPM, CPV, cost per order and ROAS?

Calculate every efficiency metric from the same three inputs: total cost, the result count and the revenue figure you agreed to use. Total cost should include the fixed fee, commission and product value, or your ratios will flatter gifted creators.

Wrap each formula in IFERROR so empty rows stay blank instead of showing errors. The examples below assume total cost in column H, views in I, clicks in J, orders in K, GMV in L and NMV in M; adjust the letters to your sheet.

• Total cost: =SUM(E2:G2) where E is fixed fee, F commission and G product value
• CPM (cost per 1,000 views): =IFERROR(H2/I2*1000,"")
• CPV (cost per view): =IFERROR(H2/I2,"")
• CPC (cost per click): =IFERROR(H2/J2,"")
• Click-through rate: =IFERROR(J2/I2,"")
• Cost per order: =IFERROR(H2/K2,"")
• ROAS on NMV: =IFERROR(M2/H2,"") and ROAS on GMV: =IFERROR(L2/H2,"")
• Net share of GMV: =IFERROR(M2/L2,"")
• Pull a creator name: =XLOOKUP(C2,Creators!A:A,Creators!B:B,"Not found")
• Campaign total NMV: =SUMIFS(Performance!M:M,Performance!B:B,"TET27")
• Days late: =IF(N2="","",MAX(0,N2-M2)) with planned date in M and actual date in N

KOC performance scorecard

11. Example: tracking 30 KOCs across two campaigns

Example: a skincare brand runs a product launch and a mega-sale push in the same quarter, with 30 KOCs, some booked for both. The creator tab has 30 rows. The pipeline tab has one row per creator per campaign, so a creator booked twice appears twice with different campaign codes, fees and statuses.

Each Monday the coordinator updates statuses, logs new drafts and adds a performance snapshot for every post that is under 30 days old. A summary tab uses SUMIFS and COUNTIFS to show, per campaign, how many deliverables are late, approved, posted and paid, plus total cost, NMV and ROAS on NMV. When a creator disputes a commission, the team filters the performance tab by post ID and shows the dated snapshots and the source report.

Creator campaign reporting

12. What are the most common influencer tracking spreadsheet mistakes?

Most broken trackers fail for structural reasons, not because the team was careless. Fix these and the sheet stays usable for much longer.

• One row per creator holding several posts or campaigns
• Free-text statuses, so filters miss half the rows
• Overwriting performance numbers instead of adding dated snapshots
• Mixing GMV, NMV and commission in one column
• Leaving product value and commission out of total cost
• Typing names instead of looking them up by ID
• No owner or next-action column, so nobody chases late work
• Sharing the master sheet with creators instead of a filtered view

13. When does a spreadsheet stop scaling, and when should you move to a creator CRM?

A spreadsheet is the right tool until the coordination around it becomes the job. Typical signs: several campaigns run in parallel, more than one person edits the same rows, approvals happen in chat and never reach the sheet, and payment status is rebuilt by hand before every finance meeting.

At that point a creator CRM gives you the same tabs as linked records, with history, reminders, permissions and a shared view for clients. Keep the spreadsheet structure in this guide as your field list: it maps cleanly onto most CRM setups, so moving later costs far less.

Influencer CRM software