---
updatedAt: 2025-01-29T10:30:43.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# Microsoft Conversions (Purchases)

conversions

# Overview

Microsoft Conversions (Purchases) represent the total number of purchases as reported by Microsoft Ads.

> 📘 Microsoft Conversions = Number of Purchases Reported by Microsoft

The calculation is based on data from the [Ads](https://triplewhale.readme.io/docs/ads-table) table.

### Detailed Breakdown

The formula above is derived from the following components:

Conversions = `SUM(conversions)` --> [Ads](https://triplewhale.readme.io/docs/ads-table) table\
Microsoft Ads = `where channel = 'bing'`

# Insights and Actions

Monitoring Microsoft Conversions enables you to understand how well your Microsoft Ads are driving sales. This data can help optimize your ad strategy:

* **Analyze Conversion Trends**: Track conversion data over time to spot trends and adjust campaigns accordingly.
* **Enhance Ad Targeting**: Leverage high-performing conversion data to refine audience targeting for more accurate customer acquisition.
* **Boost Campaign Efficiency**: Identify campaigns generating the highest number of conversions, allowing you to reallocate resources to increase return on investment.
* **Drive Better Results**: Experiment with creative elements and bids based on conversion data to further enhance campaign performance.

# Example Use

### Prompt

> How many Microsoft-reported conversions were there yesterday?

### Response

![](https://files.readme.io/b15b7a6b78ee4d17d42071f654e6c49b967278400828e466b0ef98570424eafc-image.png)

### Query

```sql
SELECT
  SUM(a.conversions) AS microsoft_reported_conversions
FROM
  ads_table AS a
WHERE
  a.event_date = CURRENT_DATE() - 1
  AND a.channel = 'bing';
```