The Scenario
You are a product manager for e-commerce search. Your site's search results page has twelve filter attributes visible in the facet rail, things like brand, color, size, price range, and material. They have been in the same order since the site launched.
Your hypothesis: customers are using three of them constantly and ignoring the rest. If you can prove it, you can simplify the filter UI, promote the top filters to the primary rail, and move the others to an "Advanced Filters" expandable.
The data is in Algolia analytics. You want it in a Google Sheet for the product review on Wednesday.
The bad version of Monday:
- You look for filter analytics in the Algolia dashboard and find the section is not in the main navigation
- You find it in the documentation and it requires the analytics API
- You ask the data team for a pull
- The data team puts it in the queue
- Wednesday arrives and you present the hypothesis without data to back it up
The fast version is one prompt, Monday afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that pulls Algolia filter analytics directly and writes them into the sheet, no data team required.
Open the SheetXAI sidebar and type:
Fetch the top filter attributes used in searches on my Algolia index 'products' in the last 30 days. Write attribute name to column A and usage count to column B. Sort by usage count descending.
SheetXAI calls the Algolia filter analytics API and writes the attribute usage data into the sheet. You have your answer before the end of the afternoon.
What You Get
A filter usage ranking with:
- Column A — filter attribute name, exactly as configured in Algolia
- Column B — how many times that filter was applied in the last 30 days
- Sort order — highest usage first, so the top three jump out immediately
The usage count is the argument. If "brand" has 180,000 filter applications and "material" has 4,000, the case for promoting brand and demoting material is already made.
Want the top values within each attribute? Ask SheetXAI to pull a breakdown for the top filter.
What If the Data Is Not Quite Ready
Filter analytics are clean in structure but the product decision usually requires more slicing.
When you want to see value-level usage for a specific filter attribute
Knowing "brand" is the top filter is useful. Knowing which brands are selected most often is more useful.
For the 'brand' attribute in my Algolia index 'products', pull the top 20 filter values customers selected in the last 30 days. Write value name to column A and selection count to column B. Sort by count descending.
When you want to compare filter usage between mobile and desktop sessions
Your site has different filter UIs on mobile and desktop. You want to know if usage patterns differ.
Fetch filter attribute usage from my Algolia index 'products' for the last 30 days, broken down by device type if available. Write attribute name, desktop usage count, and mobile usage count to columns A, B, and C. Highlight rows where mobile and desktop usage rank the same attribute differently in the top three.
When you want to calculate the share of searches that used each filter
Raw counts are harder to communicate than percentages. You want to show what share of all searches involved each filter.
Fetch filter attribute usage from my Algolia index 'products' for the last 30 days. Write attribute name and usage count to columns A and B. Then fetch total search count for the same period and write the percentage of searches that used each filter to column C.
When you want to pair filter usage with conversion rates to make the business case
Not every frequently used filter drives conversions. You want to know which filters lead to purchases.
Fetch filter attribute usage and associated conversion rate from my Algolia index 'products' for the last 30 days. Write attribute name, usage count, and conversion rate for searches that used that filter to columns A, B, and C. Sort by conversion rate descending so the highest-value filters appear at the top. Add a column D ranking each filter by the product of usage count and conversion rate, which is a proxy for total business impact.
The pattern: start with the ranking, drill into the attributes that matter, and pair usage with conversion to make a data-backed case for the UI change.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask it to pull your Algolia filter analytics. The Algolia integration is included in every SheetXAI plan. For related workflows, see how to pull zero-results query data for content gap analysis or the Algolia in Google Sheets overview.