Question 1

What does the Amazon Search Term Analyzer do?

Accepted Answer

It groups a Sponsored Products seller search term report by campaign, ad group and customer search term. Your thresholds identify possible targeting opportunities, exclusions to review, inefficient terms and cases that need more data. Every suggestion includes its reason.

Question 2

Which report should I use?

Accepted Answer

Download one Sponsored Products Search term report from Amazon Ads: reporting → sponsored ads reports → Sponsored Products → Search term. CSV, TSV and a single-sheet XLSX are supported, up to 10 MB and 100,000 rows. Include campaign, ad group, search term, clicks, spend, total sales and total purchases/orders. Use one account and currency.

Question 3

Does this work with German reports?

Accepted Answer

English and common German column names are recognized. Select the number/date format before importing: EN uses 1,234.56 and month/day/year; DE uses 1.234,56 and day/month/year. ISO dates work with either setting. Unsupported or missing columns produce a clear error; missing metrics never become zero.

Question 4

How are ACOS and the review rules calculated?

Accepted Answer

ACOS is total spend divided by total attributed sales, multiplied by 100. Targeting candidates meet your purchase minimum and target ACOS. Exclusion reviews require zero purchases and sales, plus both your click and spend minimums. Terms with enough purchases and clicks but ACOS above target are efficiency reviews. Thresholds are editable examples, not universal benchmarks.

Question 5

Will the tool change my Amazon campaigns?

Accepted Answer

No. Results and downloads are review worksheets, not Amazon bulk upload files. Before making changes, check relevance, your margins, existing keywords and negatives, and the advertised products. The report alone cannot establish which terms are new targets or map every campaign to an advertised ASIN.

Question 6

Which attribution window does it use?

Accepted Answer

Matching 7-day total sales and purchases are preferred. Unified Sales/Purchases are treated as 7-day totals for Sponsored Products sellers. Matching 14-day columns retain their 14-day label. Chosen column names are shown. Recent periods carry a warning because conversions can arrive later; the additional three-day buffer is a cautious tool rule, not a guarantee of final data.

Question 7

Are my files uploaded or stored?

Accepted Answer

The report is read in your browser and is not sent to SYNQ or Amazon. No account or email is required. Clear the report or close the tab to remove the working data. Page-visit analytics do not receive report contents. Downloaded files remain on your device until you delete them.

Question 8

How is this different from N-Gram Analysis?

Accepted Answer

N-Gram Analysis compares word combinations across search terms. This analyzer produces a review list for complete search terms within each campaign and ad group. Use them together to understand language patterns and then inspect specific terms.

Question 9

Does an exclusion review mean guaranteed wasted spend?

Accepted Answer

No. It means the row matches your review thresholds. A small sample, delayed attribution, a launch objective or a relevant brand query can change the decision. Protected phrases are excluded from both targeting and exclusion recommendations. No savings or ranking improvement is promised.

Question 10

Does the export include rows on other pages?

Accepted Answer

Yes. The CSV contains every group matching the action and text filters, including groups on other table pages. Each row includes the report period, currency, attribution window, thresholds and coverage note. It does not export only the currently visible page.

Amazon PPC Search Term Analyzer

Your next PPC review starts here.

How to use your review list

Frequently asked questions

Related Free Amazon Tools

N-Gram Analysis

ACOS Target Calculator

Search Term Impression Share Analyzer