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.
- 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
- From Target to Day Rate: Working Days, Billable Days, Business Costs and the Rate You NeedFree
- Hourly Rate, Day Rate and Effective Rate: What Non-Billable Hours Do to What You Earn Locked
- Package Pricing: Hours, Hourly Rate, a Revision Buffer and Clean Round Prices Locked
- Proposal Win Rate: Counting Won, Lost and Pending, Decided Proposals and the Value You Win Locked
- Win Rate by Lead Source: Referrals, Enquiries, Outreach and Marketplaces Compared Locked
- Expected Value of a Proposal: Win Rate × Fee, Pay per Selling Hour and the Break-Even Win Rate Locked
- The Client Pipeline: Stages, Chance of Winning, Weighted Value and Coverage of a Fee Goal Locked
- Sales Cycle: Days from Enquiry to Proposal to Decision and Follow-Up Dates Locked
- Scope and Hours Tracking: Estimate versus Actual, Overrun and the Effective Rate per Project Locked
- Scope Creep: Logging Change Requests, Billed and Unbilled Out-of-Scope Hours and What They Cost Locked
- Timesheet Analysis: Hours by Task Type, Share of Time, Rank and Billable Share Locked
- Retainer vs Project Income: Monthly Totals, Retainer Share and a Moving Average Locked
- Retainer Tiers: Included Hours, Overage Charges and the Effective Rate per Client Locked
- Invoices and Payment Terms: Due Dates, Days Late, Open Invoices and Reminders Locked
- Client Concentration: Share of Fees, Rank, the Top Three and a Concentration Index Locked
- What If the Largest Client Leaves? Lost Fees, Replacement Projects, Proposals and Selling Hours Locked
- Capacity Planning: Billable Hours, Committed Retainer and Project Hours, Spare Time and Utilisation Locked
- Income Forecast and Slow Months: Trend, FORECAST.LINEAR, Shortfalls and a Cash Buffer Locked
- Price Rise What-If: A Scenario Grid of Price Increases and Lost Clients with Mixed References Locked
- Final Project: A Quarterly Review of Hours, Effective Rate, Win Rate and Client Dependence Locked
Learner reviews
Be the first to review this course.