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
Click ID (gclid). Single line text. Never a dropdown, never a number field. This is the link between the lead and the ad click.
Click ID type. Optional but useful: gclid, gbraid, wbraid or msclkid. Saves guesswork later.
Click timestamp. When the click happened, in UTC. Lets you tell at a glance whether a deal is still inside the conversion window.
Conversion time. When the stage change happened. This is what you upload, not the date you ran the export.
Deal value and currency. Real numbers. If the currency varies, store it explicitly.
Stage. The pipeline stage you upload from, for example Qualified, Booked, Closed Won.
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
Filter leads created in the last 30 days.
Count how many have a non empty click ID.
Divide by total leads from paid search. Anything under 80% needs attention.
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.























