Home / Connectors / Microsoft Advertising
Connector

Microsoft Advertising connector: datasets and metric definitionsBeta

Bring in Microsoft (Bing) campaign, ad group and ad performance. Updates daily.

3 datasets9 metric definitionsRead-onlyRefreshes daily2 cross-source metrics

When you connect Microsoft Advertising, Quiriz imports the datasets below and adds the metric definitions to Company Context, the one place your company’s definitions live. Every answer that uses one of these metrics uses the same definition, in the app, in Slack and in the Excel, Sheets, PowerPoint, Slides, Word and Docs add-ins. An admin can edit any of them.

DatasetsMetric definitionsWorks withQuestionsFAQ

Datasets

DatasetWhat it holds
[Microsoft Ads] Campaign performanceMicrosoft Advertising campaign totals per day (Search, Shopping and Audience campaigns). conversions and conversion_value use the conversion goals set up in Microsoft Advertising.
11 columnsdate, campaign_id, campaign_name, platform, account_name, impressions, clicks, cost, conversions, conversion_value, currency
[Microsoft Ads] Ad group performanceAd group performance
11 columnsdate, campaign_id, campaign_name, ad_group_id, ad_group_name, impressions, clicks, cost, conversions, conversion_value, currency
[Microsoft Ads] Ad performanceAd performance
12 columnsdate, campaign_id, campaign_name, ad_group_name, ad_id, ad_name, impressions, clicks, cost, conversions, conversion_value, currency

Metric definitions

Each metric is a total over the period you ask about. A metric built from other metrics, such as a rate, divides the totals for the whole period; it does not average daily rates. Dated by is the date column that decides which period a row belongs to.

[Microsoft Ads] Campaign performance

MetricHow it is calculatedDated byNotes
Microsoft Ads spendSum of costdateMicrosoft Ads spend in the ad account currency, by day.
Microsoft Ads impressionsSum of impressionsdateTimes Microsoft Ads showed an ad.
Microsoft Ads clicksSum of clicksdateClicks on Microsoft Ads ads.
Microsoft Ads conversionsSum of conversionsdateConversions as Microsoft Ads counts them (the account's attribution and conversion events).
Microsoft Ads conversion valueSum of conversion_valuedateValue of Microsoft Ads conversions in the account currency.
Microsoft Ads ROASMicrosoft Ads conversion value ÷ Microsoft Ads spenddateConversion value per unit of spend (2.5 = 2.50 back for 1.00 spent).
Microsoft Ads CPCMicrosoft Ads spend ÷ Microsoft Ads clicksdateAverage cost per click.
Microsoft Ads CTRMicrosoft Ads clicks ÷ Microsoft Ads impressionsdateClicks per impression, as a decimal (0.01 = 1%).
Microsoft Ads CPAMicrosoft Ads spend ÷ Microsoft Ads conversionsdateAverage cost per conversion.

Works with other connectors

These metrics are added automatically when Microsoft Advertising and the other connector are both connected. The rules they follow are on the connectors page.

MetricHow it is calculatedNeedsNotes
Microsoft Ads nCACMicrosoft Ads spend ÷ New customersShopify + Microsoft AdvertisingMicrosoft Ads spend per new customer: Microsoft Ads spend divided by New customers in the same period.
Microsoft Ads aMERNew customer net sales ÷ Microsoft Ads spendShopify + Microsoft AdvertisingFirst-order net sales per Microsoft Ads dollar: New customer net sales divided by Microsoft Ads spend in the same period.

Questions to ask

Ask Microsoft Advertising in plain words

Try the questions on sample data with no signup, then connect Microsoft Advertising read-only and ask your own.

Try Quiriz free →

Frequently asked questions

Does Quiriz change anything in Microsoft Advertising?
No. The Microsoft Advertising connector is read-only. Quiriz reads the data into datasets and never writes back to Microsoft Advertising.
How often does the Microsoft Advertising data refresh?
Once a day. Each dataset shows when it was last updated, and answers use the latest refresh.
Can I change how a metric is calculated?
Yes. The definitions are added to Company Context, where an admin can edit the formula, the filter or the date it uses. A daily refresh never overwrites a definition someone has changed.
Can I combine Microsoft Advertising with other sources?
Yes. 2 cross-source metrics are added automatically when the other connector is there too. An admin can also define a metric from metrics on different datasets. See cross-source metrics.

All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.