27. How to get 50 random customers?

Note: The scenario below uses data from the DESelect Demo Data Package.

Scenario: You want to get your best 50 customers from DESelect_DEMO_Customers.

1. Selection Criteria

On the selections overview screen, click on the New Selection button to create a new selection. 

Drag DESELECT_DEMO_Customers to the Selected Data Extensions section.

2. Target Definition

Hit the Create Data Extension button, enter a name, eg. Best 50 Customers, and press Save.

Select all the fields by clicking on the Add All Fileds button.

Click Save Data Extension.

Click on the gear icon on the right to open the settings menu, select Sort & Limit. Under Select choose the first radio button and fill in '50' to set the number of records. Under Sort by select the second radio button to randomly select. Click Save.

3. Preview

When you click Run Preview on the Preview screen, a results table will be shown with 50 records.