Google Ads Offline Conversion Tracking (OCT): Importing CRM Data (2026 Guide)

If you generate leads (B2B, Service, Real Estate), your Google Ads dashboard is lying to you. It says you got 100 leads at $50 CPA. It doesn't tell you that 90 of them were spam, 9 were broke, and only 1 bought. Smart Bidding sees 100 "successes." It will find more spam.

Offline Conversion Tracking (OCT) closes the loop. It tells Google: "Hey, ignore those 99. Find more people like the 1 guy who actually paid."

In this "Mega-Authority" guide, we cover:

1. The GCLID: The unique ID that powers everything.
2. The Setup: Capturing GCLID in forms.
3. The Import: Sending data back (Manual vs Automated).
4. The Optimization: Switching bidding to OCT.

Part 1: The GCLID (Google Click ID)

When a user clicks your ad, the URL looks like this: yourwebsite.com/?gclid=TeSt1234...

That gclid string is the fingerprint of the click. It contains the Keyword, Device, Time, and User signals. The Goal: You must grab this string and save it in your CRM next to the lead's email.

Part 2: Execution - Capturing the GCLID

Step 1: Create a Hidden Field In your form builder (Gravity Forms, HubSpot, Typeform):

1. Add a "Hidden Field".
2. Name the label GCLID.
3. Set the dynamic default value to pull query parameter gclid.

Step 2: Save to CRM Map that form field to a custom property in Salesforce/HubSpot called Google Click ID.

Step 3: Verification Submit a test lead with /?gclid=TEST appended to the URL. Check your CRM. Does it say "TEST"? If yes, you are ready.

Part 3: Execution - The Import

You have the data. Now Google needs it.

Method A: Manual Upload (The "Excel" Way)

1. Export "Closed Won" deals from CRM.
2. Format CSV: GCLID, Conversion Name, Conversion Time, Value.
3. Tools → Conversions → Uploads.

Method B: Zapier/Make (The "Automated" Way)

1. Trigger: "Deal Moves to Closed Won" (HubSpot).
2. Action: "Upload Offline Conversion" (Google Ads).
3. Map the GCLID field.

Method C: Native Integration Salesforce and HubSpot have one-click integrations. Enable them. They are more reliable than Zapier.

Part 4: The Bidding Switch

Once data is flowing, you need to change your optimization target.

1. Create Conversion Action: "Closed Won Deal" (Import Category).
2. Observation Phase: Let it run for 30 days. Don't bid on it yet. Just ensure data matches.
3. Value Setting: Assign dynamic values (actual revenue).
4. The Switch:
   • Change Campaign Settings -> Goals.
   • Remove "Lead Form" (or set to Secondary).
   • Add "Closed Won Deal" as Primary.
   • Switch Bidding to tROAS.

Warning: You need volume. If you only get 5 deals a month, tROAS will fail. You need roughly 15-30 conversions per month for the algorithm to work. If volume is low, optimize for a "Qualified Lead" stage instead (e.g., "Deal Stage: Proposal Sent").

Part 5: Summary & Checklist

OCT is the ultimate competitive advantage in B2B.

Your Action Plan:

1. Check your forms. Are you capturing GCLID?
2. Create the "Closed Won" conversion action today.
3. Connect your CRM via Native Integration or Zapier.
4. Wait 4 weeks for data population before switching bidding.

Bid on revenue, not registrations.

The Lead Quality Paradox

Without OCT, you're optimizing for the wrong thing — and making it worse.

Scenario: You generate 100 leads at $20 CPA. You're celebrating. But 95 of those leads are junk — students, competitors, people who filled the form for the free PDF.

What does Google do? It goes and finds 100 more people who look exactly like your form-fillers. Which means 95% junk again. You've trained the algorithm to be perfectly accurate at finding worthless leads.

OCT breaks this loop by telling Google which leads actually became revenue. Now the algorithm learns what a real customer looks like — not just a form-filler.

The GCLID Magic Key

Every time someone clicks your Google Ad, Google appends a ?gclid=AbCdEf123 parameter to the URL. This is the click ID — a unique fingerprint for that specific click.

The chain:

1. User clicks ad → lands on yoursite.com/contact?gclid=AbCdEf123
2. Hidden field on your form captures the GCLID automatically
3. GCLID passes into your CRM alongside Name + Email
4. 30 days later, deal closes → CRM triggers upload: GCLID + Conversion Name + Conversion Value + Timestamp
5. Google matches the GCLID back to the original click → attributes the revenue

The GCLID is the link between an ad click and a closed deal. Without capturing it, OCT cannot work.

Method C: The Zapier Route

For teams closing fewer than 100 deals per month, native CRM integrations are overkill. Use Zapier:

1. Trigger: New Deal in Pipedrive (or HubSpot/Salesforce) with Status = "Won"
2. Action: Google Ads → "Upload Offline Conversion"
3. Map: GCLID field → Conversion Name → Conversion Value (deal amount)

Setup time: 2 hours. No developer required. Gets expensive or unreliable above ~100 conversions/month — at that scale, switch to a direct API integration.

The Algorithm Learns Geography and Demographics

Once OCT is running for 4–6 weeks, something powerful happens: the algorithm begins to pattern-match on quality.

Example outcome: "Engineers in California who submitted forms on Thursday afternoons convert to closed deals at 8x the rate of Students in Florida who submitted on Monday mornings."

Google starts bidding higher for Thursday afternoon clicks from California-based engineers. You never told it to do this. It figured it out from the conversion value signals you sent back.

This is why tROAS for lead gen is the end goal of OCT — once you're feeding revenue data back, you can graduate from optimizing for lead volume (tCPA) to optimizing for revenue (tROAS). Set your target, and let the algorithm allocate budget toward your highest-value customer profiles.

One technical note: Change your click-through conversion window to 90 days for B2B campaigns. Most CRM deals close within 30 days — but enterprise B2B cycles are often 60–90 days. A 30-day window will drop OCT data for your most valuable deals.