Skip to main content
The Explorer lets you build custom analytics queries with a visual query builder. Pick the metrics you want, break them down by a dimension, filter and set a date range, then view the result as a scorecard, chart, or table. Save a query to add it to a report as a widget for ongoing monitoring.
You build queries visually with menus - no syntax required. Every query is really an AftersellQL (AQL) statement, and the Explorer also exposes that text form for power users who prefer to type. For the metric and dimension catalog, the AQL clause syntax, and the timezone rules, see the AftersellQL (AQL) reference.

​
Building a query

  1. Open the Explorer in your Aftersell admin.
  2. In the metric picker, choose one or more metrics to measure (for example Revenue, Impressions, Accept Rate).
  3. Add a breakdown to slice those metrics by a dimension such as Date, Surface, Funnel, or Device. Without a breakdown you get a single total for the whole period.
  4. Set the date range, and turn on Compare if you want to overlay an earlier period.
  5. Choose how to display the result (scorecard, line, bar, area, funnel chart, or table).
  6. Run the query. Results appear on screen.
Some metric and dimension combinations aren’t compatible - for example, Impressions and Accept Rate can’t be broken down by device, and Decline rate can’t be broken down by currency. The Explorer prevents incompatible combinations automatically. For the full list of metrics, dimensions, and which combinations are allowed, see the AQL reference.

​
Filtering by multiple funnels

The funnel filter supports multi-select operators so you can scope a query to a subset of your funnels:
  • is one of - includes only the selected funnels.
  • is not one of - excludes the selected funnels.
When you choose is one of or is not one of, the value input changes to a scrollable checkbox list showing all your funnel names. Select as many funnels as you need. When you group results by Funnel and apply an is one of filter, the line chart shows one line per selected funnel - even if you select more than the default number of series. No selected funnel is collapsed into an “Other” category.

​
Setting a timezone

By default, queries run in UTC. You can override the timezone for a query so date-bucketed results (daily, weekly, monthly breakdowns) reflect your local time.
  1. Open the Explorer in your Aftersell admin.
  2. In the toolbar, click the Timezone selector (next to Compare).
  3. Choose a timezone from the list, or select Account default to use the timezone configured in your analytics settings.
  4. Run your query. Results are bucketed using the selected timezone.
The selected timezone is saved with the query and restored when you reload it.
Queries that include Impressions, Accept Rate, or Revenue Per Visit always bucket dates in UTC, regardless of the timezone you select. For the available zones, the Account-default rules, and the TIMEZONE AQL clause, see Timezones in the AQL reference.

​
Saving a query as a widget

Once you have a query you like, save it and add it to a report as a widget so it keeps updating - see Manage widgets. To remove a widget you no longer need, load it in the Explorer and click Delete in the title bar. Deleting a widget removes it from every report it appears on. The Delete button is only shown for widgets you own; global template widgets are read-only.

​
Exporting results

The Explorer shows your query results on screen as a scorecard, chart, or table - it does not download a file directly from the query view. To get the results as a file, save the query and add it to a report as a widget. Each widget has its own Export to CSV button that downloads the widget’s data as a .csv file. For the standard Analytics-page exports (Excel and CSV), see Exporting your data.

​
Need help?

If you have questions about the Explorer or want to enable access, contact the Aftersell support team through the in-app chat.