The CRM Fields You Need Before Offline Tracking Works

Offline conversion tracking lives or dies on a handful of CRM fields. Here is the exact list, why each one matters, and how to add them without annoying your sales team.

Every failed offline conversion project I have seen started the same way: someone tried to build the upload before the CRM could hold the data.

Here is the field list I set up before anything else. It works in HubSpot, Salesforce, Pipedrive, Zoho or a spreadsheet.

The required fields

  1. Click ID (gclid). Single line text. Never a dropdown, never a number field. This is the link between the lead and the ad click.

  2. Click ID type. Optional but useful: gclid, gbraid, wbraid or msclkid. Saves guesswork later.

  3. Click timestamp. When the click happened, in UTC. Lets you tell at a glance whether a deal is still inside the conversion window.

  4. Conversion time. When the stage change happened. This is what you upload, not the date you ran the export.

  5. Deal value and currency. Real numbers. If the currency varies, store it explicitly.

  6. Stage. The pipeline stage you upload from, for example Qualified, Booked, Closed Won.

  7. Uploaded flag. A checkbox or timestamp so the same row never goes up twice.

The fields that make life easier later

  • UTM source, medium and campaign. Not needed for matching, but essential when someone asks which campaign produced the money. See capture UTM parameters in your CRM.

  • Landing page. Tells you which page actually converts, independent of the ad platform.

  • First touch and last touch click IDs. Separate fields, because overwriting the first one destroys long funnel attribution. See first touch and last touch fields.

  • Hashed email and phone. Your fallback when the click ID is missing, using Enhanced Conversions for Leads.

  • Lead source detail. A human readable label the sales team trusts, which keeps them honest about where leads came from.

How the data gets in

Hidden fields on the form, populated by script at submit time. The click ID is read from the URL or from a first party cookie you set on landing.

The pattern is the same everywhere: capture on arrival, store in a cookie, write into hidden fields on submit. Implementation in hidden UTM fields for any form and capture every click ID with one script.

Do not ask sales to paste anything. If a human has to copy a click ID, your data will be empty within a week.

Make the fields impossible to break

  • Set field types to text, not number. Long identifiers get mangled by numeric fields and spreadsheets.

  • Lock the fields as read only in the CRM interface so nobody tidies them.

  • Do not let automation clear them on stage change, which some workflow tools do by default.

  • Add a required note to your import mappings so bulk imports do not wipe them.

A five minute audit

  1. Filter leads created in the last 30 days.

  2. Count how many have a non empty click ID.

  3. Divide by total leads from paid search. Anything under 80% needs attention.

  4. Spot check three records: is the value stored as text, is the timestamp UTC, is the stage correct?

If you are using HubSpot specifically, the field setup and workflow are in HubSpot gclid capture and offline conversions.

Frequently asked questions

Do I need a separate field per platform?

Yes. Keep gclid, fbclid and msclkid in their own fields. Mixing them into one column causes silent upload failures.

What if my CRM has limited custom fields?

Prioritise click ID, conversion time, stage, value and uploaded flag. Everything else can live in a reporting layer.

Should I store the whole URL?

It helps for debugging, but parse the parts you need into their own fields. Nobody wants to regex a URL inside a scheduled export.

The short version

Seven fields do the work: click ID, click type, click time, conversion time, value, stage and an uploaded flag. Populate them automatically, lock them down, and audit the fill rate monthly.

Want this set up properly?

If your CRM is missing half of these, that is the first job, and it is usually quicker than people expect. I build and repair tracking for ecommerce stores and lead generation businesses, so the numbers in your reports match the money in your bank account.

Have a look at what I do, or book a call and we can go through your setup together.

Need accurate tracking?

Its Free

500+ Happy Clients ⭐️

Keep Reading

See exactly where you’re wasting ad spend and how better tracking can double your sales.

See exactly where you’re wasting ad spend and how better tracking can double your sales.

Tracking in 3 Hours

Tracking in 3 Hours

I Manage Everything

I Manage Everything

24/7 Expert Support

24/7 Expert Support

TESTIMONIALS

Trusted by 500+ satisfied clients

Discover how we’ve driven growth and innovation.

500+ Tracking

500+ Tracking

Adélaïde De Vos

3,922 followers

I had the pleasure to work with Abdul and I can say that he exceeded my expectations. He was professional, patient, and clear in his explanations and committed to client satisfaction. If you're looking for someone who is not only highly skilled but also reliable and committed to client satisfaction, I highly recommend Kayium!

Dean Watson

1,030 followers

Kayium setup our tracking for Google Ads and Meta Ads, which helped us get 20%+ more conversions on the same ad spend. He didn’t just handle the technical setup,he also took the time to explain why it works and how it improves results. If you’re looking for someone skilled, reliable, and committed to delivering real results, I highly recommend him!

David Friend

CEO: Profitable Sites

Kayium set up accurate tracking that helped us scale ads fast and boost conversions by over 25%. He gave us clear insight into which ads drive revenue.

Lalita Sundari

7,924 followers

I've worked with Kayium; his strategic mindset and expertise in GTM, GA4, Pixel & Server Side Tracking, are invaluable! I highly recommend Kayium!

© 2026 Abdul Kayium

Owned by Kayium

© 2026 Abdul Kayium

Owned by Kayium