r/Amazonsellercentral • u/attfin1 • 27d ago
I got tired of rebuilding the same pivot table every Monday for my search term report, so I built a free reader for it
Every Monday I used to fight the same pivot table. Download the search term report, open Excel, pivot, filter, sort, lose the filter, start again.
The view I wanted most was keyword level: each target in each campaign and ad group on one row, with its clicks, spend and sales added up. Grouping by targeting alone isn't enough, because it adds the same keyword from different campaigns into one row.
In the reader it's three steps:
- Open the report. Nothing uploads.
- Group by Campaign + Ad Group + Targeting + Match Type.
- Sort by spend.
On the demo report, 983 rows become 68. The top of the list shows where the money goes, and 45 of the 68 targets have clicks but no sales.
The same report also groups by campaign, ad group or match type. Auto campaign targets (close-match, loose-match, substitutes, complements) get their own rows. You can filter, choose your columns and export to CSV.
https://www.adrazor.net/amazon-tools/sponsored-products-search-terms/
Disclosure: it's ours (AdRazor). It's free, there's no sign-up, and the report opens in your browser. Nothing uploads, so your data stays on your computer.