Note:
- Make sure you select Microsoft Ads only in the BigQuery Query builder or in the Klipfolio data source builder.
- When you want to see all the available Microsoft Ads metrics (and dimensions) in your Data Studio report or template, make sure you use the Cervinodata Microsoft Ads connector.
List of available Microsoft Ads metrics (and dimensions) for Data Studio (and other destinations)
These are all the Microsoft Ads metrics available through Cervinodata for Data Studio, Klipfolio, Google BigQuery and in Cervinodata's API clients.
Cross-platform metrics
The metrics below are Microsoft Ads specific metrics (and dimensions) on top of the Cross-platform blended metrics (see the cross-platform metrics here).
Microsoft Ads (specific) metrics (and dimensions)
From the available metrics and dimensions (see for a complete list of available metrics and dimensions from the Microsoft Advertising platform: https://learn.microsoft.com/en-us/advertising/reporting-service/campaignperformancereportcolumn?view=bingads-13) the following metrics and dimensions are collected by Cervinodata and are available via Cervinodata:
- Report date (TimePeriod)
- Organisation UUID
- Organisation Name
- Account ID
- Account Name
- Campaign ID
- Campaign Name
- Netwerk Type (AdDistribution)
- Device Type (DeviceType)
- Impressions
- Clicks
- Conversions
- Media Cost (amount in micros) (Spend divided by a million)
- Media Cost (Spend)
- CPC
- Cost / Conversion
- CTR
- Conversion Rate
- CPM
- Average Position
- Absolute Top Impression Rate Percent
- Absolute Top Impression Share Lost To Budget Percent
- Absolute Top Impression Share Lost To Rank Percent
- Absolute Top Impression Share Percent
- Ad Relevance
- All Conversions
- Revenue
- All Revenue
- Assists
- Audience Impression Lost To Budget Percent
- Audience Impression Lost To Rank Percent
- Audience Impression Share Percent
- Click Share Percent
- Exact Match Impression Share Percent
- Expected Ctr
- Historical Ad Relevance
- Historical Expected Ctr
- Historical Landing Page Experience
- Historical Quality Score
- Impression Lost To Budget Percent
- Impression Lost To Rank Agg Percent
- Impression Share Percent
- Landing Page Experience
- Low Quality Clicks
- Low Quality Conversions
- Low Quality General Clicks
- Low Quality Impressions
- Low Quality Sophisticated Clicks
- Phone Calls
- Phone Impressions
- Quality Score
- Top ImpressionRatePercent
- Top Impression Share Lost To Budget Percent
- Top Impression Share Lost To Rank Percent
- Top Impression Share Percent
- View Through Conversions