Compose SQL segment

To use custom SQL to create a segment:

1. Select Compose SQL Segment on the Audience page.

   

2. Select the Target Table from the drop-down menu.

3. Name the segment and optionally provide a description.

4. Add your SQL to the Enter Query code box (enter the portion of your SQL after WHERE).

5. Select the Validate button to confirm that your SQL is valid.

6. You can select Run Count to see how your SQL affects the Total Count of records in your segment.

7. Select Finish and select your next action.