Microsoft Advertising connector: datasets and metric definitionsBeta
Bring in Microsoft (Bing) campaign, ad group and ad performance. Updates daily.
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
| Dataset | What it holds |
|---|---|
| [Microsoft Ads] Campaign performance | Microsoft 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 performance | Ad group performance11 columnsdate, campaign_id, campaign_name, ad_group_id, ad_group_name, impressions, clicks, cost, conversions, conversion_value, currency |
| [Microsoft Ads] Ad performance | Ad performance12 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
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Microsoft Ads spend | Sum of cost | date | Microsoft Ads spend in the ad account currency, by day. |
| Microsoft Ads impressions | Sum of impressions | date | Times Microsoft Ads showed an ad. |
| Microsoft Ads clicks | Sum of clicks | date | Clicks on Microsoft Ads ads. |
| Microsoft Ads conversions | Sum of conversions | date | Conversions as Microsoft Ads counts them (the account's attribution and conversion events). |
| Microsoft Ads conversion value | Sum of conversion_value | date | Value of Microsoft Ads conversions in the account currency. |
| Microsoft Ads ROAS | Microsoft Ads conversion value ÷ Microsoft Ads spend | date | Conversion value per unit of spend (2.5 = 2.50 back for 1.00 spent). |
| Microsoft Ads CPC | Microsoft Ads spend ÷ Microsoft Ads clicks | date | Average cost per click. |
| Microsoft Ads CTR | Microsoft Ads clicks ÷ Microsoft Ads impressions | date | Clicks per impression, as a decimal (0.01 = 1%). |
| Microsoft Ads CPA | Microsoft Ads spend ÷ Microsoft Ads conversions | date | Average 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.
| Metric | How it is calculated | Needs | Notes |
|---|---|---|---|
| Microsoft Ads nCAC | Microsoft Ads spend ÷ New customers | Shopify + Microsoft Advertising | Microsoft Ads spend per new customer: Microsoft Ads spend divided by New customers in the same period. |
| Microsoft Ads aMER | New customer net sales ÷ Microsoft Ads spend | Shopify + Microsoft Advertising | First-order net sales per Microsoft Ads dollar: New customer net sales divided by Microsoft Ads spend in the same period. |
- Shopify + Microsoft Advertising: New-customer cost and return on Microsoft. Microsoft Ads nCAC and aMER, the same pair for Microsoft Advertising spend.
Questions to ask
- How much did we spend on Microsoft Ads each month this year?
- Which Microsoft Ads campaigns had the best ROAS last month?
- Which Microsoft Ads ad groups had the lowest cost per conversion in the last 30 days?
- Which Microsoft Ads ads spent the most in the last 30 days?
Related guides
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?
How often does the Microsoft Advertising data refresh?
Can I change how a metric is calculated?
Can I combine Microsoft Advertising with other sources?
All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.