How to get started with the DESelect Demo Data Package



Demo Data Package Version 2 Scenarios Overview

Demo Data Package Version 1 Scenarios Overview

Demo Data Package (read this first)

Demo Data Package Version 2 Data Structure

Demo Data Package Version 1 Data Structure

Getting Started

1. Select Contacts that have not received any emails in the last 14 days

2. Exclude Contacts in a Data Extension from a campaign

3. Select Accounts that don't have any Orders in the last 30 days

4. Select Orders from the last 6 months

5. Select Order Lines for certain Products

6. Select Accounts filtered on country, revenue and number of employees

7. Select the Contacts with an email from a given domain

8. Select the Products in one of several Product Families

9. Select Accounts without Contacts

10. Select Contacts that are known Subscribers

11. Select Contacts with the Company Name of the Account they are related to

12. Add results of one Selection to the results of another Selection - Data Action Append

13. Get the Order Line with the highest Quantity for each Product (basic deduplication)

14. Get the Order Line with preferred Products (basic deduplication with defined values)

15. Get the preferred Order Line based on complex rules (advanced deduplication)

16. Get the Accounts of which the highest value Order has an amount of more than 1000 euro

17. Get the Accounts of which the lowest value Order has an amount of less than 100 euro

18. Get Accounts with more than 1 Order

19. Get Accounts that have an average Order size of more than 50 euro

20. Get the Accounts that in total have more than 50 euro in Orders

21. Add a fixed value to your results

22. Add a dynamic value to your results

23. How can I add a timestamp to my data?

24. Calculate Date Difference

25. Tranform date fields

26. Match Contacts with Orders on multiple fields

27. How to get 50 random customers?

28. Get a Contact's First Name in Camel Case

29. Find how many orders each customer placed

30. Get customers for birthday campaign

31. Predefine the relationship between Customers and their Orders

32. Validate gender values for your customers

33. Retaining a field value that does not need to be transformed in a Custom Value

34. Create an email campaign with expiration date

35. Categorizing customers and personalizing email campaign greeting field using Waterfall Selection

Demo Data Package Scenarios

Demo Data Package

Version

DESelect

Overview

Whitelisting DESelect Segment IP

Enable DESelect Segment in new Business Units

How to configure a user to access DESelect Segment?

What are the minimum SFMC permissions to use DESelect Segment?

How to configure Schedule Selections in DESelect?

Install DESelect Segment in SFMC

Transferring user licenses

How do I install DESelect Segment in SFMC?

How do I install DESelect Segment Free?

Troubleshooting Guide: Unable to Install DESelect Search via AppExchange on Salesforce

How do I unistall DESelect Segment Free?

Installing DESelect Segment in Salesforce Marketing Cloud

Does DESelect need to create folders in Marketing Cloud?

Recommended Browser Settings

How to add the Synchronised Data Extension to my DESelect Segment account?

Why don't I have access to the Admin Panel?

DESelect Segment Free Limitations

Whitelisting DESelect Search IP

Other

Setup DESelect Segment

Does DESelect Segment offer training material?

Training Resources

Is DESelect Segment case sensitive?

What is the difference between Now and Today in Date type fields?

Is it secure to use DESelect?

What happens in DESelect when a field in a source / target data extensions is deleted?

How does DESelect Segment handle deleted Selections' Query Activities?

Which DateTime format does DESelect use?

How is the number of active users / licenses used calculated?

What types of Data Extensions does DESelect Segment support?

Are Encrypted fields supported in DESelect?

Are multibyte characters supported in DESelect?

How to optimize your Selection in DESelect Segment?

Are DESelect Segment Selections running faster / slower than Query Activities in Automation Studio?

DESelect Segment Cheat Sheet

Can I still access a Selection with a deleted Selected Data Extension?

Does Daylight Saving Time automatically apply to the time zones?

Recurring Journeys with scheduled Selections

What do you need to know to work with Data Views in SFMC?

Master Data Extensions

Cleaning up temporary Data Extensions

How do I schedule the running of my Waterfall Selection?

How can DESelect Segment help with personalization?

Can I archive my Selection?

Are Custom Data Views supported in DESelect Segment?

Can I create a Selection (ad-hoc) within my Waterfall Selection?

Can I archive my Waterfall Selection?

Which users are on the same Selection as I am?

Does "Not In" Filter exclude empty values?

When to opt for a Master DE, a Selection Template, copy the Selection, or Data Sets & Filter Sets?

Which Relation/JOIN types are supported in DESelect Segment?

What is an Extended Partnership Structure?

Why is the _Subscriber Data View not showing Results?

How to Set Up Email Integration for Error Notifications in Slack and Microsoft Teams?

Why can I not see my Data Extension in DESelect Segment?

How to Resolve "Request Failed with Status Code 500" Error?

Share your feedback with us

Can I recover/retrieve a deleted Selection?

What does DESelect store in Google Cloud?

How Can I Track Query Execution in DESelect Segment Without Automation Data Views?

How to use and manage a template

How to use DESelect Segment Data Extensions as Entry Sources in Journey Builder?

How to Use DEs Generated in DESelect Segment as an Entry Source in Journey Builder?

How to solve: "Cannot create a datafolder with a ParentFolder property of null"

How to resolve "You can only query existing data extensions or system data views" error?

How do I solve the 403 error in DESelect Segment?

Error "Violation of PRIMARY KEY constraint. Cannot insert duplicate key"

Error: 'API Permission Failed'

What affects DESelect Segment's performance?

Does DESelect Segment have a retry policy?

How to resolve _Unfiltered error?

How do I fix "Data Extension could not be updated. The SendableCustomObjectField is invalid" error when editting a Data Extension?

How to resolve “Selected Data Extension [DE Name] cannot be found. Therefore, this selection cannot be opened” error?

How to resolve “Cannot insert a NULL value into a non-nullable column” error?

How to resolve the “You do not have access” error?

How to resolve "API Permission Failed when accessing DESelect or running preview/running a Selection” error?

Why is my selection failing with a 'Automation/Query Failed due to system error,' and how can I resolve it?

How to resolve “Time-out” error?

How to resolve “Error: Query activity terminated because it has exceeded the transaction log size limit. Reducing query complexity helps prevent this error in many cases” error?

How to resolve “Error saving the Query field.'fn_' is a reserved word and may not appear in your query” error?

How to resolve "String or Binary Data Would Be Truncated" Error?

How to resolve “SOAP API” Error?

How to resolve "Retrieving Valid Relations Failed" Error?

How to solve the "ECONNREFUSED" error?

How to resolve the "Query Failed Status Code 400" error?

How to resolve the "Error saving the Query field.Invalid object name" error?

How to resolve “Data could not be retrieved, make sure Data Extension properties are provided correctly and data still exist” Error?

What are the field length limitations in DESelect?

How to Resolve “ECONNRESET” Error in DESelect?

Why is DESelect Segment loading slowly after logging in?

Troubleshooting

What is a “Selection”?

Can I copy my Selection to another Business Unit?

What is a Waterfall Selection?

Can I set my Selection as a template?

How can I modify the name my Selection?

Can I have an overview of all my scheduled Selections?

How to copy Standard or Shared Custom Values inside a Selection?

Can I create a Selection using a template?

Can I copy my Selection?

How to save folders as favorites in DESelect Segment?

How to reorder columns in the Overview page?

Step 0: Selections Overview

Can I relate Data Extensions on multiple fields?

Can I select multiple values from a Picklist?

Can Data Views be queried in DESelect Segment?

When a user changes the criteria of a selection, will DESelect modify the underlying Data Extension or will it create a new Data Extension?

How to handle timezones in filters?

Filter types in DESelect Segment

How can I use a dropdown instead of a free input field in Filters?

Is there a limit in the number of joins/rows/columns for one Selection?

How to filter on Data Extensions?

How can I use Append Data Entension?

How to work with exclusion and suppression lists?

How can you create a relationship between two Data Extensions?

Can some folders be hidden from Available Data Extensions or Target Data Extensions?

How to use Data Views with DESelect?

How to use Data Views in DESelect?

Can the user define any relationship between Data Extensions that (s)he wants?

What data can DESelect Segment use?

How does DESelect Segment work with Synchronized Data Extensions and Data Views?

How do I create my first Selection?

When to use In/Not in Results instead of adding the Data Extension to my Selected Data Extensions?

Does In/Not In filter types support Number and Decimal data types?

How to browse/ search your Data Extensions

How to quickly change the relations between my Selected Data Extensions?

Can I directly convert a date field into a different timezone in the Filters section?

Can I save and reuse a set of Filters?

Can I add Synchronized Data Extensions into DESelect Segment?

What are Behavioral Filter Sets?

Why DESelect Segment adds a "OR field IS NULL" to the SQL Query when creating DOES NOT CONTAIN filters?

Can I stop the run of a Selection that is in progress?

How can I combine 'OR' and 'AND' statements in DESelect Segment?

How to use In and Not In filter types

How to use Equals and Is not equal to filter types?

How does Contain and Does not Contain filter type works?

How does Contains one of and Does not Contain one of filter type works?

How does Begins with and Ends with filter type works?

How does Is Empty and Is not Empty filter type works?

How does Is smaller than and Is smaller than or equal to filter type works?

How does Is greater than and Is greater than or equal to filter type works?

How does Between and Not Between filter type works?

How does is after and is before filter types works?

How does in previous and in next filter types works?

How does calendar and relative filter works?

How to use In Result and Not in Result filter types?

Step 1: Selection Criteria

How can I limit and deduplicate results from multiple Data Sources within one Selection?