Tabellab
Marketing Analytics Intermediate

Marketing Operations: Request Intake, Sprint Capacity & Utilisation, Turnaround SLAs, Campaign QA Error Rates, Tool-Stack Cost per User & Backlog Ageing

Run a marketing operations team on numbers instead of gut feeling. You will turn a request log into lead times and rush flags, score and rank requests, calculate sprint capacity and utilisation, plan sprints and forecast velocity, measure turnaround against SLAs and read its percentiles, count approval rounds and rework, track campaign QA error rates, escapes, Pareto categories and control limits, age and flow the backlog with Little's law, cost the tool stack per active user, right-size seats at renewal, allocate shared costs, test demand against capacity in a scenario grid, relate team load to quality and finish with a monthly scorecard, in 20 hands-on labs with fictional Sedgewick Outdoors 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

About this course: Marketing Operations: Team Capacity, SLAs and Quality is a hands-on spreadsheet course for people who keep a marketing team running: operations managers, campaign managers, team leads and analysts. In 20 labs you work with the fictional outdoor retailer Sedgewick Outdoors. You turn a request log into lead times and rush flags, score and rank requests, calculate net sprint capacity and utilisation, plan sprints and forecast velocity, check turnaround against service level agreements and read its percentiles, measure approval rounds and rework, track campaign QA error rates, escapes and control limits, age the backlog and apply Little's law, cost the tool stack per active user, right-size seats at renewal, allocate shared costs, test demand against capacity in a scenario grid and finish with a monthly scorecard. Every formula is checked as you type, there is a 20-question exam and a certificate. All companies, people and numbers are fictional and for learning only.

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. Campaign Request Intake: Requested Lead Time, Minimum Lead Time by Size and Rush Flags per TeamLabFree
  2. Triage Scoring: Weighted Priority Scores with SUMPRODUCT, Ranks and an Approve or Waitlist DecisionLab Locked
  3. Sprint Capacity: Available Days, Net Hours after Leave and Overhead, and Capacity per RoleLab Locked
  4. Utilisation and Load: Project Utilisation, Total Load and Overload FlagsLab Locked
  5. Sprint Planning: Plannable Hours, Running Totals, Commit or Carry Over and Carry-Over HoursLab Locked
  6. Sprint Velocity: Completion Rates, a Moving Average, a Linear Forecast and Sprints to Clear the BacklogLab Locked
  7. Turnaround SLAs: Targets per Request Type, Met or Missed, Days over the SLA and SLA AttainmentLab Locked
  8. Turnaround Distribution: Mean, Median, 90th Percentile and the Share within the SLALab Locked
  9. Approval Rounds and Rework: Hours per Round, Rework Hours, First-Pass Rate and Rework ShareLab Locked
  10. Campaign QA: Errors per 100 Checks, a Target Status, the Overall Error Rate and the Share of Clean LaunchesLab Locked
  11. QA Escapes: Escape Rate per Launch, the Overall Escape Rate and a Pareto Analysis of Defect CategoriesLab Locked
  12. QA Control Limits: Weekly Error Proportions, a Centre Line, Upper Control Limits and SignalsLab Locked
  13. Backlog Ageing: Age in Days, Age Bands with an Approximate Lookup, Counts per Band and Waiting TimeLab Locked
  14. Backlog Flow: Arrivals, Completions, Net Flow, Backlog Trend and Little's Law Waiting TimeLab Locked
  15. Tool Stack Costs: Cost per Active User, Seat Utilisation, Unused Spend and Low-Use FlagsLab Locked
  16. Seat Right-Sizing: Right-Sized Licences with ROUNDUP, Savings per Tool and a Renewal WindowLab Locked
  17. Cost Allocation: User and Request Shares, Allocated Tool Cost per Team and Cost per Active UserLab Locked
  18. Capacity vs Demand: Demand Hours by Request Type, Utilisation Needed and a Growth-by-Headcount Scenario GridLab Locked
  19. Load and Quality: Correlation, Regression Slope, R-Squared and a Forecast of Errors at a Higher LoadLab Locked
  20. Final Project: A Marketing Operations Scorecard with SLA, Utilisation, QA and Tool-Cost KPIsLab 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