The short answer
Start with what you can afford to spend to win one completed job. Then work back to the clicks and inquiries needed, include fees, and check your cash and capacity. We’ll walk through a fictional $3,000 media budget and $500 fee so you can try the calculation with your own numbers. Those amounts aren’t a recommended spend.

Start with the budget worksheet

No email required.

Open the file in Excel or import it into Google Sheets, then save your own copy.

Replace the yellow inputs and use the notes beside each field. Your entries stay in that copy.

See the worked budget example

How much can you spend on ads and still make the jobs worthwhile? Start with the work you want, what you earn from it and how many extra jobs you can handle. The worksheet helps you run the numbers.

It opens with a made-up example. Replace the yellow inputs with your own numbers for one service, service area and planning month. All amounts are in US dollars.

There isn’t one right budget or percentage of revenue for every business. Use the example to see how the calculation works, then try your own numbers.

This worksheet is for Google Search ads that send people to your website. Local Services Ads (LSA), calls directly from ads and other campaign types need their own cost and response assumptions.

The completed-job estimate includes work that eventually comes from that month’s inquiries. Some of those jobs may finish later, so it doesn’t tell you how much cash you’ll collect that month.

Pull together your ad spend, fees, job revenue and direct costs. For the same group of unique inquiries, check which were a good fit, which booked and which became completed jobs. Give those customers time to decide and the jobs time to finish before judging the results.

Starting without that history? Mark your rates as assumptions and try a weaker outcome too. That will help you see what you could afford if things go more slowly.

Where to find the numbers for your plan

Use records for the service and area you’re planning to advertise. Beside each input, note where the number came from and when you checked it.

Keep inquiries from paid search separate from referrals and repeat customers. If you use another channel’s rates for a new campaign, treat them as a starting assumption until you have paid-search results.

Unsure of a number? Clear the fictional value and leave it blank. The results that need it will show “n.a.” until there’s enough information to calculate them.

If your business is new, the worksheet can help you see what to measure first. You’ll need more than the example’s numbers to choose your budget.

Here’s where to look for each input:

  • Expected average cost per click (CPC): check the cost and clicks for the matching Google Ads campaign. For a new campaign, use a relevant Keyword Planner forecast. Look for average CPC, rather than the top-of-page bid estimate.
  • Inquiries per click: compare the campaign’s clicks with the unique calls and forms they brought in. Check your tracking against the actual call and form records. Count each inquiry once, and leave out contact-page visits that didn’t become inquiries.
  • Qualification and booking rates: look through your intake notes, dispatch log or customer management system (CRM). Which inquiries fit your service and area? Which became a booked job or an estimate appointment? Use the booking definition you chose throughout.
  • Completion rate and job contribution: match bookings to completed jobs and invoices. Your bookkeeping or job-cost records can show what you expect to collect and the direct cost of doing the work. If a completed job hasn’t been paid for, include an assumption about what you’ll collect.
  • Fees and other acquisition costs: check your management agreement and invoices, plus any planned setup or landing-page work. Include the costs that belong to this plan, counting each one once.
  • Capacity and spending limit: check what’s already booked and how much cash you have for this plan. Allow for how long this service takes, with room for existing customers and work from other channels.

1. Work out what you can afford to spend to win a job

Start with one completed job. From the revenue you expect to collect, subtract direct labor, materials, subcontractors and other costs that increase when you take on that job.

What’s left is called the job’s contribution. This is the money available to cover advertising, overhead and profit. Leave advertising out of this first calculation because the worksheet counts it separately.

How much of that contribution do you need to keep for overhead and profit? Set that amount aside. What remains is your acquisition limit: the most you can spend to win one completed job.

That limit needs to cover the ads, management fees and any other costs of bringing in the work.

Let’s try a fictional service job. You expect to collect $1,000 and spend $250 on labor, $125 on materials and $25 on other delivery costs.

The direct costs add up to $400, leaving $600 in contribution before advertising. We’re using these numbers to explain the calculation; they aren’t typical trade prices or margins.

If you keep $250 for overhead and profit, you have $350 left to win the job. That $350 has to cover media, management and the other acquisition costs you assign to these jobs. Media means the money spent on the ads themselves.

The $350 is part of this example, not a suggested Quips price or an industry benchmark.

Use separate copies for work with very different costs and margins, such as emergency repairs and system installations.

This worksheet looks at the first job you win. Use that job’s contribution here. To plan around repeat business or lifetime revenue, you’ll need a separate model that includes future delivery costs, customer retention and when you collect payment.

2. Calculate your lead-to-job conversion rates

Think about what happens after someone gets in touch. Does the job fit your business? Do they book? Does the work go ahead? A form or appointment alone doesn’t tell you how much revenue to expect.

Follow one group of inquiries from your ads through those stages. If someone calls and fills in a form about the same job, count that inquiry once.

For example, if someone inquires in October and their job finishes in November, keep that result with the October inquiry group.

November’s completed jobs may have come from earlier inquiries. Match each job to its original inquiry before calculating your rates.

Note the date you checked. An estimate that’s still open or a job that hasn’t finished is pending, rather than automatically lost.

Give customers time to decide and your team time to finish the work. If you’re checking sooner, mark the rates as provisional. The right waiting period depends on the service.

Decide what you mean by a booking and stick with it. Are you counting booked jobs or estimate appointments? If it’s estimate appointments, your completion rate needs to include both winning the sale and eventually completing the job.

The worksheet’s “Media cost per booked job” uses that booking count. It includes estimate appointments if that’s the definition you chose.

You might know how many qualified leads become completed jobs without knowing the booking stage. Keep that combined rate out of the booking field, where it would give you a misleading booking count and cost per booking.

See if your records can fill in the separate stages. Otherwise, leave them unknown. Here’s how to calculate each rate:

  • Click to inquiry: unique inquiries ÷ ad clicks.
  • Qualification: suitable inquiries ÷ all unique inquiries. Decide what fits based on the service, area and kinds of work you accept.
  • Booking: booked jobs or estimate appointments ÷ qualified inquiries.
  • Completion: completed, paying jobs ÷ all bookings. Include canceled bookings and estimates that didn’t sell in the total booking count you divide by.

3. Calculate a starting Google Ads budget

Enter how many completed jobs you want and what you expect to pay per click. Your own account history for the same service and area is the best place to start when you have it.

For a new campaign, you can use a relevant Keyword Planner forecast as an assumption. Look for forecast average CPC, which means average cost per click. A top-of-page bid estimate or maximum bid is a different number.

Treat the forecast as an estimate, especially in a small local market where there may be less reliable data.

Multiply your inquiry, qualification, booking and completion rates. The result is the share of clicks you expect to become completed jobs.

Then work out the media spend needed: target completed jobs × average cost per click ÷ completed jobs per click.

If any of those rates is zero, this plan can’t produce completed jobs in the model.

Using the fictional rates below, 10% × 80% × 75% × 90% = 5.4% completed jobs per click.

Put 0.054 into the calculation: 15 target jobs × $10 ÷ 0.054 = $2,777.78 in media before fees.

When filling in percentage inputs in the worksheet, enter 10% or 0.10, not 10.

You’ll find the calculated amount in “Media for your job target.” Copy it into “Monthly media spend” to see how that budget works in the proposed plan.

You can also try a different amount, as we do with the $3,000 example. Changing the job target alone won’t update the proposed-plan results; you need to change the media spend too.

The worksheet divides media spend by cost per click, then applies each conversion rate. It assumes you spend the full proposed media amount.

It also assumes your cost per click and response rates stay the same. Check those assumptions again when you try different searches, areas or spending levels, because results can change as you expand.

Next, add your fixed monthly management fee, any percentage-of-media fee and the other costs of winning work that belong to this plan.

Those may include tracking tools, landing-page work, setup costs and applicable taxes. To check what you can afford, put a one-time cost in the month you expect to pay it.

Enter zero when a cost genuinely doesn’t apply.

Check all three proposed-plan results: acquisition target, capacity and all-in spending limit. A plan might fit your cash limit but bring in more jobs than you can handle, so look at each one.

If the spend needed for your target fails a check, revisit the number of jobs you want or the costs and margins before committing.

You’ll also see media cost per booking and per completed job. Keep those separate so you know which result you’re paying for.

4. Review a $3,000 Google Ads budget example

Let’s put the numbers together. This is a made-up example to show how the worksheet works, not customer results or a forecast of what you should expect.

We’ll spend $3,000 on ads in a month at $10 per click. The rates are 10% inquiry, 80% qualification, 75% booking and 90% completion.

We’ll also include a $500 fixed management fee, with no percentage fee or other costs. There’s room for 20 completed jobs and a $4,000 all-in spending limit.

At $600 contribution per completed job, 16.2 jobs leave $9,720 before the cost of winning them. Subtract the $3,500 in acquisition costs and $6,220 remains for overhead and profit.

That remaining contribution isn’t net profit or cash already received. And 16.2 jobs is a planning average, rather than a promise of 16 or 17 jobs.

Each completed job costs $216.05 to win, including fees. That fits the $350 acquisition allowance in this example. Your result will depend on how closely your inputs match what happens.

You’ll still need to check whether enough people in your market are looking for the service. The worksheet can test the numbers, but it can’t establish demand.

Fictional monthly plan, in US dollars
MeasureCalculationResult
Clicks3,000 ÷ 10300
Unique inquiries300 × 10%30
Qualified inquiries30 × 80%24
Bookings24 × 75%18
Completed jobs18 × 90%, capped at 2016.2
All-in acquisition costs$3,000 media + $500 fee$3,500
Media cost per booking$3,000 ÷ 18$166.67
Media cost per completed job$3,000 ÷ 16.2$185.19
All-in cost per completed job$3,500 ÷ 16.2$216.05

5. Check capacity, cash and a weaker outcome

How many extra completed jobs can your team take on from this campaign? Start with the room left after existing customers and other channels. Use the same mix of services and time period as your forecast.

The worksheet stops counting completed jobs at that capacity, while keeping the full proposed ad spend and fees. Inquiries you can’t turn into work won’t add revenue to the plan.

At the original rates, about $3,704 in media would model 20 completed jobs. But after the $500 fee, the $4,000 all-in cash limit leaves only $3,500 for media.

Those are two different limits to work within. You don’t need to spend up to either one, and the amount you choose still needs to meet your acquisition-cost target.

Now try a $15 cost per click and keep everything else the same. Expected jobs fall to 10.8, and the all-in cost of winning each completed job rises to about $324.07.

What if qualification falls to 60% too? Expected jobs drop to 8.1, and the all-in cost reaches about $432.10 per completed job. That’s above the $350 allowance.

Or suppose you only have room for 10 completed jobs. The original plan is then capped at 10 jobs and costs $350 per completed job.

At that point, buying more clicks would take you over the target unless something else improves. Allow for how long each kind of job takes when checking your spare capacity.

A few calls won’t tell you the whole story. With few qualified inquiries, one or two outcomes can make the cost per job look very different. There isn’t one test budget or number of days that proves a campaign will work.

You could focus on a narrower service or area and watch the results for longer, if you can afford to. Extra time helps you see outcomes, but it won’t make unprofitable jobs affordable. Choose spending you can support rather than increasing it just to collect more data.

Save your chosen inputs with the date and the records behind them. Before trying another scenario, reopen the original example or use a separate saved copy.

Leave an unknown rate blank; the result that needs it will become unavailable. Enter zero only when the rate you measured or assumed is actually zero.

6. Convert monthly media spend to a daily budget

Once you have a monthly media plan, you can use it to work out an average daily budget. For most campaigns, keeping that daily budget unchanged for a full calendar month gives you a monthly spending limit of 30.4 times the daily amount.

A $3,000 monthly media plan works out to about $98.68 per day. Use that as a reference for the account setting. It isn’t a forecast of traffic or exactly what you’ll spend each day.

For most campaigns using average daily budgets, Google can bill up to twice that daily budget on an individual day.

The limits change if you start partway through a month or edit your budgets. Lowering a budget won’t reset money already spent.

On a day when you edit the budget, the highest average daily budget you choose that day determines the daily limit. Check the budget report before changing the settings.

Campaign total budgets work differently. They use a set campaign amount and dates, so these daily-budget calculations don’t apply to them.

If you run several campaigns, count each separate or shared budget once. The worksheet’s daily reference covers your combined media plan. Divide that plan appropriately instead of putting the full amount into every campaign.

Keep cash available for fees, setup costs and the gap between paying for ads and collecting payment for the work.

Even a plan that looks profitable can leave you short of cash during that gap. Pick a test amount and review date you can manage if results are weaker than this example.

7. Use real outcomes to decide what changes next

Before you start spending, try the landing page as a customer would. Send a test inquiry and check that someone can receive it, respond and find out whether the job is a good fit.

Record ad spend and fees separately. As real results replace your assumptions, keep the same definitions for inquiries, qualified leads, bookings and completed jobs so the comparison stays useful.

When it’s time to review, look for the first place the plan falls short:

Clicks cost more than expected? Check your targeting and the searches bringing people in.

Lots of inquiries aren’t a good fit? Check the service area and what those people were looking for.

Suitable inquiries aren’t booking? Look at how the team handles the first contact and follows up.

Bookings aren’t becoming paid work? Look at the sales process and how the work is delivered.

If you’re considering more spend, check that the results, available cash and team capacity support the next amount.

Once a group of inquiries has had time to become completed work, compare the cost per job with your limit. If it’s still too high, work on the problem or reduce spending before paying for more traffic.

If there are only a few results, or customers are still deciding, leave room for that uncertainty in your next decision.

About the author

Drew Arnold is a co-founder of Quips. He writes about Google Ads, websites and local SEO for home service businesses.

Sources

Google documentation checked October 26, 2026.