--- title: Waterfall Selection slug: segment/waterfall-selection createdAt: 2026-01-15T00:08:25.128Z --- :::hint{type="info"} This feature is available in **Unaric Segment Advanced**. ::: Waterfall Selections are series of Selections that run one after the other. Optionally, a Target Data Extension from a Selection can directly be used as an input to the next Selection. Hence, it can also be used to split up large Selections into smaller ones and run them in a sequence that reduces the risk of time-outs. ## How it works The Waterfall Selection itself does not have a single, unified Target Data Extension at the parent level. Instead, each individual Selection in the sequence retains and writes to its own designated Target Data Extension. Hence, there is no output mapping screen in the Waterfall builder itself. Each selected Selection is represented as a *Step.* There is no limitation on the number of steps that a user can create and run. Steps run sequentially, therefore, they will run only if the previous step is completed successfully. Once a Waterfall Selection has been run, you will be provided with each step's total number of results chained down to the rest of the total number of results of the next steps after. ### Data chaining Because each Selection retains its own target, you can use the output of one step directly as the input (source) of the next step. This creates a powerful data pipeline. For example, in a multi-step campaign: - **Step 1 Selection:** Joins your customers and orders, calculates aggregate spending, and writes to its own target: **DE A** (*Total amount of customer spendings*). - **Step 2 Selection:** Uses **DE A** as its input source, evaluates spending ranges to assign tiers, and writes to its own target: **DE B** (*Categorizing customers*). - **Step 3 Selection:** Uses **DE B** as its input source, generates personalized greeting formulas, and writes to the final target: **DE C** (*Personalized Greetings*). - **Step 4 (Waterfall Selection):** Runs Selections 1, 2, and 3 one after the other in sequence. ## Create a Waterfall Selection 1. In the Unaric Segment Home page, select **Waterfall Selections**. ::Image[]{src="https://support.deselect.com/hc/article_attachments/29381373075089" size="60" width="716" height="107" isUploading="false" darkWidth="716" darkHeight="107" showCaption="false"} 2. Click **Create New.** 3. Provide a name for the Selection, select the folder to store it, and click **Save**. 4. Start adding all the Selections that should be part of the Waterfall. Once you have completed it, click **Next**. ::Image[]{src="https://support.deselect.com/hc/article_attachments/29381388958225" size="60" width="2938" height="1338" isUploading="false" darkWidth="2938" darkHeight="1338" showCaption="false"} 4. Click **Run**. After running your Waterfall Selection, you'll be able to see the number of records that you got in each step of the Waterfall: ::Image[]{src="https://support.deselect.com/hc/article_attachments/29381373079185" size="60" width="1808" height="1118" isUploading="false" darkWidth="1808" darkHeight="1118" showCaption="false"} ### Create a new Selection within a Waterfall Selection 1. Open or create a Waterfall Selection. 2. Click on the **Create new selection **button ::Image[]{src="https://support.deselect.com/hc/article_attachments/29443297832209" size="60" width="2918" height="1490" isUploading="false" darkWidth="2918" darkHeight="1490" showCaption="false"} 3. Provide a new name for your new Selection. 4. Create your new Selection. 5. Open the Waterfall Selection. You will see the new Selection has been automatically added. ## Schedule Waterfall Selections Set a schedule to automatically run your Waterfall Selection in Unaric Segment. 1. Enter the Waterfall Selection to which you want to apply the schedule setting. 2. Click on the scheduling icon. ::Image[]{src="https://support.deselect.com/hc/article_attachments/29470816807569" size="80" width="2848" height="184" isUploading="false" darkWidth="2848" darkHeight="184" showCaption="false"} 3. Switch on the toggle to enable the setting. 4. Optionally, you can change the preferred timezone of when you want to run the Selection by choosing the **Select a timezone** dropdown. 5. Choose between: - *Once*: Set a specific **date** and** time** ::Image[]{src="https://support.deselect.com/hc/article_attachments/4418468510353" size="70" width="532" height="191" isUploading="false" darkWidth="532" darkHeight="191" showCaption="false"} :::Paragraph{listStyleType="disc" indent="2"} *Repeat:* Set a *frequency* ::: ::Image[]{src="https://support.deselect.com/hc/article_attachments/4418468831761" size="70" width="528" height="197" isUploading="false" darkWidth="528" darkHeight="197" showCaption="false"} 6. After setting the desired schedule, click the **Schedule** button. The scheduling icon will turn green. ::Image[]{src="https://support.deselect.com/hc/article_attachments/29470816810129" size="80" width="2846" height="96" isUploading="false" darkWidth="2846" darkHeight="96" showCaption="false"} 7. Click **Save **to finish. The Waterfall Selection will automatically run as you have scheduled. :::hint{type="info"} In case the Waterfall Selection fails to run, the user who created the Waterfall Selection will be notified via email. You can also customize who should receive a notification. See [Email Notifications](docId:-5TfMYfzlvpWuwPGX0A2g) ::: ### Check scheduled Waterfall Selections ::::VerticalSplit{layout="middle"} :::VerticalSplitItem You can easily see whenever a Selection is part of a scheduled Waterfall Selection. On the Home page, you will see a blue funnel icon appear if that Selection is part of a scheduled Waterfall Selection. ::: :::VerticalSplitItem ::Image[]{src="https://support.deselect.com/hc/article_attachments/29470832660113" size="50" width="210" height="208" isUploading="false" darkWidth="210" darkHeight="208" showCaption="false"} ::: :::: When entering the Schedule Selection setting, the following message will be displayed on top. It will also display the name of the Waterfall Selection this Selection is part of. ::Image[]{src="https://support.deselect.com/hc/article_attachments/12786870495761" size="70" width="801" height="245" isUploading="false" darkWidth="801" darkHeight="245" showCaption="false"} ## Archive Waterfall Selections You can archive Waterfall Selections and restore them at any time. By default, all users will have an **Archived Waterfall Selections** folder where all the archived Waterfall Selections go. ::Image[]{src="https://support.deselect.com/hc/article_attachments/29474963771409" size="80" width="2842" height="430" isUploading="false" darkWidth="2842" darkHeight="430" alt="Archived Waterfall Selections folder" showCaption="false"} Go to the Home page of Waterfall Selections and chose which Waterfall Selection you want to archive. There are two ways to archive a Waterfall Selection: - By clicking the** Archive** button in the Action column. ::Image[]{src="https://support.deselect.com/hc/article_attachments/29474947714193" size="80" width="2910" height="474" isUploading="false" darkWidth="2910" darkHeight="474" showCaption="false" indent="1"} - By dragging-and-dropping the Waterfall Selection to the **Archived Waterfall Selections** folder. :::hint{type="info"} Archived Waterfall Selections cannot be executed or modified, and if they had an active schedule, it will be automatically cancelled. ::Image[]{src="https://support.deselect.com/hc/article_attachments/29474963777169" size="70" width="1520" height="174" isUploading="false" darkWidth="1520" darkHeight="174" showCaption="false"} ::: :::hint{type="warning"} It is not possible to archive a Selection that is being used in a Waterfall Selection. If you attempt to archive it, this message will pop up: ::Image[]{src="https://support.deselect.com/hc/article_attachments/8065422494865" size="50" width="435" height="291" isUploading="false" darkWidth="435" darkHeight="291" showCaption="false"} ::: ### Restore an archived Waterfall Selection You can restore Waterfall Selections from the **Archived Waterfall Selections **folder. There are 2 ways to restore an archived Selection: - Click the **Restore** button on the **Action** column. ::Image[]{src="https://support.deselect.com/hc/article_attachments/29474963784465" size="70" width="2924" height="432" isUploading="false" darkWidth="2924" darkHeight="432" showCaption="false"} - Drag-and-drop the Waterfall Selection to the **All Selections **folder. :::hint{type="info"} If the regular Selection that is being used in the archived Waterfall Selection is archived, then upon restoring the archived Waterfall Selection the normal Selection will be restored as well. :::