Search Query Log Audit

Read a search log and report what users ask that the site cannot answer.

Single skill Verified 12 Nov searchanalyticscontent

Use it for

Sites with internal search and a log of queries that returned nothing

Skip it if

Predicting traffic — this reads what already happened

What it is

Groups zero-result and low-click queries into clusters and reports the pages that would answer them. It is the cheapest content planning input available: the questions are real, and the gap is measurable. The output is a list of candidate pages with the evidence.

Install

Clone the repository, then copy the skill folder into your agent's skills directory — ~/.claude/skills/ for Claude Code. Skills are plain files: no build step, no daemon.

Terminal
npx skills add search-query-log-audit

How to judge it

Read the SKILL.md before you install. A good skill states when it applies, what it must not do, and how to verify the result. A skill that only lists adjectives will change the agent's tone without improving its output — skip those.

Other Search & Research skills

  • Query Expansion — Turn one question into three queries that cover different phrasings.
  • SERP Gap Analysis — Compare the top results for a query and list what they all leave out.
  • Search Result Eval — Score a search result set for relevance before an agent trusts it.

Tools it pairs with

All tools

Servers it runs on

All servers
  • 01
    PostHog MCPOfficial

    Queries PostHog for events, funnels, and cohorts through a project-scoped API key. The useful pattern is a question translated into one existing query, not free expl…

    #analytics#product#data
    TypeScriptstdio
  • 02
    Amplitude MCPCommunity

    Reads Amplitude charts and cohort data through the dashboard API: event segmentation, funnel results, and retention curves. It is a reporting interface rather than a…

    #analytics#product#retention
    TypeScriptstdio
  • 03
    ClickHouse MCPCommunity

    Runs SQL against a ClickHouse database with a read-only user: table listing, schema inspection, and query execution. The natural fit is event data where an agent can…

    #database#analytics#sql
    Pythonstdio