Tabellab

Creative Rotation Plan: Days Live, Expected Retire Dates, Status and the Weekly Number of New Creatives

Lesson 16 of 20 Lab 🔒 Locked

Lessons in this course

  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