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 |
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 |
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 |
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 |
Comments
0 comments
Please sign in to leave a comment.