Influencer tracking sheet template: one row per deliverable, from contract to payment

An influencer tracking sheet is a spreadsheet with one row per deliverable and columns for every step a creator passes through: contract, product, concept, draft, live post, invoice and payment. Each stage has a fixed status list, each row has a next action, and formulas flag what is late. It is the operations sheet. It does not hold results; those belong in the dashboard.

You will usually run three sheets in a campaign, and this post covers the middle one. The shortlist template chooses the creators, this tracker moves them through the campaign, and the dashboard template reads the results. Our micro-influencer campaign plan shows a short version of this tracker as a stage table. For the whole channel, start with the complete guide to influencer marketing in India, and see how we work for the stages the tracker follows.

Three sheets, three jobs

Keep them separate. A tracker that tries to hold views, clicks and orders turns into a 60-column sheet nobody opens. A dashboard that tries to hold dispatch dates and contract versions loses its summary.

One row per deliverable

Use one row per deliverable, not per creator, and repeat the creator ID. A creator who owes a Reel and a Story set has two rows, because the two items are approved and posted separately and can sit at different stages. Number them p001 upward. If every creator owes exactly one deliverable, the rows are the same thing and you can use one ID for both.

The column blocks

Block A: identity

Block B: contract and KYC

Block C: product

Block D: content gates

Block E: live and QA

The label check has its own column because ASCI's influencer guidelines require a clear label whenever there is a material connection, and a post that fails that check should never reach the payment column.

Block F: money and rights

Keep fee terms and TDS workings in the finance sheet; the tracker needs only the status. Our guides to influencer payment terms and TDS and GST cover what finance should record.

Fixed status lists

Every status column uses a drop-down. Free text produces "done", "Done", "completed" and "ok", and the counts stop working. Create the lists on a separate Lists tab and point the data validation at them. Order each list the way a row moves, so that a simple sort puts the furthest behind rows on top. Add a "Held" value to Payment status and a "Failed" value to Dispatch status, because you will need both, and a tracker with no way to record a problem hides it.

Formulas that do the nagging

Row 2 is the first row. Adjust column letters to your sheet.

Make the "Status changed on" column a manual date, entered when someone changes a stage. A formula on TODAY() alone cannot tell you how long a row has been stuck. The ready-to-pay check needs a live URL, a passed label check, a valid invoice and a Y for payment details. Without all four, finance does not pay. In our process, creators are paid after deliverables are verified, and the check makes the verification visible.

Add conditional formatting: red fill when the flag says LATE, amber when a row has sat in one stage more than three working days, grey when the row is fully paid.

A filled-in example (made-up rows)

Who updates what

Give the brand view-only access, with comment rights on the Content block. Lock the formula columns, and keep a named owner for each block so nobody has to ask who last touched a row.

Keep sensitive details out of the sheet

PAN numbers, bank account numbers and home addresses do not belong in a tracker shared with a brand team, an agency and a courier. Keep them in a restricted tab or a finance document, referenced by creator ID. The tracker holds "received" as Y or N. Share the dispatch list with the courier as a separate file, and delete it when the campaign closes. Data protection in influencer marketing explains why this habit matters before the main duties under the new rules start to apply.

Tracking products given as benefits

If your campaign gives creators products, trips or gifts, add a second tab: a ledger with one row per item, giving the creator ID, the date, the item and its market value. A SUMIFS formula gives the running total per creator for the financial year. Section 194R, as TaxGuru's summary of the CBDT circular describes it, can apply once the total benefits to a resident in a financial year exceed ₹20,000, and a product returned after a shoot does not count. Set an amber flag at ₹15,000 so that nobody is surprised. Whether and how to deduct is a question for your CA. This is general information, not legal or tax advice.

The weekly routine

• Monday: sort by flag. Every red row gets an owner and a date before the end of the day.
• Daily in the live week: check every new post within the hour, then update live date, URL and the two QA columns.
• Friday: copy the sheet's values into a tab named with the date. When someone disputes a date, you can show what the sheet said that week.
• After close: archive the tracker with the dashboard and the report, as in the post-campaign analysis checklist.

Before you launch the sheet

• One row per deliverable, with creator ID and post ID
• Drop-down lists on every status column
• Formula columns locked
• Sensitive details in a separate restricted tab
• The benefit ledger created if you give products
• Brand and agency access levels set
• IDs match the shortlist, the tracking links and the dashboard
• A named owner for every column block

If you would rather have us keep the tracker, every Influencer Gully campaign comes with a shared tracker covering each creator, deliverable, date, approval and result, run by your named strategist. Send us a brief for a creator plan within 48 hours, or read about our micro and nano influencer service for programmes with many rows. For the launch meeting that sets these columns up, use the kickoff checklist, and for dates, the campaign timeline template.