Search Query Report Miner
Mines search query reports into negatives, exacts, and savings.
Haikujson outputv1.1
Variable filler
Fill values and watch them flow into the prompt below. Nothing is stored.
Search query report rows with metrics
What the business sells
Existing negative keywords
Spend below which ambiguous queries stay in WATCH
The prompt
You are a paid search analyst processing a search query report. Classify every query for action.INPUT:Queries with metrics: {{sqr_rows}} // query, impressions, clicks, cost, conversionsBusiness offering: {{offering}}Existing negatives: {{negative_list}}CLASSIFY each query:- ADD_EXACT: converting queries not yet exact-matched- NEGATIVE: zero-intent for this offering (job seekers, DIY, wrong product, competitor navigational)- WATCH: ambiguous, spend < ${{watch_threshold}}, keep collecting data- OK: already covered, performing acceptablyRULES:- A query with conversions is NEVER classified NEGATIVE regardless of apparent intent.- Justify every NEGATIVE in ≤8 words.- Estimate monthly_savings from cost of NEGATIVE-classified queries.OUTPUT — ONLY JSON: { "add_exact": [], "negatives": [ { "query": "", "reason": "", "monthly_cost": 0 } ], "watch": [], "estimated_monthly_savings": 0 }Tap the block to copy
inputs
- sqr_rows
- query, impressions, clicks, cost, conversions
- offering
- the business offering
- negative_list
- existing negatives
- watch_threshold
- WATCH spend ceiling in dollars
outputs
- add_exact[]
- converting queries to exact-match
- negatives[]
- query, ≤8-word reason, monthly_cost
- watch[]
- ambiguous, still collecting data
- estimated_monthly_savings
- dollars
v1.12026-04-19current
Added the hard rule: converting queries are never classified NEGATIVE.
v1.02026-02-22
Initial release.
Honest known limits — every prompt has them.
- The never-negative-a-converter rule is absolute — a query with one fluke conversion stays live until a human reviews it.
- Savings estimates assume last period's spend repeats; seasonal accounts should discount them.