Data Explorer
The Data Explorer is a point-and-click toolkit for building your own analyses from your shop's raw data — you pick tables and fields by clicking, instead of writing a query language.
What can I do here?
- Browse the available tables and fields and add them to your query with a click
- Define filter conditions (e.g. "Status equals completed")
- Group fields and compute metrics (count, sum, average, minimum, maximum)
- Set a sort order and a maximum row count
- Run the query and view the result as a table, sort it, and export it as CSV or JSON
- Save a query (optionally public for other users) and reload it later
Step by step
- Open the "Builder" tab and search for the desired table in the table list on the left.
- Expand the table and click the fields you want — they appear as "Selected fields" at the top of the builder.
- Add filters as needed: field, operator (e.g. "equals", "greater than", "contains") and value.
- Use "Group by" to group fields, and add metrics (e.g. sum of a field).
- Optionally set a sort order and a maximum row count, then click "Run query".
- Check the result in the "Results" tab, sort columns by clicking a column header, and export as CSV or JSON if needed.
- Click "Save query" to store the configuration with a name and description for future use.
Fields explained
| Field | Meaning | Notes/Impact |
|---|---|---|
| Selected fields | The columns to include in the result | Added via the table list on the left |
| Filter – Field/Operator/Value | Condition records must satisfy | Multiple filters are combined |
| Group by | Fields the results are grouped by | Usually combined with metrics |
| Metrics (aggregations) | Calculation such as count, sum, average, minimum, maximum per field | Only meaningful in combination with grouping |
| Sort order | Field and direction (ascending/descending) results are sorted by | Multiple sort criteria possible |
| Limit | Maximum number of result rows | Between 1 and 10,000 |
| Name / Description (Save) | Label for the saved query | For later reuse |
| Public (Save) | Makes the saved query visible to other users | Without this, visible only to you |
Values & statuses
Filter operators
| Value | Plain meaning |
|---|---|
| Equals / Not equals | Exact value comparison |
| Greater than / Less than | Numeric or date comparison |
| Contains | Text search within a field |
| Is null / Is not null | Checks whether a field has a value or not |
Metric type
| Value | Plain meaning |
|---|---|
| Count | Counts the records |
| Sum | Adds up the values of a field |
| Average | Calculates the mean |
| Minimum / Maximum | Smallest or largest value present |
Frequently asked questions
Do I need programming or SQL knowledge?
No, every query is assembled by clicking — you don't need to know any query language.
What's the difference from the "Reports" area?
"Reports" offers fixed, predetermined standard analyses. The Data Explorer instead lets you freely build your own combinations of tables, fields, filters and metrics.
Where do I find my saved queries again?
In the "Saved" tab — there you can load a query (it reopens in the builder) or delete it.