Demo Data Package Version 1 Scenarios Overview – DESelect

Below you can find an overview of all scenarios that are available to do with the data in the demo data package.

Scenario	What functionality does it cover?	SQL alternative
DESelect Enable
Select Contacts with the Company Name of the Account they are related to	Defining relations: with matching	INNER JOIN
Select Contacts that are known Subscribers	Defining relations: with matching Data Views	INNER JOIN
Select Accounts without Contacts	Defining relations: without matching	LEFT JOIN with IS NULL
Select the Products in one of several Product Families	Filters: in	IN
Select the Contacts with an email from a given domain	Filters: contains	LIKE '%value%'
Select Accounts filtered on country, revenue and number of employees	Filters: equals, greater than or equal to, smaller than or equal to	=, >=, <=
Select Order Lines for certain Products	Defining relations: with matching Filters: equals, equal to or greater than	INNER JOIN, =, >=
Select Orders from the last 6 months	Filters: dynamic date filters	DATEADD
Exclude Contacts in a data extension from a campaign	Defining relations: without matching	LEFT JOIN with IS NULL
Add results of one selection to the results of another selection	Data action: append	N/A

DESelect Plus
Add a fixed value to your results	Custom values: fixed value	SELECT 'value' AS
Add a dynamic value to your results	Custom values: dynamic value	CASE WHEN THEN
Get the Accounts that in total have more than 50 euro in Orders	In Results filter (subqueries) with aggregations	IN subquery SUM
Get the Accounts of which the highest value Order has an amount of more than 1000 euro	In Results filter (subqueries) with aggregations	IN subquery MAX
Get the Accounts of which the lowest value Order has an amount of less than 100 euro	In Results filter (subqueries) with aggregations	IN subquery MIN
Get Accounts with more than 1 Order	In Results filter (subqueries) with aggregations	IN subquery COUNT
Get Accounts that have an average Order size of more than 50 euro	In Results filter (subqueries) with aggregations	IN subquery AVG
Select Accounts that don't have any Orders in the last 30 days	Filters: Not In Results, dynamic dates	NOT IN subquery
Select Contacts that have not received any emails in the last 14 days	Filters: Not In Results, dynamic dates Data Views	NOT IN subquery

DESelect Advanced
Get the Order Line with the highest Quantity for each Product (deduplication)	Prio deduplication	ROW_NUMBER

Related articles