Amazon Sponsored Products Action Plan Generator

Upload your Amazon Search Term Report to generate an actionable PPC analysis.

This is a MVP of an idea for a no-frills app I have developed to help Amazon PPC Advertisers to make their ads more profitable.

Because it's an MVP it's a stripped down version of what would be the final product. The aim is just to get feedback to see if it's worth continuing with or not.

There's a short (optional) feedback form at the end of the analysis. It will really help me if you tell me what you think and any areas that need improving. Your feedback is the only data I store... nothing else.

Thanks very much

Michael

PS Below you'll see an example of the analysis - it's the same process that we used to increase 1 of our clients' profits by $8k in just 1 month.

Here's The Step-By-Step Optimisation Analysis You Will Receive...

Spend Overview

All Data

Metric Total Profitable Zero Sales Too Expensive
Spend GBP 956.39 GBP 207.87 GBP 659.95 GBP 88.57
% of Total 100.0% 21.7% 69.0% 9.3%

Profitable = ACoS <= 25.0% | Too Expensive = ACoS > 25.0%

Sufficient Data -- Meets Your Minimum Criteria

Metric Total Profitable Zero Sales Too Expensive
Spend GBP 284.70 GBP 138.38 GBP 57.75 GBP 88.57
% of Total 29.8% 14.5% 6.0% 9.3%

Profitable = ACoS <= 25.0% | Too Expensive = ACoS > 25.0%

Insufficient Data -- You Need A Longer Date-Range To Make Decisions

Metric Total Profitable Zero Sales Too Expensive
Spend GBP 671.69 GBP 69.49 GBP 602.20 GBP 0.00
% of Total 70.2% 7.3% 63.0% 0.0%

Profitable = ACoS <= 25.0% | Too Expensive = ACoS > 25.0%


Section 1: Zero-Sales Search Terms

What

Add search terms generating zero sales as negative matches. They are leaking spend without generating any revenue.

Why

10 search term(s) with sufficient data have spent GBP 46.04 without generating a single sale. This is wasted advertising spend that can be recovered immediately.

An additional 36 search term(s) show zero sales but have insufficient click data to act with confidence. They have spent GBP 62.29 combined and require monitoring.

How

Sufficient Data -- Act Now

Campaign Ad Group Search Term Clicks Spend Action
21st AUTO (copy of bday earrings) 21st accessory 21st anniversary present lady 33 GBP 11.66 Add as Ad Group NEG. EXACT
30th accessory 30th accessory present Manual Keywords 30th accessory present lady 10 GBP 4.79 Add as Ad Group NEG. EXACT
30th accessory 30th accessory present Manual Keywords 30th bracelet 8 GBP 4.07 Add as Ad Group NEG. EXACT
21st prods (dupe of 30th accessory campaign +) 21st accessory present Manual Keywords 21st present lady 6 GBP 4.02 Add as Ad Group NEG. EXACT
40th accessory loose 40th presents 40th anniversary present lady accessory 10 GBP 4.00 Add as Ad Group NEG. EXACT
21st prods (dupe of 30th accessory campaign +) 21st accessory present Manual Keywords 21st anniversary accessory lady 8 GBP 4.00 Add as Ad Group NEG. EXACT
40th accessory loose 40th presents 40th anniversary present 9 GBP 3.60 Add as Ad Group NEG. EXACT
18th AUTO exact match 18th bracelet anklets AUTO 18th anniversary decoration 7 GBP 3.44 Add as Ad Group NEG. EXACT
18th AUTO exact match 18th bracelet anklets AUTO 18th anniversary 7 GBP 3.35 Add as Ad Group NEG. EXACT
18th AUTO exact match 18th bracelet anklets AUTO 18th anniversary bracelet 7 GBP 3.11 Add as Ad Group NEG. EXACT

Insufficient Data -- Monitor

36 search term(s) with zero sales have insufficient data to act on. Total spend: GBP 62.29.

Campaign Ad Group Search Term Clicks Spend Reason
30th accessory 30th accessory present Manual Keywords genuine gold 30th bracelet 6 GBP 2.90 Insufficient: GBP 2.90 spend (need GBP 3.00)
30th accessory 30th accessory present Manual Keywords unusual 30th present lady 5 GBP 2.90 Insufficient: GBP 2.90 spend (need GBP 3.00)
18th AUTO exact match 18th bracelet anklets AUTO 16th anniversary present child accessory 6 GBP 2.84 Insufficient: 43 impressions (need 50); GBP 2.84 spend (need GBP 3.00)
18th accessory NEW AD 18th AUTO b01d61s0qa 9 GBP 2.80 Insufficient: GBP 2.80 spend (need GBP 3.00)
30th accessory 30th accessory present Manual Keywords 30th anniversary bracelet lady 6 GBP 2.80 Insufficient: GBP 2.80 spend (need GBP 3.00)
18th accessory NEW AD 18th AUTO b0y4pq98fx 8 GBP 2.59 Insufficient: GBP 2.59 spend (need GBP 3.00)
18th AUTO exact match 18th bracelet anklets AUTO 18th anniversary present idea 5 GBP 2.49 Insufficient: 26 impressions (need 50); GBP 2.49 spend (need GBP 3.00)
40th accessory loose 40th presents 40th accessory present lady 6 GBP 2.27 Insufficient: GBP 2.27 spend (need GBP 3.00)
21st AUTO (copy of bday earrings) 21st accessory 21st anniversary 6 GBP 2.16 Insufficient: 36 impressions (need 50); GBP 2.16 spend (need GBP 3.00)
21st AUTO (copy of bday earrings) 21st accessory b0fk65yb3j 6 GBP 2.16 Insufficient: GBP 2.16 spend (need GBP 3.00)

*Showing top 10 of 36 terms by spend. *

These terms need more data before a decision can be made. Re-run this analysis after the terms have accumulated additional clicks. Set a calendar reminder to review these in 2-4 weeks.


Section 2: Too-Expensive Search Terms

What

Reduce bids on search terms with ACoS above the target to move them towards break-even. Target ACoS is 25.0%.

Why

5 search term(s) are generating sales but at an ACoS above the 25.0% target. These terms are profitable in terms of generating orders but the bids are too high. Reducing bids to break-even could recover approximately GBP 39.80 in excess spend.

How

Sufficient Data -- Act Now

Campaign Ad Group Search Term Spend Sales ACoS Current CPC Action
30th accessory 30th accessory present Manual Keywords 30th present lady GBP 20.05 GBP 28.25 71.0% GBP 0.59 Reduce bid to GBP 0.21
30th accessory 30th accessory present Manual Keywords 30th bracelet lady GBP 13.08 GBP 28.25 46.3% GBP 0.50 Reduce bid to GBP 0.27
40th accessory loose 40th presents 40th anniversary present lady GBP 23.24 GBP 50.95 45.6% GBP 0.39 Reduce bid to GBP 0.22
16th AUTO copy of bday anklets 16th anklets and bracelet 16th anniversary present child GBP 22.59 GBP 62.90 35.9% GBP 0.31 Reduce bid to GBP 0.22
18th accessory NEW AD 18th AUTO 18th anniversary present GBP 21.90 GBP 73.90 29.6% GBP 0.35 Reduce bid to GBP 0.30

Insufficient Data -- Monitor

No too-expensive terms with insufficient data found.


Section 3: Migrate Broad/Phrase to Exact Match

What

Graduate proven broad/phrase search terms to exact match. This gives maximum bid control and prevents spend on irrelevant variations of your winning terms.

Why

When a search term consistently converts at or below your target ACoS via broad or phrase match, it has proven itself. Moving it to exact match:
- Increases bid control: You can bid specifically on this exact term without funding exploratory traffic.
- Prevents cannibalization: Adding a negative exact in the source campaign stops the broad/phrase from competing with your exact match ad.
- Scales proven winners: You can confidently raise bids on terms you know convert.

5 term(s) are ready to graduate.

How

Sufficient Data -- Act Now

Campaign Ad Group Search Term Spend Sales ACoS
30th prods (dupe of 40th jewellery campaign +) 30th Jewellery Gift Manual Keywords 30th birthday gifts for women GBP 42.63 GBP 184.75 23.1%
40th Jewellery 40th Jewellery Gift Manual Keywords 40th birthday necklace sterling silver GBP 3.51 GBP 73.90 4.8%
30th prods (dupe of 40th jewellery campaign +) 30th Jewellery Gift Manual Keywords 30th birthday necklace GBP 7.43 GBP 36.95 20.1%
40th Jewellery 40th Jewellery Gift Manual Keywords 40th birthday gifts for women jewellery GBP 5.39 GBP 28.25 19.1%
40th Jewellery 40th Jewellery Gift Manual Keywords 40th birthday necklace GBP 6.05 GBP 28.25 21.4%

Insufficient Data -- Monitor

1 search term(s) are performing at or below target ACoS but have insufficient data to act on. Total spend: GBP 1.06.

Campaign Ad Group Search Term Clicks Spend Reason
18th Necklace - SPA Research 18th Necklace - SPA Manual 18th silver necklace niece 2 GBP 1.06 Insufficient: 2 clicks (need 5); GBP 1.06 spend (need GBP 3.00)

These terms are performing at or below target ACoS but need more data before graduation. Monitor and re-run once they accumulate more clicks.


Section 4: ASIN Zero-Sales Targets

No ASIN product targeting data found in this period.


Section 5: ASIN Too-Expensive Targets

No ASIN product targeting data found in this period.


Section 6: Auto Zero-Sales Search Terms

What

Add auto campaign search terms generating zero sales as negative exact matches. These terms are consuming budget in auto campaigns without converting.

Why

6 search term(s) with sufficient data have spent GBP 28.33 without a single sale. This spend can be recovered by adding these as negative exact matches.

An additional 22 search term(s) show zero sales but have insufficient data to act with confidence. They have spent GBP 35.32 combined and require monitoring.

How

Sufficient Data -- Act Now

Campaign Ad Group Search Term Clicks Spend Action
21st AUTO (copy of bday earrings) 21st accessory 21st anniversary presents ladies 21 GBP 7.43 Add as Ad Group NEG. EXACT
18th accessory NEW AD 18th AUTO 18th anniversary presents 19 GBP 6.77 Add as Ad Group NEG. EXACT
21st AUTO (copy of bday earrings) 21st accessory 21st anniversary presents ladies 12 GBP 4.23 Add as Ad Group NEG. EXACT
18th AUTO exact match 18th bracelet anklets AUTO 18th anniversary decorations 7 GBP 3.44 Add as Ad Group NEG. EXACT
18th AUTO exact match 18th bracelet anklets AUTO 18th anniversary 7 GBP 3.35 Add as Ad Group NEG. EXACT
18th AUTO exact match 18th bracelet anklets AUTO 18th anniversary bracelet 7 GBP 3.11 Add as Ad Group NEG. EXACT

Insufficient Data -- Monitor

22 search term(s) with zero sales have insufficient data to act on. Total spend: GBP 35.32.

Campaign Ad Group Search Term Clicks Spend Reason
18th AUTO exact match 18th bracelet anklets AUTO 16th anniversary presents children accessory 6 GBP 2.84 Insufficient: 43 impressions (need 50); GBP 2.84 spend (need GBP 3.00)
16th AUTO copy of bday anklets 16th anklets and bracelet 16th anniversary presents children 8 GBP 2.54 Insufficient: GBP 2.54 spend (need GBP 3.00)
30th AUTO copy of bday anklets 30th accessory 30th anniversary accessory ladies 7 GBP 2.52 Insufficient: GBP 2.52 spend (need GBP 3.00)
18th AUTO exact match 18th bracelet anklets AUTO 18th anniversary present thoughts 5 GBP 2.49 Insufficient: 26 impressions (need 50); GBP 2.49 spend (need GBP 3.00)
21st AUTO (copy of bday earrings) 21st accessory 21st anniversary 6 GBP 2.16 Insufficient: 36 impressions (need 50); GBP 2.16 spend (need GBP 3.00)
16th AUTO copy of bday anklets 16th anklets and bracelet children 16th anniversary presents 7 GBP 2.05 Insufficient: GBP 2.05 spend (need GBP 3.00)
18th AUTO exact match 18th bracelet anklets AUTO 16th anniversary presents children 4 GBP 2.00 Insufficient: 4 clicks (need 5); GBP 2.00 spend (need GBP 3.00)
18th AUTO exact match 18th bracelet anklets AUTO 18th anniversary card 4 GBP 1.97 Insufficient: 4 clicks (need 5); GBP 1.97 spend (need GBP 3.00)
16th AUTO copy of bday anklets 16th anklets and bracelet 16th anniversary presents children 6 GBP 1.82 Insufficient: 45 impressions (need 50); GBP 1.82 spend (need GBP 3.00)
21st AUTO (copy of bday earrings) 21st accessory 40th anniversary presents ladies 5 GBP 1.73 Insufficient: GBP 1.73 spend (need GBP 3.00)

Showing top 10 of 22 terms by spend.

These terms need more data before a decision can be made. Re-run this analysis after the terms have accumulated additional clicks. Set a calendar reminder to review these in 2-4 weeks.


Section 7: Auto Too-Expensive Search Terms

What

Reduce bids on auto campaign search terms with ACoS above the target. Target ACoS is 25.0%.

Why

1 search term(s) are generating sales but at an ACoS above the 25.0% target. Reducing bids will bring these terms closer to profitability.

How

Sufficient Data -- Act Now

Campaign Ad Group Search Term Spend Sales ACoS Current CPC Action
16th AUTO copy of bday anklets 16th anklets and bracelet 16th anniversary presents children GBP 18.23 GBP 62.90 29.0% GBP 0.31 Reduce bid to GBP 0.27

Insufficient Data -- Monitor

No auto too-expensive terms with insufficient data found.


Section 8: Harvest Auto Campaign Winners

What

Harvest profitable auto campaign search terms into dedicated exact match campaigns for precise bid control.

Why

Auto campaigns discover new search terms but offer limited bid control. When a search term consistently converts profitably in an auto campaign, harvesting it to an exact match campaign lets you:
- Set precise bids on proven converters
- Prevent budget waste by negating the term in the auto campaign
- Scale winners with dedicated budgets and bid strategies

Auto campaigns have spent GBP 146.37 generating GBP 560.86 in sales. 5 search term(s) are converting profitably and ready to harvest into exact match.

How

Sufficient Data -- Act Now

5 search term(s) from auto campaigns are converting profitably and ready to harvest.

Campaign Ad Group Search Term Spend Sales ACoS
30th AUTO copy of bday anklets 30th accessory 30th anniversary presents ladies GBP 25.62 GBP 129.20 19.8%
18th AUTO exact match 18th bracelet anklets AUTO 18th anniversary gifts GBP 3.73 GBP 73.90 5.1%
18th AUTO exact match 18th bracelet anklets AUTO 18th anniversary accessory GBP 8.74 GBP 36.95 23.6%
50th AUTO copy of bday anklets 50th accessory 50th anniversary presents ladies GBP 5.05 GBP 25.95 19.5%
30th AUTO copy of bday anklets 30th accessory 30th anniversary accessory ladies GBP 5.05 GBP 23.96 21.1%

Insufficient Data -- Monitor

3 search term(s) are converting profitably but have insufficient data to act on. Total spend: GBP 4.41.

Campaign Ad Group Search Term Clicks Spend Reason
21st AUTO (copy of bday earrings) 21st accessory lilian belle accessory 5 GBP 1.61 Insufficient: 43 impressions (need 50); GBP 1.61 spend (need GBP 3.00)
21st AUTO (copy of bday earrings) 21st accessory 21st anniversary necklace ladies 4 GBP 1.40 Insufficient: 4 clicks (need 5); GBP 1.40 spend (need GBP 3.00)
Campaign - 30/10/2025 15:17:49.359 MANUAL precise targetting sisterhood necklace 7 GBP 1.40 Insufficient: GBP 1.40 spend (need GBP 3.00)

These terms need more data before harvesting. Re-run this analysis after they have accumulated additional clicks. Set a calendar reminder to review these in 2-4 weeks.


Section 9: Mixed Match Types in Ad Groups

What

Separate ad groups that contain multiple match types (e.g., BROAD and EXACT in the same ad group) into dedicated single-match-type ad groups.

Why

Seasoned advertisers generally advise against mixing match types for several reasons related to control, data clarity, and budget efficiency:

  • Cannibalization and Attribution: If you have the keyword espresso maker as both BROAD and EXACT in the same ad group, Amazon's algorithm might funnel a search for "espresso maker" through the BROAD keyword instead of the EXACT. This makes it impossible to see the true performance of your EXACT keyword because the BROAD is stealing its traffic.

  • Bidding Conflicts: You typically want to bid higher on EXACT (high intent) and lower on BROAD (discovery). When they are in the same ad group, they share the same budget and competing settings, making it difficult to scale winners without also scaling junk traffic from BROAD.

  • Reporting Chaos: It becomes much harder to pull a clean report and see which match type is driving your ACoS. You end up doing forensic accounting on why your spend spiked.

The Search Term Isolation (Funnels) Strategy:

Step Match Type Purpose Strategy
1. Discover Auto / Broad Find new ways customers search Low bids; add converting terms to next level
2. Refine Phrase Test the middle ground of relevance Moderate bids; use Negative Exact to prevent overlap
3. Dominate Exact Scale the proven winners Highest bids; maximum control for your money terms

How

Campaign Ad Group Match Types Found
21st prods (dupe of 30th accessory campaign +) 21st accessory present Manual Keywords BROAD, EXACT, PHRASE
30th accessory 30th accessory present Manual Keywords BROAD, PHRASE

Section 10: Multi-Product Ad Groups

What

Split ad groups containing multiple products into Single Product Ad Groups (SPAGs). Each ad group should advertise only one product (or identical variations).

Why

For most sellers, having multiple products in one ad group is considered a mistake. It is not that it will break your account, but it is inefficient and can lead to significant waste.

The Budget Hog Effect: Amazon's algorithm tends to favour the product that gets the earliest clicks or has the highest historical conversion rate. One product will eat up 90% of the ad group's budget, leaving other products with zero impressions. You will never know if those products could have been winners because they never got a chance to compete.

Irrelevant Keyword Matching: If you put a 'Blue Yoga Mat' and a 'Purple Yoga Mat' in the same ad group, they share keywords. A search for 'Purple Yoga Mat' might show the Blue Mat ad, leading to lower CTR, lower CVR, lower Ad Rank, and higher CPC.

Reporting Blind Spots: Keyword data aggregates across products. You cannot easily see if Product A is carrying the weight while Product B is bleeding money.

Exception: Identical variations (e.g., a 2-pack vs 3-pack of the same product) can reasonably share an ad group. Products with different ASINs should have their own ad groups.

The SPAG Strategy (Single Product Ad Group) gives you:
- Granular bid control per product
- Clean, unambiguous performance data
- Correct ad creative matching to the specific product

How

Campaign Ad Group Other SKU Sales
18th accessory NEW AD 18th AUTO GBP 96.85
30th AUTO copy of bday anklets 30th accessory GBP 96.70
21st AUTO (copy of bday earrings) 21st accessory GBP 76.20
40th accessory loose 40th presents GBP 50.95
30th accessory 30th accessory present Manual Keywords GBP 47.95

Section 11: Mixed Auto Targeting Types

What

Separate ad groups that contain multiple auto targeting sub-types (e.g., close-match and loose-match in the same ad group) into dedicated single-sub-type ad groups.

Why

Each auto targeting sub-type serves a different purpose and should receive a different bid level:

Sub-Type Relevancy Bid Strategy
close-match High (like EXACT) Set higher bids
loose-match Medium (like BROAD) Set moderate bids
substitutes Competitor product pages Strategic bidding
complements Cross-sell pages Typically lower bids

When multiple sub-types share an ad group, you cannot set different bids per targeting strategy. This prevents granular control over discovery spend vs. high-intent spend.

How

Sufficient Data -- Act Now

Campaign Ad Group Sub-Types Found Clicks Spend Sales
30th AUTO copy of bday anklets 30th accessory close-match, loose-match 89 GBP 31.75 GBP 153.16
16th AUTO copy of bday anklets 16th anklets and bracelet close-match, loose-match, substitutes 89 GBP 27.78 GBP 62.90
21st AUTO (copy of bday earrings) 21st accessory close-match, loose-match 63 GBP 21.93 GBP 108.15
18th accessory NEW AD 18th AUTO loose-match, substitutes 62 GBP 21.90 GBP 73.90
50th AUTO copy of bday anklets 50th accessory close-match, loose-match 21 GBP 7.41 GBP 25.95

Insufficient Data -- Monitor

No mixed auto ad groups with insufficient data found.


Report generated by Amazon PPC Action Plan Generator

This is a sample report. Upload your data to generate your own.

Get Your Report

Enter your target ACoS and minimum thresholds for decision-making, then upload your search term report.