29. Find how many orders each customer placed

note the scenario below uses data from the deselect demo data package see docid 5 cozdtg0nwmlmeufrmbz scenario you want to get all customer information, along with the number of orders they placed note this scenario uses the feature aggregations, which is available in deselect plus and deselect advanced 1\ input on the selections overview screen, click on new to create a new selection drag deselect demo customers to the selected data extensions section 2\ output hit the create data extension button, enter a name, eg customers with number of orders, and press save select all the fields by clicking on the add all fields button now we're going to add a custom value under custom values on the left, click add new value under name, enter number of orders and hit next choose type aggregation choose count on the aggregation function dropdown select data extension to make the aggregation on below the field section, on the first dropdown select deselect demo orders below the field section, on the second dropdown select id create the relation between your aggregation data extension and your selected data extensions below the relation to results section, next to the field label, select customerid from the dropdown below the relation to results section, next to the matches with label, select deselect demo customers from the first dropdown below the relation to results section, next to the matches with label, select id from the second dropdown hit save drag and drop your number of orders custom value to your target data extension click save data extension 3\ preview when you click run preview on the preview screen, a results table will be shown each row in the number of orders column will contain the number of orders the customer with the corresponding id placed