Connect Amazon Ads to Power BI

Authorize the Amazon account in Catchr and select the advertising profile and report scope. In Catchr’s Power BI query builder, select campaign, date, impressions, clicks and cost for a completed period and preview a short extraction. Import the generated URL through Get data > Web in Power BI Desktop. Check the returned rows before building measures, keeping ad product, report level and attribution window clear in the model.

Yes. The Amazon Ads source includes reports for Sponsored Products, Sponsored Brands and Sponsored Display. Available breakdowns depend on the ad product and report, including campaign, ad group, targeting, search term and product analysis. Use the separate Amazon DSP connector for DSP reporting.

These fields describe different attribution windows in the reports that support them. Select the window that matches the Amazon Ads column you are comparing, and use it consistently for sales, purchases and efficiency calculations. The windows overlap: adding 7-day and 14-day sales counts some attributed sales twice. Field availability also differs across sponsored ad products, so not every campaign supports every window.

For a chosen attribution scope, ROAS is attributed sales divided by advertising cost, while ACOS is advertising cost divided by attributed sales, expressed as a percentage. Calculate each from summed sales and cost over the same rows rather than adding campaign ratios. Handle a zero denominator explicitly, and keep currencies separate or convert them consistently before combining accounts.

Yes, where the selected sponsored report supports those fields. A search term describes the query that triggered an ad; targeting describes the keyword or product target you configured. A purchased ASIN can differ from the advertised ASIN. Build separate charts for these report scopes instead of combining incompatible dimensions or assuming every campaign total will reconcile with a more restricted detail report.

Catchr reads synchronized daily Amazon reports, so a dashboard refresh is not the same as requesting new data from Amazon. A missing day can indicate that its report has not been synchronized rather than zero activity. Check the advertising profile, ad product, report level, currency and attribution window. Recent attributed sales can also change; compare completed periods and contact Catchr if a daily gap persists after synchronization.

History depends on the ad product, report type and data already synchronized for your account. Initial backfill limits are not the same across Sponsored Products, Sponsored Brands and Sponsored Display, and an empty older date does not prove that no ads ran. Check your earliest available reporting date before promising a year-over-year dashboard, and retain dated exports when you need a durable archive.

Yes. Add Amazon Seller or Amazon Vendor Central alongside your advertising data. Retail sales and ad-attributed sales have different scopes, so keep them labelled separately. Align marketplace, dates, currency and product identifiers before creating relationships; joining a product total to multiple advertising rows can otherwise inflate the result.