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

Get a complimentary 30 minute marketing consultation and an audit report from our expert who has been awarded by LinkedIn Pro as ‘Best of 2017 & 2016’ in various categories including – ‘Marketing Consulting’, ‘Digital Marketing’ and ‘Lead Generation’.

Learn how other organizations are partnering with us for turnkey marketing services and solutions impacting real business outcomes.

Roy Lingam CEO,Delphi USMLE. Chicago

NectarSpot team successfully re-branded and revamped our old website to a fast loading and aesthetically pleasing within a short time frame of four weeks. NectarSpot designers and developers created a distinct UI/UX landing pages that communicates our brand as an established brand identity helping us to get more conversions. Our end users appreciate the site’s unique and polished presentation through an informative, well laid-out content and beautifully designed pages that helps a seamless interaction . The team is extremely organized and communicative and working with their team was seamless and highly collaborative. Their team is both technically and creatively talented. After creating relevant landing pages and revamping the entire site, NectarSpot is helping us to generate qualified leads through Google Ads campaign. We see a definitive increase in key web metrics such as higher conversion rate, lower bounce rate and higher engagement. We would highly recommend NectarSpot to anyone looking to up-brand their digital identity and get qualified leads.
Read More Testimonials....

Ryan Frederickson ArT Wine Preserver

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 Testimonials....

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!