Using queries to select data
When you configure a
Select, Segment, or Extract process in a flowchart, you can use queries to identify contacts from
your databases or flat files. There are several different query methods.
How queries are evaluated in Campaign processes Queries in Campaign processes are evaluated left to right using mathematical rules.Creating queries with Point & Click These instructions explain how to create a query using the default Point & Click method in a process configuration dialog. You can also follow these instructions to edit a query. Note that selecting a new item from the Select based on list removes the existing query.Creating queries with Text Builder These instructions explain how to create a query using the Text Builder feature in a process configuration dialog. To edit an existing query, edit the text of the query directly in the query text box, after clicking the Text Builder button.Creating queries with Formula helper When you create a query to select IDs in a Select, Segment, or Extract process, you can use the Formula helper to help build the query. The Formula helper is available from the process configuration dialog. The Formula helper contains a set of buttons for inserting commonly used operators and a list of macros, operators, and functions.Specification of pre- or post-processing SQL statements If you are using a Select or Extract process, you can optionally include raw SQL statements to run before or after the process.Guidelines for using raw SQL queries Writing raw SQL is an advanced operation; users are responsible for correct syntax and query results.
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.