Demo Data Package Version 1 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%' 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