Automation studio in Marketing Studio
The Automation studio is likewise utilized as an ETL [Extract Transform Load] instrument. It helps in cutting and dicing the information, moving the information starting with one area then onto the next, changing the information into another configuration, fragmenting the information, or bringing in/sending out information into/from Salesforce Marketing Cloud and Reporting and Tracking. Important Automation Studio Activities
Automation Studio Activities are as follows :-
- Send Email action –This action is utilized to send messages to the supporters by picking the applicable email formats and the client started email definition.
- Information Extract movement – This movement is utilized to separate information of various sorts like Data Extensions, Tracking information, and so forth from the Marketing cloud and store it in a predefined area. The separated documents are zipped.
- Information plant utility – This action is utilized to stack and change information from the SQL Server climate to the objective as Oracle/Netezza climate.
- Document Transfer Activity -This action is utilized to safely move the necessary records from the Salesforce Marketing Cloud Safehouse to the FTP area. Record move action can likewise be utilized to Unzip or/and decode a document found in the Marketing Cloud’s Enhanced FTP index.
- Channel Activity – This movement is utilized to channel or fragment the information dependent on the Profile property, for example, profile credits, inclination ascribes, channels, and measures. It can likewise portion or channel the information dependent on the information put away in the information augmentation.
- Import Document Activity – This action is utilized for bringing in records from outside of Marketing Cloud into an information augmentation. These documents can be imported from the Marketing cloud safehouse into information expansions. Clients can plan the sections to import the information accurately. On the off chance that the record is encoded or compacted, it is prescribed to utilize the File move action to decode or decompress it prior to utilizing the import document action.
- SQL Query Activity – This movement is one of the fundamental exercises among the rundown. It assists the client with composing SQL inquiries to suit the particular use case. SQL inquiries can be utilized to join two tables to give social information. It very well may be utilized to channel the information dependent on explicit models or supplement the information into new information augmentations.
- Stand by Activity – This movement is utilized to make the mechanization sit tight for a particular time prior to beginning for the following computerization. This action is ordinarily utilized between other computerization exercises to empower a delay between their execution.
- Check Action – This action is utilized to stay away from mistake situations in a mechanization action. It is utilized by choosing an objective information expansion and implementing a bunch of conditions to be assessed on that information augmentation. When the condition is met, this action will stop the computerization or advise the assigned client through email or both.