---
title: "How to fix discrepancies in Microsoft Advertising data in Supermetrics"
slug: "how-to-fix-discrepancies-in-microsoft-advertising-data-in-supermetrics"
description: "Learn how to fix discrepancies in Microsoft Advertising data in Supermetrics."
updated: 2025-06-26T11:32:26Z
published: 2025-06-26T11:32:26Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to fix discrepancies in Microsoft Advertising data in Supermetrics

If you’re encountering discrepancies between the data you see in Microsoft Advertising and the results you see in your Supermetrics reports, it could be due to issues with the **Top impression rate** and **Absolute top impression rate** fields.

These errors occur because the API occasionally doesn’t return a value for the field on a specific day. This means that when it processes the rate over multiple days split by a date-based dimension, it changes the calculation. This might not match what’s shown in Microsoft Advertising, as it’s unable to fetch the missing day.

## Instructions

Our teams have tested different setups to find workarounds that stop these discrepancies from occurring in Supermetrics reporting. We recommend using one of these.

- Splitting the data by "Date" dimension, as it this gets true values for each day
- Not splitting by any date-type dimension, as this gets the true value for the whole period and matches the total in the reporting tool.
- Using the full period if breaking down by a date-type dimension, for example fetching "Last month" as the date range and using "Month" as a date dimension.