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

User Permissions Needed
To use the Query API Builder: Admin
  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
    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
  7. To test the code, click Run Query.
  8. Copy the query and use it in your code when creating API calls.