Google Ads Offline Conversion Import for Window Treatment Companies: Teach Google Which Clicks Book Consultations and Sell Shutters

← BACK TO LOCAL BLOG
All topics Paid Ads
10 Min Read

Google Ads Offline Conversion Import for Window Treatment Companies: Teach Google Which Clicks Book Consultations and Sell Shutters

Google Ads Offline Conversion Import for Window Treatment Companies: Teach Google Which Clicks Book Consultations and Sell Shutters

Google Ads reports 60 conversions last month. Your designers say half of them were tire kickers, a few were existing customers, and two were vendors. Smart Bidding does not know any of that. It just goes looking for more people like all 60.

That is the real cost of optimizing for form fills: Google gets very good at finding people who fill out forms. Offline conversion import fixes it by telling Google which clicks turned into booked consultations and sales.

Key takeaways
• Offline conversion import sends CRM outcomes such as booked consultations and sales back to the Google Ads click that started them. • Google retains the GCLID for 90 days; enhanced conversions for leads, which match on hashed email or phone, allow 63 days. • Send a ladder of events (booked consultation, quote, sale) so Google gets fast signals and revenue signals. • Capture gclid, gbraid, and wbraid at the moment of the lead, or the conversion can never be matched. • Switch bidding to the offline events only after they have steady volume, and keep primary and secondary actions clean.

This guide covers how matching works, which events to send, the CRM fields you need, upload methods, timing windows, values, bidding, and a 30-day rollout.

01

What Is Offline Conversion Import?

Short answer

Offline conversion import sends events that happen after the click, such as a booked consultation or a sale recorded in your CRM, back to Google Ads and credits them to the ad click that started the journey.

Website conversion tracking stops at the thank-you page. For a window treatment company, that is the beginning of the sale, not the end. The consultation, the measure, the quote, and the signed order all happen in your CRM, on the phone, or in the customer’s living room.

Offline conversion import closes the loop. When a lead reaches a milestone in the CRM, the CRM (or an integration tool) sends that milestone to Google Ads with an identifier that links it to the original ad click. Google’s own setup requirements, summarized here include auto-tagging, the ability to edit every page of your site, and storing each click ID next to the prospect’s details in your lead system.

It is the natural next step after call tracking and lead attribution. Attribution tells you which campaigns sell. Offline import tells Google, so its bidding can act on it.

02

Why Does It Matter So Much for Window Treatment Ads?

Short answer

The gap between a lead and a sale is wide in this industry. Optimizing for leads alone pushes budget toward cheap, low-intent inquiries.

→Lead quality varies widely. A “free consultation” form attracts serious buyers, renters, price shoppers, and people outside your area.
→The sale happens offline. Measures, quotes, and orders never touch your website, so Google cannot see them without import.
→Ticket sizes vary a lot. One whole-home shutter job can be worth more than ten single-room blind orders.
→Smart Bidding follows the signal you give it. Feed it form fills and it finds form fillers. Feed it sales and it looks for buyers.
→Competitors face the same auction. Dealers who send better signals can often afford to bid more for the homeowners who buy.

For a dealer running search campaigns with Maximize Conversions or Target CPA, offline import is often the single largest improvement left after the account structure is sound.

03

How Does Google Match an Offline Conversion to a Click?

Short answer

Two ways: by the Google click ID (GCLID, or GBRAID and WBRAID on some iOS traffic) stored with the lead, or by hashed email and phone through enhanced conversions for leads.

Method
GCLID import
How it matches
The click ID captured from the landing page URL and stored in the CRM
Upload window
90 days after the click
Best for
Dealers who can reliably capture and store click IDs
Method
Enhanced conversions for leads
How it matches
SHA-256 hashed email or phone matched to a signed-in Google user
Upload window
63 days after the click
Best for
Leads where the click ID was lost, such as cross-device journeys
Method
Both together
How it matches
Send the click ID when you have it, plus hashed contact details
Upload window
Shortest applicable window
Best for
Most dealers: highest match rate

Both windows come from Google’s offline conversion imports FAQ: conversions with a GCLID can be uploaded up to 90 days after the click, and conversions using personal information for enhanced conversions up to 63 days. If an upload is older than that, Google returns a “click is too old” error.

Window treatment sales can take longer than 63 days, especially new construction. The fix is not to wait for the sale. Send earlier milestones, such as the booked consultation, that reliably happen inside the window.

04

Which Events Should a Dealer Send Back?

Short answer

Send a ladder of three to four events: qualified lead, booked consultation, quote sent, and sale, each with a value. Use the earliest strong event for bidding until later events have enough volume.

Event
Qualified lead
When it fires in the CRM
Designer confirms a real project in your area
Typical timing
Same day
Use in Google Ads
Secondary at first; useful for new accounts
Event
Booked consultation
When it fires in the CRM
Appointment on a designer’s calendar
Typical timing
Day 0–3
Use in Google Ads
Often the best primary event to start
Event
Quote sent
When it fires in the CRM
Proposal delivered with an amount
Typical timing
Day 3–14
Use in Google Ads
Secondary, with quote value for insight
Event
Sale
When it fires in the CRM
Order signed or deposit paid
Typical timing
Day 7–60+
Use in Google Ads
Primary for value-based bidding once volume allows

Why a ladder? Bidding systems learn faster with more frequent signals. A dealer with 15 sales a month may not have enough sale events for stable bidding, but may have 50 booked consultations. Start bidding on booked consultations, keep sales as a secondary action, and move to value-based bidding on sales once volume supports it.

Define each event by a CRM stage change, not by a person remembering to click a button. If “booked consultation” means “appointment created with a designer,” it will fire consistently. If it depends on manual tagging, it will be patchy.

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

Google optimizing for the wrong leads?

Get a free review of your conversion tracking and offline imports.

Book a free consultation →
05

What Data Do You Need to Capture in the CRM?

Short answer

Store the click IDs and the contact details at the moment the lead arrives, plus a timestamp for every milestone. You cannot recover a click ID later.

CRM field
gclid
What it holds
Google click ID
Captured from
Landing page URL parameter, saved in a hidden form field
CRM field
gbraid / wbraid
What it holds
iOS-related click identifiers
Captured from
Landing page URL, same method
CRM field
Lead created time
What it holds
When the inquiry arrived
Captured from
Form or call timestamp
CRM field
Email and phone
What it holds
Normalized contact details
Captured from
Form, call, or chat
CRM field
Milestone timestamps
What it holds
Booked, quoted, sold dates and times
Captured from
Pipeline stage changes
CRM field
Values
What it holds
Quote amount and sale amount
Captured from
Quote and order records
CRM field
Consent
What it holds
Whether the lead agreed to your privacy terms
Captured from
Form checkbox

The capture method is the same hidden-field approach covered in our call tracking guide: a script reads the click ID from the landing URL, stores it for the visit, and writes it into the form. Calls need their own path. Many call tracking platforms can attach the GCLID of an ad visitor to the call record and pass it to the CRM.

Normalize contact details before hashing for enhanced conversions: trim spaces, lowercase emails, and format phone numbers in E.164 (for example +12145550142). Most CRM integrations handle hashing for you. If you build uploads yourself, hash with SHA-256 and never upload raw personal data.

06

How Do You Upload Conversions: Manual, Scheduled, or Integrated?

Short answer

Use a native CRM integration or a connector tool if you can, scheduled file uploads if you cannot, and manual CSV uploads only for testing.

Method
Native CRM integration
How it works
Your CRM connects to Google Ads and sends stage changes
Pros
Automatic, near real time
Watch out for
Check which fields and stages it supports
Method
Connector or webhook tool
How it works
A middleware tool listens for CRM events and uploads them
Pros
Works with most CRMs
Watch out for
Another system to maintain
Method
Scheduled file upload
How it works
CRM exports a sheet or HTTPS file Google pulls on a schedule
Pros
No code
Watch out for
Format errors can stop uploads quietly
Method
Manual CSV
How it works
Someone uploads a file in the interface
Pros
Good for testing
Watch out for
Easy to forget; signal goes stale

There is a 2026 change to know about. According to Relevant Audience’s summary of Google’s documentation, from June 15, 2026 offline conversion and enhanced conversions for leads uploads moved to the Data Manager API, with the older Google Ads API path blocked except for allowlisted legacy tokens. If you or a vendor built a custom upload before mid-2026, confirm it still works.

Example upload columns (GCLID import)
Google Click ID, Conversion Name, Conversion Time, Conversion Value, Conversion Currency Cj0KCQjw...AbC, Booked Consultation, 2026-10-14 15:42:00-05:00, 150, USD

Upload at least daily. Frequent uploads keep the signal fresh for bidding and keep you well inside the 63- and 90-day windows.

07

How Should You Set Conversion Values?

Short answer

Use expected value for early events and real revenue for sales. Expected value is the average sale amount multiplied by the rate at which that event turns into a sale.

Event
Qualified lead
Value formula
Average sale × lead-to-sale rate
Example
$3,000 × 12% = $360
Event
Booked consultation
Value formula
Average sale × consultation-to-sale rate
Example
$3,000 × 35% = $1,050
Event
Quote sent
Value formula
Quote amount × quote close rate
Example
$7,200 × 45% = $3,240
Event
Sale
Value formula
Actual order amount
Example
$6,840

The example figures are illustrative. Use your own averages from the last six to twelve months, and update them each quarter.

Values matter because they let Google tell a whole-home shutter lead from a single-room blind lead. Once sales flow in with real amounts, value-based bidding can push budget toward the campaigns and search terms that bring bigger projects, not just more of them.

Conversion adjustments can correct mistakes. Google allows retracting or restating an uploaded conversion for up to 55 days after it was first recorded, which is useful for cancellations and refunds.

08

How Do You Set Up Conversion Actions and Bidding?

Short answer

Create one conversion action per event, mark only the event you bid on as primary, and switch bidding gradually once it has steady volume.

Step 1
Create actions
In Google Ads, create an import conversion action for each event: Booked Consultation, Quote Sent, Sale.
Step 2
Set primary vs. secondary
Make Booked Consultation primary. Keep website form fills, quotes, and sales secondary while you build history.
Step 3
Match windows
Set click-through windows long enough for each event, up to 90 days for sales.
Step 4
Wait, then upload
Google advises waiting several hours after creating an action before the first upload. Run a test file first.
Step 5
Monitor diagnostics
Check the upload diagnostics for match rate and errors weekly.
Step 6
Shift bidding
When the new primary event has steady weekly volume, move Target CPA or Target ROAS to it and let bidding relearn.

Do not leave form fills and booked consultations both as primary. Google will count both and optimize for the easier one. One primary per campaign goal keeps the signal clean.

09

What Are the Most Common Mistakes?

Short answer

Missing click IDs, uploads that stop silently, double counting, time zone errors, and switching bidding too early.

✕Click IDs never captured. Forms without hidden fields, chat widgets, and calls without a GCLID path are the usual gaps.
✕Uploads stop and nobody notices. Set an alert if no conversions arrive for three days.
✕Double counting. The same sale sent from two systems, or form fills and consultations both marked primary.
✕Time zone mismatch. Conversion time before click time causes errors. Include the offset in every timestamp.
✕Switching bidding on thin data. A handful of events a week is not enough for stable automated bidding.
✕Forgetting consent. Make sure your privacy policy and form consent cover sharing data with ad platforms.

Most of these trace back to the CRM. If stages, timestamps, and source fields are clean, imports are reliable. Our CRM and lead tracking guide covers the pipeline setup underneath this.

10

How Do You Know It Is Working?

Short answer

Watch match rate, upload freshness, and cost per booked consultation by campaign. Over time, cost per sale and average order value should improve.

Metric
Match rate
Where to find it
Google Ads upload diagnostics
What good looks like
Most uploads matched; investigate a sudden drop
Metric
Days since last upload
Where to find it
Diagnostics or your connector
What good looks like
Never more than one day
Metric
Cost per booked consultation
Where to find it
Google Ads, with offline action as a column
What good looks like
Stable or falling after bidding relearns
Metric
Booked rate by campaign
Where to find it
CRM report
What good looks like
Campaigns ranked by booked consultations, not leads
Metric
Cost per sale and order value
Where to find it
CRM joined with ad spend
What good looks like
Improving over two to three months

The comparison that convinces owners is simple: before and after cost per booked consultation by campaign. Our upcoming guide on the cost per booked consultation dashboard shows how to build that view.

11

How Do You Roll It Out in 30 Days?

Short answer

Week 1 capture, week 2 conversion actions and test uploads, week 3 automated uploads, week 4 diagnostics and a bidding plan.

Week 1
Capture
Turn on auto-tagging. Add gclid, gbraid, wbraid hidden fields to every form and chat. Map them to CRM fields. Connect call tracking click IDs.
Week 2
Actions and test
Create import actions for each event. Set values. Upload a small test file and fix errors.
Week 3
Automate
Turn on the native integration or connector. Upload daily. Add enhanced conversions for leads with hashed contact details.
Week 4
Check and plan
Review match rates and volume. Set a date to move bidding once the new primary event is steady.

Expect two to four weeks of data before changing bidding, then another few weeks while it relearns. The payoff compounds: each month Google learns more about which homeowners actually buy. For campaign structure, see our window treatment PPC guide.

An Offline Conversion Audit

Twenty questions about what Google learns from your CRM

Answer yes or no. Every no is a place Smart Bidding may be optimizing for the wrong people.

Capture

5 items
Is auto-tagging turned on in Google Ads?
Do all forms save gclid, gbraid, and wbraid?
Does chat capture click IDs?
Do tracked calls pass click IDs to the CRM?
Are email and phone normalized on every lead?

Events

5 items
Is each milestone tied to a CRM stage change?
Do you send booked consultations?
Do you send quotes with amounts?
Do you send sales with real revenue?
Are values reviewed each quarter?

Uploads

5 items
Do uploads run at least daily?
Is there an alert if uploads stop?
Are timestamps sent with time zone offsets?
Are enhanced conversions for leads enabled?
Has a custom upload been checked since mid-2026?

Bidding

5 items
Is only one event primary per campaign goal?
Are form fills secondary once offline events flow?
Does the primary event have steady weekly volume?
Do you track cost per booked consultation by campaign?
Do you review match rate weekly?

If several answers are no, Google is learning from form fills instead of sales. That's fixable.

FAQ

Frequently Asked Questions About Offline Conversion Import

What is Google Ads offline conversion import?+
It is a way to send conversions that happen after the ad click, such as a booked consultation or a sale in your CRM, back to Google Ads and credit them to the original click.
How long do I have to upload an offline conversion?+
According to Google’s offline conversion imports FAQ, conversions with a GCLID can be uploaded up to 90 days after the click, and enhanced conversions for leads up to 63 days.
Which event should a window treatment company bid on?+
Many dealers start with booked consultations because they are frequent and happen soon after the click, then move to sales with real values once there is enough volume.
What are enhanced conversions for leads?+
A matching method that uses hashed email or phone numbers from your CRM to connect a conversion to a signed-in Google user who clicked your ad, useful when the click ID was not captured.
Do I need a developer to set this up?+
Not always. Many CRMs and connector tools offer native Google Ads integrations. Custom uploads built before mid-2026 should be checked against Google’s move to the Data Manager API.
Will this improve my cost per lead?+
It may raise cost per lead while lowering cost per booked consultation and cost per sale, because bidding shifts toward homeowners who buy rather than anyone who fills out a form.

Teach Google What a Good Lead Looks Like.

Google’s bidding is only as smart as the signal you send it. When it learns from booked consultations and sales instead of form fills, budget flows toward the homeowners who actually buy shutters and shades.

Capture the click. Send the outcome. Bid on what sells.

For related guides, see call tracking and attribution, window treatment PPC, and speed to lead.

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 Google Ads is optimizing for form fills, start with a Free Strategy Assessment. We will review your conversion setup and show how to send booked consultations and sales back to Google.