Queries

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
  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
  You can include calculated KPI formulas in your queries, such as ‘push open rate’ using the SQL tool in Queries.
• Query Builder
  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
  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
  You can create queries with your engagement data and data extension data all in one place.
• Export Your Query Results
  Download or export query results to S3, SFTP, Google Cloud Platform, Azure Blob, or email and define an ongoing schedule.
• Query Export Options
  After you create and run your queries, you can download the results locally, export, and schedule an export for your results.
• Query Limitations
  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
  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.