Free editable template

TikTok Spark Ads creator kit

Run creator posts as Spark Ads without your best ad stopping on day 8. Agree the terms, send the creator the code steps, log every code, and the tracker shows each code's expiry date, RENEW NOW a week before it ends, whether the code covers the usage term you paid for, and the cost per conversion including the creator's fees.

By GaaS editorial · Sources checked · 7 worksheet rows

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.

ItemWhat it isDefault
Code lengthChosen by the creator when they generate the code7, 30, 60 or 365 days
ExpiresCode received + code length-
Code statusDays left against your warning windowWarn 7 days before
Code covers the term?Code length ≥ usage term paid-
Usage feePost fee × usage % for the termPlaceholder % per length
All-in cost per conversion(Ad spend + post fee + usage fee + exclusivity) ÷ conversions-
AgreementUsage term, fees, keep it live, disclosure, exclusivity, comments, results8 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

Continue the work