

- Automation studio marketing cloud how to#
- Automation studio marketing cloud update#
- Automation studio marketing cloud code#
This SQL code selects all subscribers in a Salesforce Marketing Cloud Enterprise 2.0 account with their email address and the ID of the business unit that initiated the send.
Automation studio marketing cloud update#
This automation example for profile attributes update includes five steps as shown below: The next step would be to create the automation in Automation Studio, se the following sections below. Notice the space in the field name for Subscriber Key and Email Address - this is to match the attribute names in All Subscribers list so that the import activity can be automatically mapped by header row (this way it doesn't need to be mapped manually). Subscriber Key and Email Address are mandatory fields for subscriber updates via import activities. It includes three fields (attributes) as shown in the table below: Attribute name For this example let's call this data extension SetProfileAttributes.

This data extension is going to be populated using a SQL query. The profile attribute can be created in Email Studio > Profile Management as shown below:Ī data extension is also needed to store the subscribers that need to be updated.

We can also define a list of possible values to restrict the values the new attribute can take but this is optional. As a best practice it is recommended to define a default value for the custom attribute - in this case the ID of the parent business unit seems fine. We don't want this attribute to be visible to customers in their profile center therefore we'll set it as hidden. In a multi-org marketing cloud account (Enterprise 2.0) we are going to create a custom profile attribute called BusinessUnitID.
Automation studio marketing cloud how to#
This scenario can be applied to a Salesforce Marketing Cloud Enterprise 2.0 account and once the profile is populated with the business unit id (member id) it can be used for instance to define a subscriber filter at business unit level.Ĭheck out this page for more details on how to define subscriber filters. To achieve this we are going to use a SQL Query, a Data Extract and a Import File activity in Automation Studio. Let's assume we want the profile attribute to store the ID of the business unit that performs the email send. The Activities page shows all configured activities under a roof, including activities used in multiple automation and activities that are not included in automation.Author: Florin Valean Profile update use caseĪs an exercise we'll aim to update a profile attribute in a Salesforce Marketing Cloud account with multiple business units. These activities perform specific actions like moving data or extracting data or sending an email.Īctivities can be re-used as whenever you define an activity, you provide information that the activity needs at the time it runs. In Automation Studio, activities are the building blocks of automation. In this type of automation, the activities are initiated automatically when a file is dropped into a designated FTP folder that serves the purpose. To edit automation, the process is paused until the changes are saved and then preceded. This helps to build automation to perform Marketing Cloud activities on a scheduled basis.

