Influencer tracking spreadsheet: free template with a campaign report tab
· Nolyn research team
Where can I get a free influencer tracking spreadsheet?
Download the Excel or CSV template on this page; no sign-up. It has one row per post (date, creator, platform, post link, fee, views, likes, comments, shares, saves, engagement rate, cost per 1,000 views) and a Report tab with totals by platform and creator. Filled with 16 public creator posts from an Owala launch, read on November 3, 2026, it adds up to 631,673 views and, at an illustrative $250 per post, $6.33 per 1,000 views.
For agencies and brand teams who track creator posts by hand. Paste each post link and what you paid, then type the numbers yourself or upload the sheet and let Nolyn read the public views, likes, comments, shares and saves for you.
Free, no sign-up. The Excel file has the formulas and the Report tab; the CSV is the same columns with no formulas. The sample is the same workbook filled with 16 real posts.
Upload your sheet and Nolyn fills in the numbers
Add your post links, then upload the file here. Running it needs a sign-in; new accounts get 100 free credits, no card. It takes about 1 credit per TikTok or YouTube link and 2 per Instagram Reel, plus up to about 20 for the written summary, and the form shows the estimate first. Your table comes back in the same row order with Views to Saves filled in.
What each column is for
The Tracker tab has one row per post and one file per campaign. Yellow headers are yours to fill; grey headers are formulas. Platform is read from the link, so you only type four things per post unless you collect the numbers by hand too.
| Column | What goes in it | Filled by |
|---|---|---|
| Date | The day the post went live | You |
| Creator | Handle or name; keep it the same on every row so the Report tab can total it | You |
| Platform | TikTok, Instagram or YouTube, read from the link | Formula |
| Post link | The public URL of the post, one per row | You |
| Flat fee | What you paid for this post, in one currency per file | You |
| Views, Likes, Comments, Shares, Saves | The public counts on the day you read them | You, or Nolyn's upload |
| Engagement rate | (Likes + comments + shares) ÷ views; empty when likes are hidden | Formula |
| Cost per 1,000 views | Flat fee ÷ views × 1,000 | Formula |
A filled example: 16 real creator posts
This is the filled sample: 8 TikTok videos and 8 Instagram Reels from 15 creators in Owala's summer bags launch, found on the public #owalapartner and #owalabags pages. The counts are what each platform showed on November 3, 2026, and they have changed since. The $250 fee per post is illustrative; Owala's real fees are not public.
Together the posts add up to 631,673 views. Two creators carried 68.1% of them: @jenna_bariatricbestie with 238,806 and @katielynnteaches with 191,411. At the same fee, cost per 1,000 views runs from $1.05 to $331.13, which is why a campaign average of $6.33 says little until you look at the rows.
| Creator | Platform | Views | Likes | Comments | Shares | Engagement rate | Cost per 1,000 views |
|---|---|---|---|---|---|---|---|
| @jenna_bariatricbestie | TikTok | 238,806 | 15,691 | 61 | 440 | 6.78% | $1.05 |
| @dailywithcaroline | TikTok | 1,208 | 24 | 0 | 2 | 2.15% | $206.95 |
| @brynlikesit | TikTok | 9,844 | 43 | 2 | 28 | 0.74% | $25.40 |
| @stephsharesitall | TikTok | 22,211 | 95 | 3 | 36 | 0.60% | $11.26 |
| @stephsharesitall | TikTok | 11,082 | 126 | 8 | 34 | 1.52% | $22.56 |
| @miss.zamor | TikTok | 27,706 | 287 | 4 | 104 | 1.43% | $9.02 |
| @meili_zzz | TikTok | 11,420 | 214 | 9 | 71 | 2.57% | $21.89 |
| @marypat.sass | TikTok | 3,098 | 100 | 8 | 0 | 3.49% | $80.70 |
| @alyssarafael | 90,438 | not shown | 25 | not public | $2.76 | ||
| @medical_siblings | 6,536 | 88 | 55 | not public | 2.19% | $38.25 | |
| @katielynnteaches | 191,411 | 6,795 | 35 | not public | 3.57% | $1.31 | |
| @genxtravelmom | 3,218 | 76 | 18 | not public | 2.92% | $77.69 | |
| @maggieeweidner | 2,493 | 45 | 3 | not public | 1.93% | $100.28 | |
| @luefinisherthao | 9,571 | 295 | 10 | not public | 3.19% | $26.12 | |
| @gabrielleeboo | 755 | not shown | 9 | not public | $331.13 | ||
| @paigealewelogle | 1,876 | 21 | 7 | not public | 1.49% | $133.26 |
Public counts read November 3, 2026 (run 24cf91ca). Flat fee: illustrative $250 per post. Two creators hide likes, so their engagement rate stays empty. The file also has date, post link and saves.
What you get back when you upload it
Nolyn finds the Post link column and reads each public post. The table returns as a download, Excel or CSV, with every row in its original order. The numbers go straight into the empty Views to Saves columns, and a few columns are added on the right:
- Views, Likes, Comments, Shares and Saves: the public counts. "not public" means the platform does not show that count, as with shares and saves on Instagram and YouTube; "not shown" means the creator hides it.
- checked_er_pct: engagement rate, the same formula as the template.
- check_status and check_note: why a link could not be read, a row with no link, or a row that repeats an earlier post (repeats are not charged).
- checked_views to checked_saves appear only if a column already holds numbers: those stay as you typed them and the new reading sits on the right.
Finish the tracker in one paste
The returned file holds the numbers but not the formulas, so its Engagement rate and Cost per 1,000 views columns stay empty and there is no Report tab. To get them, copy Views to Saves from the returned file and paste them as values over the same columns in your Tracker tab. The rows line up because the order never changes. Engagement rate, Cost per 1,000 views and the Report tab then update on their own, and the text cells ("not public") are skipped by the sums.
From tracker to campaign performance report
The Report tab is a campaign performance report you can screenshot or paste into a deck: posts tracked, total views, likes, comments, shares and saves, pooled engagement rate, fees, cost per 1,000 views and the top post, then the same figures by platform and by creator. Type each handle once in the By creator table; the rest is formulas.
In the sample, TikTok brought 325,375 views at 5.34% engagement and Instagram 306,298 views at 3.46%, for $6.15 and $6.53 per 1,000 views. Compare engagement within a platform, not across: Instagram does not show shares, so its rate counts less.
If the client wants a written report instead of a table, send the same links to the influencer campaign report tool with your fees. It totals each creator and platform, works out cost per 1,000 views and writes a one-page report with a paragraph for the client email. For a plain views and likes table, the bulk TikTok views checker takes the same sheet.
What this spreadsheet cannot tell you
Everything here is public post data, so it fits campaign reporting on TikTok, Instagram and YouTube posts. It is not a full social media report template for an account you own: follower growth, reach, watch time, link clicks and sales live in each platform's analytics or your store, and only the account owner can see them. Stories and private or deleted posts cannot be read.
The counts are a snapshot of the day you read them. To keep them current, turn on the weekly refresh next to the returned table: every Monday the same posts are read again and you get the updated file. Or upload the returned file again and the new figures replace the old ones. A Tracker you already pasted into counts as your own numbers: they stay, and the new figures come back in checked_views to checked_saves. Each run spends credits.
How to use the template
Download the file
Use the Excel file for the formulas and Report tab, or open it in Google Sheets with File, Import. Keep one campaign per file.
Add one row per post
Fill in Date, Creator, Post link and Flat fee. Leave Platform and the formula columns alone.
Upload it to Nolyn or type the numbers
Upload the file in the form on this page and sign in to run it, or open each post and type the counts yourself.
Paste the numbers into your file
Views to Saves come back filled in. Copy them from the returned file and paste them as values over the same columns, so the formulas and Report tab pick them up.
Read the Report tab
Type your creator handles in the By creator table, then check totals, cost per 1,000 views and which posts carried the campaign.
One list of post links, every campaign job
Export a batch of links to a spreadsheet
Paste or upload up to 300 TikTok, Reels and Shorts links and get views, likes, comments and shares back in the same table.
Check views on a list of Instagram Reels
Read a whole list of Reels at once and export the counts to Excel or CSV.
Pay clippers by the view
Count a batch of clips, drop repeats, then apply your rate, minimum and cap.
Send a client report
Turn creator or clipper links into totals per account, cost per 1,000 views and a one-page report.
Run a clipping agency
Price the work, run the campaign, pay clippers and report to clients.
Compare bulk views checkers
The same five TikTok links run through several tools.
Questions
Yes. The Excel file, the CSV and the filled sample download without an account or an email address. Only the automatic fill-in needs a sign-in, because it spends credits: new accounts get 100 free credits with no card, which covers about 80 TikTok or YouTube links or 40 Reels in one run, written summary included.
Yes. Import the .xlsx with File, Import in Google Sheets; the formulas are plain SUM, COUNT, SUMIFS, INDEX and MATCH. To upload it to Nolyn from Sheets, download it again as .xlsx or .csv.
Divide the fee by the views and multiply by 1,000. A $250 post with 238,806 views costs $1.05 per 1,000 views; the same fee on 1,208 views costs $206.95. The template does this on every row and for the whole campaign.
(Likes + comments + shares) ÷ views, per post. Where likes are hidden the cell stays empty, because comments alone would read as near zero. Shares count only where the platform shows them, so compare rates within one platform.
The formulas run to row 301, which is 300 posts, the same as the limit of one Nolyn run. For more, copy the formulas down and split the upload into two files.
No. The file holds the counts from the day you read them. Upload it again whenever you want fresher numbers; each run is charged like the first.
For each post: creator, platform, link, date, fee, views, likes, comments, shares, saves, engagement rate and cost per 1,000 views. For the campaign: totals, the same figures by platform and by creator, and the top posts. The Report tab has all of these except a written summary.
Yes. The upload reads any Excel or CSV table with a column of post links and keeps your numbers as they are, so you do not need this template to use it. Empty columns named Views, Likes, Comments, Shares or Saves are filled in; everything else arrives in new columns.
Sources
- Nolyn: public counts of 16 creator posts from Owala's summer bags launch, read on November 3, 2026 (run 24cf91ca); the sample file and every figure on this page are recomputed from the saved lookups. Fees are illustrative · checked November 5, 2026
- Google Docs Editors Help: Import data sets & spreadsheets (.xlsx and .csv files) · checked November 5, 2026
- Google Docs Editors Help: Work with Office files · checked November 5, 2026
Influencers and UGC (brands and agencies)
All guidesGuide
How to find influencers for your brandHow to find influencers for your brand: 6 places to look, a vetting checklist and a real search (40 results, 9 in range, 2 worth contacting), plus UGC creators.
Comparison
Best UGC platforms for brands in 2026Best UGC platforms for brands checked Oct 24, 2026: Insense, Trend, JoinBrands, Collabstr, Billo and more, with prices per video, usage rights and free options.
Guide
Clipping campaign trackingHow clipping campaign operators track clipper views, verify them and work out payouts, with a real 19-row sample from link sheet to amount owed.
Guide
Clipping agencyHow a clipping agency runs clipping campaigns: what to charge, how to count views, pay clippers and report to clients, with a real 17-clip sample report.
Guide
Influencer outreachHow to do influencer outreach: where to reach creators (only 7 of 66 we checked list an email), what to say, 5 email and DM templates, follow-ups and FTC rules.