Paid media managers
Check spend and return by campaign every morning.
See your Microsoft Ads numbers in AWS S3.
Spend, conversions and revenue by campaign, ready each morning.
- Spend, results and return by campaign in one sheet
- Find the campaigns that cost more than they return
- A fresh campaign report before your morning check
AWS S3Start free Connect Microsoft Ads
Updated November 2026
| Date | Campaign | Network |
|---|---|---|
| Oct 1–Oct 29 | Spring sale | 1,240 |
| Oct 1–Oct 29 | Retargeting | 640 |
| Oct 1–Oct 29 | Brand search | 210 |
- SetupSign in, no key to copy
- Reads5 metrics and 4 ways to split them
- ChangesNone, read-only
- RefreshDaily to every 15 minutes
Who uses Datapipe with Microsoft Ads
Ecommerce owners
See which ads actually bring orders.
Agencies
Send each client a clear ad report every month, without exporting.
See which campaigns pay off
Each campaign lists spend, conversions and revenue. A campaign that spent without results stands out.
A campaign report that updates itself
Complete days refresh on your schedule. You do not download a new report from Microsoft Advertising.
Compare search ads with your other channels
Microsoft Ads results sit next to your other ad accounts and website. You compare them in one place.
Ask AI about your data
Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.
Before you connect
What you need
Sign in with Microsoft.
Read-only
Read access only. Datapipe never changes anything in Microsoft Ads.
Limits and exclusions
Read-only and reported by campaign, day and network. Keyword, ad group and search term reports are not included.
Full details and limits
Read-only and reported by campaign, day and network. Keyword, ad group and search term reports are not included.
Metrics and dimensions
5 metrics and 4 ways to split them.
Hover or tap a field to see what it means. Custom fields from your own account appear after you connect.
No fields match. Try another search or choose All.
Send Microsoft Ads data anywhere
Google SheetsA sheet that refreshes every morning.
Data StudioCharts that read the same numbers.
BigQueryA warehouse table for the same columns.
ClickHousePush rows into ClickHouse over HTTPS with an API key.AWS S3Write report files to your S3 bucket with IAM access keys.
Amazon RedshiftLoad rows into Redshift via the Data API with IAM keys.
FireboltPush rows into Firebolt over HTTPS with a Service Account.
PostgreSQLWrite report rows into PostgreSQL with database credentials.
MySQLWrite report rows into MySQL with database credentials.
SnowflakePush rows into Snowflake over HTTPS with a PAT token.
Databricks SQLLoad rows into Databricks SQL with a Personal Access Token.
Cloudflare R2Write report files to your R2 bucket with access keys.
Excel / CSVA Drive file you can open in Excel.
ClaudeAsk Claude about these numbers in a sentence.
ChatGPTAsk ChatGPT about these numbers in a sentence.
APIRead the same rows from your own tool.Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.Better than exporting by hand
- It refreshes on its own, so nobody pastes in a new export.
- Each campaign can be its own row.
- Spend sits next to results, so a costly campaign is obvious.
What can you do with this data?
Explore all use cases →Start from a goal
How it works
Sign in with Microsoft.
Pick where it goes. This one sends the numbers to AWS S3.
You're done. It refreshes every day.
Sample report
Sample range Oct 1–Oct 29. Each row is one campaign.
| Date | Campaign | Network | Impressions | Clicks | Spend | Conversions | Revenue |
|---|---|---|---|---|---|---|---|
| Oct 1–Oct 29 | Spring sale | 1,240 | 12,480 | 860 | $80.00 | 1,240 | 1,240 |
| Oct 1–Oct 29 | Retargeting | 640 | 8,240 | 410 | $125.50 | 640 | 640 |
| Oct 1–Oct 29 | Brand search | 210 | 3,110 | 155 | $42.00 | 210 | 210 |
Sample numbers, so you can see the shape. Your report uses your accounts.
Works well with Microsoft Ads
Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.
Microsoft Ads + Shopify“Is ad spend rising faster than orders?”See Shopify →
Microsoft Ads + Google Analytics“Do ad clicks show up as site visits?”See Google Analytics →
Microsoft Ads + HubSpot“Did the new campaign bring more deals?”See HubSpot →
Microsoft Ads + Stripe“How does ad spend compare with the revenue you collected?”See Stripe →Questions
Free to start. Paid plans add more data sources and refresh faster.
Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.
No. Name a project, add a data source, then choose a report and destination.
OAuth means you sign in with the service and grant access, without pasting an API key. Datapipe works with multiple partners to provide that sign-in. Some partners already provide it. Some integrations are API-only at present, so you paste a key or token. OAuth is coming soon for some. Some partners do not provide OAuth at all. The setup steps on each integration page say how that source connects. Signing in is only how the connection is made. It is not permission to change records. Where a source supports changes, those writes stay off until the workspace owner turns specific actions on and approves each one. We do not promise OAuth on every source, and we do not share dates.
Datapipe can see the numbers. It cannot change your ads, your store, or your site.
This page lists 5 metrics and 4 ways to split them. You pick the columns when you build the report.
A campaign shows up after it has numbers in the dates you picked. A new campaign can take a day.
The report uses the window already set on the ad account. Changing it there changes the next refresh.
One for each Microsoft Ads account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.
Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.
Try Microsoft Ads with sample data first
Build the report first, then add Microsoft Ads when you are ready.