How do I export Amazon Ads data to Tableau or Power BI?
Learn how to export Amazon Ads reports to Tableau or Power BI, automate API data loads, and refresh dashboards with scheduled data.
Export Amazon Ads reports as files, or use its reporting API to load scheduled data into a database for Tableau or Power BI. As of November 16, 2026, start with Amazon’s unified Reporting page: the older Sponsored Ads and Amazon DSP report pages are scheduled to close on December 31, 2026. (advertising.amazon.com)
How do I export Amazon Ads data to Tableau or Power BI?
For a one-off report, create and download a report in Amazon Ads Console, then connect Tableau or Power BI to the downloaded file. In the console, go to Measurement and Reporting > Reporting, choose a template or create a report, select the metrics, dimensions, date range, and time grain, then run it. For recurring dashboards, use the Reporting API or an integration that loads reports into a database; connect your BI tool to that database instead of relying on manual file replacement. Amazon says unified reporting can combine data across accounts, ad products, and countries, and provides standardized metrics and dimensions. (advertising.amazon.com)
| Option | Best for | Trade-off |
|---|---|---|
| Download a console report | A quick analysis or small number of reports | You must download and replace the file to keep data current. |
| Use an API integration or connector | Scheduled reporting without building a full pipeline | API access, credentials, configuration, or a connector subscription may be required. |
| Build an API-to-database pipeline | Multiple accounts, tailored data models, or larger reporting workflows | Requires development and ongoing maintenance. |
For Tableau, connect to a supported file or database and publish the data source; Tableau supports delimited text files such as CSV and can schedule extract refreshes when the source is reachable. For Power BI, import the file or connect to the database, then configure refresh in the Power BI service. A local file may require a gateway; cloud-hosted files or databases can avoid that setup, depending on the source. (help.tableau.com)
What data formats and APIs does Amazon Ads provide?
Amazon Ads’ reporting API returns performance reports asynchronously; its documented report format includes compressed JSON (GZIP_JSON), which usually needs to be downloaded, decompressed, and shaped before a BI tool can use it. The API requires approved access, so a direct API route suits teams with developer support; advertisers without it can use a provider that already integrates with Amazon Ads. (advertising.amazon.com)
The API also distinguishes performance reports from campaign-structure exports: reporting provides metrics for a chosen report and date range, while export APIs return campaign entities and their details. Amazon Marketing Stream is another API-based option for streaming advertising data; use it when your workflow needs more frequent updates than scheduled historical reports, and check Amazon’s current documentation for dataset coverage. (d3a0d0y2hgofx6.cloudfront.net)
How can I automate exports and refreshes?
For a no-code start, schedule a report in the unified Reporting page, then have a person or workflow place the output where your BI tool can read it. For a more reliable hands-off pipeline, automate API authentication, report creation, status checks, download, decompression, and loading to a database or cloud storage location. Then schedule Tableau or Power BI to refresh after the data load completes. Tableau can schedule refreshes for supported cloud sources; Power BI scheduled refresh depends on source access and credentials. (advertising.amazon.com)
If you already have scheduled reports in the older pages, migrate them before December 31, 2026. Amazon notes that some report types or fields do not migrate, so check the migration status and compare the resulting report fields before replacing a production dashboard. (advertising.amazon.com)
How do I map Amazon Ads fields to Tableau or Power BI?
Keep campaign, ad group, and advertised-product identifiers as dimensions, and keep dates at the same grain as the report. Treat counts such as impressions and clicks as additive; calculate ratios such as click-through rate and return on ad spend from their underlying totals, rather than summing row-level ratios. Keep ad product, marketplace, currency, and attribution definition available as fields so filters and comparisons do not mix unlike data.
Check whether a report is daily, weekly, or monthly before joining it to other datasets, and join using stable IDs plus date and marketplace where appropriate. Do not join two reports at different levels of detail without aggregating one first, or metrics can be duplicated. Unified reporting standardizes metrics and dimensions across products, but verify field names and attribution definitions in the report you actually export. (advertising.amazon.com)