Google Ads Offline Conversion Import: Send Real Sales Back to Google

Meta, Google & TikTok Ads Specialist · Upwork Verified Expert

Google Ads offline conversion import guide by Rubel Hasan Rokib

A form fill or a phone call is not a sale. Some leads buy, many do not. When Google Ads only sees leads, it optimizes for more leads, including poor ones. Offline conversion import fixes that by sending the real outcome, the sale, back to Google.

This guide explains Google Ads offline conversion import step by step, including a simple version that works with a spreadsheet.

Quick Answer

Offline conversion import lets you upload sales or qualified leads that happen outside your website, such as on the phone, in WhatsApp or in a showroom, back to Google Ads. You capture the Google click ID (GCLID) or customer details when the lead arrives, record what happened later, then upload the results by file, Google Sheets or a CRM integration so Smart Bidding learns from real revenue.

  • Capture the GCLID with every lead.
  • Record the outcome: sale, value and date.
  • Upload via file, Google Sheets or CRM.
  • Use hashed email or phone for better matching where supported.
  • Upload regularly, ideally daily or weekly.
Google Ads offline conversion import flow from click and lead to sale upload

How It Works

When someone clicks your ad, Google adds a click ID to the landing page URL. If you store it with the lead, you can later tell Google: “this click became a 25,000 taka sale”. Google then links that sale to the keyword and ad.

Step by Step

  1. Make sure auto-tagging is on in Google Ads.
  2. Add a hidden field to your forms that stores the GCLID from the URL.
  3. Save the GCLID with each lead in your CRM or Google Sheet.
  4. In Google Ads, create a conversion action of the type Import.
  5. When a lead becomes a sale, record the GCLID, conversion name, time and value.
  6. Upload the data by file or a scheduled Google Sheet.
ColumnExample
Google Click IDCj0KCQ…
Conversion NameOffline Sale
Conversion Time2026-11-03 14:30:00+06:00
Conversion Value25000
CurrencyBDT

WhatsApp and Phone Leads

For WhatsApp or calls, capture the GCLID on the page and pass it into the WhatsApp message or CRM where possible. Even uploading a portion of real sales helps Google learn. See my WhatsApp click tracking and call tracking guides.

Tips

  • Upload within the allowed time window after the click.
  • Use consistent time zones.
  • Start with a simple sheet before building a full CRM integration.
  • Combine with Enhanced Conversions for better matching.

Offline Conversion Import FAQ

What is offline conversion import in Google Ads?

It is a way to upload sales or qualified leads that happen outside your website back to Google Ads so it can optimize for real outcomes.

What is a GCLID?

The Google Click ID is a unique value added to your landing page URL when someone clicks an ad. It links later sales back to that click.

Can I upload offline conversions from Google Sheets?

Yes. Google Ads supports scheduled uploads from Google Sheets.

Do I need a CRM?

No. A well-kept spreadsheet works for many small businesses.

How often should I upload offline conversions?

Daily or weekly is ideal so Smart Bidding gets fresh data.

Final Thoughts on Google Ads Offline Conversion Import

If you need help with Google Ads Offline Conversion Import, message me on WhatsApp and I will point you in the right direction.

Offline conversion import is one of the most powerful and least used features in Google Ads. Capture the click ID, record real sales and upload them regularly. Your campaigns will start optimizing for revenue instead of form fills.

Official Resources

Need help with offline conversion import?

I am Rubel Hasan Rokib, a data-driven digital marketer based in Bangladesh. Send me your website or ad account details on WhatsApp and I will reply with a clear plan.

Get a Free Ads & Tracking Audit

Send me your website and tell me what you need. I will check your ads setup, Pixel, Conversion API and GA4 tracking, and reply with clear next steps. No obligation.

Picture of Rubel Hasan Rokib

Rubel Hasan Rokib

Data-driven digital marketer and tracking expert from Bangladesh with 5+ years of agency experience. I help brands grow with Meta Ads, Google Ads, TikTok Ads, GA4, Conversion API and server-side tracking. Upwork Verified Expert with 100% Job Success.

Join the Discussion

Have a question about this guide or your own setup? Leave a comment below. I read and reply to every comment.

Leave a Reply

Your email address will not be published. Required fields are marked *

Keep Reading

More Articles You Might Like