TikTok Ads & Short-Video Advertising: Hook Rate, Hold Rate, CPV, CPA, Creative Rotation, Bidding & Attribution Windows
The arithmetic behind TikTok ads and boosted creator posts, one spreadsheet at a time. You measure hook rate and hold rate, read quartile views and completion, price attention with CPM, CPV and cost per 6-second view, follow the funnel from view to purchase and set break-even and target CPAs. After that you score creatives against format benchmarks, catch creative fatigue with a trend line, cost boosted creator posts all-in, check bid strategies and delivery, size budgets for the learning phase, pace a monthly budget, compare attribution windows, correct recent days for conversion lag, judge split tests with a z-score, run a test lane with kill rules, plan creative rotation with dates, summarise audiences with SUMIFS, link frequency to CTR, build a CPA what-if grid and finish with an account dashboard: 20 hands-on labs, fictional tea brand Tindlewick Tea Co., every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course teaches the working arithmetic behind TikTok ads and boosted creator posts in 20 interactive spreadsheet labs. You play the analyst at Tindlewick Tea Co., a fictional online tea shop, and work through its ad account step by step: you calculate hook rate and hold rate from 2-second and 6-second views, read quartile views, price attention with CPM, CPV and cost per 6-second view, and follow clicks to landing page views and purchases until you have a CPA. From unit economics you derive a break-even and a target CPA, score creatives against format benchmarks, spot creative fatigue, cost creator posts including the fee, check bid caps and delivery, size budgets for the learning phase and pace a month. Later labs cover attribution windows, conversion lag, split-test significance, kill rules, a rotation plan with dates, audience summaries, frequency and a what-if grid, and end with an account dashboard. Every formula is checked as you type. All companies, creators and numbers are fictional and all benchmarks are illustrative.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
Lessons
- Hook Rate & Hold Rate: 2-Second Views, 6-Second Views and a Diagnosis for Every TikTok AdFree
- Watch Depth: Quartile Views, Completion Rate and Share of the Video Watched (Column Chart) Locked
- The Price of Attention: CPM, CPV and Cost per 6-Second View by Ad Group Locked
- From View to Purchase: Landing Rate, Purchase Rate and CPA per Campaign Locked
- What a Purchase May Cost: Contribution, Break-Even CPA, Break-Even ROAS and a Target CPA Locked
- Creative Scorecard: Format Benchmarks with XLOOKUP, Hook Index, CPA Index and a Verdict (Conditional Formatting) Locked
- Creative Fatigue: Daily Hook Rate, 3-Day CPA, Loss Against the Launch Baseline and a SLOPE Trend (Line Chart) Locked
- Boosted Creator Posts: Paid CPV, All-In Cost per 1,000 Views and All-In CPA Against the Brand's Own Ads (Bar Chart) Locked
- Bidding: Lowest Cost, Cost Cap and Bid Cap, Delivery, CPA Against the Goal and an Action per Ad Group Locked
- Budgets and the Learning Phase: Expected Purchases per Week, Minimum Daily Budget and How Many Ad Groups You Can Afford Locked
- Budget Pacing: Cumulative Spend, an Even-Pace Plan with EOMONTH, Pace Index and a Month-End Projection (Line Chart) Locked
- Attribution Windows: 1-Day Click vs 7-Day Click + 1-Day View, View-Through Share and What a Window Does to the CPA Locked
- Conversion Lag: a Lag Curve, Maturity per Reporting Day, Projected Purchases and Projected CPA (Line Chart) Locked
- Creative Split Tests: Lift in Purchase Rate, Pooled Standard Error, z-Score and a Verdict Locked
- Creative Testing Lane: Test Budget per Creative, Kill Rules, the Chance of Zero Purchases and Graduation (Conditional Formatting) Locked
- Creative Rotation Plan: Days Live, Expected Retire Dates, Status and the Weekly Number of New Creatives Locked
- Audience Types and Countries: Spend, CPA, ROAS and Share of Spend with SUMIFS (Bar Chart) Locked
- Frequency and Reach: Cost per 1,000 People, the Link Between Frequency and CTR with CORREL and a Forecast (Scatter Chart) Locked
- What-If Grid: CPA by CPM and Purchase Rate with Mixed References, the Break-Even Zone and the Highest Affordable CPM (Conditional Formatting) Locked
- Final Project: Account Dashboard with Hook Rate, Blended CPA, CPA by Type, the Best Ad and the Ads Above Break-Even (Column Chart) Locked
Learner reviews
Be the first to review this course.