The Scenario
You are a search product manager. Your company's Algolia index drives 50,000 daily searches. Leadership wants a relevance audit: for the top 50 most-searched queries, is Algolia returning the right product first?
You have an Excel workbook with an "expected top hit" for each of your top 50 queries, compiled by the merchandising team. You need to compare expected versus actual, flag mismatches, and deliver the audit by end of week.
The bad version:
- You search for each of the 50 queries in the Algolia dashboard and note the first result
- By query 22 you are not confident you are reading the correct record
- Your manager asks you to add revenue data per query
- You restart from scratch on a Wednesday afternoon
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that pulls Algolia top queries with their top hits, compares them against your expected list, and flags mismatches, all in one prompt.
Open the SheetXAI sidebar and type:
Fetch the top 50 search queries from my Algolia index 'products' for the last 30 days. For each query, retrieve the objectID of the top-ranked result. Write query to column A of the Audit tab, actual top-hit objectID to column B, and click count to column C. Then compare column B against the expected top-hit objectIDs in column E and mark any mismatch with "MISMATCH" in column D.
SheetXAI pulls the analytics data, runs a search for each query to get the live top hit, writes the comparison table, and flags mismatches.
What You Get
A relevance audit ready for review:
- Column A — search query
- Column B — objectID Algolia actually returns first
- Column C — click count for that query over 30 days
- Column D — "MISMATCH" where actual top hit does not match expected
- All 50 queries covered — without a single manual search in the dashboard
The mismatch count is your relevance score. 8 of 50 mismatches is an 84% relevance rate and you know exactly which 8 to investigate.
What If the Data Is Not Quite Ready
Relevance audits often surface follow-up questions.
When expected top hits include products now out of stock
An out-of-stock product cannot be a valid expected result.
Before comparing, check column E of the Audit tab against the Products tab. If an expected objectID belongs to a product where Status is "out of stock," clear that cell and write "OOS" in column F. Then run the top-hit audit for the remaining rows.
When you want to add revenue data per query
Your manager wants revenue alongside relevance.
Fetch the top 50 search queries from my Algolia index 'products' for the last 30 days alongside their top hits and total revenue. Write query, top-hit objectID, click count, and revenue to columns A through D of the Audit tab, sorted by revenue descending.
When you want a category-level relevance summary
Instead of 50 individual queries, you want to know which product categories have the worst relevance rate.
Fetch the top 100 search queries from my Algolia index 'products' for the last 30 days with their top-hit objectIDs. Look up each top-hit objectID in the Products tab to find its category. Write category, average query count, and mismatch rate per category to the Category Audit tab.
When you want the full audit plus a written summary in one pass
The search team needs a paragraph they can paste into the weekly update.
Fetch the top 50 search queries from my Algolia index 'products' for the last 30 days. Get the actual top hit for each and compare against the expected objectIDs in column E. Write the full comparison to the Audit tab. Then write a plain-text summary in cell A55 describing how many queries matched, how many mismatched, and which three mismatched queries had the highest click counts.
The pattern: pull, compare, summarize in one prompt. The audit takes one step instead of an afternoon.
Try It
Get the 7-day free trial of SheetXAI and open your expected-results workbook, then ask it to run the relevance audit against Algolia. The Algolia integration is included in every SheetXAI plan. For related workflows, see how to pull full Algolia search analytics to Excel or the Algolia in Excel overview.