Template for agency owners and agents
How do I track my TikTok LIVE creators in a spreadsheet?
Use one row per creator and eleven columns: handle, agent, join date, region, diamonds this month, valid LIVE days, LIVE hours, level, last contact, next step and notes. Update it once a day. The template is below. When several people need the same numbers, or copying the month takes hours, it is time to move to an app.
This guide is for owners and agents of a TikTok LIVE agency who track creators by hand. It works in Excel, Google Sheets or any spreadsheet. See also the daily checklist for an agency manager.
The template
The file has the eleven column headings and two made-up example rows. Delete the examples and add your own creators. It opens in Excel and Google Sheets.
What each column is for
| Column | Why it is there |
|---|---|
| Creator handle | The creator's TikTok username. One row per creator. |
| Agent | Who looks after this creator. It shows at a glance if one agent has too many. |
| Joined on | The join date, so you can see who is new and needs extra attention. |
| Region | The creator's market, if your agency works in more than one. |
| Diamonds this month | The month so far. Copy it from your Backstage data. |
| Valid LIVE days this month | The number of valid days so far, as TikTok counts them. |
| LIVE hours this month | The hours so far. |
| Level | The creator's current level in your agency. |
| Last contact | The date you last messaged the creator. It stops the same person being missed twice. |
| Next step | One sentence: what you will do or ask next. |
| Notes | Anything worth remembering, such as the creator's preferred LIVE time. |
How to keep it current
- Update once a day. Pick one time, for example before the first LIVE of the day, and copy the new figures in.
- Sort by last contact. The creators you have not messaged for longest come first. Message them today.
- Sort by valid LIVE days. Creators with few valid days late in the month need a plan now, not at month end.
- Fill next step for everyone you contact. An empty cell means nobody owns the follow-up.
- Save a copy at month end. Keep one file per month, so you can compare months.
When to outgrow it
A spreadsheet is a good start. Move to an app when one of these becomes true:
- Several agents need to see the same numbers, and each keeps their own copy.
- Copying the month from Backstage takes hours instead of minutes, or the figures are often a day behind.
- Creators ask the same questions every day, and the answers get lost in chats.
- You want each agent to see only their own creators, and the owner to see everyone. A shared sheet cannot do that.
What CN Creator App does instead
CN Creator App reads each creator's monthly diamonds, valid days and LIVE hours from your agency's own Backstage account and keeps the roster up to date. If you already have a spreadsheet, you can bring your creators in from Excel. CN Creator App is an app for TikTok LIVE agencies. It is not a TikTok product.
- How to see all your TikTok LIVE creators in one roster
- How to import creators from Excel
- How to set staff permissions
When this is not for you
If you are a single creator and not an agency, you do not need this. A note of your LIVE days is enough.
Questions about tracking creators
What should I track for each TikTok LIVE creator?
Handle, agent, join date, diamonds this month, valid LIVE days, LIVE hours, level, the date of your last contact and one next step. The template has these eleven columns.
Can I use the template as it is?
Yes. Download it from this page and use it in Excel or Google Sheets. No sign-up is needed.
How often should I update the spreadsheet?
Once a day is enough for most agencies. Choose one time and keep to it, so the numbers are always from the same hour.
When should an agency move from a spreadsheet to an app?
When several people need the same numbers, when the month-end copy takes hours, or when each agent should see only their own creators. See the roster guide.
Can I bring my spreadsheet into CN Creator App?
Yes. CN Creator App can import creators from Excel. The import guide shows the steps.
In the app, a new subscription starts with 1 month free. Not sure which plan fits? Answer six short questions.