trackiq-amazon-wasted-spendlisted
Install: claude install-skill TrackIQ-HQ/trackiq-amazon-wasted-spend
# Wasted-Spend Sweeper
Finds the Sponsored Products keyword spend that is not paying for itself, and
hands back a bulk-upload workbook with every ID attached and a one-pager
explaining the cut.
Run it weekly. The value compounds, because each run reports what the last
one recovered.
## Requires
- The TrackIQ MCP, for `list_marketplaces`, `get_targets`, `get_ad_groups`,
`get_campaigns` and `get_search_terms`.
- **A break-even ROAS.** Ask for it before running. It comes from product
margin, is not derivable from the MCP, and every verdict depends on it.
- `openpyxl` for the workbook, via `assets/build_workbook.py`. Without it,
produce the same columns as CSV or a table — the contract is in
`assets/method.md`.
- **Without the MCP:** works from a Sponsored Products bulk report or the
search-term report exported from Campaign Manager, as long as the export
carries campaign, ad group and keyword IDs.
## First run
Fill in a copy of `assets/account.example.md` saved as account.md beside the
skill. Every TrackIQ skill reads the same file, so an account already set up
for another TrackIQ report needs nothing added here.
If the runtime has no filesystem, print the same block and ask the user to
paste it into their project instructions once.
## Read first
- `assets/pulls.md` — the three pulls, pagination, and the ID trap
- `assets/method.md` — the four pools, the ranking, the bid formula, the bulk
column contract
- `assets/checks.md` — what to verify before anythin