Turn Algolia no-results searches into Notion content briefs

Every Monday at 8am, pull my top no-results searches from Algolia for the last 7 days using the Analytics: Top Searches with No Results operation. Cap the run at the top 10 queries so the backlog stays manageable.

For each of those top 10 queries, run Search Single Index against my main catalog index to see what records are close but not matching. The near-misses are the useful context for why customers might have been searching and what related items already exist.

Then, using your judgment, draft a content brief the marketing team can pick up. Each brief should include the exact query, why users are likely asking for it (intent and likely use case), a suggested article or category page to create, a short list of target keywords, and any similar existing items in the catalog that could be linked, expanded, or reused.

Before filing each brief, run Query a Database on my Notion Content backlog database, filtering by the query text, to check whether a brief for that query already exists. If one exists, skip that query. If not, use Create a Page in the Content backlog database with the drafted brief as the page content and the query as the page title.

Finish with a short summary of which queries got new briefs, which were skipped as duplicates already in the backlog, and any queries with unusually high no-result counts that stood out.