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.
- 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
- Campaign Request Intake: Requested Lead Time, Minimum Lead Time by Size and Rush Flags per TeamFree
- Triage Scoring: Weighted Priority Scores with SUMPRODUCT, Ranks and an Approve or Waitlist Decision Locked
- Sprint Capacity: Available Days, Net Hours after Leave and Overhead, and Capacity per Role Locked
- Utilisation and Load: Project Utilisation, Total Load and Overload Flags Locked
- Sprint Planning: Plannable Hours, Running Totals, Commit or Carry Over and Carry-Over Hours Locked
- Sprint Velocity: Completion Rates, a Moving Average, a Linear Forecast and Sprints to Clear the Backlog Locked
- Turnaround SLAs: Targets per Request Type, Met or Missed, Days over the SLA and SLA Attainment Locked
- Turnaround Distribution: Mean, Median, 90th Percentile and the Share within the SLA Locked
- Approval Rounds and Rework: Hours per Round, Rework Hours, First-Pass Rate and Rework Share Locked
- Campaign QA: Errors per 100 Checks, a Target Status, the Overall Error Rate and the Share of Clean Launches Locked
- QA Escapes: Escape Rate per Launch, the Overall Escape Rate and a Pareto Analysis of Defect Categories Locked
- QA Control Limits: Weekly Error Proportions, a Centre Line, Upper Control Limits and Signals Locked
- Backlog Ageing: Age in Days, Age Bands with an Approximate Lookup, Counts per Band and Waiting Time Locked
- Backlog Flow: Arrivals, Completions, Net Flow, Backlog Trend and Little's Law Waiting Time Locked
- Tool Stack Costs: Cost per Active User, Seat Utilisation, Unused Spend and Low-Use Flags Locked
- Seat Right-Sizing: Right-Sized Licences with ROUNDUP, Savings per Tool and a Renewal Window Locked
- Cost Allocation: User and Request Shares, Allocated Tool Cost per Team and Cost per Active User Locked
- Capacity vs Demand: Demand Hours by Request Type, Utilisation Needed and a Growth-by-Headcount Scenario Grid Locked
- Load and Quality: Correlation, Regression Slope, R-Squared and a Forecast of Errors at a Higher Load Locked
- Final Project: A Marketing Operations Scorecard with SLA, Utilisation, QA and Tool-Cost KPIs Locked
Learner reviews
Be the first to review this course.