Scenario 3 - Filling a campaign audience

Linda_Stinson

Employee

12-09-2014

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?

Accepted Solutions (1)

Accepted Solutions (1)

Linda_Stinson

Employee

16-09-2014

This workflow shows one way of implementing the scenario:

672227_pastedImage_0.png

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.

Additional data vip status.jpg

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

Sort by preffered status and limit.jpg

Answers (0)