---
title: "Microsoft Ads to Snowflake: Connector Setup and SQL"
canonical: "https://www.owox.com/blog/articles/microsoft-ads-snowflake-owox"
updated: "2026-10-05"
---

# How to load Microsoft Ads data into Snowflake with OWOX Data Marts

To get Microsoft Ads data into Snowflake, create a connector Data Mart, sign in with Microsoft, enter the numeric account and customer IDs, choose the Ad Performance Report and publish. The connector creates the table in your Snowflake account and refreshes it on a schedule. The report is segmented by device, network and match type, so every query starts with an aggregation.

[Snowflake](/blog/topics/snowflake) · Updated October 1, 2026 · [Vadym Kramarenko](/team/vadym-kramarenko) · 7 min read

![How to load Microsoft Ads data into Snowflake with OWOX Data Marts](https://cdn.owox.com/www/content-marketing-article/microsoft-ads-snowflake-owox/thumbnail/1-fxmrep.png/public)

Microsoft Ads is rarely the largest line in a paid search budget, which is exactly why it gets left out of reporting. The numbers stay in the Microsoft Advertising interface, somebody exports them once a month, and the cross-channel report shows Google with a footnote.

Loading Microsoft Ads into Snowflake fixes that for good. This guide sets it up with the Microsoft Ads connector in [OWOX Data Marts](https://www.owox.com/app-signup): the IDs to use, the report to load, what the table looks like and the SQL to read it.

## What you end up with

A table in your own Snowflake account, `microsoft_ads_ad_performance_report`, with daily performance for every ad: impressions, clicks, spend and conversions, alongside the campaign, ad group and ad they belong to.

The connector requests the report from the Microsoft Advertising API, writes it into the table and repeats on a schedule. It does not model the data. The reporting logic is SQL you write.

## Before you start

**In Microsoft Advertising.** A user who can open the account, and two numbers: the **account ID** and the **customer ID**. Take both from the address bar when the account is open: the value of `aid` is the account ID and the value of `cid` is the customer ID. Microsoft also shows alphanumeric account numbers in some places. Those are not the ones the connector needs.

**In Snowflake.** A storage of type [Snowflake](/data-storages/snowflake) connected to your project, as described in the [storage guide](https://docs.owox.com/docs/storages/supported-storages/snowflake/): account identifier, warehouse, and a key pair or a username with a programmatic access token. The role must be able to create a database, a schema and tables. A small dedicated warehouse with auto-suspend is enough for a daily load, and [Snowflake pricing explained](/blog/articles/snowflake-pricing-cost-control) shows what it costs.

## The Turning Point

OWOX Data Marts

See your first report built in real time. _15 minutes._

1.  Connect your data warehouse
2.  Pick your metrics
3.  Get a live Google Sheets report

In the time it takes to write a ticket. Then imagine never writing that ticket again.

[Book a Demo](/book-a-call)

We'll use your actual use case

## Step 1: create the Data Mart

Click **New Data Mart**, enter a title such as “Microsoft Ads Performance”, select the Snowflake storage and click **Create Data Mart**. On the Data Setup tab, set **Definition Type** to **Connector** and choose **Microsoft Ads**.

## Step 2: sign in and enter the IDs

**Sign in with Microsoft** is the short way. Use the Microsoft Advertising user who has access to the account. The connector can only import accounts that this user can reach.

**Manually** means bringing your own credentials: an app registered in Microsoft Azure, which gives a client ID and client secret, a refresh token obtained for that app, and a developer token requested in Microsoft Advertising under Settings, Developer Settings. The [credentials guide](https://docs.owox.com/packages/connectors/src/sources/microsoft-ads/credentials/) covers each step. With the sign-in button you skip all of it.

![Edit Connector form for Microsoft Ads in OWOX Data Marts on a Snowflake Data Mart, with a Sign in with Microsoft button, a Manually link and required Account ID(s) and Customer ID fields – one sign-in and two numbers connect the account](https://cdn.owox.com/www/content-marketing-article/microsoft-ads-snowflake-owox/screens/1.png/public)

Then enter **Account ID(s)** and **Customer ID**.

Two advanced settings are worth a look before you continue.

*   **Report Timezone.** The default is Greenwich Mean Time. If your account runs in another time zone, set it here, or daily totals will not match the Microsoft Advertising interface.
*   **Aggregation.** Daily by default. Weekly and monthly are available if you never need the day.

## Step 3: choose the report and the fields

Each Data Mart loads one endpoint. Microsoft Ads has three.

*   **Ad Performance Report.** Daily ad performance: impressions, clicks, spend and conversions, segmented by device, network and match type. This is the one for reporting.
*   **User Location Performance Report.** The same metrics by the user’s physical location: country, state and city.
*   **Campaigns.** Campaign and ad group structure: type, status, bid strategy and budget. No metrics.

Then select fields.

![Connector Fields panel for Microsoft Ads in OWOX Data Marts with 44 of 95 fields selected for the ad performance report, and AccountId, TimePeriod, CampaignId, AdId, DeviceType, Network and other dimensions locked as keys – the report’s grain is fixed by its dimensions](https://cdn.owox.com/www/content-marketing-article/microsoft-ads-snowflake-owox/screens/2.png/public)

Notice how many fields are locked. The report’s keys are not only the ad and the day. They include currency, ad distribution, device type, device operating system, network, top versus other, both match types, language and campaign type. These columns are always loaded, because together they identify a row.

The last screen asks for the database, schema and table. The setup proposes a database named after the source, the schema `PUBLIC` and a table named after the endpoint.

## Step 4: publish and run

Click **Publish & Run Data Mart**. Publishing starts the first import. When it finishes, the Data Setup tab shows the source, the Snowflake table it writes to and the columns.

![Data Setup tab of a Microsoft Ads connector Data Mart in OWOX Data Marts, showing the MicrosoftAds source with the ad\_performance\_report endpoint, the Snowflake database, schema and table it writes to, and the output schema – the report lands in a table in your account](https://cdn.owox.com/www/content-marketing-article/microsoft-ads-snowflake-owox/screens/3.png/public)

## Step 5: load history and set the schedule

**History.** Click **Manual Run** and choose **Backfill (custom period)**. One backfill run covers at most 31 days. For a longer history, run consecutive periods, each after the previous one has finished.

![Manual Run panel in OWOX Data Marts with Backfill (custom period) selected, start and end date fields and a note that a backfill run can cover at most 31 days – history is loaded one month at a time](https://cdn.owox.com/www/content-marketing-article/microsoft-ads-snowflake-owox/screens/4.png/public)

**Schedule.** A Data Mart without a trigger does not run again. On the **Triggers** tab, add a trigger of type **Connector Run**: daily, weekly, monthly or at an interval.

![Create Scheduled Trigger form in OWOX Data Marts on the Microsoft Ads Data Mart, with trigger type Connector Run, a daily schedule at 09:00 and a time zone – the load repeats without anyone starting it](https://cdn.owox.com/www/content-marketing-article/microsoft-ads-snowflake-owox/screens/5.png/public)

Scheduled runs are incremental. Each one loads the current day plus the days set by the **Reimport Lookback Window**, two by default, so late conversions update rows that were already loaded. Rows are merged on the keys, so a re-imported day replaces the earlier version.

## What the table looks like in Snowflake

**One ad has many rows per day.** Because of the keys above, a single ad on a single day appears once for each combination of device, network, match type and the rest. A `SELECT *` looks like duplicates. It is not: it is the report’s grain. Every query on this table starts with `GROUP BY`.

**Names are case-sensitive, and capitalised.** The connector creates the schema, table and column names quoted, exactly as written, and Microsoft’s field names start with a capital letter: `CampaignName`, `Spend`, `TimePeriod`. In Snowflake a quoted name is case-sensitive and an unquoted one is read as upper case, so `SELECT Spend` looks for `SPEND` and fails. Write `"Spend"`, and quote the schema and table too: `ads_owox."PUBLIC"."microsoft_ads_ad_performance_report"`. The database name is not quoted.

**The day is `TimePeriod`.** There is no column called date. With daily aggregation, `TimePeriod` is the day.

## Query the data

Both queries were validated on Snowflake against a table loaded by the connector. The examples use a shared database, `ads_owox`, for all ad platforms.

Spend, clicks and impressions by campaign and day, for the last 30 days:

```
SELECT
  "TimePeriod" AS date,
  "CampaignName" AS campaign,
  SUM("Impressions") AS impressions,
  SUM("Clicks") AS clicks,
  SUM("Spend") AS spend
FROM ads_owox."PUBLIC"."microsoft_ads_ad_performance_report"
WHERE "TimePeriod" >=
  DATEADD(day, -30, CURRENT_DATE())
GROUP BY "TimePeriod", "CampaignName"
ORDER BY date, spend DESC;
```

The same period by device, with cost per click and click-through rate computed from the sums:

```
SELECT
  "DeviceType" AS device,
  SUM("Impressions") AS impressions,
  SUM("Clicks") AS clicks,
  SUM("Spend") AS spend,
  SUM("Spend") / NULLIF(SUM("Clicks"), 0) AS cpc,
  SUM("Clicks") / NULLIF(SUM("Impressions"), 0) AS ctr
FROM ads_owox."PUBLIC"."microsoft_ads_ad_performance_report"
WHERE "TimePeriod" >=
  DATEADD(day, -30, CURRENT_DATE())
GROUP BY "DeviceType"
ORDER BY spend DESC;
```

Do not sum or average the `Ctr`, `AverageCpc` and `ConversionRate` columns. They are ratios for one segment of one ad on one day. Recompute them from summed clicks, impressions and spend, as above.

## From table to report

A connector Data Mart can be reported from directly. On its **Destinations** tab you attach reports to Google Sheets, Data Studio, Slack or email, each with its own columns and schedule.

In practice this table is too granular to hand to anyone as it is. Publish the campaign-by-day query above as its own Data Mart and report from that. [Snowflake reports in Google Sheets](/blog/articles/automate-snowflake-google-sheets) covers the delivery, and [self-service marketing analytics on Snowflake](/blog/articles/snowflake-self-service-marketing-analytics) shows how to put Microsoft Ads next to the other channels in one table.

## When the numbers do not match the interface

Three causes account for most differences.

*   **Time zone.** The report time zone in the connector is not the account’s time zone. Set it in the advanced settings and run a backfill for the affected period.
*   **Recent days.** Conversions are still arriving. Compare a period that ended more than a few days ago, or raise the lookback window.
*   **Partial aggregation.** A filter on device or network in the query, left over from an earlier analysis, removes rows the interface total includes.

If a run fails outright, Run History shows the error the API returned. The usual one is an ID problem: an alphanumeric account number where the numeric `aid` value belongs, or an account the signed-in user cannot open.

## Where to go next

The same setup loads the other sources into the same Snowflake account: [Google Ads](/blog/articles/google-ads-data-snowflake-owox), [Facebook Ads](/blog/articles/facebook-ads-to-snowflake-data-marts), [LinkedIn Ads](/blog/articles/linkedin-ads-to-snowflake), [TikTok Ads](/blog/articles/tiktok-ads-data-snowflake), [Reddit Ads](/blog/articles/reddit-ads-to-snowflake) and [Shopify](/blog/articles/shopify-data-to-snowflake).

For the layer you build on top of these tables, see [Snowflake as a reusable reporting layer](/blog/articles/snowflake-reusable-reporting-layer). For the platform itself, start with [what Snowflake is and how it works](/blog/articles/snowflake-data-warehouse-explained).

## Your New Normal

Turn your data into decisions.

Governed data marts give you the clean foundation ML needs to actually work.

*   No AI hallucinations
*   Analyst-governed definitions
*   Every number traces to SQL

[Get started free](https://www.owox.com/app-signup)

## FAQ

## Frequently Asked Questions

Why do Microsoft Ads totals in Snowflake differ from the Microsoft Advertising interface?

The most common cause is the time zone. The connector's Report Timezone setting defaults to Greenwich Mean Time, so daily totals shift if the account runs in another zone. Set it in the connector's advanced settings and backfill the period. Recent days can also differ while conversions are still arriving.

How do I load Microsoft Ads data into Snowflake automatically?

Create a Data Mart in OWOX Data Marts on your Snowflake storage, set its definition type to Connector and choose Microsoft Ads. Sign in with Microsoft, enter the numeric account ID and customer ID, pick the Ad Performance Report and the fields you need, then publish. A Connector Run trigger on the Triggers tab repeats the load daily, weekly, monthly or at an interval.

How do I deliver Microsoft Ads data from Snowflake to stakeholders?

Publish a query that aggregates the report, for example spend by campaign and day, as its own Data Mart. On its Destinations tab, create reports to Google Sheets, Data Studio, Slack or email, each with its own columns and schedule. The data stays in your Snowflake account, and every report reads the same definition.

Why does the Microsoft Ads table have several rows for one ad on one day?

That is the grain of the Ad Performance Report. Its keys include device type, device operating system, network, ad distribution, match types, language and campaign type as well as the ad and the day, so one ad has a row for each combination. Always aggregate with GROUP BY, and recompute ratios such as CTR and CPC from summed clicks, impressions and spend.

How do I schedule Microsoft Ads loads and keep recent days correct?

Add a Connector Run trigger on the Data Mart's Triggers tab. Each scheduled run is incremental: it loads the current day plus the days set by the Reimport Lookback Window, two by default, so late conversions update rows that were already loaded. Rows are merged on the report's keys, so a re-imported day replaces the earlier version. Run History lists every run with its status.

Can Microsoft Ads be combined with Google Ads and other channels in Snowflake?

Yes. Load each platform with its own connector Data Mart into the same Snowflake account, then write one query that selects date, channel, impressions, clicks and spend from each table and combines them with UNION ALL. For Microsoft Ads the day is the TimePeriod column and spend is Spend. Publish the query as a Data Mart so every report uses the same definition.

Why does my query fail on Microsoft Ads column names in Snowflake?

The connector creates schema, table and column names quoted, exactly as Shopify spells them in camel case, for example totalPrice and processedAt. In Snowflake a quoted name is case-sensitive and an unquoted name is read as upper case, so the column is not found. Write every name in double quotes exactly as created.

Which Microsoft Ads IDs does the connector need?

The numeric account ID and customer ID used by the Microsoft Advertising API. Open the account in Microsoft Advertising and read them from the address bar: the aid value is the account ID and the cid value is the customer ID. The alphanumeric account numbers shown elsewhere in the interface are not accepted. The signed-in user must have access to the account.

## Who wrote this

![Vadym Kramarenko](https://cdn.owox.com/www/webflow/6798e703afdf787334941cde_Vadym-Kramarenko.png/public)

[Vadym Kramarenko](/team/vadym-kramarenko) · Growth Marketing Manager

Vadym Kramarenko is a Growth Marketing Manager at OWOX, where he drives user acquisition and product-led growth strategies. He hosts the OWOX podcast, interviewing analytics professionals about data-driven marketing, attribution, and reporting best practices. Vadym specializes in turning complex analytics concepts into practical, actionable marketing frameworks.

[LinkedIn](https://www.linkedin.com/in/vadim-kramarenko/) · [All articles](/team/vadym-kramarenko)

[Snowflake](/blog/topics/snowflake)

## Related articles

[Snowflake · How to Load Facebook Ads Data into Snowflake with OWOX Data Marts · October 1, 2026](/blog/articles/facebook-ads-to-snowflake-data-marts)

[Snowflake · How to Turn Snowflake into a Self-Service Marketing Analytics Engine · October 1, 2026](/blog/articles/snowflake-self-service-marketing-analytics)

[Snowflake · Snowflake for Data Analysts: How to Turn Your Warehouse into a Reusable Reporting Layer · October 1, 2026](/blog/articles/snowflake-reusable-reporting-layer)

[See all articles →](/blog/articles)

## Book a call

You are booked. The invitation is on its way to , with the calendar invite and the meeting link.

[Reschedule](#)

[Cancel](#)

## Schedule a meeting

You are booked. The invitation is on its way to , with the calendar invite and the meeting link.

[Reschedule](#)

[Cancel](#)

## Links

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Snowflake](https://www.owox.com/blog/topics/snowflake) — /blog/topics/snowflake.md
- [Vadym Kramarenko](https://www.owox.com/team/vadym-kramarenko) — /team/vadym-kramarenko.md
- [OWOX Data Marts](https://www.owox.com/app-signup)
- [Snowflake](https://www.owox.com/data-storages/snowflake) — /data-storages/snowflake.md
- [storage guide](https://docs.owox.com/docs/storages/supported-storages/snowflake)
- [Snowflake pricing explained](https://www.owox.com/blog/articles/snowflake-pricing-cost-control) — /blog/articles/snowflake-pricing-cost-control.md
- [Book a Demo](https://www.owox.com/book-a-call) — /book-a-call.md
- [credentials guide](https://docs.owox.com/packages/connectors/src/sources/microsoft-ads/credentials)
- [Snowflake reports in Google Sheets](https://www.owox.com/blog/articles/automate-snowflake-google-sheets) — /blog/articles/automate-snowflake-google-sheets.md
- [self-service marketing analytics on Snowflake](https://www.owox.com/blog/articles/snowflake-self-service-marketing-analytics) — /blog/articles/snowflake-self-service-marketing-analytics.md
- [Google Ads](https://www.owox.com/blog/articles/google-ads-data-snowflake-owox) — /blog/articles/google-ads-data-snowflake-owox.md
- [Facebook Ads](https://www.owox.com/blog/articles/facebook-ads-to-snowflake-data-marts) — /blog/articles/facebook-ads-to-snowflake-data-marts.md
- [LinkedIn Ads](https://www.owox.com/blog/articles/linkedin-ads-to-snowflake) — /blog/articles/linkedin-ads-to-snowflake.md
- [TikTok Ads](https://www.owox.com/blog/articles/tiktok-ads-data-snowflake) — /blog/articles/tiktok-ads-data-snowflake.md
- [Reddit Ads](https://www.owox.com/blog/articles/reddit-ads-to-snowflake) — /blog/articles/reddit-ads-to-snowflake.md
- [Shopify](https://www.owox.com/blog/articles/shopify-data-to-snowflake) — /blog/articles/shopify-data-to-snowflake.md
- [Snowflake as a reusable reporting layer](https://www.owox.com/blog/articles/snowflake-reusable-reporting-layer) — /blog/articles/snowflake-reusable-reporting-layer.md
- [what Snowflake is and how it works](https://www.owox.com/blog/articles/snowflake-data-warehouse-explained) — /blog/articles/snowflake-data-warehouse-explained.md
- [See all articles →](https://www.owox.com/blog/articles) — /blog/articles.md