Tabellab

Freelance Digital Marketer: Day Rates, Package Pricing, Proposal Win Rate, Pipeline, Scope & Hours, Retainers and Client Concentration

Run the numbers of a one-person marketing business. You will turn a planning target into a day rate, compare the quoted hourly rate with the effective rate you earn, price service packages from hours, log proposals and calculate win rates by lead source, value a proposal by its expected fee per hour of selling, weight a client pipeline by stage, measure the sales cycle in days, track estimated against actual hours, put a price on scope creep, analyse a timesheet, split retainer from project income, price retainer tiers with overage, follow invoices and late payment, measure client concentration, test what happens if the largest client leaves, plan capacity, forecast slow months, try a price rise in a scenario grid and finish with a quarterly review: 20 hands-on labs, fictional Yarrowby Studio 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

Pricing, selling and managing a one-person marketing business comes down to a handful of calculations, and this course lets you practise every one of them in a live spreadsheet. Across 20 hands-on labs for the fictional Yarrowby Studio you turn a planning target into a day rate, compare quoted and effective hourly rates, price packages from hours, track proposals and win rates by lead source, weight a client pipeline, measure the sales cycle, compare estimated and actual hours, put a price on scope creep, split retainer and project income, follow invoices and late payment, measure client concentration, plan capacity and test a price rise. The first lab is free, the Coach checks each cell as you type, and a 20-question exam leads to a certificate. All data are fictional and the course is planning arithmetic, not an income promise.

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. From Target to Day Rate: Working Days, Billable Days, Business Costs and the Rate You NeedLabFree
  2. Hourly Rate, Day Rate and Effective Rate: What Non-Billable Hours Do to What You EarnLab Locked
  3. Package Pricing: Hours, Hourly Rate, a Revision Buffer and Clean Round PricesLab Locked
  4. Proposal Win Rate: Counting Won, Lost and Pending, Decided Proposals and the Value You WinLab Locked
  5. Win Rate by Lead Source: Referrals, Enquiries, Outreach and Marketplaces ComparedLab Locked
  6. Expected Value of a Proposal: Win Rate × Fee, Pay per Selling Hour and the Break-Even Win RateLab Locked
  7. The Client Pipeline: Stages, Chance of Winning, Weighted Value and Coverage of a Fee GoalLab Locked
  8. Sales Cycle: Days from Enquiry to Proposal to Decision and Follow-Up DatesLab Locked
  9. Scope and Hours Tracking: Estimate versus Actual, Overrun and the Effective Rate per ProjectLab Locked
  10. Scope Creep: Logging Change Requests, Billed and Unbilled Out-of-Scope Hours and What They CostLab Locked
  11. Timesheet Analysis: Hours by Task Type, Share of Time, Rank and Billable ShareLab Locked
  12. Retainer vs Project Income: Monthly Totals, Retainer Share and a Moving AverageLab Locked
  13. Retainer Tiers: Included Hours, Overage Charges and the Effective Rate per ClientLab Locked
  14. Invoices and Payment Terms: Due Dates, Days Late, Open Invoices and RemindersLab Locked
  15. Client Concentration: Share of Fees, Rank, the Top Three and a Concentration IndexLab Locked
  16. What If the Largest Client Leaves? Lost Fees, Replacement Projects, Proposals and Selling HoursLab Locked
  17. Capacity Planning: Billable Hours, Committed Retainer and Project Hours, Spare Time and UtilisationLab Locked
  18. Income Forecast and Slow Months: Trend, FORECAST.LINEAR, Shortfalls and a Cash BufferLab Locked
  19. Price Rise What-If: A Scenario Grid of Price Increases and Lost Clients with Mixed ReferencesLab Locked
  20. Final Project: A Quarterly Review of Hours, Effective Rate, Win Rate and Client DependenceLab 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