Get a monthly keyword ranking report for each Amazon product in minutes instead of hours of exports: AI agent prompt
Amazon and Walmart sellers and the agencies that manage them spend days each month exporting keyword rankings and search volumes into spreadsheets to see what's slipping. An AI agent can pull those numbers together for each product and point out what changed and what to do next. Helium 10 reported on Oct 21, 2026 that ecommerce agency CoreTrex now asks its Helium agent for a ranking-shift and search-volume report per product (ASIN), cutting each report from 30 to 45 minutes down to 5 to 10, about 80% less time, so the team reviews keywords far more often and adjusts targeting and ad spend faster.
EcommerceAmazon keyword ranking reportsbeginnerThe prompt
I sell [product] on [Amazon / Walmart], product ID [ASIN or item ID]. Here's my keyword data for the last [3] months: [paste export with keyword, rank by date and monthly search volume]. Here's my ad spend by keyword if I have it: [paste or 'none']. 1) Show the top 20 keywords by search volume with my rank then and now, and mark each as rising, falling or steady. 2) Call out the 5 biggest drops and the 5 biggest gains and a likely reason for each, labeled as a guess. 3) List high-volume keywords where I rank poorly or not at all that fit my product. 4) Recommend what to change in my title, bullets and backend keywords, and where to raise, lower or pause ad spend. 5) Finish with a 5-line summary I can send a client or partner. Use only the numbers I gave you.
How to use it
- Copy the prompt above.
- Replace every [bracket] with your own details (or fill in the blanks on AgentPlaybook Real Estate, which remembers your answers for the next prompt).
- Paste it into Helium 10, ChatGPT, Claude and review the answer before you use it.
Works with: Helium 10, ChatGPT, Claude, Grok Bot, Google Sheets, Excel
Real-world example: helium10.com/blog/reduce-keyword-analysis-time-with-our-new-agent-heli
Featured in: Free AI agent prompts for small business (beginner-friendly) · AI prompts for Google Sheets and Excel work · AI prompts for writing SOPs, reports, policies and checklists · AI prompts for marketing agencies, consultants and freelancers
Before you use it: what to check
Check yourself
- This prompt works on text other people wrote (emails, reviews, messages or web pages). That text can hide instructions aimed at AI, such as "ignore your rules and…". Paste it as material to work on, and never let the AI act on requests inside it, like paying, sharing logins or changing records. How prompt injection works →
- Check hours, breaks, overtime and any rules for young workers against your local labour law and staff contracts before you publish a schedule.
- Remove names, contact details, account numbers and other personal data the task doesn't need before you paste, and check your AI tool's data and training settings.
- Read and edit the draft before it reaches a customer or goes public. If you later automate this prompt, start with "draft and notify me", not "send automatically".
Using an AI agent? Download this prompt as a SKILL.md agent skill with these checks built in, or get the .zip for Claude.ai. How to install skills.
Want to make this prompt even better? Grade it with the free prompt grader or build your own with the AI prompt generator.
32 copy-paste agent prompts (PDF) plus 5 new prompts every week.
Get it free