Query Playground

The Query Playground is a flexible environment for creating, editing, and visualizing behavior-based data queries. Use it to explore user activity, optimize dashboards, or test ideas quickly before saving them as reusable insights.

Structure

Playground Layout

1. Header

Located at the top, the header provides global controls for your query.

Key actions available in the header include:

• Rename Query – Click the title to rename your query for easy reference.

• Save Query – Save your progress or commit finalized queries for dashboard use.

• Copy to Dashboard – Add this query to a dashboard as a new block.

• Copy to Account – Add a copy of query to your account.

• Access – Adjust sharing settings (only you, view only, account)

• Delete – Permanently remove the current query.

• Export as CSV – Download the chart data as a CSV file.

• Copy Share Link – Generate a shareable link to this query.

• Clear Cache & Refresh – Force rerun the query

INFO

Some of the above actions will only be available for queries stored at the account level. Only the user who created the query can modify the access level. Only the creator or an account administrator can delete a saved query.

2. Date Range + Comparison Period

Below the header contains actions that help manage the query.

• Date Range Selector - Define the window of time the data should cover.
• Comparison Period - When enabled, shows a second dataset comparing results from a previous equivalent time range.
• AI Chart Builder - Launch the AI Chart Builder to generate queries via natural language prompts.
• Run Query - Executes the query using the current settings and displays updated results and visualizations.

INFO

If this query is added to a dashboard, the dashboard-level date range (if set) will override the local query date range.

3. Chart Content Area

This section shows the visualized output of your query, such as a column chart, line graph, or table. It's a live preview of what will appear on your dashboard if the query is saved and added to one.

4. Chart Results

For non-table visualizations, this area displays the underlying raw data in tabular format. This data mirrors what is exported when using the Export as CSV function and is helpful for double-checking exact values or doing offline analysis.

5. Sidebar

The sidebar contains everything needed to define what data is pulled and how it is displayed.

Chart Type

Choose the visualization style for your query. Refer to Chart Types for guidance on which styles best suit your data.

INFO

If unsure, start with a table to validate your data selection before switching to a graph or more visual layout.

Measures / Dimensions

The building blocks of your query:

• Dimensions – Qualitative fields used to group or segment your data. Examples include Country, Session End Date, Device Type, or Source.

• Measures – Quantitative metrics that are aggregated over dimensions. Examples include Session Count, Conversion Rate, Revenue, and Average Order Value.

Dimensions determine how data is grouped; measures determine what is being calculated.

For a detailed explanation, see Field Selector.

Filters

Limit the scope of your data by applying filters. These can include user traits, behaviors, device types, locations, and more.

INFO

Filters applied here are combined with any dashboard-level filters. Both must be satisfied for data to appear in the results.

See Filtering Data for more information.

Other Query Options

Depending on your selected chart type and data, additional configuration options may appear in either:

• The Query tab

• The Options tab

These may include:

• Sorting and ordering rules

• Result limits (e.g., Top 10 countries)

• Custom color schemes

• Aggregation strategies (e.g., sum vs. average)

AI Chart Builder

The AI Chart Builder provides a simple way to generate queries using plain language. Powered by Fanplayr’s Verada AI, it interprets your intent and configures dimensions, measures, filters, and chart types for you.

AI Chart Builder

To use it:

1. Click AI Chart Builder from the top of the playground.

2. Enter a prompt describing what you want to see.

3. Review the auto-configured query.

4. Click Run Query to execute and preview the results.

Here are a list of potential questions to ask:

• Show me the logical flow of sessions to non-bounces to orders over last 3 months
• For Q1 2024, show me total page views by day and compare to previous period. Filter for users in Mexico
• Show me a table of sessions by country from jan 1 to jan 30, order by most sessions
• Numbers for bounce rate, page views, avg page views, and time on site per user

INFO

Use clear, specific language when describing timeframes, filters, or metrics to get more accurate results.