Data Explorer lets you quickly analyze your marketing data directly on the Supermetrics Hub. No need to export to spreadsheets or build dashboards. It’s designed for fast checks, comparisons, and answering ad-hoc questions.
When to use Data Explorer
Use Data Explorer when you need to:
Check trends in key metrics week-over-week
Validate the impact of a campaign, post, or site change
Break down audiences (such as new vs. returning users) to understand behavior
Monitor progress against weekly or monthly goals
Spot anomalies, such as unexpected spikes or dips, before they escalate
Requirements and limitations
To use the Data Explorer, you need access to the Supermetrics Hub and at least one connected data source. The queries run directly in the Data Explorer. No destination setup is required.
When using Data Explorer, note that:
The current version does not support saving queries.
Row limits and available options depend on the selected data source.
Metric–dimension compatibility is enforced by the connector. Incompatible fields cannot be queried together.
Build a query in Data Explorer
On the Supermetrics Hub, select Data Explorer from the sidebar and click Explore my data.
In the sidebar, click Data source.
Select the data source to use, and click Next.
Select the connection to use, and click Next
Select the accounts to use, and click Next.
In the sidebar, click Date range and select a preset (such as Last 7 days or This year to date). You can also define a custom date range.
Click Fields.
Add metrics (quantitative values) and dimensions (categorical breakdowns).
For time-series tables, add at least one dimension, such as Date.
Your selection appears under Selected metrics and Selected dimensions.
Selected metrics and Selected dimensions can be rearranged which will affect how the columns will be ordered in the table.
Click Filters to add any optional filters.
You can, for example, include or exclude rows based on field values (such as contains, equals, greater than).
You can add multiple filters, and even nest them using AND/OR to further refine your results further.
Click Sort & limit (optional).
Select a sort order
Set a row limit to improve performance and focus your results.
Click Options to adjust connector-specific options, if available. Options vary by data source.
At the bottom of the sidebar, click Load data. The table will populate with your selected metrics and dimensions.
You can now iterate on your query. Modify fields, filters, or the date range as needed and click Load data again. Use pagination to navigate through results.
Working with fields
Pay attention to these things when you're building your query:
Metrics are numeric values, such as sessions, conversions, or cost.
Dimensions group or slice data, such as date, country, or campaign.
Some fields cannot be combined. If a field is unavailable or becomes incompatible after a selection, choose a different combination.
Use the search box in Fields to find specific items quickly.
Expand the field categories to see additional fields provided by the data source.
For a detailed explanation of metrics and dimensions, see our support article About metrics and dimensions.
Filters, sorting, and limits
To make your queries lighter and focus only on the data you need, use the selections in the sidebar.
Filters help narrow down the results. Add one or more conditions to target only the data you need.
Sort & Limit lets you order results by a field and limit the number of rows returned (the default limit is shown in the panel).
A good practice is to start your query broad, then narrow down with the filters and limits to improve query speed.
Reading the results table
The columns in the query results reflect your selected metrics and dimensions
Use pagination controls at the bottom to move through rows. You can also click Rows per page at the bottom of the page to see more or fewer lines on screen
If the query results are empty or incomplete:
Widen the date range
Remove or relax filters
Try a simpler metric–dimension combination
FAQ & troubleshooting
Why can't I save my query?
We are currently working on adding the capability to save and manage queries.
Why can't I visualize my data?
We are building a dashboarding solution in parallel and saved queries will be able to power dashboards soon.
Why do I see fewer rows than expected?
Increase the row limit in Sort & Limit, remove restrictive filters, or use pagination to see more rows.
Can I hit request limits or quotas when using Data Explorer?
Yes, many data sources have limits and quotas. Learn more about them here: About daily request quotas and limits
My query is slow or times out. What can I do?
Shorten the date range, reduce the number of accounts being queried, reduce the number of fields, particularly dimensions.