How to track online research to in-store purchase for Microsoft Ads

Architecture

The exact event sequence

Five stages. The break is a physical one. No click identifier survives a walk into a shop, so the entire funnel depends on a bridge — an appointment, a reservation, a loyalty account or an email given at the till — and the honest deliverable includes the share of revenue that has no bridge at all. The identifier has to survive all of them.

1. Step 1

   Online research

   Product views and store locator use. The intent signal.

2. Step 2

   Appointment booked or reservation made

   The practical bridge. It captures an identity and a click identifier.

3. Step 3

   Store visit

   Modeled by ad platforms rather than measured. Treat it as directional.

4. Step 4

   In-store transaction

   The money event, from the point of sale.

5. Step 5

   Join to an online identity

   Through the appointment, a loyalty ID or an email captured at the counter.

Diagnostic sequence

What's specific to Microsoft Ads

The funnel logic above is the same wherever you advertise. These are the parts that change because it's Microsoft Ads.

1. 1

   Click identifier: msclkid

   Microsoft's click identifier, appended when auto-tagging is enabled. It depends on the UET tag being present on the site — without UET, msclkid arrives in the URL and there's nothing consuming it, which is a common half-configured state on accounts imported from Google.

2. 2

   Import mechanism: offline conversion import

   Uploaded against msclkid, closely mirroring Google's approach. Because so many Microsoft accounts are imported wholesale from Google Ads, people assume full parity — verify the current column format and requirements in Microsoft's documentation rather than reusing your Google template unchanged.

3. 3

   Deduplication

   The same counting question applies: one conversion per click for lead-type goals, every conversion for ecommerce. Accounts imported from Google frequently carry over the goal structure and not the counting review, so it's worth reading every goal rather than assuming the import got it right.

4. 4

   Window and timing

   Check Microsoft's current offline import window and attribution settings directly. They resemble Google's closely enough to be assumed and differ enough to matter.

5. 5

   The Microsoft gotcha

   Almost every Microsoft account we open was imported from Google Ads, and the import copies campaign structure without copying the tracking. The result is a live account spending money with UET missing, msclkid unconsumed, or conversion goals pointing at pages that don't exist on the site any more.

Source-of-truth validation

How to prove the chain works

One real journey, followed all the way, then a reconciliation. Neither on its own is enough.

• A live Microsoft ad clicked, and the identifier confirmed present on the landing URL.
• The same identifier confirmed on the point-of-sale transaction, joined to an online identity where one exists after a full real journey through every step.
• Join to an online identity confirmed arriving at Microsoft Ads, verified by the upload's match rate and Microsoft's conversion goal diagnostics.
• Your point-of-sale transactions by date, with the share joined to an online identity stated as a number reconciled against Microsoft Ads per record over a fully closed window.
• The same reconciliation repeated 30 days later.

Straight talk

When this doesn't apply to you

Worth checking before you build anything, because two of these are common and both mean the work isn't worth doing.

• If you have no appointments, no loyalty scheme and no identity capture at the counter, there is no bridge to build. That is a real finding and it should be said before anyone is billed for a project.
• If your Microsoft account is a straight import you've never separately configured, fix the account structure and UET installation first — offline import on top of an unconfigured account produces data nobody will trust.
• If your cycle from click to join to an online identity regularly exceeds the import window, the final event can't drive bidding whatever you build. Optimize toward appointments and reservations, valued at your own average in-store transaction instead and use the later data for budget decisions rather than for bidding.
• If almost none of your transaction records carry a click identifier today, that's the whole project. Fix capture first — the import is the easy half and no tooling rescues a record with nothing to reference.