Now that you've identified an event path that leads to customers canceling their service, (from BILL DISPUTE to REVIEW CONTRACT) you can generate a targeted list (segment) of customers.
- Confirm that you have the dominant path selected in the path diagram.Tip: Click Select Dominant to automatically select the path.
- Select Create Segment.
- In the Create segment window, enter:
Name Tutorial Segment Description Customers from BILL DISPUTE path. Don't select Create Segment yet!Analytical segments offers different methods to create the list of customers.You'll explore these methods here:
- To view the underlying SQL for the segment, select Show SQL.
- Scroll to the bottom of the Create segment window and select Copy to copy the SQL to your system's clipboard.
- Paste the SQL into a text editor. You'll use it later in a SQL node for a new workflow.
- Select Hide SQL.
- Scroll to the bottom of the Create segment window and select Copy to copy the SQL to your system's clipboard.
- Select Create Segment.
Copy the underlying SQL and create a new workflow
Create a customer segment
To view the new segment, select
.
Tip: Select Retrieve Count to see how many customers are currently included in the segment.
Now we can create a customer list that uses the segment on a regular basis to discover customers on the BILL DISPUTE to REVIEW CONTRACT path and take action to keep them from canceling their service.