KDP Ads AutopilotDaily report setup
← Dashboard

Set up your daily report

This is the exact report the engine reads every morning. You build it once in the Amazon Ads console, point it at your private address, and it delivers itself daily — you never download anything again. In the console go to Measurement & reporting → Reporting → Create report, then match the settings below.

1 · Filters

Accounts
Your advertiser account
Campaigns
All campaigns
Country
All countries
Ad product
All ad products important
This is what makes one report cover both Sponsored Products and Sponsored Brands — the engine manages both from the “Ad product” column.

2 · Columns

Dimensions
Ad product · Campaign (name, country, currency, budget) · Portfolio · Placement · Search term · Placement classification · Matched target · Target (value + match type) · Country (+ code) · Advertised product (ID, SKU) · Ad (ID, name, format) · Day of Month · Date
Metrics
Impressions · Viewable impressions · Clicks · CTR · Viewable CTR · Total cost · Purchases · Purchases (new to brand) · Cost per purchase (+ new to brand) · Sales · Long-term sales · ROAS · Long-term ROAS

Tip: it's fine to include a few extra columns — the engine only reads the ones it needs. The must-haves are Ad product, Campaign, Search term, Target, Advertised product, Total cost, Purchases, Sales and Date.

3 · Report range & format

Report range
Last 90 days (the engine uses the most recent 30 — 90 just gives it headroom)
Unit / time
Daily — one row per day
File format
CSV

4 · Delivery — the hands-free part

Frequency
Recurring · Daily
Time
Your local morning (e.g. 8 AM) — anything before you check your dashboard
Send to
Your private delivery address
Find it on your dashboard under “Hands-free delivery” and copy it in here. You can add your own email as a second recipient too.
Finish
Click “Save and run” (not just “Save”) do this
This sends the first report immediately, so it flows into the app today and you can confirm it's working — instead of waiting until tomorrow's scheduled run.

After that, Amazon emails the report to your address every morning, the cloud picks it up, and your plan is ready when you open the app. Nothing to download or upload.

© 2026 Hans and Martina Thörn Durefelt · hansmartinatwinflames.com