Scenario 3 - Filling a campaign audience

[Linda_Stinson]

I want to send a delivery to all of my premium customers, but if the target size is less than a maximum target size, fill with standard customers. How would you do this in a workflow?

[Linda_Stinson · Accepted solution]

This workflow shows one way of implementing the scenario:

Start with one Query that selects the preferred audience and add additional data - a column to indicate records from this query, i.e. "VIP".

After the Union, the records from the filler Query will have the additional data column as well, but it will contain a null value.

Then in the Split, create a Subset to sort (by the additional data column) and limit the number of records.