Site Search Zero-Results Analysis Builder
Analyze onsite search queries that return zero results, cluster intent, size revenue impact, and prioritize fixes for ecommerce or content discovery.
Prompt Template
You are a product analytics lead. Analyze onsite search zero-results data for [website/app/store] and identify fixes that improve discovery and conversion. Data context: - Site type: [ecommerce, marketplace, help center, SaaS app, media library, documentation site] - Time period: [date range] - Fields available: [query, user/session ID, timestamp, result count, clicked result, conversion, revenue, category, device, locale] - Search system details: [Algolia, Elasticsearch, native CMS search, Shopify, custom, unknown] - Query volume and traffic: [total searches, zero-result searches, sessions] - Business goals: [conversion, self-service success, product discovery, support deflection, content engagement] - Known issues: [synonyms missing, typos, out-of-stock items, naming mismatch, locale/language, discontinued products] - Segments to compare: [new vs returning, geography, device, source, customer tier, product category] - Quality concerns: [bots, internal users, test queries, PII, spam, low volume] Deliver: 1. Data cleaning plan for casing, punctuation, typos, PII, bots, and duplicate queries. 2. Zero-results rate calculation and trend summary. 3. Query clustering by intent, product/content gap, synonym gap, typo, unavailable item, and navigation query. 4. Opportunity sizing by query volume, affected sessions, downstream conversion, revenue, or support impact. 5. Prioritized fix backlog: synonyms, redirects, merchandising rules, content creation, inventory/category mapping, UI changes. 6. Example SQL or analysis steps if fields are available. 7. Dashboard layout with filters, charts, and alert thresholds. 8. Experiment plan to measure impact after fixes. Be careful with small samples and privacy. Focus on changes that help users find what they meant, not just reducing the zero-results number.
Example Output
Zero-Results Summary
Zero-results searches account for 14.8% of all searches, up from 9.6% last month. The largest cluster is synonym mismatch: users search "rain jacket" while products are tagged as "shell jacket."
| Cluster | Example Queries | Searches | Likely Fix | Priority |
|---|---|---:|---|---|
| Synonym gap | rain jacket, waterproof coat | 1,840 | Add synonym and category boost | High |
| Out-of-stock demand | black linen pants size M | 620 | Back-in-stock capture + related items | Medium |
| Typo/misspelling | sandles, watter bottle | 410 | Fuzzy matching | Medium |
Experiment
Add synonyms for the top 20 validated query pairs and measure zero-results rate, search-to-product-click rate, and revenue per search session for two weeks against the previous baseline.
Alert
Trigger review when zero-results rate rises above 12% for three consecutive days or any single query exceeds 100 zero-result searches in 24 hours.
Tips for Best Results
- ๐กCluster queries by user intent before prescribing fixes; typo, synonym, and inventory gaps need different remedies.
- ๐กInclude conversion or revenue fields if available so prioritization is not just query volume karaoke.
- ๐กFilter internal, bot, and PII-heavy searches before sharing examples widely.
- ๐กMeasure search-to-click and conversion after fixes; reducing zero results is not enough if results are irrelevant.
Related Prompts
Dataset Summary and Insights
Paste or describe a dataset and get an instant summary of key statistics, patterns, anomalies, and actionable insights.
SQL Query Writer for Business Reports
Generate SQL queries for common business reporting needs โ revenue trends, cohort analysis, funnel metrics, and more.
Dashboard KPI Definition Framework
Define the right KPIs for your business dashboard with clear formulas, targets, and data sources.