Whenever the Run button is pressed in DESelect, Query Activities are created inside your Marketing Cloud account. These are normal Query Activities and you can use them wherever you would use any other Query Activity you have created, for example in Automation Studio.
The Query Activities generated by DESelect can be found at:
- Automation Studio > Activities > SQL Query > DESelect > Selections.
Each Query Activity that's generated will have the same name as the selection, followed by a random number.
In case you are using deduplication in the selection, an additional Query Activity is created and run after the initial one. This one will have the same name as the selection, followed by '-dedup', followed by a random number.
For example, if you have a selection called "Halloween Promotion 2020", your Query Activity will be called: "2020 Halloween Promotion 1600333453317". If you use the deduplication feature, you'll find an additional Query Activity called "Halloween Promotion 2020-Dedup 1600333453317".
When you click the Run button in DESelect, the standard Query Activity starts running. Once it completes if deduplication is used the deduplication Query Activity also starts.
Of course, you are free to add these Query Activities inside an Automation or use them in Journey Builder. In case you are using deduplication, do not forget to add both generated Query Activities inside your Automation. Also, beware of the order, the deduplication Query Activity needs to run second.
Related Articles:
Comments
0 comments
Please sign in to leave a comment.