Tabellab

Visual Content Production: Template Reuse, Turnaround Time, Revision Rounds, Asset Library Coverage & Cost per Asset

Run a marketing design team with numbers instead of gut feeling. You will measure how often assets are built from templates, turn request and delivery dates into turnaround times, count revision rounds and first-pass approvals, and check which formats and sizes the asset library still lacks. You will price an asset in-house and from freelancers, compare the two, find the break-even volume, and rank templates by the hours they save. Then you describe turnaround with the median and the 80th percentile, handle rush requests, find the causes of revision rounds, weight library gaps by demand, test capacity against demand, forecast volume, build an outsourcing what-if grid, clean a messy asset log and finish with a four-quarter production scorecard: 20 hands-on labs, fictional Northgrove Outfitters 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

Visual Content Production is a hands-on course for marketers, brand managers and creative leads who want to run a design team with numbers. Across 20 spreadsheet labs you work for Northgrove Outfitters, a fictional online outdoor-gear shop with a small in-house design team and a pool of freelancers. You calculate the template reuse rate, convert request and delivery dates into calendar and working days, measure revision rounds and first-pass approval, and check asset library coverage by format and size, also weighted by demand. You then work out the cost per asset in-house and from freelancers, compare the two, find the break-even volume, rank templates by the hours they save, describe turnaround with the median and the 80th percentile, test capacity against demand, forecast volume and build an outsourcing what-if grid. The course ends with a four-quarter production scorecard, a 20-question exam and a certificate. Every cell is checked as you type. All companies, people and numbers are fictional.

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. Template Reuse Rate: Flagging Template-Based Assets, Counting with COUNTIF and COUNTIFS and the Reuse Rate per FormatLabFree
  2. Turnaround Time per Asset: Calendar and Working Days, SLA Lookups, On-Time Flags and the Average per FormatLab Locked
  3. Revision Rounds: Rounds per Asset, First-Pass Approval, Over-Scope Flags and the Average per Requesting TeamLab Locked
  4. Asset Library Coverage: Available vs Missing Assets by Format, Size and Collection, Overall Coverage and Gap FlagsLab Locked
  5. In-House Cost per Asset: Monthly Cost Pool, Hourly Cost of Design Time, Tools and Overhead Share and Cost by FormatLab Locked
  6. Freelance Cost per Asset: Expected Invoice, Rush Surcharge, Extra Rounds and the Average Cost per FormatLab Locked
  7. In-House vs Freelance: All-In Freelance Cost, Cheaper Option per Format, Weighted Blend and the Break-Even VolumeLab Locked
  8. Monthly Production Scorecard: Reuse Rate, Blended Cost per Asset, Freelance Share and a Trend ChartLab Locked
  9. Template Performance: Hours Saved per Asset, Rank by Uses, Top-3 Concentration and Payback of the Build HoursLab Locked
  10. Turnaround Distribution: Median, 80th Percentile, Share within the SLA and a Histogram ChartLab Locked
  11. Rush Requests: Lead Time, Rush Flags, the Rush Rate per Team and Highlighting with a Formula RuleLab Locked
  12. Causes of Revision Rounds: Hours Lost, Shares, a Cumulative Pareto Share and the Savings of a Better BriefLab Locked
  13. First-Pass Approval and Quality: Rates per Producer, Weighted Group Rates, Brand-Check Fails and a Highlight RuleLab Locked
  14. Library Coverage Weighted by Demand: Requests without an Asset, SUMPRODUCT Coverage, the Top Gap and a Bar ChartLab Locked
  15. Library Reuse Value: Cost per Use, Unused Assets, Money Tied Up and the Reuse ShareLab Locked
  16. Capacity and Overload: Weekly Capacity, Demand Hours, Utilisation, Overload Hours and a Demand ChartLab Locked
  17. Volume Forecast: Trend with SLOPE, FORECAST.LINEAR, Freelance Assets Needed above Capacity and the Freelance BudgetLab Locked
  18. Outsourcing What-If: Capacity Cut-Off, a Cost Grid with Mixed References, Cost per Asset and a Heat MapLab Locked
  19. Data Quality Checks: Duplicate IDs, Missing Formats, Reversed Dates, Impossible Rounds and a Clean-Row CountLab Locked
  20. Final Project: The Visual Production Scorecard with Reuse, Turnaround, Cost per Asset, a Chart and a Target FlagLab 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