← ClaudeAtlas

trackiq-amazon-wasted-spendlisted

Finds Amazon advertising spend that is not paying for itself — keywords that spent and sold nothing, keywords bidding above what they return, the same keyword duplicated across ad groups bidding against itself, and search terms worth negating — then produces an Amazon bulk-operations workbook with the campaign, ad group and keyword IDs already attached, plus a one-page summary of what is being cut and why. Use when the user asks about wasted ad spend, wasted spend, negative keywords, keywords to pause, bid cuts, where money is being lost in PPC, an account cleanup, a PPC audit, or how to lower ACOS.
TrackIQ-HQ/trackiq-amazon-wasted-spend · ★ 0 · AI & Automation · score 72
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