Tabellab

Quality Checks before Resharing: Caption Length, Tracking Tags, Duplicate Captions and an Issue Count

Lesson 19 of 20 Lab 🔒 Locked

Lessons in this course

  1. One Pillar, Many Pieces: Listing the Derivatives, Hours per Piece and Share of EffortLabFree
  2. Hours and Cost per Derivative: Hourly Rates by Role, Repurposed vs From-Scratch and the SavingLab Locked
  3. Reach per Derivative: Reach per Hour, Share of Total Reach, Rank and the Best PieceLab Locked
  4. Cost per 1,000 Reach: Comparing Derivatives with a Paid Benchmark and Flagging LosersLab Locked
  5. The Distribution Checklist: Items Done, Coverage per Derivative and the Gaps per ItemLab Locked
  6. Channel Fit Scoring: Criteria Weights, Weighted Scores with SUMPRODUCT, Fit Labels and Weak SpotsLab Locked
  7. Evergreen Resharing Schedule: Reshare Intervals by Post Type, Next Reshare Dates, Working Days and StatusLab Locked
  8. The Repurposing Multiplier: Pillar vs Derivative Reach per Hour and the Reach MultipleLab Locked
  9. Planning a New Pillar: Standard Hours by Format, Planned Quantities, Running Totals and the Capacity Cut-offLab Locked
  10. Totals by Channel: COUNTIF, SUMIFS and Reach per Hour from a Production LogLab Locked
  11. The Coverage Matrix: Which Pillar Reached Which Channel, Coverage per Pillar and per Channel, and the GapsLab Locked
  12. Engagement per Format: Simple Average vs Weighted Rate, AVERAGEIFS and SUMIFSLab Locked
  13. Choosing What to Make Next: Priority Index, RANK, LARGE and INDEX-MATCH for the Top PicksLab Locked
  14. Reshare Decay: Reach per Reshare, Retention vs the Previous Share, a Forecast and the Limit of a Straight LineLab Locked
  15. The Reshare Calendar: Posts per Month with COUNTIFS, a Monthly Cap, Gaps between Reshares and a Warning ColourLab Locked
  16. Evergreen or Spike? Launch vs Tail Reach, Tail Share, a Classification Rule and a Stacked ChartLab Locked
  17. Capacity What-If: Usable Hours, Maximum Derivatives, a Scenario Grid and the Limit HighlightedLab Locked
  18. Filling an Hours Budget: Reach per Hour Order, Cumulative Hours, Make or Skip and the Share of Reach CapturedLab Locked
  19. Quality Checks before Resharing: Caption Length, Tracking Tags, Duplicate Captions and an Issue CountLab Locked
  20. Final Project: The Repurposing Scorecard for One Report, from Cost and Reach to a Keep-or-Review VerdictLab Locked