Supermetrics for Microsoft Fabric
Connect Amazon Ads to Microsoft Fabric — Unified Microsoft Analytics
Deliver your Amazon Ads data to Microsoft Fabric OneLake as Delta tables. Archive ACoS data, search term reports, and ASIN-level performance.
Why Connect Amazon Ads to Microsoft Fabric?
Store your raw Amazon Ads data in Microsoft Fabric for custom pipelines and full data ownership.
Archive search term reports
Amazon Ads search term data has limited retention. Fabric preserves every search term report forever.
ASIN-level data lake
Combine Amazon Ads with Seller Central and Shopify data in Fabric for unified e-commerce analytics.
Query via SQL endpoint
Query Amazon Ads data in Fabric to analyze ACoS and TACoS trends across your entire catalog.
How to Connect Amazon Ads to Microsoft Fabric
Three steps. Under two minutes. Zero code.
- 1
Create a data transfer
Log into Supermetrics, select Amazon Ads as your source and Microsoft Fabric as your destination.
- 2
Connect your Fabric workspace
Authenticate with your Microsoft account, choose your Fabric workspace and lakehouse, and select the metrics and dimensions you want to transfer.
- 3
Set schedule and start transfer
Choose your refresh frequency (hourly, daily, or weekly) and click Start. Your Amazon Ads data begins flowing into your Fabric lakehouse as Delta tables.
Amazon Ads Data Format in Microsoft Fabric
Supermetrics delivers your Amazon Ads data in clean, structured files ready for downstream processing.
Delta Lake format — ACID transactions, time travel, and schema enforcement. Native to Fabric lakehouses.
Columnar binary format — the underlying storage for Delta tables, readable by any Parquet-compatible tool.
What to Build with Amazon Ads Data in Microsoft Fabric
Once your Amazon Ads data lands in Microsoft Fabric, here's what becomes possible.
ACoS optimization pipeline
Feed Amazon Ads data from your lakehouse into Power Automate functions that flag unprofitable ASINs automatically.
Marketplace analytics lake
Combine Amazon Ads with Seller Central data in Fabric for unified marketplace analytics.
What Amazon Ads Data Can You Pull into Microsoft Fabric?
Supermetrics gives Microsoft Fabric 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
Why Supermetrics for Microsoft Fabric?
Purpose-built for marketing data since 2009. 200,000+ companies trust Supermetrics to move 15% of global ad spend into reporting and analytics destinations.
No Vendor Lock-In
Your data lands in Microsoft Fabric — infrastructure you own and control. Use any BI tool, any transformation layer, any ML platform. If you ever switch providers, your data and dashboards stay with you.
170+ Marketing Data Sources
Purpose-built for marketing data — not a generic ETL tool. Supermetrics covers 99% of metrics and dimensions from each source, with pre-structured tables ready for analysis. No transformation layer required.
Flexible File Formats
Export your Amazon Ads data as CSV, JSON, or Parquet. Choose the format that fits your downstream tools — whether that's a query engine, ML pipeline, or custom ETL.
Your Data, Your Infrastructure
Supermetrics moves data directly to your destination — nothing is stored on our servers. SOC 2 Type II certified, GDPR and CCPA compliant. Your data stays in infrastructure you control, simplifying privacy and compliance reviews.
Flat-Rate, Predictable Pricing
Fixed annual pricing regardless of data volume — no per-row charges, no surprise bills during peak campaign seasons. Transfer as much Amazon Ads data as you need without worrying about cost spikes.
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
How do I connect Amazon Ads to Microsoft Fabric with Supermetrics?
Log into the Supermetrics Hub, create a new data transfer, select Amazon Ads as the source and Microsoft Fabric (OneLake) as the destination. Authenticate with your Microsoft account, choose your Fabric workspace and lakehouse, select your metrics and dimensions, set a schedule, and start the transfer. Supermetrics writes data directly to OneLake as Delta Lake tables — no Data Factory pipelines to build. Once the data lands, it's instantly available through the lakehouse SQL endpoint for T-SQL queries and through the Spark endpoint for notebook-based analysis, giving every team their preferred access method from day one.
Is my Amazon Ads data secure in Microsoft Fabric?
Supermetrics is SOC 2 Type II certified and GDPR compliant. Data transfers are encrypted end-to-end. Once in Fabric, your data inherits Microsoft's full enterprise security stack: Entra ID authentication, workspace-level and item-level permissions, row-level security that flows all the way through to Power BI DirectLake reports, sensitivity labels from Microsoft Purview for data classification, and OneLake data access roles for fine-grained folder-level control within lakehouses. Supermetrics never stores your marketing data after delivery.
Can I combine Amazon Ads data with other sources in Microsoft Fabric?
Yes — that is one of Fabric's core strengths. Once your Amazon Ads data lands in a lakehouse as Delta Lake tables, you can join it with data from any other source using two complementary access paths: T-SQL via the lakehouse SQL endpoint (familiar to any SQL analyst) or Apache Spark notebooks for complex transformations and data science workflows. Because every Fabric lakehouse stores data in OneLake's open Delta Lake format, there is no data duplication — the same physical data is accessible across the SQL endpoint, Spark, Power BI DirectLake mode, KQL databases, and Data Activator alerts. Supermetrics supports 170+ marketing data sources, all deliverable to the same Fabric workspace.
What Amazon Ads fields can I transfer to Microsoft Fabric?
All standard Amazon Ads reporting fields are available, including Impressions, Clicks, Spend, Sales, ACoS, ROAS, and more. You select the exact metrics and dimensions during setup. Data arrives in your lakehouse as Delta Lake tables, which means you get ACID transactions, time travel (query historical snapshots), and schema evolution out of the box. The data is immediately queryable from any Fabric experience and can power Power BI DirectLake dashboards that read the Delta tables in-place — no import or scheduled refresh required — delivering near-real-time reporting with no data movement.
How often does Amazon Ads data update in Microsoft Fabric?
Your transfer schedule controls data freshness. Supermetrics supports hourly, daily, weekly, or monthly transfers to Fabric. Most teams run daily refreshes to have yesterday's complete Amazon Ads data ready each morning. Incremental loading writes only new and changed records, keeping transfer times fast and Fabric capacity usage low. Because the data lands as Delta Lake tables, Power BI reports using DirectLake mode reflect the latest data without a separate import refresh — the moment Supermetrics delivers new Amazon Ads records, your dashboards are up to date.
Is ASIN-level data available in Fabric?
Yes. ASIN, product title, and all keyword-level metrics are available in the structured file exports.
Can I export Amazon Ads search term data?
Yes. Search term reports with spend, clicks, and conversion data are included in the export.
Also Connect to Microsoft Fabric
Ready to Connect Amazon Ads to Microsoft Fabric?
Join 200,000+ companies that use Supermetrics to connect their marketing data. Set up in under two minutes.