---
title: "How to use the Query Manager"
slug: "how-to-use-the-query-manager"
description: "Easily construct queries with the Supermetrics API using the Query Manager tool to output CSV or JSON data."
updated: 2025-09-26T08:57:30Z
published: 2025-09-26T08:57:30Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to use the Query Manager

The Query Manager tool allows you to easily construct queries to pull your data with the Supermetrics API and output CSV- or JSON-formatted data for a range of destinations. You can access the Query Manager in the [Supermetrics Hub](https://hub.supermetrics.com/).

## Before you begin

The Query Manager can be used with a Supermetrics API subscription. Please [contact our sales team](https://supermetrics.com/pricing/supermetrics-api) for a quote.

If you don’t have a subscription yet, you can test the Query Manager with a 14-day trial subscription for any data source. The trial subscription will be created automatically when you authenticate the data source with Supermetrics. You can start one trial per data source, for as many data sources as you want.

## Instructions

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **API queries** under **Manage**.
2. Click **Select data source**.
3. Select a data source and connection to use.
4. In the sidebar on the left, build your query.
  1. Select the data source from the list of options. Depending on the data source, enter your credentials and click **Start**, or click **Start** directly and then log in to the data source. [See our data source -specific connection guides for the permissions each data source requires](/v1/docs/connect).
  2. Select the data source accounts to include. Depending on the data source, this can mean properties such as ad accounts, views, or pages. See our data source account documentation.
  3. Under **Select dates**, set the date range for your query, either from the list of pre-set dynamic date ranges, or by setting custom start and end dates.
  4. Under **Select metrics**, select what metric data to include in your query.
  5. Under **Split by dimensions**, select dimensions to split your metric data to rows or columns.
  6. Under **Filter**, you can apply filters to your data, and under **Options**, you can define data-source-specific options and set advanced settings to your query. These are optional settings.
5. When you’ve configured your query, click **Run**to test it.
  - You can see your data in a preview table and raw JSON format to ensure the data is returned as expected.
6. Select a format option for the query URL depending on your data destination. See our guides for how to connect your data to [Power BI](/v1/docs/how-to-connect-data-to-power-bi-using-the-supermetrics-api) or [Qlik Sense](/v1/docs/how-to-connect-data-to-qlik-sense)

> [!CAUTION]
> The query URL includes an API key that gives anyone with the URL access to your data. Treat this as you would a password and keep it safe. If you need to share the URL publicly, use the Short URL option that does not display your API key.
  - You can also export the data directly in CSV or JSON format.

## More resources

- [How to connect data to Power BI](/v1/docs/how-to-connect-data-to-power-bi-using-the-supermetrics-api)
- [How to connect data to Qlik Sense](/v1/docs/how-to-connect-data-to-qlik-sense)