Copy and paste into your AI tool
You are a senior Amazon brand analytics specialist with expertise in translating platform data into commercial strategy for consumer brands.

BEFORE YOU EXECUTE:
1. Confirm which Brand Analytics report(s) data is being provided -- Search Query Performance, Market Basket Analysis, Repeat Purchase Behavior, or multiple. The analysis approach differs for each.
2. Brand Analytics is available to Brand Registry-enrolled sellers only. If the seller does not have Brand Registry, this prompt is not applicable.
3. Do not fabricate benchmarks. If industry average click-through rates or conversion rates are referenced, state clearly that these are directional estimates, not Amazon-provided standards.
4. Search Query Performance data is available at WEEK, MONTH, and QUARTER granularity. Confirm the time period of the data provided to contextualize trends accurately.
5. Flag any data anomalies (sudden drops, zero values, extreme outliers) before drawing conclusions -- these often indicate reporting gaps, not real performance changes.

POLICY REMINDER: Amazon Brand Analytics currently includes: Search Query Performance Report, Market Basket Analysis Report, Repeat Purchase Behavior Report, Top Search Terms Report, and Demographics Report. Search Frequency Rank is available within search-related reports and reflects how frequently a query is searched relative to all queries in that period. Report availability and features may change -- verify your current report access in Seller Central > Brand Analytics. Access requires Brand Registry enrollment.

---

TASK: Analyze the Brand Analytics data provided and produce a prioritized action plan for the brand.

OUTPUT FORMAT:

---

**[IF SEARCH QUERY PERFORMANCE DATA IS PROVIDED]**

**SECTION A -- SEARCH QUERY PERFORMANCE ANALYSIS**

**A1 -- Top Performing Queries**
| Query | Search Frequency Rank | Brand Impressions | Brand Clicks | Brand Cart Adds | Brand Purchases | Click Share | Purchase Share |
|---|---|---|---|---|---|---|---|
[Populate from data -- top 10 queries by purchase share]

**A2 -- Opportunity Gaps (high impressions, low click share)**
| Query | SFR | Brand Impressions | Brand Click Share | Gap vs. Leader | Recommended Action |
|---|---|---|---|---|---|

Interpretation: These are queries where customers are seeing your brand but choosing a competitor. Closing the click-share gap on 2-3 of these could materially move revenue.

**A3 -- Keyword Strategy Implications**
1. Title / bullet copy recommendations: [specific keywords to add or move based on SQP data]
2. Backend search term gaps: [queries with impressions but zero purchases -- test in backend]
3. PPC bidding recommendations: [queries where brand purchase share is strong -- reduce bids; queries where share is weak vs. SFR -- increase bids or test new campaign]
4. New product opportunities: [queries with very high SFR where brand has zero presence]

---

**[IF MARKET BASKET ANALYSIS DATA IS PROVIDED]**

**SECTION B -- MARKET BASKET ANALYSIS**

**B1 -- Top Co-Purchase Pairs**
| Your ASIN | Frequently Bought With ASIN | Category | Combination Rate | Action |
|---|---|---|---|---|

**B2 -- Strategic Implications**
1. Bundle opportunity: [specific products that co-purchase frequently -- build a virtual or physical bundle]
2. Cross-merchandising: [use "Frequently Bought Together" data to inform A+ Content cross-sell modules]
3. Competitor co-purchase risk: [are customers buying your product alongside a competitor's? What does this signal?]
4. Brand portfolio gaps: [are customers buying accessories or complementary products you don't sell? Size of the adjacent opportunity?]

---

**[IF REPEAT PURCHASE BEHAVIOR DATA IS PROVIDED]**

**SECTION C -- REPEAT PURCHASE BEHAVIOR ANALYSIS**

**C1 -- Repurchase Summary**
| ASIN | Repeat Purchase Rate | Avg. Days Between Orders | New Customer % | Repeat Customer % |
|---|---|---|---|---|

**C2 -- Interpretation by Segment**
High repeat rate (>30%): [what this signals and how to capitalize -- Subscribe and Save eligibility, loyalty focus]
Low repeat rate (<15%) for a consumable: [diagnoses and corrective actions -- quality review, competitor switching, one-time gifting pattern]
Long days-between-orders for a consumable: [inventory and Subscribe and Save frequency implications]

**C3 -- Recommended Actions by ASIN**
| ASIN | Repeat Rate | Priority Action | Expected Outcome |
|---|---|---|---|

---

**SECTION D -- INTEGRATED INSIGHTS AND PRIORITY ACTION LIST**
Synthesize findings across all reports provided into a ranked action list:

| Priority | Action | Report Source | Estimated Impact | Effort | Owner |
|---|---|---|---|---|---|
| 1 | | | | | |
| 2 | | | | | |
| 3 | | | | | |
| 4 | | | | | |
| 5 | | | | | |

**SECTION E -- DATA QUALITY FLAGS**
List any anomalies, gaps, or limitations in the data that could affect the reliability of the analysis above.

PASTE YOUR DATA BELOW. Include: which Brand Analytics report(s) you are sharing data from, the time period covered (week/month/quarter and date range), the raw data export (paste as CSV or table), and any specific business question you want the analysis to answer. [YOUR DATA HERE]
What you'd paste after the divider
Report: Search Query Performance
Time period: Q1 2026 (January-March)
ASINs: B09XXXXXX (Silicone Baking Mat Set)
Business question: Which keywords should we prioritize for PPC and listing updates?

[Paste SQP export data here -- columns: Search Query, Search Frequency Rank, Brand Impressions, Brand Clicks, Brand Click Share, Brand Cart Adds, Brand Purchase Share]
01

Export Search Query Performance at the QUARTER level for strategic planning and at the WEEK level when diagnosing a sudden rank drop -- the weekly view reveals the specific period where performance changed.

02

Search Frequency Rank is relative, not absolute -- a rank of 500 in a high-volume category may represent more total searches than a rank of 50 in a niche category. Always read SFR alongside your impression volume for context.

03

Run Market Basket Analysis on your top 5 ASINs by revenue quarterly. The co-purchase data changes as the competitive landscape shifts, and what was true 12 months ago may not reflect current buyer behavior.

What does the Brand Analytics Interpreter prompt do?
This prompt turns raw Amazon Brand Analytics exports into specific, actionable decisions. It works across the three most commercially valuable reports -- Search Query Performance, Market Basket Analysis, and Repeat Purchase Behavior -- so sellers can act on the data rather than just read it.
What data do I need to use this prompt?
An example of the exact input format is provided on this page under "Example Input." Generally you'll prepare your data in the structure shown, paste it after the prompt body, and the AI will return the analysis described above. If you're missing any inputs, the prompt will ask you what it needs.
How long does this take to set up?
Setup time for this prompt is 30-60 mins. That includes pulling your data, formatting it to match the example, and running the prompt. Once your data pipeline is set up the first time, subsequent runs take only a few minutes.
Which AI tool should I use this with?
This prompt is designed to work with any major large language model — ChatGPT (GPT-4 or newer), Claude (Sonnet 4 or newer), or Gemini. For structured analysis, math, and tabular outputs, Claude and GPT-4 class models produce the most reliable results.
Does this prompt work for Shopify or other platforms?
This prompt is built for Amazon sellers and references Amazon-specific data points such as referral fees, FBA fulfillment fees, and ASIN-level metrics. The underlying methodology can be adapted to other platforms by substituting equivalent inputs, but the prompt as written is Amazon-first.
What skill level is required to use this prompt?
This prompt is rated intermediate. Some familiarity with your platform's data exports and basic AI prompting is helpful for getting the most out of it. Most ecommerce operators can use it productively within a single session.
Is this prompt free to use?
Yes. Every prompt in the SMB Advantage Prompt Library is free for any small business operator to use. The only cost is whatever you pay for your AI tool subscription (ChatGPT Plus, Claude Pro, etc.).
Stay in the loop

Want notes when new prompts ship?

A few times a week, field notes on what's actually working when AI meets ecommerce ops. Plus first look at new prompts and tools as they go live.