
The Unified Query Engine in Conversion
Queries, groups, and criteria
Queries are made up of groups and individual criteria:- Criteria — a statement that evaluates to either true or false for a given contact (e.g.,
Job Title = "CEO"). - Groups — one or more criteria joined with AND or OR logic.
Operators
The available comparison operators depend on the field’s data type.
String
String
String comparisons are case insensitive.
Number
Number
Boolean
Boolean
A boolean value of
false does not mean the field is unknown.Date
Date
Date and time
Date and time
Criteria types
Contact
Filter by contact field values. Select a field, an operator, and enter a value to compare against.Company
Filter by the contact’s company fields. Select a field, an operator, and enter a value to compare against. Each contact either has company data directly attached or has a linked company.Opportunities
Match contacts linked to opportunities, either through their company or an Opportunity Contact Role. You can narrow results by adding field and role constraints.Audiences
Filter contacts based on the audiences they belong to or do not belong to. You can select any number of audiences in a single criterion.Campaigns
Filter contacts based on the campaigns they are members of or not members of. You can select any number of campaigns in a single criterion.Page visit
Filter contacts based on the web pages they have visited. Toggle between Has visited and Has not visited to filter for contacts who have or have not visited a page.Website activity tracking is limited by cookie policies and settings. Conversion can only track activity when the pixel is loaded during a contact’s session.
- Has been sent
- Has not been sent
- Opened
- Has not opened
- Clicked a link
- Has not clicked a link
All email activity has bots filtered out by default.
Form submission
Filter contacts based on form submissions tracked in Conversion. Toggle between Has submitted and Has not submitted to filter for contacts who have or have not submitted a form.Custom event
Filter contacts based on custom events tracked via the Events API. You can toggle between Has occurred and Has not occurred to filter for contacts who have or have not had a specific event tracked. EventEnter the name of the custom event to filter on (e.g.,
LOG_IN, feature_activated).
FrequencySpecify the minimum number of times the event must have occurred. (Example: at least 1 time.) Time frame
Optionally add a time frame to filter on when the event occurred. Time frames can be configured relative to the current timestamp. (Example: event occurred within the past 7 days.)
Workflow
Filter contacts based on workflows they have entered or exited in Conversion. Select whether a contact has entered or has exited a workflow.Querying inside workflows
When you build a query inside a workflow, event-based criteria (such as page visits, email activity, form submissions, and custom events) include an additional Reference triggering event option.Reference triggering event
Enabling Reference triggering event scopes the criterion to the specific event that triggered the workflow, rather than evaluating against all matching events in the contact’s history.- If the workflow was not triggered by an event, or was triggered by an event of a different type, the criterion will never match the contact running through the workflow.
- If the workflow was triggered by a matching event, the criterion evaluates against that single event only.