Get started with queries about-queries-in-campaign

The query tool is available at various levels of the application and can be used to define target populations, segment customers, extract and filter tracking logs, create filters, and more.

It provides a dedicated assistant — the generic query editor — accessible from the Tools > Generic query editor… menu. This editor enables database queries to extract, organize, group, and sort information. For example, it can retrieve recipients who clicked more than n times on a newsletter link during a given period.

The generic query editor centralizes all querying capabilities. It allows the creation and storage of restriction filters, which can then be reused in other contexts, such as the Query box of a targeting workflow.

Access the query editor and select a table

Query the database

Steps to create a query are detailed in Campaign v8 (console) documentation

image

Add a query in a workflow

Learn the key steps related to the query creation in the context of a workflow in the Campaign v8 documentation

image

Filter conditions

To design your query, you must select the filtering conditions in the query editor. Available capabilities and use cases are detailed in the Campaign v8 documentation

image

recommendation-more-help
601d79c3-e613-4db3-889a-ae959cd9e3e1