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
Fill the character sheet
Who the creator is and the real person behind the avatar, their look, setting and voice, the product, the claims they may make (true for them) and must not make. A Digital Twin needs the real person's consent statement recorded in HeyGen; the sheet flags it.
Write the 30-second shot list
Five shots: hook, problem, demo, proof, CTA. Change lines and lengths; start and end times update and the total is checked against your target length.
Copy the prompts
One direction prompt per shot, built from the character sheet and shot list so every shot keeps the same look and voice, plus the full script and a claims check to read before you render.
Price it and run pre-flight
Pick an engine, the number of ads and takes per usable ad to see the cost against human UGC. Then add each ad to Pre-flight: it goes green only when consent, the platform's AI label and the claims check are all done.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Shot | Seconds | Line or action |
|---|---|---|
| Hook | 0 to 3 | Holds the can to camera: "ok this actually works??" |
| Problem | 3 to 8 | "I was so done with 3pm crashes." |
| Demo | 8 to 18 | Pours, shakes, drinks; product label in frame 2+ seconds |
| Proof | 18 to 25 | "Two weeks in, I just don't reach for the second coffee anymore." |
| CTA | 25 to 30 | "Link's right there. Try the starter pack." |
Worked review example
Fictional drink brand, one creator (a Digital Twin of a paid creator with consent on file), 30-second ads on HeyGen's Avatar III Digital Twin at $0.60 a minute: $0.30 an ad, $60 for 200. The same 200 ads cost $231 on Avatar IV Photo Avatar, $483 on Avatar IV Digital Twin and $720 on Avatar V Digital Twin; human UGC from $99 a video would be $19,800.
Pre-flight: the TikTok ad is ready; the Meta ad is blocked until a disclaimer is added; a photo-avatar test is blocked because nobody's written consent is on file.
What this template does and does not establish
Prices are HeyGen's published API pay-as-you-go rates (updated Nov 9, 2026) and cover the talking head only, not plan fees, editing, music, b-roll or the creator's own fee. $99 is Billo's starting price, not an average. Platform rules change; the checks cover HeyGen consent, TikTok and Meta AI labelling and US FTC rules only. Not legal advice. No account connection, macros or automatic changes.
Primary references
- HeyGen: API plans and pay-as-you-go prices
- HeyGen: avatar consent
- Billo: UGC rates
- TikTok ads policy: misleading and false content
- Meta: gen AI transparency in ads
- FTC: final rule banning fake reviews and testimonials
