Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Scenario 3 - Filling a campaign audience

Linda_Stinson
Employee
Employee

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?

1 Accepted Solution
Linda_Stinson
Correct answer by
Employee
Employee

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

View solution in original post

1 Reply
Linda_Stinson
Correct answer by
Employee
Employee

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

View solution in original post