Creator and platform
Who posted the video and where: TikTok, Instagram, YouTube, Facebook or Snapchat. One row per video, so a creator who posts on three platforms gets three rows.
Free UGC tracker templatethat does the math.
Log every creator video and see engagement, payouts and cost per 1K views as you type. Then take it to Google Sheets or Excel with every formula intact. No signup.
Videos
3
Total views
522.3K
Engagement rate
9.6%
Total payout
$700
Cost per 1K views
$1.34
- Eng. rate10.3%Payout$300Per 1K views$0.73
- Eng. rate6.9%Payout$250Per 1K views$2.89
- Eng. rate7.2%Payout$150Per 1K views$6.30
Stop updating views by hand.
Shortalyze keeps this tracker up to date for you: every creator video on TikTok, Instagram, YouTube and Facebook, with payouts worked out.
What to track for every UGC video
Together they tell you which creators to keep, which videos to ask for more of, and what every view costs you.
Post date and link
When the video went live and where to find it, so anyone on your team can open it and check the numbers.
Views, likes, comments, shares
The numbers from the video itself. Update them every time you report, the formulas do the rest.
Engagement rate
Likes, comments and shares divided by views. It shows which videos people act on, not just scroll past.
Payout
What you owe for the video: a flat fee, a rate per 1,000 views, or a base fee plus a bonus every time a video passes a view milestone.
Cost per 1K views
Payout divided by views, times 1,000. The one number that compares creators on different deals fairly.
How to use this UGC tracker template
- 1
Pick how you pay
Flat fee, per 1,000 views or fee plus bonus. The payout column follows your choice.
- 2
Add every video
One row per video. Engagement, payout and cost per 1K views are worked out as you type.
- 3
Take it with you
Copy it into Google Sheets or download it for Excel. The formulas come along and keep working.
When your tracker fills itself in
A spreadsheet works for a handful of videos. With more creators, this is what changes.
Every video, filled in for you
Add a creator once and every new video and its views show up by themselves.
Learn morePayouts worked out by the terms
Fees, view bonuses and rates per 1,000 views add up per creator, ready to pay.
Learn moreAsk your AI about your creators
Ask Claude or ChatGPT which video took off and what you owe, answered from live numbers.
Learn more
Frequently asked questions
What is a UGC tracker template?
A spreadsheet where you log every video your UGC creators post: who posted it, on which platform, when, how it performs and what you pay for it. This one also works out engagement rate, payout and cost per 1,000 views for you.
Is this UGC tracker template free?
Yes. There is no signup and no e-mail to fill in. Everything is worked out in your browser, and you can copy or download the result as often as you like.
Does it work in Google Sheets and Excel?
Yes. Copy for Google Sheets puts the rows on your clipboard: paste them into cell A1 of an empty sheet. Download for Excel gives you a CSV file that opens in Excel and imports into Google Sheets. In both, the formulas keep working when you change a number.
How do you calculate engagement rate for UGC?
Add up the likes, comments and shares of a video, divide by its views and multiply by 100. A video with 10,000 views and 500 interactions has an engagement rate of 5%.
How do I calculate cost per 1,000 views?
Divide what you paid for a video by its views and multiply by 1,000. It lets you compare a creator on a flat fee with one paid per view.
Which pay models does the template support?
A flat fee per video, a rate per 1,000 views (CPM), and a base fee plus a bonus every time a video passes a number of views, such as $50 for every 100,000 views.
Can I track TikTok, Instagram, YouTube, Facebook and Snapchat videos together?
Yes. Pick the platform per row. Because every video gets its own row, you can sort or filter by platform afterwards to see where each creator does best.
How often should I update the views?
As often as you report on your creators. Every update means opening each video and copying its numbers. That part is what Shortalyze does for you: it checks your creators' accounts twice a day, or 4 times a day on a yearly plan, and keeps every video's views up to date.