Skip to content

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, conversions
Business 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 acceptably
RULES:
- 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