---
schema_version: "1"
id: 21e40b34a3b582d1a3685aa7c5d62d0da6bbf8d75e9497d0a1545638a0f2d19a
title: Query Marketing Cloud Intelligence Data with the API Builder
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_anlyz_query_builder.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_query_builder.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: c8bddbbebf2e043e1c56e2a8e94f2bee68d6714d19d6fb46d4c228354f65cc94
description: Use the Marketing Cloud Intelligence Query API Builder to perform advanced queries on your existing data.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Query Marketing Cloud Intelligence Data with the API Builder

Use the Marketing Cloud Intelligence Query API Builder to perform advanced queries on your existing data.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d35474e38">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d35474e38 ">To use the Query API Builder:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d35474e38 ">Admin</td>

          </tr>
        </tbody>
      </table>

1. From the Analyze & Act tab, click **Query API Builder**.
2. Select the workspace you’re including in the query.
3. Set a date range for the query.
4. Select the dimensions and measurements you’re including in the query.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/images/icon_note.png)
    
    Note If you add two dimensions with the same display name, the query can’t identify which data stream type to look in. It’s recommended you provide unique names when naming the query.
5. To filter by a specific dimension or measurement, click **Open Filter**.
6. Click **Generate Query**.
    
    Here’s an example of a generated query.
    
    ![query builder](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/salesforce_datorama/images/analyze/dato_anlyz_quey_builder.png)
7. To test the code, click **Run Query**.
8. Copy the query and use it in your code when creating API calls.