Offline conversion imports and MSCLKID
Offline conversion imports close the loop between ad clicks and offline revenue. Here is how to capture MSCLKID and upload CRM milestone data.
Why offline conversion tracking is essential for B2B#
In B2B lead generation, high-ticket services, and complex sales cycles, the actual transaction occurs weeks or months after the initial website inquiry inside a CRM like Salesforce or HubSpot.
Offline conversion imports bridge this gap by feeding closed-won deal data back into Microsoft Advertising, allowing automated Smart Bidding to optimize for real revenue as detailed in Microsoft Offline Conversion Guide, 2026.
Capturing and storing the MSCLKID parameter#
When Auto-tagging is enabled, Microsoft Advertising appends a unique click identifier (msclkid) to all landing page URLs. Your website forms must capture this value in a hidden field and write it to your CRM contact record.
Never hash or truncate MSCLKID; the exact alphanumeric string must be returned unchanged during upload.
Formatting offline conversion upload files#
Upload files must contain five mandatory columns: Microsoft Click ID, Conversion Name, Conversion Time (with UTC timezone offset), Conversion Value, and Currency Code as specified in Microsoft Campaign Management Offline API, 2026.
Automating CRM sync via REST API or Zapier#
Schedule automated daily uploads using Microsoft Advertising's REST API or integration middleware like Zapier or Make to ensure bid strategies receive fresh conversion feedback continuously.
Consult our Microsoft Ads Hub for offline upload templates and field schemas.
The offline conversion data pipeline#
The sequence below details the five stages of an end-to-end offline conversion tracking pipeline.
| Pipeline Stage | Operational Action | Key System Involved |
|---|---|---|
| 1. Ad Click | Auto-tagging appends ?msclkid=XYZ to URL | Microsoft Advertising Engine |
| 2. Form Capture | JavaScript reads parameter into hidden form field | Website Landing Page |
| 3. CRM Record | Contact created with stored MSCLKID field | HubSpot / Salesforce CRM |
| 4. Deal Won | Deal marked Closed-Won with verified revenue | Sales Pipeline / Billing |
| 5. Upload Sync | MSCLKID + Timestamp + Value uploaded to API | Microsoft Offline Goal API |
Frequently asked questions#
What is MSCLKID in Microsoft Ads?
MSCLKID is the Microsoft Click ID, a unique tracking parameter automatically attached to ad landing page URLs to identify individual ad clicks.
How long does MSCLKID remain valid for offline conversion upload?
Microsoft Advertising supports offline conversion uploads for clicks occurring up to 90 days in the past.
How frequently should offline conversions be uploaded?
Offline conversions should be uploaded at least weekly, with daily or real-time automated API uploads recommended for active Smart Bidding campaigns.
Can I upload multiple milestone stages for a single lead?
Yes, you can upload separate conversion goals (e.g., 'MQL', 'SQL', 'Closed Won') tied to the same MSCLKID at different timestamps.
What happens if an MSCLKID does not match any ad click?
The upload error report will flag the row as 'Click ID Not Found'; unmatched rows are skipped without affecting valid conversions in the batch.
Read more on this topic#
The Microsoft Ads Hub
Free tools, campaign guides and live news for every Microsoft Ads format.
Open the hubHow Microsoft Ads conversion tracking and the UET tag work
How the UET tag records visits, how conversion goals decide what counts, and how to test the whole chain before trusting the numbers.
Read the entryMicrosoft Advertising attribution models and conversion windows
A practical guide to Microsoft Advertising attribution models, conversion window settings, and cross-channel credit distribution.
Read the entryConversion lag and how to read recent Microsoft Ads data
A technical guide to understanding conversion lag, click-date backfilling, and evaluating recent performance on Microsoft Ads.
Read the entryReady to feed closed sales revenue back into Microsoft Ads?
folkfox configures closed-loop offline conversion pipelines and automated CRM integrations on Microsoft Advertising.