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|
|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
|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%'|
|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||UNION|
|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|
|Select Contacts that have not received any emails in the last 14 days||Filters: Not In Results, dynamic dates
|NOT IN subquery|
|Get the Order Line with the highest Quantity for each Product (deduplication)||Prio deduplication||ROW_NUMBER|
Please sign in to leave a comment.