N-gram Analysis
Automate keyword optimization for Amazon PPC campaigns
Upload Search Term Report
Drag and drop your CSV file here, or click to browse
N-gram Tool
/
Dashboard
Analytics
Detailed insights from your uploaded search term report
No Data Available
Upload and process a CSV file from the Dashboard to see analytics.
Overview
Total Campaigns
0
Total Monograms
0
Total Bigrams
0
Total Trigrams
0
Financial Summary
Total Spend
$0.00
Across all campaigns
Total Sales
$0.00
Revenue generated
Overall ACOS
0%
Advertising Cost of Sales
Total Orders
0
Conversions
Campaign Breakdown
| Campaign Name | Monograms | Bigrams | Trigrams | Search Terms | Spend | Sales |
|---|
N-gram Distribution by Campaign
Archive
View and manage your archived N-gram analysis reports
No Archived Reports
Process a CSV file and click "Archive Report" to save it here.
Documentation
Complete guide to using the N-gram Automation Tool
What is the N-gram Automation Tool?
The N-gram Automation Tool is a powerful web application designed specifically for Amazon PPC advertisers to analyze and optimize their search term reports. It automatically extracts N-grams (word combinations) from your search terms and helps you identify keywords that should be negated to improve campaign performance and reduce wasted ad spend.
Understanding N-grams
N-grams are contiguous sequences of words extracted from your search terms. This tool generates three types of N-grams:
Monograms (1-word)
Single words extracted from search terms.
Example: From "wireless bluetooth headphones"
- wireless
- bluetooth
- headphones
Useful for identifying broad irrelevant terms like competitor brand names or completely unrelated products.
Bigrams (2-word)
Two consecutive words from search terms.
Example: From "wireless bluetooth headphones"
- wireless bluetooth
- bluetooth headphones
Ideal for finding phrase patterns that indicate poor intent or low-converting combinations.
Trigrams (3-word)
Three consecutive words from search terms.
Example: From "best wireless bluetooth headphones"
- best wireless bluetooth
- wireless bluetooth headphones
Perfect for identifying specific long-tail phrases that consistently underperform.
How to Use This Tool
1
Export Your Search Term Report
In Amazon Seller Central or your advertising console, navigate to Reports > Advertising Reports > Search Term Report. Download the report as a CSV file. Make sure to select an appropriate date range (typically 30-60 days for meaningful data).
2
Upload Your CSV File
On the Dashboard, drag and drop your CSV file onto the upload area, or click "Browse Files" to select it. The tool accepts standard Amazon search term report format with columns for Campaign Name, Search Term, Impressions, Clicks, Spend, Orders, and Sales.
3
Process the File
Click the "Process File" button. The tool will automatically:
- Filter out ASIN entries (product targeting, not keyword targeting)
- Group data by campaign name
- Extract all monograms, bigrams, and trigrams
- Calculate aggregated metrics (CTR, CVR, CPC, ACOS) for each N-gram
4
Download & Analyze the Excel Report
Download the generated Excel file. Each campaign gets its own sheet with organized sections for Monograms, Bigrams, Trigrams, and Search Terms. Review the metrics to identify poor performers.
5
Add Keywords to Reference Columns
In the Excel file, you'll find three reference columns at the end: Monogram, Bigram, and Trigram. Add the N-grams you want to negate to these columns. The NE/NP column will automatically show "NP" (Negative Phrase) for any matching N-grams in the data.
Understanding the Excel Output
The generated Excel file contains the following structure:
| Sheet | Description |
|---|---|
| Summary | Overview with hyperlinks to all campaign sheets for easy navigation. |
| [Campaign Name] | Individual sheet per campaign with Monogram, Bigram, Trigram, and Search Term sections arranged horizontally. |
Metrics Explained
| Metric | Description | Formula |
|---|---|---|
| CTR | Click-Through Rate - percentage of impressions that resulted in clicks | (Clicks / Impressions) x 100 |
| CVR | Conversion Rate - percentage of clicks that resulted in orders | (Orders / Clicks) x 100 |
| CPC | Cost Per Click - average amount paid for each click | Spend / Clicks |
| ACOS | Advertising Cost of Sales - percentage of sales spent on advertising | (Spend / Sales) x 100 |
Identifying Keywords to Negate
Look for N-grams with these characteristics:
High Spend, Zero Sales
N-grams with significant spend but no conversions. These are clear candidates for negation.
High ACOS (>100%)
Keywords where you're spending more on ads than you're making in sales. Typically unsustainable.
Low CTR (<0.2%)
Search terms that rarely get clicked may indicate poor relevance to your product.
Low CVR with High Clicks
Getting clicks but no conversions suggests the search intent doesn't match your product.
Best Practices
- Regular Analysis: Run this analysis weekly or bi-weekly to continuously optimize your campaigns.
- Start with High Spend: Focus first on N-grams with the highest spend and no/low sales.
- Consider Context: Before negating, consider if an N-gram might be valuable in certain contexts. Use phrase negatives instead of exact when appropriate.
- Archive Reports: Use the Archive feature to track your analysis history and compare performance over time.
- Test Incrementally: Don't negate too many keywords at once. Make changes incrementally and monitor results.
- Review Trigrams First: Trigrams are more specific and safer to negate as they won't block as many search terms as monograms.
Frequently Asked Questions
Why are ASINs filtered out?
ASINs (starting with "B0") represent product targeting, not keyword targeting. They require different analysis and negation strategies, so they're excluded from N-gram analysis which focuses on search term keywords.
What's the difference between NE and NP?
NE = Negative Exact (blocks only the exact search term), NP = Negative Phrase (blocks any search containing that phrase). This tool uses NP to mark keywords for phrase-level negation.
How do the reference columns work?
Add keywords you want to negate to the Monogram, Bigram, or Trigram reference columns. Excel formulas automatically check each N-gram against its corresponding reference column and display "NP" if there's a match.
Can I process multiple files?
Currently, the tool processes one file at a time. For multiple date ranges, combine your CSV files before uploading, or process them separately and compare using the Archive feature.