Automation Studio in Marketing Cloud is a very powerful studio. It consists out of individual activities like SQL, Send email, Import file, File transfer, etc. Activities can be combined into Automations. This is very useful when you want to refresh segments, transfer a file from the sFTP or trigger a script before executing a Journey.
Automatically refresh segments in Segment Designer
When creating a segment via Segment Designer both the data extension as the SQL Activity are created within Marketing Cloud. We’ve developed our own automation for refreshing segments. It is not necessary to add them to an Automation. However, you can still use these SQL Activities in Automation Studio if you wish to do so.
You can find the SQL Activities in Automation Studio >> Activities >> SQL Query >> Query >> ActivationStudio. You can also see the SQL queries we use to create the unique scores per lead and get all the email metrics. Don’t delete these activities.
What about refreshing scores?
It’s not necessary to include our SQL Activities for Score Designer in Automation Studio since we built our own automation. Activation Studio will execute the relevant SQL Activities periodically. It is, like mentioned above, possible to include SQL Activities connected to segments.