Internal Amazon rank tracking: how to track 500 keywords without third-party tools

Why third-party Amazon rank trackers cap out

Helium 10. Jungle Scout. Sellics. DataDive. Sellerboard. Convenient for 50 keywords on a single ASIN, these tools are quickly limited once you move to 500 keywords across 30 products.

Three ceilings come back every time.

Pricing scales linearly with keyword count. On a catalogue of 50 active ASINs, tracking ten keywords per product means 500 keywords. You move up a tier, you pay more, and the scraped data loses precision because Amazon varies its results by user, location and history.

The history is not yours. The day you change tool, you start from zero. Over eighteen months of data, that is an asset you leave behind.

And the data is not connected to anything else. Rank on its own steers nothing. You want to cross rank with the budget you injected that day, stock availability, category best seller rank, the competitor who just entered. With a third-party tool you export to CSV and consolidate by hand.

That is why some teams build their own tracking in-house. Here is how it can work.

‍

One possible stack: Search Term Reports, the Bulk API and Python

Three components, all official Amazon. No paid third-party tool.

Amazon Ads Search Term Reports. They list every search term that triggered your Sponsored Products and Sponsored Brands campaigns, with impressions, clicks, spend, sales and average position. That is what your customers actually type, not what you assume they type.

The Bulk Operations API. It pulls campaign, ad group and keyword performance as CSV through the official API. No scraping. No risk of being blocked. Generous quotas.

Python and a light database, PostgreSQL or SQLite depending on the account. A script that runs daily. Maintainable, owned, exportable.

No heavy cloud needed. A small server and a cron job are enough to start. What matters is not sophistication. It is keeping the data yourself and not hitting a pricing ceiling.

‍

What happens every morning at four

The cron pulls yesterday's Search Term Reports and Bulk Reports. The script writes them into a dated folder.

It parses, normalises (case, accents, spacing) and stores everything with impressions, clicks, spend, sales, average position, return on ad spend and cost of sales.

For each tracked keyword it computes an impression-weighted average rank over a rolling seven days. That is far more stable than a 24-hour snapshot, which can swing wildly by time of day. It also stores the minimum and maximum rank, to surface volatility.

For each product and each keyword, it keeps today's rank, the rank seven days ago, the delta, and a green, amber or red status against a threshold. If a keyword drops out of the top ten having been there yesterday, an alert goes out by Slack or email.

‍

What it changes in practice

Without internal rank tracking, you notice a rank drop when you see revenue fall: seven to ten days after the drop began. By the time you have identified the cause, whether a competitor scaling, a broken listing, a stockout or seasonality, you have already lost several days of sales.

With internal rank tracking, you see the drop the next day. You cross it with the Bulk Reports within two hours. You identify the cause. You redeploy budget or raise bids before the week is out.

It is less glamorous than a new DSP stack, but it is one of the highest-return levers to put in place on an account that is scaling. See our approach for the other levers.

‍

A concrete case: Polar

On the Polar account (former client, 11 countries, Amazon advertising and DSP), ROAS went from 13.84 to 17.33 in 2025 compared with 2024, on a budget down 32%. This figure is not tied to rank tracking. In general, catching rank drops the next day rather than ten days later allows faster budget and bid decisions.

Results from a real client case. Past performance does not guarantee future results. Outcomes vary by catalogue, budget, category and competition.

‍

The limits, worth knowing before you copy it

Rank derived from Search Term Reports is not a raw search results rank. It is the weighted average position of your paid advertisement on that term. A good proxy for operational monitoring. Not equivalent to scraping the results page, which shows you the organic and sponsored top ten at a given moment for a given user. If you need fine competitive analysis, keep an occasional Helium 10 subscription.

You also need enough advertising volume to generate the data. A keyword you run no advertising on does not appear in Search Term Reports. To track purely organic keywords you need to run a periodic targeted Sponsored Products campaign, even on a small budget, or supplement with a third-party tool.

And you need a minimum of technical skill in-house. Not big data, but intermediate Python and some SQL. If you do not have the resource, you outsource it to an agency or you stay on a third-party tool.

‍

‍

Questions we get asked

Can I build it myself?

Yes, if you have someone in-house with intermediate Python and a working notion of APIs. Otherwise, outsourcing to an agency or a technical freelancer can work out cheaper than paying for a third-party tool.

How many keywords can it track?

Tracking is limited only by your API quotas and your database: beyond a few thousand keywords the database needs more care.

How does it differ from Helium 10 Cerebro or Jungle Scout Keyword Scout?

Those are excellent tools for finding new keywords to target. They are less suited to daily tracking of a large portfolio of keywords you have already identified. The two approaches are complementary.

Does it work for other marketplaces?

Yes. Multi-marketplace from the start. You point the script at the right Amazon Ads profile identifier. A brand selling on five marketplaces is tracked on all five.

How do I know whether it applies to my account?

A complimentary audit: a 30-minute call, then our analysis of your catalogue, your advertising volume and your current tracking. Book the audit.

‍

The last word

Internal rank tracking is not a technical gadget. It is an operational advantage: you see drops the next day instead of ten days later, and you keep ownership of years of history.

To see how it would apply to your account: book the free audit. See also our DSP offer and our seven mistakes that cap return on ad spend.

‍