Case study · Ecommerce

Automated Google Ads offline conversion import for a UK retailer

Captured the Google click ID with every lead and automated the upload of confirmed offline sales back to Google Ads: 153 conversions uploaded, 153 successful, 0 errors.

Case study cover: Automated Google Ads offline conversion import for a UK retailer
Client
UK online retailer (hoses and fittings)
Market
United Kingdom
Business model
Online shop with many orders completed after the first contact
Platform
Google Sheets
Period
2024
Scope
GCLID capture, Apps Script endpoint, Google Sheet, scheduled offline conversion import, consent fields

Evidence: the work and the verified results below are shown in my own project screenshots. They are kept private because they contain client account details.

01The business problem

Many of this retailer's sales were completed offline, after the customer first clicked an ad and got in touch. Google Ads never saw those sales.

As a result, campaigns looked weaker than they were, and Smart Bidding was learning from enquiries instead of from the orders that actually happened.

02Why it was technically difficult

To credit an offline sale to the right ad, Google Ads needs the click ID (GCLID) from the original visit. That ID has to be captured at the moment of the enquiry and kept until the sale is confirmed, sometimes weeks later.

Manual uploads are fragile: they get forgotten, delayed or formatted wrongly. The process had to run on its own.

03My approach

I set it up so every lead carries its GCLID from the first form submission, sales are written to one sheet in the format Google Ads expects, and Google Ads collects them on a schedule.

04How it fits together

  1. Ad click (GCLID)
  2. Website form
  3. Lead with GCLID
  1. Confirmed sale
  2. Apps Script → Google Sheet
  3. Scheduled Google Ads import
Offline sale back to the ad that started it (generic labels)

05What I implemented

  • GCLID captureThe Google click ID stored with every form submission through Google Tag Manager.
  • Apps Script endpointA Google Apps Script endpoint that appends each confirmed conversion to a Google Sheet.
  • Scheduled importThe sheet connected to Google Ads as a scheduled offline conversion import, so nobody uploads by hand.
  • Consent fieldsConsent fields (ad user data and ad personalisation) included in every row, as Google requires for UK and EEA users.

06Testing and validation

Checked the Google Ads upload results: 153 conversions uploaded, 153 successful, 0 errors.

Reviewed the conversion action settings, including a 90-day click-through window.

07Outcome

Delivered

  • GCLID captured with every lead
  • Automated sheet-based offline conversion import
  • Consent fields in every row

Verified

  • Google Ads upload report: 153 changes, 153 successful, 0 errors.

Not known / not published

  • Sales and campaign performance figures are client data and are not published.

08Technical stack

  • Google Ads
  • Google Tag Manager
  • Google Apps Script
  • Google Sheets

09Related services

10Go deeper

Jobair Mahmud
Jobair Mahmud

AI-driven Performance Marketing & Web Analytics Consultant · About me

Google Ads for Moving Companies: Negative Keyword Fortress & CallRail Tracking
Local Services United States & United Kingdom

Google Ads for Moving Companies: Negative Keyword Fortress & CallRail Tracking

Eliminated broad-match budget bleed, blocked DIY truck rental queries, and synced qualified phone calls to Smart Bidding for a regional residential and commercial mover.

Client
Regional residential and commercial moving company
Platform
Google Ads, CallRail, WordPress
  • Google Ads
  • Offline Conversions
  • GTM
Cross-domain GA4 and consent-aware conversion tracking for a European fintech company
Fintech Europe

Cross-domain GA4 and consent-aware conversion tracking for a European fintech company

One measurement setup across a Webflow marketing site and separate application subdomains, with form events, Google Ads and Reddit conversions, and Consent Mode tied to the consent platform.

Client
European fintech and crypto analytics company
Platform
Webflow, Stripe
  • GA4
  • GTM
  • Cross-Domain
  • Consent Mode
  • Google Ads

See all case studies or book a tracking consultation.

Let's Talk

Dealing with a similar problem?

Tell me what you're seeing in your reports. I'll reply with what I'd check first and whether I can help.

or reach me directly