---
schema_version: "1"
id: 467c9fe69fe1712ab90a25549c9cb95b8dd58fc8d1976bcae30b726ab8edd24d
title: Queries
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_dat_queries.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_dat_queries.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: bde52084b82e6ecd0241c02ee9d45a9117f47e084d03987e2ac75a433548041b
description: Use Queries to pull granular data and get insights on your subscriber level data. For example, learn which subscribers engaged in a particular journey or investigate messages sent to a specific subscriber. Explore and export results for a deeper understanding of your data.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Queries

Use Queries to pull granular data and get insights on your subscriber level data. For example, learn which subscribers engaged in a particular journey or investigate messages sent to a specific subscriber. Explore and export results for a deeper understanding of your data.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Intelligence Reports Advanced</td></tr></tbody></table>

You can create a query using either the Query Builder or SQL. The Query Builder is a clicks-no-code tool. You can create queries automatically based on selected dimensions and measurements. If you prefer to write queries manually, or need to schedule a large data extract, you can use a SQL editor.

- **[Queries Data View](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_queries_data.htm&release=264.0.0&type=5)**  
    When querying your data in Intelligence Reports Advanced, there are many fields available. You can view the available data set fields in the Queries tab, in the Data Set tab in the left pane. Queries unify all the available fields into one Engagement Data table.
- **[Calculated KPI Formulas and Common SQL Functions](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_queries_funcs.htm&release=264.0.0&type=5)**  
    You can include calculated KPI formulas in your queries, such as ‘push open rate’ using the SQL tool in Queries.
- **[Query Builder](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_query_builder_main.htm&release=264.0.0&type=5)**  
    Use the Query Builder to create queries without code. Select dimensions, measurements, and then and run your query all within one place. You can also create custom builder calculations inside the Query Builder to create custom fields.
- **[Query Your Data with SQL](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_queries_sql.htm&release=264.0.0&type=5)**  
    You can create queries manually using an SQL editor. You can also use or modify one of the predefined queries in the Query Library. These represent commonly used queries in Query Builder and SQL formats.
- **[Querying Data Extensions](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_data_extension_before_begin.htm&release=264.0.0&type=5)**  
    You can create queries with your engagement data and data extension data all in one place.
- **[Export Your Query Results](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_queries_results.htm&release=264.0.0&type=5)**  
    Download or export query results to S3, SFTP, Google Cloud Platform, Azure Blob, or email and define an ongoing schedule.
- **[Query Export Options](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_queries_export.htm&release=264.0.0&type=5)**  
    After you create and run your queries, you can download the results locally, export, and schedule an export for your results.
- **[Query Limitations](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_queries_limits.htm&release=264.0.0&type=5)**  
    There are two tools you can use to create queries, the query builder and SQL. SQL should be used for more complex use cases. If you experience any limitations with the preview or downloading your data, consider the export or schedule export options.
- **[Contact Deletion in Intelligence Reports Advanced](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_contact_delete.htm&release=264.0.0&type=5)**  
    Data protection and privacy compliance is a top priority for Intelligence Reports Advanced. If a contact is deleted through the contact deletion framework, the subscriber key is deleted in Intelligence Reports within seven days. The events linked to the subscriber aren’t deleted and are anonymously reflected in reports with no identifiable subscriber information.