3 min read
Exporting Analytics
Export search and filter analytics data as CSV for external analysis.
Exporting Analytics
FilterIQ provides CSV export for all analytics data, enabling you to perform advanced analysis in spreadsheets, BI tools, or data warehouses.
How to Export
- Go to any analytics view (Summary, Search Queries, Filter Usage, etc.)
- Set the date range you want to export
- Click the Export CSV button
- The download will start immediately
Available Exports
Search Query Export
Includes:
| Column | Description |
|---|---|
| query | The search term |
| count | Number of times this query was searched |
| result_count | Average number of results returned |
| click_through_rate | Percentage of searches that led to a click |
| zero_result | Whether this query returned zero results |
| date | Date of the aggregated data |
Filter Usage Export
Includes:
| Column | Description |
|---|---|
| filter_key | The filter identifier (e.g., "color", "size") |
| filter_value | The specific value selected (e.g., "Black", "M") |
| select_count | Number of times this value was selected |
| deselect_count | Number of times this value was deselected |
| collection_handle | The collection where the interaction occurred |
| date | Date of the aggregated data |
Performance Export
Includes:
| Column | Description |
|---|---|
| date | Date |
| avg_response_time_ms | Average search response time in milliseconds |
| p95_response_time_ms | 95th percentile response time |
| total_requests | Total search requests |
| error_count | Number of failed requests |
Data Retention
| Data Type | Retention |
|---|---|
| Individual events | 90 days |
| Daily aggregates | Indefinite |
| Export availability | Matches retention period |
Events older than 90 days are available only as daily aggregates, not individual records.
Using Exported Data
In Google Sheets
- Export the CSV
- Open Google Sheets
- Go to File > Import > Upload
- Select the CSV file
- Use pivot tables to analyze trends
In Excel
- Export the CSV
- Open Excel
- Go to Data > From Text/CSV
- Import the file
- Use Power Query for advanced analysis
Best Practices
- Export weekly for ongoing reporting
- Save exports in a shared drive so your team can access historical data beyond the retention window
- Combine search and filter exports to understand the full shopper journey -- what they searched for, then how they filtered
- Track zero-result rate over time to measure the impact of your synonym and catalog improvements
Was this page helpful?
Related documentation
AnalyticsSearch AnalyticsTrack and analyze how shoppers use search on your store.AnalyticsFilter AnalyticsTrack which filters shoppers use, how they combine filters, and which options are most popular.AnalyticsZero-Result AnalysisAnalyze search queries that return no results and take action to improve product discovery.