Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.
How to use the template
Ask
Copy the first DM and the follow-up from the DM templates tab. Name the post and what it does well; say it stays their post and the engagement counts on it.
Agree the terms
Use the eight clauses: usage term, code length, fees (post plus usage, renewal priced now), keep the post live, disclosure, optional exclusivity, comments, results. Work out the fee on the Rates tab.
Get the code
Send the code-request DM with the creator's four steps: allow ad authorization, open the post's Ad settings, generate a code for the agreed length, send it. Paste it into TikTok Ads Manager.
Track every code
Log each sparked post in the Creator tracker. It shows the expiry date, OK / RENEW NOW / EXPIRED, whether the code covers the paid term, and the all-in cost per conversion. Send renewals before codes run out.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Item | What it is | Default |
|---|---|---|
| Code length | Chosen by the creator when they generate the code | 7, 30, 60 or 365 days |
| Expires | Code received + code length | - |
| Code status | Days left against your warning window | Warn 7 days before |
| Code covers the term? | Code length ≥ usage term paid | - |
| Usage fee | Post fee × usage % for the term | Placeholder % per length |
| All-in cost per conversion | (Ad spend + post fee + usage fee + exclusivity) ÷ conversions | - |
| Agreement | Usage term, fees, keep it live, disclosure, exclusivity, comments, results | 8 template clauses |
Worked review example
Fictional roster reviewed on 17 November 2026: of 6 sparked posts, Maya's has 2 days left and the lowest all-in cost per conversion ($36.92), so the renewal DM goes today. Daniela paid for 30 days but sent a 7-day code that expired on 10 November; her ad CPA was $42.86, but $61.43 with her fees. Tessa's 60-day code expired on 9 November.
What this template does and does not establish
TikTok's +142% engagement, +43% conversion rate, +30% completion and −4% CPM compare Spark with non-Spark ads, come from a page about Video Shopping Ads, and give no period or method. TikTok doesn't document what happens at expiry; the kit relies on its error notices and third-party guides. App and Ads Manager menu names change. Rate percentages are placeholders, and the clauses are templates, not legal advice.
Primary references
- TikTok: Spark Ads for Video Shopping Ads
- TikTok: How to create Spark Ads for Smart+ campaigns
- TikTok: Spark Ads
- TikTok: Spark Ads code error notifications
- FTC: Disclosures 101 for social media influencers
