Tabellab
Marketing Analytics Intermediate

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.

20 lessons 20 labs Certificate

  • 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

  1. Hook Rate & Hold Rate: 2-Second Views, 6-Second Views and a Diagnosis for Every TikTok AdLabFree
  2. Watch Depth: Quartile Views, Completion Rate and Share of the Video Watched (Column Chart)Lab Locked
  3. The Price of Attention: CPM, CPV and Cost per 6-Second View by Ad GroupLab Locked
  4. From View to Purchase: Landing Rate, Purchase Rate and CPA per CampaignLab Locked
  5. What a Purchase May Cost: Contribution, Break-Even CPA, Break-Even ROAS and a Target CPALab Locked
  6. Creative Scorecard: Format Benchmarks with XLOOKUP, Hook Index, CPA Index and a Verdict (Conditional Formatting)Lab Locked
  7. Creative Fatigue: Daily Hook Rate, 3-Day CPA, Loss Against the Launch Baseline and a SLOPE Trend (Line Chart)Lab Locked
  8. Boosted Creator Posts: Paid CPV, All-In Cost per 1,000 Views and All-In CPA Against the Brand's Own Ads (Bar Chart)Lab Locked
  9. Bidding: Lowest Cost, Cost Cap and Bid Cap, Delivery, CPA Against the Goal and an Action per Ad GroupLab Locked
  10. Budgets and the Learning Phase: Expected Purchases per Week, Minimum Daily Budget and How Many Ad Groups You Can AffordLab Locked
  11. Budget Pacing: Cumulative Spend, an Even-Pace Plan with EOMONTH, Pace Index and a Month-End Projection (Line Chart)Lab Locked
  12. Attribution Windows: 1-Day Click vs 7-Day Click + 1-Day View, View-Through Share and What a Window Does to the CPALab Locked
  13. Conversion Lag: a Lag Curve, Maturity per Reporting Day, Projected Purchases and Projected CPA (Line Chart)Lab Locked
  14. Creative Split Tests: Lift in Purchase Rate, Pooled Standard Error, z-Score and a VerdictLab Locked
  15. Creative Testing Lane: Test Budget per Creative, Kill Rules, the Chance of Zero Purchases and Graduation (Conditional Formatting)Lab Locked
  16. Creative Rotation Plan: Days Live, Expected Retire Dates, Status and the Weekly Number of New CreativesLab Locked
  17. Audience Types and Countries: Spend, CPA, ROAS and Share of Spend with SUMIFS (Bar Chart)Lab Locked
  18. Frequency and Reach: Cost per 1,000 People, the Link Between Frequency and CTR with CORREL and a Forecast (Scatter Chart)Lab Locked
  19. What-If Grid: CPA by CPM and Purchase Rate with Mixed References, the Break-Even Zone and the Highest Affordable CPM (Conditional Formatting)Lab Locked
  20. Final Project: Account Dashboard with Hook Rate, Blended CPA, CPA by Type, the Best Ad and the Ads Above Break-Even (Column Chart)Lab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy