How to download your reports
The free check needs your ad reports as files. Here is where to find them.
Menus change. If a name below is not on your screen, look for the closest one.
For every platform, choose the last 30 to 60 days, break it down by day, and save as CSV.
Meta Ads Manager
- Open Ads Manager and sign in.
- Click Reports in the left menu, or use the Export button above the table.
- Set the dates to the last 30 to 60 days.
- Break the data down by Day.
- Export as CSV.
Also download your Activity history. It lists the changes made to your account. Find it in the account’s history or settings area, set the same dates, and export it.
Google Ads
- Open Google Ads and sign in.
- Click Reports in the left menu.
- Pick a table or report that shows cost by campaign.
- Set the dates to the last 30 to 60 days.
- Segment by Day.
- Click the download icon and choose .csv.
Also download your Change history. Look under Tools, then Change history. Set the same dates and download it as CSV.
Amazon Ads
- Open the Amazon Ads console and sign in.
- Go to Measurement & reporting, then Sponsored ads reports.
- Create a new report for your ad type.
- Set the dates to the last 30 to 60 days.
- Choose Daily for the time unit.
- Run the report and download it as CSV.
Amazon’s campaign history shows on screen only, so there is no file to download for it.
If you customize the report’s columns
The waste check reads the Search term report. If you pick its columns yourself, tick these.
Needed: Campaign Name, Customer Search Term, Targeting, Clicks, Spend, Orders (7 or 14 day), and Date (or Start Date and End Date).
Recommended: Campaign ID, Ad Group Name, Match Type, KENP Read, Country or Marketplace, Sales, and Currency.
If your books are in Kindle Unlimited, keep KENP Read (Kindle Edition Normalized Pages read). Without it, page reads don’t count as sales, and we mark sales-based findings too early to tell.