Cost per Booked Consultation for Window Treatment Companies: Build the Dashboard That Shows Which Marketing Actually Pays

← BACK TO LOCAL BLOG
All topics Websites & Conversion
10 Min Read

Cost per Booked Consultation for Window Treatment Companies: Build the Dashboard That Shows Which Marketing Actually Pays

Cost per Booked Consultation for Window Treatment Companies: Build the Dashboard That Shows Which Marketing Actually Pays

Two channels each cost $3,000 last month. One produced 80 leads, the other 35. On a cost-per-lead report, the first wins easily. Then you look at the calendar: the 35 leads booked 20 consultations, and the 80 booked 14.

Cost per lead measures how cheaply you can get people to raise their hand. Cost per booked consultation measures how cheaply you can get a designer into a home with a real buyer. For a window treatment business, the second number is the one that predicts revenue.

Key takeaways
• Cost per booked consultation is total channel cost divided by consultations booked from that channel in the same period. • Track the full funnel by source: spend, leads, contacted, booked, shown, quoted, sold, and revenue. • Include all costs, such as agency fees, marketplace subscriptions, and direct mail printing, not just ad spend. • Use first-touch source for budget decisions and last-touch for channel management, and be consistent. • Review monthly, decide quarterly: move budget only on two to three months of consistent data.

This guide gives you the formulas, the data you need from ads and the CRM, how to join them, a dashboard layout, benchmarks to set for yourself, and how to act on what you find. All example figures are illustrative.

01

What Is Cost per Booked Consultation?

Short answer

Cost per booked consultation is the total cost of a marketing channel in a period divided by the number of in-home consultations booked from that channel in the same period.

Formula
Cost per booked consultation = Total channel cost ÷ Consultations booked from that channel Example: $4,200 ÷ 24 = $175

It sits between two more familiar numbers. Cost per lead is easy to get but says little about quality. Cost per sale is the truest number but arrives slowly, because many window treatment projects close weeks after the first call.

Cost per booked consultation is fast enough to manage month to month and close enough to revenue to trust. It answers the question owners actually care about: how much does it cost to get a designer in front of a real buyer?

02

Why Is Cost per Lead Misleading for Dealers?

Short answer

Because lead quality varies widely by channel. A cheap lead that never books is more expensive than a costly lead that buys.

Channel
Channel A
Spend
$3,000
Leads
80
Cost per lead
$38
Booked
14
Cost per booked consultation
$214
Channel
Channel B
Spend
$3,000
Leads
35
Cost per lead
$86
Booked
20
Cost per booked consultation
$150

These figures are illustrative, but the pattern is common. Social lead forms, marketplaces, and broad display often produce many leads at a low cost per lead and a lower booking rate. Search, Google Business Profile, and referrals often cost more per lead and book far more often.

Without booked data, budget drifts toward the cheapest leads. Your social ads might still be worth running, but you need the full funnel to know how much to spend and how to qualify.

03

Which Metrics Belong on the Dashboard?

Short answer

A full funnel by source: spend, leads, contacted, booked, shown, quoted, sold, and revenue, with the rates and costs between each step.

Metric
Cost per lead
Formula
Cost ÷ new leads
What it tells you
Lead volume efficiency
Metric
Contact rate
Formula
Contacted ÷ leads
What it tells you
Speed and persistence of follow-up
Metric
Booking rate
Formula
Booked ÷ leads
What it tells you
Lead quality plus sales process
Metric
Cost per booked consultation
Formula
Cost ÷ booked
What it tells you
The main marketing efficiency number
Metric
Show rate
Formula
Shown ÷ booked
What it tells you
Reminder and qualification quality
Metric
Close rate
Formula
Sold ÷ shown
What it tells you
Designer and offer performance
Metric
Cost per sale
Formula
Cost ÷ sold
What it tells you
Full-funnel efficiency
Metric
Average order value
Formula
Revenue ÷ sold
What it tells you
Project size by source
Metric
Marketing ROI
Formula
(Revenue × gross margin − cost) ÷ cost
What it tells you
Whether the channel pays

If contact rate is low, the problem is response, not marketing. If booking rate is low but contact rate is high, look at lead quality and the first conversation. If close rate is low, look at the consultation itself. The funnel tells you where to look.

04

What Counts as Cost?

Short answer

Everything you spend to get leads from that channel: ad spend, platform and marketplace fees, agency or management fees, creative, printing and postage, and call tracking or software allocated to it.

Channel
Google Ads
Costs to include
Ad spend, management fee share, call tracking numbers
Channel
Google LSA
Costs to include
Lead charges, any management fee share
Channel
Meta ads
Costs to include
Ad spend, creative production, management fee share
Channel
SEO and content
Costs to include
Monthly SEO fee, content writing, tools share
Channel
Marketplaces
Costs to include
Subscription, per-lead fees
Channel
Direct mail
Costs to include
Design, printing, postage, list costs
Channel
Showroom events
Costs to include
Event costs, food, promotional items
Channel
Referrals and trade
Costs to include
Referral rewards, partner gifts, event costs

Be consistent rather than perfect. If you split a $2,000 agency fee across channels, use the same rule every month. A slightly rough but consistent cost model is much more useful than a precise one that changes each time.

Client result
48booked jobs
For Arcadia Blinds, Dallas–Fort Worth

Not sure which marketing pays?

Get a free review of your marketing numbers and dashboard.

Book a free consultation →
05

What Data Do You Need, and Where Does It Live?

Short answer

Spend lives in ad platforms and invoices. Leads, stages, and revenue live in your CRM. Source ties them together.

Data
Spend
Source system
Google Ads, Meta, LSA, invoices
Key fields
Date, channel, campaign, cost
Data
Leads
Source system
CRM
Key fields
Created date, first-touch source, last-touch source, campaign
Data
Stages
Source system
CRM pipeline
Key fields
Contacted, booked, shown, quoted, sold dates
Data
Revenue
Source system
CRM or order system
Key fields
Order amount, sold date
Data
Calls
Source system
Call tracking
Key fields
Source, duration, tag (new lead or not)

The weak link is almost always source. If 30% of leads have “unknown” source, every cost metric is wrong. Fix capture first with our call tracking and attribution guide, then build the dashboard.

06

How Do You Join Ad Spend With CRM Data?

Short answer

Normalize channel and campaign names, then join spend and CRM counts by month and channel. Start in a spreadsheet; move to a dashboard tool once the logic works.

Step 1
Name channels the same everywhere
Use one list: google-ads, google-lsa, gbp, meta, seo, direct-mail, referral, showroom, marketplace.
Step 2
Export spend
Monthly cost by channel and campaign from each platform and from invoices.
Step 3
Export CRM counts
Monthly leads, booked, shown, sold, and revenue by first-touch channel.
Step 4
Join on month + channel
One row per channel per month with spend and every funnel count.
Step 5
Calculate
Add the formulas for each rate and cost.
Step 6
Automate
Once the sheet works, connect it to a dashboard tool such as Looker Studio, or use your CRM’s reporting.
One row of the joined table
month, channel, spend, leads, booked, shown, sold, revenue 2026-10, google-ads, 4200, 60, 24, 21, 9, 41600

Decide how to count leads that booked in a later month than they arrived. The simplest rule is cohort reporting: count bookings and sales against the month the lead was created. It is slower to fill in but gives fairer comparisons.

07

What Should the One-Page Dashboard Show?

Short answer

Four blocks: a top-line summary, a channel table, a trend chart, and a short notes section with decisions.

✓Top line. Total spend, booked consultations, cost per booked consultation, sales, revenue, and ROI for the month.
✓Channel table. One row per channel with spend, leads, booking rate, cost per booked consultation, close rate, cost per sale, and average order value.
✓Trend. Cost per booked consultation by channel over the last six to twelve months.
✓Funnel view. Leads to booked to shown to sold, so leaks are visible.
✓Notes and decisions. What changed, what you are testing, and what you will do next month.

Keep it to one page. If the owner cannot read it in five minutes, it will not be used. Detailed campaign-level views can live on a second tab for whoever runs the ads.

08

How Do You Set Your Own Benchmarks?

Short answer

Work backward from your margins: the most you can afford to pay for a booked consultation is what a consultation is worth to you, minus the profit you want to keep.

Break-even cost per booked consultation
Value of a booked consultation = Average order value × Close rate (from booked) × Gross margin Example: $4,000 × 35% × 45% = $630 Target: keep cost per booked consultation well below $630

The example uses illustrative numbers. Plug in your own averages from the last six to twelve months. The result is your ceiling. Channels well below it deserve more budget; channels near or above it need fixing or cutting.

Industry averages are rarely useful here, because order values and close rates differ so much between a blinds-only dealer and a shutter and motorization specialist. Your own break-even number is the benchmark that matters.

09

How Do You Act on the Numbers?

Short answer

Review monthly, decide quarterly. Shift budget toward channels well below break-even, fix the funnel step that leaks on weaker channels, and test one change at a time.

What you see
Low contact rate
Likely cause
Slow or inconsistent follow-up
What to do
Fix response first; see speed to lead
What you see
Good contact, low booking rate
Likely cause
Lead quality or first conversation
What to do
Tighten targeting, add form qualifiers, improve scripts
What you see
Low show rate
Likely cause
Weak reminders or casual bookings
What to do
Add confirmation and reminder texts
What you see
Low close rate
Likely cause
Consultation or pricing
What you see
Channel well below break-even
Likely cause
Strong fit
What to do
Increase budget gradually and watch the rate
What you see
Channel above break-even for 3 months
Likely cause
Poor fit or setup
What to do
Fix or cut

Avoid reacting to a single month. Window treatment demand is seasonal, and one month can swing on a few large orders. Two to three months of consistent data is a safer basis for moving money.

10

How Does It Connect to Ad Platform Bidding?

Short answer

Send booked consultations and sales back to ad platforms so their bidding optimizes for the same number your dashboard tracks.

Your dashboard tells you which channels and campaigns deliver booked consultations. Ad platforms, left alone, optimize for whatever conversion they can see, usually form fills. Offline conversion import sends booked consultations and sales from the CRM back to Google Ads, so bidding and reporting line up.

Once that is in place, cost per booked consultation in Google Ads should roughly match your dashboard. When they differ a lot, it usually means a tracking gap worth investigating. Lead scoring adds another layer: report booked rate by score band to see which sources bring the projects you want. See our lead scoring guide.

11

How Do You Roll It Out in 30 Days?

Short answer

Week 1 clean source data, week 2 build the spreadsheet, week 3 calculate break-even and review, week 4 automate and set a monthly review meeting.

Week 1
Clean source
Standardize channel names. Find and fix leads with unknown source.
Week 2
Build the sheet
Export three months of spend and CRM counts. Join by month and channel. Add formulas.
Week 3
Break-even and review
Calculate your break-even cost per booked consultation. Rank channels against it.
Week 4
Automate and schedule
Connect a dashboard tool or CRM report. Book a 30-minute monthly review.

The first version will raise questions about data quality. That is useful. Each fix makes the next month’s numbers more trustworthy, and within a quarter you will be making budget decisions on evidence instead of instinct.

A Marketing Dashboard Audit

Twenty questions about how you measure marketing

Answer yes or no. Every no is a place budget decisions may be based on the wrong number.

Data

5 items
Does every lead have a source?
Are channel names standardized?
Are booked, shown, and sold dates recorded?
Is revenue recorded on sold jobs?
Are non-leads removed from lead counts?

Costs

5 items
Are all channel costs included, not just ad spend?
Are agency fees allocated consistently?
Are marketplace fees included?
Are direct mail print and postage included?
Is the cost model the same every month?

Dashboard

5 items
Do you report cost per booked consultation by channel?
Do you see the full funnel by channel?
Is there a six to twelve month trend?
Does it fit on one page?
Is there a notes and decisions section?

Decisions

5 items
Do you know your break-even cost per booked consultation?
Do you review monthly?
Do you move budget on two to three months of data?
Do you fix funnel leaks before cutting channels?
Do ad platforms optimize for booked consultations?

If several answers are no, budget is following clicks instead of consultations. That's fixable.

FAQ

Frequently Asked Questions About Cost per Booked Consultation

What is cost per booked consultation?+
It is a channel’s total cost in a period divided by the number of in-home consultations booked from that channel in the same period.
Why not just use cost per lead?+
Lead quality varies widely between channels. A cheap lead that never books costs more than an expensive lead that buys, so cost per lead can push budget in the wrong direction.
What costs should be included?+
All costs to generate leads from that channel: ad spend, platform and marketplace fees, agency fees, creative, printing, postage, and allocated software like call tracking.
What is a good cost per booked consultation for a blinds company?+
It depends on your order value, close rate, and margin. Calculate your break-even by multiplying average order value, close rate from booked consultations, and gross margin, and aim well below it.
How often should we review the dashboard?+
Review monthly and make budget decisions quarterly, based on two to three months of consistent data, because demand is seasonal.
What tools do we need?+
A spreadsheet is enough to start. Once the logic works, connect it to a dashboard tool or use your CRM’s reporting.

Spend on What Fills the Calendar.

When every channel is measured by the cost to get a designer in front of a real buyer, budget decisions get simpler. Strong channels grow, weak ones get fixed or cut, and marketing becomes a predictable part of the business.

Track the funnel. Know your break-even. Move budget on evidence.

For related guides, see call tracking and attribution, offline conversion import, and window treatment marketing.

Yay Blitz helps window treatment companies connect Graphic and Web Design, Paid Local Advertising, and AI Lead Management into one measurable system for getting and converting leads.

If you cannot see cost per booked consultation by channel, start with a Free Strategy Assessment. We will review your data and help you build a dashboard that shows which marketing pays.