Compose SQL segment

To use custom SQL to create a segment:

1. Click 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. Click the Validate button to confirm that your SQL is valid.

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

7. Click Finish and select your next action.