How to reconcile Microsoft Ads against your booking or reservation system
This is the check we run first on every account, written out so you can run it without us. It takes about thirty minutes and needs two numbers: what Microsoft says it produced, and what your booking or reservation system actually shows. The gap between them is the only honest measure of whether your tracking works — and if it comes back small, you do not need us.
Free30 minutesNo obligation
Specific to Microsoft × Booking System
Microsoft Ads vs your booking system: UET on the booking engine
Reconcile Microsoft Advertising against direct bookings by storing msclkid on the reservation and matching it in an offline import, checking Microsoft's current import window directly. Bookings from Bing tend to come from desktop searches by older travelers, so totals are small and stable. Expect a close match; a near-zero count usually means UET is missing from the booking engine.
The join key is msclkid, appended only when auto-tagging is switched on in the Microsoft account. Many advertisers imported their Google campaigns and never checked it, and many hotels have the UET tag on their marketing site but not on the hosted booking engine where the reservation completes. If either is missing, the PMS record has no identifier and Microsoft only sees bookings through whatever tag happens to fire.
Microsoft's conversion goals count on their own settings, much as Google's do, so a goal set to count every conversion will double a guest who books two rooms in separate transactions. Check whether your reporting dates conversions by click or by conversion, and compare against bookings by booking date rather than arrival date. Pull the conversion report filtered to the booking goal, and check Microsoft's offline import window before uploading completed stays.
Because Bing search volume for a property name is modest, Microsoft's booking count should sit close to your direct-channel figure for branded campaigns. A large surplus usually means the goal is also firing on OTA confirmation pages, or a duplicate goal was imported from Google. The most common reason for disagreement is the booking engine missing UET entirely.
Microsoft × Booking System · what breaks
Why Microsoft and your booking or reservation system disagree
- 01
OTA and marketplace bookings pooled with direct
The defining error. A good month on Booking.com or a marketplace reads as advertising success, and none of it was bought with media.
- 02
Nightly rate or per-person price used as the value
A four-night stay is four times a one-night stay. Reporting the rate makes the long bookings you most want look identical to the short ones.
- 03
Cancellations never reversed
Long lead times mean meaningful cancellation rates, especially on flexible rates.
- 04
Booking counted instead of the delivered stay
A booking made in January for July is six months from being revenue and some of it will not happen.
Microsoft × Booking System · the fix
What you get from this — Microsoft × Booking System
A number instead of a suspicion
The likely cause, narrowed
A basis for deciding
Microsoft × Booking System · architecture
What each side is actually counting — Microsoft × Booking System
- 1
What Microsoft counts
msclkid inside the import window, a conversion goal name matching one in the account, a timestamp and a value.
- 2
How Microsoft attributes it
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.
- 3
The window it uses
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.
- 4
What your booking or reservation system counts
Bookings that were actually delivered, at total value, found in Your PMS, booking engine or reservation system, filtered by channel.
- 5
The filter that makes them comparable
Direct channel only — exclude ota, marketplace and channel-manager bookings.
Microsoft × Booking System · events
Reading the gap — Microsoft × Booking System
| What you see | What it usually means |
|---|---|
| 15%+ platform higher | Usually the wrong event entirely — the platform is counting marketplace bookings, cancelled bookings, or bookings that have not yet been delivered. |
| 20%+ platform lower | Usually structural — the platform is missing direct bookings — usually the identifier lost at the handoff to a hosted booking engine. |
Microsoft × Booking System · diagnose
Diagnostic order — Microsoft × Booking System
- 01
Confirm both numbers cover the same period and channel
- 02
OTA and marketplace bookings pooled with direct
The defining error. A good month on Booking.com or a marketplace reads as advertising success, and none of it was bought with media.
- 03
Nightly rate or per-person price used as the value
A four-night stay is four times a one-night stay. Reporting the rate makes the long bookings you most want look identical to the short ones.
- 04
Cancellations never reversed
Long lead times mean meaningful cancellation rates, especially on flexible rates.
- 05
Read the upload's match rate and Microsoft's conversion goal diagnostics
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.
Microsoft × Booking System · prove
How to know you did it right — Microsoft × Booking System
Source of truth
your booking or reservation system — completed stays or bookings for a fully closed month
Microsoft × Booking System · free audit
What we check in the free audit
- Confirm both numbers cover the same period and channel
- OTA and marketplace bookings pooled with direct
- Nightly rate or per-person price used as the value
- Cancellations never reversed
- Read the upload's match rate and Microsoft's conversion goal diagnostics
Checked against
your booking or reservation system — completed stays or bookings for a fully closed month
Free30 minutesNo obligation
Microsoft × Booking System · when not to buy
When the answer is that you do not need us — Microsoft × Booking System
- If almost all of your completed stays or bookings come from a channel with no click behind it, no tracking work will reach them — and knowing that is worth more than a build.
- 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.
Microsoft × Booking System · what we deliver
The method, step by step — Microsoft × Booking System
Pull what Microsoft reports
The upload's match rate and microsoft's conversion goal diagnostics.
Pull what your booking or reservation system shows
Export bookings by service or arrival date for a fully closed period, filtered to the direct channel, at total booking value rather than a nightly or per-person rate.
Filter both to the same thing
Direct channel only — exclude ota, marketplace and channel-manager bookings.
Compare per record, not on totals
FAQ
Microsoft × Booking System questions, answered
Yes, a guest can click both before booking, and each platform claims the reservation. Reconcile each against the PMS separately rather than adding them together.
Check that auto-tagging is on and that UET loads on the booking engine's confirmation page. A tag on the marketing site alone never sees the reservation complete.
Because you should know the size of the problem before anyone quotes you for it. If the gap is small, you have saved yourself a purchase. If it is large, you now know what you are buying rather than taking our word for it.
No. Both numbers come from systems you already own and neither leaves them. There is no tool to sign up for and nothing to upload.
Then compare totals for a closed period and treat the result as directional rather than exact. The upload's match rate and microsoft's conversion goal diagnostics is still the right place to read the platform's side.
Under five percent is working. Five to fifteen usually means reversals are missing. Above twenty is normally the wrong event being counted, not a broken tag — which is why debugging tags first wastes so much time.
Then fix the filter before drawing any conclusion. Direct channel only — exclude ota, marketplace and channel-manager bookings. A mismatch in scope produces a gap that looks like a tracking fault and is not one.
Book the free thirty-minute call and bring both numbers. We will tell you which of the causes above it is, and whether it is something you can fix yourself — which it sometimes is.
More on Microsoft × Booking System
- Google Ads × Booking SystemHow to reconcile Google Ads against your booking or reservation system
- Meta × Booking SystemHow to reconcile Meta Ads against your booking or reservation system
- TikTok × Booking SystemHow to reconcile TikTok Ads against your booking or reservation system
RELATED GUIDES
Systems of record beside booking system, and the funnels it settles
- Microsoft × Enrolment SystemHow to reconcile Microsoft Ads against your application or enrolment system
- Microsoft × Job SystemHow to reconcile Microsoft Ads against your job management system
- Microsoft · Auto repairMicrosoft Ads conversion tracking for auto repair and collision shops
- Microsoft · Car rentalMicrosoft Ads conversion tracking for car rental companies
- Cobot → Microsoft AdsConnecting Cobot to Microsoft Ads
- andcards → Microsoft AdsConnecting andcards to Microsoft Ads
- Microsoft × Invoicing SystemHow to reconcile Microsoft Ads against your invoicing system
- Microsoft × POS SystemHow to reconcile Microsoft Ads against your point-of-sale system
Free · 30 min
Found a gap between Microsoft and your booking or reservation system?
WhatsAppFree30 minutesNo obligation
