The Reshare Calendar: Posts per Month with COUNTIFS, a Monthly Cap, Gaps between Reshares and a Warning Colour
Lessons in this course
- One Pillar, Many Pieces: Listing the Derivatives, Hours per Piece and Share of EffortFree
- Hours and Cost per Derivative: Hourly Rates by Role, Repurposed vs From-Scratch and the Saving Locked
- Reach per Derivative: Reach per Hour, Share of Total Reach, Rank and the Best Piece Locked
- Cost per 1,000 Reach: Comparing Derivatives with a Paid Benchmark and Flagging Losers Locked
- The Distribution Checklist: Items Done, Coverage per Derivative and the Gaps per Item Locked
- Channel Fit Scoring: Criteria Weights, Weighted Scores with SUMPRODUCT, Fit Labels and Weak Spots Locked
- Evergreen Resharing Schedule: Reshare Intervals by Post Type, Next Reshare Dates, Working Days and Status Locked
- The Repurposing Multiplier: Pillar vs Derivative Reach per Hour and the Reach Multiple Locked
- Planning a New Pillar: Standard Hours by Format, Planned Quantities, Running Totals and the Capacity Cut-off Locked
- Totals by Channel: COUNTIF, SUMIFS and Reach per Hour from a Production Log Locked
- The Coverage Matrix: Which Pillar Reached Which Channel, Coverage per Pillar and per Channel, and the Gaps Locked
- Engagement per Format: Simple Average vs Weighted Rate, AVERAGEIFS and SUMIFS Locked
- Choosing What to Make Next: Priority Index, RANK, LARGE and INDEX-MATCH for the Top Picks Locked
- Reshare Decay: Reach per Reshare, Retention vs the Previous Share, a Forecast and the Limit of a Straight Line Locked
- The Reshare Calendar: Posts per Month with COUNTIFS, a Monthly Cap, Gaps between Reshares and a Warning Colour Locked
- Evergreen or Spike? Launch vs Tail Reach, Tail Share, a Classification Rule and a Stacked Chart Locked
- Capacity What-If: Usable Hours, Maximum Derivatives, a Scenario Grid and the Limit Highlighted Locked
- Filling an Hours Budget: Reach per Hour Order, Cumulative Hours, Make or Skip and the Share of Reach Captured Locked
- Quality Checks before Resharing: Caption Length, Tracking Tags, Duplicate Captions and an Issue Count Locked
- Final Project: The Repurposing Scorecard for One Report, from Cost and Reach to a Keep-or-Review Verdict Locked