Tabellab

Content Repurposing & Distribution: Pillar Assets, Derivative Hours, Reach per Piece, Distribution Checklists, Channel Fit & Evergreen Resharing

Turn one strong asset into many pieces without burning the team out. You will list the derivatives of a pillar webinar and add up their hours, price them against making the same pieces from scratch, compare reach per hour, cost per 1,000 reach and a paid benchmark, score distribution checklists and a coverage matrix, weight channel fit with SUMPRODUCT, plan evergreen resharing dates, forecast reach decay and cap the monthly calendar, then compare simple and weighted engagement, rank what to make next, test capacity what-ifs, fill a fixed hours budget, audit captions and links, and finish with a scorecard that returns a Keep or Review verdict for every derivative. 20 hands-on labs, fictional data, 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

Content Repurposing & Distribution turns one strong pillar asset into many pieces and lets you check, in a spreadsheet, whether the extra pieces are worth their hours. In 20 hands-on labs you list the derivatives of a webinar and add up their hours, price them against making the same pieces from scratch, and compare reach per hour and cost per 1,000 reach with a paid benchmark. You score a distribution checklist and a coverage matrix, weight channel fit with SUMPRODUCT, plan evergreen resharing dates and a monthly calendar, forecast how reach fades with each reshare, rank what to make next, test capacity what-ifs, fill a fixed hours budget and audit captions and links. The last lab combines everything into a scorecard. All labs follow the fictional publisher Ashgrove Studio, and a grader checks every formula as you type. All companies, people and numbers are fictional and for practice only.

Lessons

  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

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