Skip to main content
Square Online → Microsoft AdsIntegration guide

Connecting Square Online to Microsoft Ads

Square Online orders settle into the same Square account as the card taken at the counter, which is a genuine advantage: the online and in-person halves of the business are already denominated in one ledger. Microsoft Ads reaches an older, higher-income, more desktop-weighted audience than Google, and it is routinely the cheapest qualified traffic a B2B advertiser can buy. The join between them succeeds or fails on one thing: whether the MSCLKID reaches the Square Online order before the conversion happens, because Microsoft Ads can only match a conversion it can tie back to a click it recognizes.

Free30 minutesNo obligation

Specific to this pair

Square Online to Microsoft Ads: MSCLKID survives only on your domain

The MSCLKID survives only on a domain you control, so connect a custom domain and check whether Square Online allows the UET tag. Square orders lack an obvious click-ID field, so upload online-channel orders matched on hashed email and phone, valued net of tips and tax, and confirm your offline goal accepts enhanced conversion data.

Local search for pickup, delivery and small retail is where Microsoft Ads sends Square Online traffic. The first question is the domain. If the shop runs on a Square-provided domain, your ads land somewhere you cannot run server-side capture, and the MSCLKID lives only in whatever Square's pages keep. Connect a custom domain, then check whether Square Online lets you add the UET tag and whether its checkout leaves your domain.

Square orders do not obviously carry a field your storefront can write a click ID into, so check before planning around one. The fallback is hashed email and phone: Square Online collects both on most orders, especially pickup orders where the phone is used for ready texts. Confirm your Microsoft offline conversion goal accepts enhanced conversion data, then upload online orders matched on those.

Filter twice before uploading. First by sales channel, so counter sales never reach Microsoft. Then by value: send the total net of tips and tax, because Square's order total includes both and tips on food orders are substantial. Refunds show up in Square as separate records; check whether your Microsoft account supports conversion adjustments before deciding whether to retract or simply report refunds outside the platform.

Square Online → Microsoft Ads · what breaks

Why this join usually fails — Square Online → Microsoft Ads

  1. 01

    The MSCLKID never reaches Square Online

    Square Online sites are frequently on a Square-provided domain, and checkout may hand off to Square-hosted payment pages depending on configuration.

  2. 02

    Counter sales counted as online conversions

    The convenience of one ledger is also the trap. If the sales channel is not filtered, every card swipe at the register lands in your ad reporting as a conversion you paid for.

  3. 03

    Auto-tagging switched off

    Microsoft auto-tagging is frequently disabled in accounts that were set up quickly or imported from Google, and without it no MSCLKID arrives at all — so the entire offline import has nothing to match against and fails silently.

  4. 04

    Nothing reconciles afterwards

    Microsoft Ads reports offline conversion uploads with rows accepted and rejected. A successful upload is not a matched conversion — check that conversions actually appear against campaigns afterwards.

Square Online → Microsoft Ads · the fix

What working looks like — Square Online → Microsoft Ads

  • The MSCLKID on every order

  • Conversions arriving in Microsoft Ads

    Conversions appear against the campaign, ad group and keyword that produced the click, with the value you sent, and become usable for automated bidding.

  • Reconciled against the source

Square Online → Microsoft Ads · architecture

How Square Online and Microsoft Ads actually connect

  1. 1

    Square Online holds the truth

    The filter is the whole job. Square's default reporting cheerfully sums counter sales and online orders, and that total is not something any ad platform should be optimizing toward.

  2. 2

    Microsoft Ads needs a click to match

    Microsoft matches uploaded conversions to clicks using the MSCLKID, and the conversion goal must be created as an offline conversion type. The click has to fall inside Microsoft's import window — verify the current limit in your account rather than assuming it matches Google's.

  3. 3

    The identifier is the bridge

    The MSCLKID, captured at the visit and carried into the Square Online order.

  4. 4

    The event source decides reliability

    Send net of tips and taxes. Tips on food orders are substantial and are not your revenue.

  5. 5

    Deduplication at the destination

    Microsoft deduplicates on the combination of click identifier, conversion name and conversion time. Uploading the same click against a second conversion goal counts twice, which is the usual cause of inflated numbers here.

Square Online → Microsoft Ads · normal or broken

Working vs. broken, side by side — Square Online → Microsoft Ads

Normal, not a fault

  • The MSCLKID present on the order

  • Sent from the Square transaction record

  • Deduplicated correctly

    Microsoft deduplicates on the combination of click identifier, conversion name and conversion time. Uploading the same click against a second conversion goal counts twice, which is the usual cause of inflated numbers here.

  • Reconciles with the source

Actually broken

  • The MSCLKID missing on most records

    Square Online sites are frequently on a Square-provided domain, and checkout may hand off to Square-hosted payment pages depending on configuration.

  • Sent from the browser

    The convenience of one ledger is also the trap. If the sales channel is not filtered, every card swipe at the register lands in your ad reporting as a conversion you paid for.

  • Counted twice, or not at all

    Microsoft auto-tagging is frequently disabled in accounts that were set up quickly or imported from Google, and without it no MSCLKID arrives at all — so the entire offline import has nothing to match against and fails silently.

  • Nobody has reconciled it

Square Online → Microsoft Ads · diagnose

Diagnostic order — Square Online → Microsoft Ads

  1. 01

    Count orders carrying the MSCLKID

  2. 02

    Follow one real conversion end to end

  3. 03

    Filter by sales channel and re-check the total

    Compare the filtered online total against Square Online's own order count. If they disagree, the filter is wrong before the tracking is.

  4. 04

    Confirm auto-tagging is enabled and check the upload diagnostics

    One account setting decides whether any of this works. Then read the per-row errors on the upload rather than the success count.

  5. 05

    Read the match rate, not the success message

    Microsoft Ads reports offline conversion uploads with rows accepted and rejected. A successful upload is not a matched conversion — check that conversions actually appear against campaigns afterwards.

Square Online → Microsoft Ads · prove

How it gets proven — Square Online → Microsoft Ads

Source of truth

Square transactions filtered to the online sales channel, by location.

  • The MSCLKID confirmed present on a live order.
  • Auto-tagging confirmed on, and the accepted count reconciled against conversions appearing in campaign reporting.
  • Online-channel transactions reconciled against imported conversions for a settled week.

Square Online → Microsoft Ads · free audit

What we check in the free audit

  • Count orders carrying the MSCLKID
  • Follow one real conversion end to end
  • Filter by sales channel and re-check the total
  • Confirm auto-tagging is enabled and check the upload diagnostics
  • Read the match rate, not the success message

Checked against

Square transactions filtered to the online sales channel, by location.

Get my free conversion tracking audit

Free30 minutesNo obligation

Square Online → Microsoft Ads · when not to buy

When you don't need this — Square Online → Microsoft Ads

  • Measure identifier coverage yourself first — pull your last hundred orders and count how many carry the MSCLKID.
  • If Square Online is a small side channel next to your counter business, measure it on order count and do not build an import for it.
  • If you are not running Microsoft Ads at meaningful spend, skip it — though for B2B the traffic is often cheaper and better qualified than people expect, which is worth testing before dismissing.

Square Online → Microsoft Ads · what we deliver

What gets built — Square Online → Microsoft Ads

  • Identifier capture into Square Online

    Persist the identifier in first-party storage on your own domain before the handoff, and reattach it to the order at the point the transaction is written.

  • Event source: the Square transaction record

    Send net of tips and taxes. Tips on food orders are substantial and are not your revenue.

  • Dispatch to Microsoft Ads

    Offline conversion import through the Microsoft Advertising API or a scheduled upload.

  • Reversals where they exist

    Refunds appear in Square as their own records and should be sent as reversals.

Written guarantee

95%+ tracking accuracy

Measured against Square transactions filtered to the online sales channel, by location.. Miss it and we keep working at no cost.

Get my free conversion tracking audit

From $400 · See packages

FAQ

Square Online → Microsoft Ads questions, answered

Yes. Use a custom domain where UET runs, and upload online orders to an offline conversion goal, matched on MSCLKID where you have it and hashed email or phone otherwise.

Free · 30 min

Get Square Online and Microsoft Ads joined properly

Free30 minutesNo obligation