How to use Automation Studio in Salesforce Marketing Cloud (ExactTarget) to create workflow for an automated email marketing campaign?

So far we have seen how to create Journey builder in Salesforce Marketing Cloud

Now its time to automate activities of your email campaign using Automation Studio

"Automation Studio is a Marketing Cloud application used to execute multi-step marketing and data management activities on an immediate, triggered, or scheduled basis.Use Automation Studio workflow canvas to build simple or multi-step automations."

So here we are in the main Dashboard of Automation Studio where you can find status different automation

We have two types of automation one is Scheduled and other is Triggered

"Schedule Automation is ones that you execute based upon the specific recurring schedule."

"Triggering Automation allows us to listen a file drop on a secure FTP side."

You can build automations using automation activities such as Send Email, Import File, or SQL Query. Configure and manage automation activities on the Activities page.

Let’s go with the activity SQL Query to configure your campaign:

SalesForce > Journey Builder > Automation Studio > Activities > SQL Query

"SQL Query : A query is an activity that retrieves data extension or data view information matching your criteria, then includes that information in a data extension. Provide a name, external key, and description to identify and describe the activity within the application interface and for API calls. A query activity executes your SQL statements for up to 30 minutes. Query activities exceeding this limit display an error status and do not output results."

Create SQL Query and give location to save your query and target to the DE you want to place it in folder

The query can be in the below format if you want to exclude one DE from Another DE using Event id’s

  • Select
  • object.[Field Name]
  • from [Table Name] as object
  • Where
  • object.[Field Name] NOT IN {
  • SELECT object. Field Name From Table Name as object
  • Where obj.Event ID= ‘ ’
  • AND obj.RegistrationStatus= 1
  • And obj.Registrationtype= ‘’

Click on Run Once and you can see the new list in your Data Extension list.

For Making the particular List Dynamic (Automatically the record count of subscribers changes)

Create New Automation > Drag Send Email and select your particular Campaign > Schedule them with Start and End date > Drag SQL Query to integrate it to the automation Campaign.

That’s it your Email Campaign is ready to go now from SalesForce Marketing Cloud – Exact Target

Blog Categories

Looking for a Top Rated* Marketing Company?

Contact us at +1 630 999 (7768) or submit a business inquiry online.

NectarSpot team executed the Quick and solid build of AMP website. Not afraid of small tweaks here and there. The team has, from the beginning of project, focus on conversion and provided a seamless workflow for my prospects to visit, educate and finally purchase on my e-commerce portal. They provided design, development on AMP framework and helped to host e-commerce portal on scalable and secure google cloud. We are looking forward to working with them in future for other projects as well.

Read More....

Ryan Frederickson

Art Wine Preserver

Read more to gain insights from our blogs.
Receive latest marketing insights, data and inspiration by subscribing .

Start Your Project Today (100% Satisfaction Guaranteed)

  • NectarSpot Inc. is an integrated digital marketing agency specializing in Design & Development of Web, Mobile & Voice Applications.
    We excel in providing Optimization, Automation, PPC & Analytics services to high performing brands across industries.

    Contact us today at +1 630 999 (7768) or email at to know more.

Need help?

We are right here!