Demo Data Package Version 2 Scenarios Overview

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%' 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 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 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