Supermetrics for Microsoft Copilot
Connect Amazon Ads to Microsoft Copilot — Marketplace Ad Analytics in Teams

Bring your Amazon Ads data into Microsoft Teams. Ask Copilot about ACoS, ROAS, keyword performance, and product-level ad efficiency — share marketplace advertising insights with your e-commerce team in your Microsoft 365 workspace.
Why Connect Amazon Ads to Microsoft Copilot?
Analyze your Amazon Ads data in Microsoft Copilot with natural language — just ask what you want to know.
- Amazon Ads has unique metrics like ACoS and TACoS that require marketplace-specific context. Copilot understands these metrics and lets you query Sponsored Products, Sponsored Brands, and Sponsored Display performance without navigating Amazon's ad console.
- Copilot analyzes ad performance at the ASIN level, identifying products with strong ROAS vs those where advertising costs exceed margins. Ask about new-to-brand metrics to understand customer acquisition efficiency.
- Supermetrics connects Amazon Ads alongside other e-commerce and ad platforms. Ask Copilot to compare marketplace ad efficiency against DTC channel performance in the same thread.
How to Connect Amazon Ads to Microsoft Copilot
Three steps. Under two minutes. Zero code.

- 1
Deploy Supermetrics agent in Teams
Open Microsoft Copilot in Teams, search for the Supermetrics agent in the agent store, and add it to your workspace.
- 2
Authorize your data source
Authorize your account when prompted — a quick sign-in to connect your data source.
- 3
Ask questions in Teams chat
Start a conversation with the Supermetrics agent in Teams and ask anything about your marketing data in plain English.
Example Microsoft Copilot Prompts for Amazon Ads
Copy these prompts or use them as inspiration. Microsoft Copilot understands natural language — just ask what you want to know.
What Amazon Ads Data Can You Analyze in Microsoft Copilot?
Supermetrics gives Microsoft Copilot access to your full Amazon Ads reporting data — metrics and dimensions you already know from the Amazon Ads interface.
Key Metrics
- Impressions
- Clicks
- Spend
- Sales
- ACoS
- ROAS
- CPC
- CTR
- Orders
- Units sold
- Conversion rate
- TACoS
- New-to-brand orders
- New-to-brand sales
- DPV (detail page views)
Key Dimensions
- Campaign name
- Ad group name
- Keyword
- Search term
- Match type
- ASIN
- Product title
- Ad format (SP/SB/SD)
- Targeting type
- Placement
- Portfolio name
- Bidding strategy
Resources & Guides
How to make marketing data AI-ready
PPC reporting: extract insights from paid campaigns
Why Supermetrics for Microsoft Copilot?
The only native Microsoft Copilot connector with 170+ data sources, campaign management, and enterprise-grade security.
Native Microsoft Copilot Connector
One-click setup directly in Microsoft Copilot. No plugins to install, no terminal commands, no technical skills required. The first marketing data platform with native AI integrations.
170+ Data Sources
Connect Amazon Ads alongside 170+ other platforms through a single integration. Cross-channel analysis in one conversation.
Cross-Channel Analysis
Query Amazon Ads alongside every other marketing platform in a single conversation. No data exports, no tab switching.
Enterprise Security
SOC 2 Type II certified. GDPR compliant. OAuth authentication. Your data is encrypted at rest and in transit.
Real-Time Data
No stale exports. Supermetrics pulls fresh data from Amazon Ads every time you ask Microsoft Copilot a question. Always current, always accurate.
No Data Limits
Query any date range, any number of campaigns, any level of granularity. No row limits, no sampling, no restrictions on the data you can pull.
Frequently Asked Questions
- Deploy the Supermetrics agent from the Microsoft 365 Copilot agent store. Once added, authorize Amazon Ads as a data source. You can then query your Amazon Ads data in natural language directly inside Microsoft Teams chat — no exports, no dashboards, no context switching.
- Yes. Supermetrics uses OAuth-based authentication with your Amazon Ads credentials encrypted at rest and in transit. Data is processed within the Microsoft 365 trust boundary and only fetched as needed to serve your queries. Supermetrics is SOC 2 Type II certified and GDPR compliant.
- Absolutely. Supermetrics connects 170+ data sources to Microsoft Copilot through a single agent. You can ask Copilot to compare Amazon Ads performance against data from other platforms in the same Teams conversation — cross-referencing ad spend with revenue, web analytics, or CRM data.
- You can access all standard Amazon Ads reporting metrics through Supermetrics, including Impressions, Clicks, Spend, Sales, ACoS, and more. Both metrics and dimensions are available, so you can slice data by campaign, date, audience, and other dimensions.
- No. Setup takes under two minutes with zero coding. The Supermetrics agent handles all API connections, authentication, and data formatting behind the scenes. Just deploy the agent in Teams, authorize your data source, and start asking questions in plain English.
- Yes. The Amazon Ads connector includes Sponsored Products, Sponsored Brands, and Sponsored Display campaign data. You can compare performance across ad formats in Copilot.
- Yes. New-to-brand orders and new-to-brand sales are available, letting you analyze customer acquisition effectiveness on Amazon.
Also Connect to Microsoft Copilot
Ready to Connect Amazon Ads to Microsoft Copilot?
Join 200,000+ companies that use Supermetrics to connect their marketing data. Set up in under two minutes.