With Data explorer, you can build queries directly on the Supermetrics Hub to speed up your data analytics work and pinpoint the exact data you need. Once you've built your queries, you can save them, modify them, and export them in CSV or JSON format.
Data explorer enables you to build one query, view the results in table format, and use this query as a basis to quickly make changes to the data source accounts, date ranges, metrics, or dimensions. You can save those modified queries as individual queries to make sure that you can get a quick look at your data whenever you need.
Note
When using Data explorer, note that:
Row limits and available options depend on the selected data source.
Metric–dimension compatibility is enforced by the data source connector. Incompatible fields cannot be queried together.
Instructions
Build a query in Data explorer
On the Supermetrics Hub, go to Data Explorer.
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.
When you have the data you need, click Save to save the query. You can also click Export to save the query results in JSON or CSV format, and then save the query.
Edit saved queries
All saved queries are listed on the Data explorer landing page.
Click the name of a query to open the query for editing.
Once you've made changes to the query, update the query by clicking Save. If you need to save the updated query as a new one, click Save as and give the query a name
To duplicate a query, click the 3-dot menu on the Data explorer landing page and select Duplicate.
To delete a query, click the 3-dot menu on the Data explorer landing page and select Delete.
Best practices for Data explorer
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.
Note that the field compatibility checker is not yet supported in the following data sources:
Facebook Insights
X Ads
Display & Video 360
Instagram Insights
Google Ad Manager
Google Ads
Google Campaign Manager 360
Google Search Console
Mailchimp
Microsoft Advertising
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 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 metrics, use more specific filters, or lower the row limit.