For BrandsFree TemplateAgencies

Influencer Campaign Tracker Template:
A Free Spreadsheet With Built-In Cost-Per-Result Formulas

Most influencer trackers record who you hired. This one also tells you what each creator cost per view, click, and purchase, so you can see who actually delivered. Download it free, then use the guide below to run approvals, reporting, and fair comparisons.

Last updated: October 2026 · 10 min read · By the Identity Kit team
Free download
Influencer Campaign Tracker Template (.xlsx)

Works in Excel and Google Sheets. Includes status and platform dropdowns, automatic total cost, CPM, CTR, CPC, conversion rate, CPA, and ROAS for every creator, and a Summary tab with blended metrics and best performers. Holds up to 100 creators.

Download the free tracker →
No sign-up required. Organizes campaign data only; not accounting, legal, or tax advice.
Quick Answer — How Do You Track an Influencer Campaign?

Use one spreadsheet with a row for every creator, recording status, dates, links, costs, and results. In five steps:

  1. Add every shortlisted creator, and set one currency and one definition of impressions or views for the campaign.
  2. Record each creator's deliverables, dates, fee, other costs, and a unique tracking link or code before content goes live.
  3. Update status at every checkpoint, from brief sent through content review to live.
  4. Enter results at fixed dates, such as 7 and 30 days after go-live, using the same dates for every creator.
  5. Compare cost per outcome (CPA, ROAS), and check profit using your own gross margin.
Key Facts — Influencer Campaign Tracking
▸An influencer campaign tracker records each creator's status, dates, links, costs, and results in one place.
▸CPM is total cost divided by impressions times 1,000; CPA is total cost divided by purchases; ROAS is revenue divided by total cost.
▸Creators should be compared on the same measurement dates, one currency, and one definition of impressions or views.
▸Tracking links and codes must be created before content goes live, and each creator needs a unique one.
▸ROAS ignores product cost, so a profit check using your own gross margin shows whether the campaign made money.
In this guide
1. Download the free template2. Why track campaigns in one place3. What the template tracks4. The built-in formulas, with a worked example5. How to set up and use it6. Campaign workflow and approval checkpoints7. When to enter results8. How to compare creators fairly9. Data mistakes to avoid10. When to move beyond a spreadsheet11. Common mistakes12. FAQ

Why Track Influencer Campaigns in One Place

1. One place for the whole campaign
Creators, dates, links, costs, and results live together, so nothing depends on scattered messages and screenshots.
2. Cost per result becomes visible
Once cost and results sit side by side, you can see which creators were efficient, not just which ones had the biggest reach.
3. Approvals and deadlines stay on schedule
Brief, due, and go-live dates in one view make it easy to spot late content before it affects launch timing.
4. Reporting takes minutes, not days
If you enter results as they arrive, the Summary tab produces campaign totals and blended metrics instantly.
5. You build your own benchmarks
Every campaign you track adds to a record of what your brand actually pays and gets, which beats any outside average.

What the Template Tracks

The workbook has three tabs and 25 columns on the main sheet, grouped into seven areas.

Instructions
A legend explaining input cells, calculated cells, definitions, and assumptions.
Creators
One row per creator per campaign, with dropdowns for status and platform, and automatic calculation of total cost and all six metrics. Holds up to 100 creators and includes a fictional example in row 5.
Summary
Campaign totals, blended CPM, CTR, CPC, conversion rate, CPA and ROAS, a profit check using your own gross margin, the best creators by CPA, ROAS, and CPM, and a count of creators by status.
Creator: Name, handle or profile link, platform, followers
Workflow: Status, deliverables, brief sent date, content due date, go-live date
Links: Post link, tracking link or code
Cost: Fee, other costs (product, shipping, usage rights, paid amplification), total cost (calculated)
Results: Impressions or views, link clicks, purchases or sign-ups, revenue
Calculated metrics: CPM, CTR, CPC, conversion rate, CPA, ROAS
Notes: Approvals, feedback, rights, and anything worth remembering

The Built-In Formulas, With a Worked Example

The template includes one fictional creator so you can see every formula in action: an $800 fee, $100 of product and shipping, 120,000 views, 1,500 clicks, 45 purchases, and $2,700 in revenue. Replace these numbers with your own. For what each metric means and when to use it, see our guide to influencer marketing KPIs.

Total cost
Fee + other costs
$800 + $100 = $900
CPM
Total cost ÷ impressions × 1,000
$900 ÷ 120,000 × 1,000 = $7.50
CTR
Clicks ÷ impressions
1,500 ÷ 120,000 = 1.25%
CPC
Total cost ÷ clicks
$900 ÷ 1,500 = $0.60
Conversion rate
Purchases ÷ clicks
45 ÷ 1,500 = 3.00%
CPA
Total cost ÷ purchases
$900 ÷ 45 = $20.00
ROAS
Revenue ÷ total cost
$2,700 ÷ $900 = 3.00

Formulas return a blank, not an error, when a creator has no data yet, so unfinished rows stay clean.

How to Set Up and Use the Tracker

1

Download and open the template

Open it in Excel, or in Google Sheets choose File, then Import, upload the file, and select Create new spreadsheet.

2

Set one currency and one measure of reach

Decide on one currency and one definition of "impressions or views" for the whole campaign, and use it for every creator. Mixing definitions makes CPM and CTR meaningless.

3

Replace the example row

Row 5 is fictional. Overwrite it with your first creator, or delete it.

4

Add every shortlisted creator

Add one row per creator, including those you are still considering, so you can see your pipeline and drop-offs.

5

Record links and codes before content goes live

Fill in the tracking link or code for each creator first. Results you cannot attribute cannot be compared.

6

Update status as work progresses

Use the dropdown at each checkpoint, from Shortlisted through Reporting to Closed.

7

Enter results at fixed dates

Add impressions, clicks, purchases, and revenue at about 7 and 30 days after go-live, using the same dates for every creator.

8

Review the Summary tab

Check blended metrics, set your own gross margin for the profit check, and note the best performers. Then decide what to repeat, change, or drop.

Before you start, set your numbers with our influencer marketing budget framework.

Campaign Workflow and Approval Checkpoints

The Status dropdown follows eight checkpoints. Each one has a job to finish before the creator moves on.

1. Shortlisted
Vet each creator before you reach out. Vetting checklist →
2. Contacted
Send a short, personalized message and request a media kit and rate card. Finding and contacting creators →
3. Agreed
Confirm deliverables, dates, fee, rights, and disclosure in writing.
4. Brief sent
Send a one- to two-page brief and record the date. Brief examples and template →
5. Content in review
Check the draft against the brief and give consolidated feedback within the agreed turnaround.
6. Live
Save the post link, confirm disclosure and tracking work, and note the go-live date.
7. Reporting
Collect creator analytics and enter results at your fixed dates. KPIs and reporting →
8. Closed
Pay on the agreed terms, record learnings, and decide whether to work together again.

When to Enter Results

About 48 hours after go-live
Early views and engagement. Use them to spot problems and to decide on any paid amplification.
About 7 days after go-live
Most organic reach is in. Enter impressions, clicks, and early purchases.
About 30 days after go-live
Use this as your main report date. Enter final results and review cost per outcome.
About 90 days after go-live
Review repeat purchases and reuse of the content in ads, and decide on longer partnerships.

How to Compare Creators Fairly

1. Compare cost per outcome, not reach alone
A creator with fewer views can still be cheaper per purchase. CPA and ROAS show efficiency, while CPM shows the price of attention.
2. Match the metric to the goal
For awareness campaigns, look at CPM and views. For traffic, look at CPC and CTR. For sales, look at CPA and ROAS. Do not judge an awareness creator by sales alone.
3. Check profit, not only revenue
ROAS ignores product cost. Use the profit check on the Summary tab with your own gross margin to see whether the campaign made money.
4. Look at small numbers with care
A creator who drove two purchases has a CPA based on very little data. Treat tiny samples as hints, not proof.
5. Consider the whole picture
Some influence shows up as later search or direct visits that link tracking misses. Use codes and a checkout survey alongside links.

Data Mistakes to Avoid

⚠Mixing impressions, reach, and views across creators and platforms.
⚠Mixing currencies in one campaign without converting.
⚠Entering results on different dates for different creators.
⚠Leaving out other costs, such as product, shipping, usage rights, and paid amplification, so total cost looks lower than it was.
⚠Giving two creators the same code or link, which makes attribution impossible.
⚠Counting revenue from discount codes that leaked to coupon sites.
⚠Judging a campaign before the measurement window has passed.

When to Move Beyond a Spreadsheet

A spreadsheet is enough for most small and mid-size campaigns. Consider dedicated software, and check current features and pricing before paying, when:

✓You manage dozens of creators at once, or several campaigns in parallel.
✓Several teammates or an agency need to edit the data at the same time.
✓You want automated reminders, contracts, and payments in the same place.
✓You need live integration with sales or analytics data.

Common Campaign Tracking Mistakes

Tracking only the creators you hired
Shortlisted and declined creators show you where the process loses people. Track them too.
Entering costs but not results
A tracker without outcomes only tells you what you spent. Fill in results at your fixed dates.
Using the tracker as a one-off
Reuse the same structure each campaign so you can compare campaigns over time.
Forgetting to save post links
You will need them for reporting, content reuse, and for checking disclosure.
Skipping tracking setup
Links and codes must exist before content goes live. Retrofitting them rarely works.
Trusting averages from other brands
Your own data from your own campaigns is the benchmark that matters.

Frequently Asked Questions

What should an influencer campaign tracker include?

It should include each creator, platform, status, deliverables, key dates, post link, tracking link or code, fee, other costs, total cost, results such as impressions or views, clicks, purchases, and revenue, and calculated metrics such as CPM, CTR, CPC, conversion rate, CPA, and ROAS.

How do I track influencer campaigns in Google Sheets?

Download the template, open Google Sheets, choose File, then Import, upload the file, and select Create new spreadsheet. Add one row per creator, update the status dropdown as work progresses, and enter results at fixed dates such as 7 and 30 days after go-live.

How do I calculate cost per acquisition for influencers?

Divide the total cost of a creator, including fee and other costs, by the number of purchases or sign-ups attributed to them. The template calculates this automatically from the cost and results columns.

What is the difference between ROAS and ROI?

ROAS divides revenue by cost and ignores margin. ROI uses profit, so it shows whether the campaign actually made money after product and campaign costs. A campaign can have a healthy ROAS and a negative ROI.

When should I enter influencer results?

Pick fixed dates and use them for every creator. Many teams check at about 48 hours, 7 days, and 30 days after go-live, and use 30 days as the main report. Review again at about 90 days for repeat purchases and content reuse.

How do I compare influencers fairly?

Use the same measurement dates, one definition of impressions or views, one currency, and the metric that matches the campaign goal. Compare cost per outcome, such as CPA or ROAS, rather than reach alone, and treat results from very small samples with caution.

Is a spreadsheet enough for influencer campaign tracking?

For most small and mid-size campaigns, yes. Consider dedicated software when you manage many creators or campaigns, need shared real-time editing, or want automated contracts, payments, and reminders.

Is the influencer campaign tracker free?

Yes. The template on this page is free to download and use, and works in Excel and Google Sheets. It organizes campaign data and is not accounting, legal, or tax advice.

Related Articles

For Brands
Influencer Marketing KPIs: What to Measure for Every Campaign Goal (With Formulas and a Reporting Template)
For Brands
How to Vet an Influencer Before You Hire Them: A 12-Point Checklist for Brands and Agencies
For Brands
Local Influencer Marketing: How Restaurants, Shops, and Local Businesses Work With Local Creators
📈

Fill your tracker faster: ask creators for their Identity Kit.

An Identity Kit profile puts a creator's media kit, rate card, and CV in one link, so the first columns of your tracker can be filled from one page instead of a long thread. Creators can build theirs free in minutes.

Create a Free Identity Kit →
identitykit.in · Free forever · Media kit + Rate card + Creator CV