Microsoft Advertising

Sign-in: Microsoft Advertising

Loads into the Ads data, next to the other connectors of this kind: in Explorer, on boards, for the AI analyst and over the API.

How to connect

On the Sources page, in the Accounts block, connect a Microsoft Advertising account.
In the project's source, choose what to load: the ad account.
Click Load data. After that the workspace schedule loads it every day.

Ad account ID — The number in the Microsoft Advertising address after aid= (not the alphanumeric account number)
Customer ID — The number in the address after cid=. If empty, it is found from the ad account ID

Conversions count goals marked “Include in conversions”, like the Conversions column in Microsoft Advertising
Daily statistics cover the last 36 months: that's how long Microsoft keeps them

Every connector of this kind loads into the same fields, so their numbers sit side by side in one query.

Day
Week — Monday of the week
Month — First day of the month
Source
Account
Campaign
Campaign ID
Currency
Impressions
Clicks — Link clicks for Meta
Spend — Excluding VAT, in the account currency
Conversions — As counted by the ad platform
Conversion value — As counted by the ad platform, in the account currency. TikTok, LinkedIn, Pinterest, VK Ads and X don't report it
CTR — Clicks / impressions
CPC — Spend / clicks
CPM — Spend / impressions × 1000
Cost per conversion — Spend / conversions
Conversion rate — Conversions / clicks
Platform ROAS — Conversion value / spend on the days that have it