Static operator tooling · upload-only ranking

Query-to-Tool Opportunity Mapper

Upload one Google Search Console query export, cluster utility-intent demand, score page gaps transparently, and leave with a deterministic ranked backlog of micro-tools worth shipping next.

← Back to tools Jump to results

1. Upload a GSC query export

Required logical columns: query, clicks, impressions, and position. Optional: CTR and page. Headers are normalized, CTR is recomputed, and everything stays in your browser.

Upload one CSV file Valid rows are clustered by normalized base term. Non-utility rows, empty-base utility rows, low-demand clusters, and already-covered clusters remain visible in the summary but do not appear in ranked output.
No CSV loaded yet.
What you get
A deterministic backlog with score breakdowns, page-gap context, build briefs, and export buttons.
What this does not do
No Search Console API, no SERP crawling, no LLM calls, and no automatic page publishing.

2. Summary block

Every exclusion bucket stays visible so the ranked table never hides why rows or clusters disappeared.

parsedRows
0
validRows
0
utilityRows
0
clusters
0
rankedClusters
0
excludedClusters
0
invalidRows
0
nonUtility
0
emptyBaseTerm
0
lowDemand
0
alreadyCovered
0
How scoring works
Each eligible cluster is scored with deterministic components. Intent, page-coverage gap, monetization signal, specificity, demand, and CTR gap all contribute to the final rank.
opportunityScore = intentWeight + coverageWeight + monetizationWeight + specificityWeight + demandWeight + ctrGapWeight
Coverage-state rules
  • no-page → zero mapped page URLs across the cluster.
  • mixed-pages → more than one distinct page URL appears in support rows.
  • weak-page → one page exists, but its slug does not strongly overlap the base term and intent.
  • exactish-page → one page exists, slug overlap is at least 0.6, and the slug also contains the canonical intent token.

3. Ranked opportunities

Select a row slug to inspect supporting queries, page evidence, the score breakdown, and the build brief.
No ranked output yet
Load the sample fixture or upload your own GSC export to compute a deterministic micro-tool backlog.

Privacy note: analysis runs fully in your browser. Exported rows are derived only from the CSV you loaded.