Skip to content
Picaro.AI Picaro.AI Prompt Library

Analyze where shoppers drop off from search to purchase (SQP)

On this page you find which stage of the journey — from a shopper searching on Amazon to making a purchase — is weakest, broken down by product × search term. You can see where you’re losing shoppers across the funnel — searched and shown → clicked → added to cart → purchased — so you can tie the findings back to improving your ads or product pages.

Whereas Analyze high-performing search patterns with N-grams uses ad data to look at efficiency inside your own ads, this page analyzes the search behavior of all Amazon shoppers (the whole market).

About this page

Section titled “About this page”
ItemDetails
What you can doList, for each product × search term, which stage from search to purchase is the bottleneck, and find the ones with the most room to grow (opportunity score)
Applies toWhole-market search data (SQP data derived from Amazon Brand Analytics). It reveals the search behavior of all Amazon users, not your own ad performance
Data & connection neededProducts that already have SQP data imported (on a connected account, with SQP available for the target products)
ScopeRead-only (analysis only). The prompts on this page only list the state of the funnel; they don’t change or record any ad settings or product pages

When to use this

Section titled “When to use this”
  • You want to find, by product × search term, which stage from search to purchase is weakest
  • You want to pinpoint bottlenecks such as being shown but not clicked, or added to cart but not purchased
  • You want to know, as a priority, which search terms have the most room to grow (opportunity score)
  • You want to check how the search funnel moves month to month due to seasonal factors and medium-to-long-term trends
  • You want to confirm, before building the end-of-month report, that the data needed for the contribution slide is already in place

Before you run

Section titled “Before you run”
  • Whether SQP data exists … products that don’t have SQP data imported can’t be analyzed. Only products with data already fetched are eligible.
  • How to specify the target product … specify a product by ASIN (e.g. B0XXXXXXXX) or internal ID (the management ID of a product registered in Picaro). Decide in advance which number you’ll use, so you don’t mix them up.
  • The period you can fetch … Amazon’s report finalization has a lag of several days, so the current latest week and latest month aren’t usable yet. The last week / last month in the list of available periods is the finalized period.
  • When data first became available … the SQP data start date differs by product. First check the list of available periods, then pick the target period.

Quick reference

Section titled “Quick reference”
GoalWhat you getChangesPrompt
Find the search-funnel weak spot (bottleneck) for each productA list of opportunity scores and bottleneck classifications by product × search termNo changePrompt 1
Check how the search funnel moves month to monthA list of monthly opportunity scores, bottlenecks, and change vs. the previous monthNo changePrompt 2
Confirm contribution data is ready before building a reportA verdict on whether the data exists, row counts, anonymization rate, and fallback availabilityNo changePrompt 3

Prompt 1: Find the search-funnel weak spot for each product

Section titled “Prompt 1: Find the search-funnel weak spot for each product”

After confirming the SQP-eligible products and their available periods in order, compute the opportunity score and bottleneck for each stage from search to purchase, by product × search term.

When to use — when you want to work out which search term is losing shoppers at which stage (impression / click / cart add / purchase).

What you need — nothing in particular (the AI proposes the target product and period for you to choose from). The number of rows to show (top 30 in the example).

I want to run an SQP analysis. Follow these steps:
1. Confirm which products have SQP data available
2. Pick a target product and fetch its available weekly periods
3. Run a funnel analysis on the top 30 for the latest finalized week
   Return the opportunity score and bottleneck classification

What you can change — the number of rows (e.g. top 30) / the target product / the target week.

What you get back — a table that lists, for each product × search term, the opportunity score × your own purchase share × bottleneck classification (low impressions / low click-through rate / low cart-add rate / low purchase rate).

Changes — analysis only. Does not change ad settings or records.

Next steps — for terms with a high opportunity score, consider raising bids through the approval flow in Adjust bids. If you want to cross-check against the search patterns inside your own ads, use Analyze high-performing search patterns with N-grams.

Prompt 2: Check how the search funnel moves month to month

Section titled “Prompt 2: Check how the search funnel moves month to month”

Over a longer span than weekly, capture how a product’s search funnel moves with seasonal factors and medium-to-long-term trends, on a monthly basis.

When to use — when you want to confirm, from the month-to-month trend, whether a search-funnel weak spot is temporary or an ongoing tendency.

What you need — the target product (ASIN or internal ID). The number of rows to show (top 30 in the example).

For product {{TARGET_PRODUCT (e.g. B0XXXXXXXX)}}, run an SQP analysis by month.
After confirming the available months, use the latest finalized month and the top 30,
and return the opportunity score and bottleneck classification.

What you can change — the target product (specified by ASIN or internal ID) / the number of rows (e.g. top 30) / the target month.

What you get back — a table that lists, for each monthly search term, the opportunity score × your own purchase share × bottleneck × change vs. the previous month.

Changes — analysis only. Does not change ad settings or records.

Next steps — for terms where you’ve confirmed a trend, consider how to respond through the approval flows in Adjust bids or Add negative keywords.

Prompt 3: Confirm contribution data is ready before building a report

Section titled “Prompt 3: Confirm contribution data is ready before building a report”

Before generating the end-of-month report, run a lightweight check that confirms the SQP and ad data needed for the contribution slide is in place.

When to use — when you want to confirm, before spending time on report generation, that there’s enough data for the target period and that anonymization hasn’t thinned it out.

What you need — the target period and the comparison period (the current and previous month in the example).

Run a contribution data precheck for period {{TARGET_PERIOD (e.g. 2026-04-01 to 2026-04-30)}} and comparison period {{COMPARISON_PERIOD (e.g. 2026-03-01 to 2026-03-31)}}.
Return the analysis-data discovery result, the row counts for the target and comparison periods,
the share of anonymized search terms, and whether fallback data can fill any gaps.

What you can change — the target period / the comparison period.

What you get back — whether the data exists × the row counts for each period × the anonymization rate × whether fallback data can fill any gaps, plus one of the following three verdicts.

  • Ready … the report can be generated as is.
  • Needs confirmation … generation is possible, but you need to watch the anonymization rate or data volume.
  • Blocked … there isn’t enough data to generate the report.

Changes — analysis only. Does not change ad settings or records.

Next steps — if the verdict is “Ready,” proceed to Generate a report. If it’s “Blocked,” widen the target period, or fall back to the alternatives in Prompt 2 to match a period where data is available.

Section titled “Related”