Offline Conversions in Google Ads: Manual Upload, Google Sheets, Zapier, API and CRM Without Overcomplicating It

Short Answer

Offline conversions in Google Ads do not have to start as a big CRM project. You can begin with manual upload, Google Sheets, scheduled imports, Zapier, API or direct CRM integration. What matters is starting to send Google Ads at least something with more business value than an ordinary form submission: a qualified lead, meeting, order, deal won or lead value.

The worst option is doing nothing because "it will be difficult". The first version can be manual and uncomfortable. If it is accurate and consistent, it can be more useful for optimization than beautifully automated measurement of a poor form signal.

What You Need to Collect on the Website

Minimum data model: lead_id, lead submission time, GCLID/gbraid/wbraid, UTM, form source, email/phone according to legal rules, lead status, value or estimated value. For e-commerce or offline orders, add order_id, value, currency and payment status.

Without a click ID, imports through GCLID fall apart. Without lead_id, it is hard to match the form submission with the later business status. Without the event time, you cannot correctly interpret when the business action happened.

Five Import Paths

1. Manual file upload in Google Ads. The simplest start for low volumes. 2. Google Sheets with scheduled import. Practical and inexpensive if a developer or marketer prepares the right data format. 3. Zapier or similar automation. Paid, but fast without major development. 4. CRM integration. Good for companies that truly use a CRM in their sales process. 5. API / Data Manager. Best for robust operations and higher volumes.

The Google Sheets option is underrated. Someone on the team can add qualified leads to a sheet, Google Ads can import them on a schedule, and the company gets its first feedback loop for bidding without a month-long IT project.

Conversion Time: When It Is a Mistake and When It Is Not

Import time is not automatically wrong. It depends on which event you are importing. If you import "lead became qualified today at 10:00", then the conversion time is the qualification time. If you import the original form submission, then the conversion time is the form submission time. If you import a closed deal, the time is deal won or payment.

The mistake is mixing meanings. For example, sending a conversion named Qualified Lead but giving it the time of the original form submission when your business rule says qualification happened only after a call. Even worse is sending different statuses under the same conversion name.

What to Import First

Start with one clear status: Qualified Lead or Won Deal. Qualified Lead has the advantage of higher volume and shorter delay. Won Deal has higher business accuracy but lower volume and longer delay. For smaller accounts, it may be reasonable to send both statuses as two conversions, but manage bidding carefully.

If you have values, send them. In lead generation, the value can be an estimate based on close probability or service type. A consistent rough model is better than zero value for all leads.

Practical Spreadsheet Format

Starter columns: Conversion Name, Conversion Time, Conversion Value, Conversion Currency, Google Click ID, Order ID or Lead ID, and optionally GBRAID/WBRAID as needed. Internally, also keep the lead name, email, phone, salesperson and note, but send Google Ads only what is necessary and allowed.

Before automating, run 2-3 manual imports. You will verify the format, time zones, conversion names, data acceptance and whether the sales team can fill in lead status.

Audit Questions

Do we have GCLID for a sufficient share of leads? Do we have lead_id? Do we know when the lead was created and when it was qualified? How many imports does Google accept? Which campaigns generate quality leads? Does cost per form differ from cost per qualified lead? If yes, that is exactly why you need offline imports.

Offline conversions are not only a technical integration. They connect marketing and sales. When the sales team does not qualify leads consistently, the import will just become another bad signal.

FAQ

Frequently Asked Questions

Do I need CRM?

Is manual import embarrassing?

Should I import lead time or qualification time?