Businesses benefit from automation.
A State of Marketing report performed by Salesforce reveals marketers expect a 40% increase in the number of data sources they use between 2021 and 2022; this not only accounts for both business-to-customer marketing and business-to-business. Even if their estimate is incorrect, even a fraction of that increase quickly becomes overwhelming. More data sources mean exponentially more data points to consider, and more complex marketing tactics are necessary to keep up.
Introducing automation to your marketing and other processes keeps your business moving. Marketing automation takes advantage of all gathered data and extracts valuable insights, allowing you to create the best customer experience possible. There’s no need to use valuable human resources to complete repetitive marketing tasks or worry about marketing effectively on multiple channels. Automation Studio in Salesforce Marketing Cloud can handle many, varied types of automation, and when used in conjunction with DESelect Segment, it becomes even more effective.
Automation Studio in Salesforce Marketing Cloud is a powerful tool. It’s an application used to execute multi-step marketing and data management activities. It works on an immediate, triggered, or scheduled basis. It also makes sending emails, queries, imports, and more happen automatically — exactly when you expect and need them.
In short, it allows you to automate your marketing processes like a pro. Automation Studio saves you time to invest in the aspects of your company that need you the most. Companies looking to accelerate automated marketing campaigns effectively and underlying processes in light of the inbound increase in data sources should consider Automation Studio.
As with many Salesforce tools and techniques, Automation Studio requires some knowledge about the technical aspects of data management. This guide helps you learn your way around SFMC Automation Studio, which will open your business up to new opportunities and increased traffic, customer conversion, and sales.
Automation Studio canvas in Salesforce Marketing Cloud
Automation Studio is, first and foremost, an ETL tool — extraction, transforming, and loading — and can automate any and all processes connected with the extraction, transformation, and loading of data.
Automation Studio doesn’t stop with ETL processes. Salesforce tools are designed to be an effective one-stop-shop for all a user’s needs so that you can utilize it with many other SFMC programs. Most popularly, it’s used with Email Studio. You can segment the audience in Automation Studio, save it in data extensions, and then automate email campaigns to those segmented audiences. It’s also possible to leverage created data extractions in Journey Builder. Wherever you need automation, Automation Studio is there.
In Automation Studio, activities are the building blocks of automation, and they can be used to perform specific actions such as extracting or transferring data or sending an email. Automation Studio offers several problem-solving options to suit your needs:
Suppose your company is new to automation and trying to integrate it for the first time. In that case, Automation Studio is a user-friendly tool that guides you every step of the way – from creating new automation activities to presenting real-time, easy-to-read data reports. In that case, this means you can be up and running with a brand new automation system quickly and on the road to more efficient marketing.
What was previously called triggered automation starts when a file is added to a designated folder on your Enhanced FTP location. This is a great option if you need to bring in data from an external location that isn’t being posted on a reliable schedule or you use other processes that update files in an FTP folder, and you want to create an automation that starts when activity occurs in that folder. File drop automations begin automatically when a file is dropped into a designated Enhanced FTP folder rather than on a schedule.
Scheduled automation runs on a recurring basis based on a schedule you define. It’s an excellent option for businesses hoping to keep their brand fresh in the mind of potential and existing customers. Regular invitations to your website drive engagement and convert prospective buyers into measurable sales increases.
If you’ve ever received a birthday email, you’ve received scheduled marketing. Companies can import and refresh birthday lists daily, then send an email to all contacts whose birthday falls on that day. It’s a personal touch that makes customers feel heard, seen, and appreciated.
DESelect Segment also offers scheduling functionality. Using our drag-and-drop feature, you can create an advanced segment and schedule the selection immediately – all within the app, in three easy steps.
Create an FTP user for Salesforce Marketing Cloud
As discussed above, data extraction is the process of pulling data from multiple sources and storing it in one safe place. Automatic data extraction does this at your chosen intervals, ensuring all of your data is exactly where you need it when you need it.
Security-conscious customers have often requested to use their strong cipher keys for file description when importing files into the Marketing Cloud. Automation file transfer activities can now be configured to decrypt a file from a Marketing Cloud FTP site using a customer-specified RSA key, a public-key cryptosystem used for secure data transmission.
The activity will save the decrypted content to a Safehouse location to prepare import into the data extension. And, again, security-conscious customers want to have complete control over the lifecycle management of encryption keys to control access to their data. The Marketing Cloud ‘Bring Your Own Key’ is a new capability for the customers who have dedicated data, environment, and encryption at rest, dedicated database in their Marketing Cloud messaging in journey environment. You can now bring your own encryption keys to the Marketing Cloud by generating a key in your own trusted environment and importing it into the Marketing Cloud with ‘Bring Your Own Key’. Now, you can manage the lifecycle of your keys and rotate keys self-service based on the frequency of your own security deposit policy. You can revoke encryption keys to make data inaccessible in the event of suspicion or activity of a breach. This is like an ultimate control, a big red stop button because no one can access the customer data once revoked. And once you are satisfied with your forensic analysis, you can restore keys to make the data accessible again. And finally, with ‘Bring Your Own Key,’ you now have visibility in your key states and key transition history.
Verification activities allow you to avoid unintentional automation outcomes. You can select a target data extension in your automation, and evaluate target data extensions based on the conditions you have set.
Once the conditions are met, the activity will stop the automation or send you a notification. You can also choose to receive an email with more context to help with troubleshooting. This prevents mistakes and allows for quick responses if something does go wrong.
Simply put, a wait activity pauses your automation for a specified time until the next steps are successfully performed. You can add one or multiple wait activities in a single automation. When used in conjunction with verification activities, it can eliminate accidents.
Select and configure email messages to send singularly or within a scheduled sequence. You can also create a customized Send Definition to apply to other automations.
(It’s important to note that Email Sends are more often used via Journey Builder, since it allows more reporting and tracking possibilities, but Automation Studio has email sending capabilities as well).
Classifying specific subscribers or contacts based on their attributes and other conditions makes identifying data much easier. Start by creating a filter activity in Email Studio. Be aware that using this activity to apply to a data extension that already contains certain data will overwrite the existing data in that data extension.
There are limitations to consider: the filtering option segments your data in a no-code manner but doesn’t allow you to perform an advanced segmentation. For instance, it’s not possible to segment on more than two data extensions, and it’s impossible to create advanced statements for segmentation like in results or leverage custom values and picklists.
More about Automation Studio activities can be found in this article.
While Automation Studio offers many possibilities, it also requires a certain level of expertise in data and the technical side of marketing. This makes it best reserved for experienced marketers who already use Salesforce Marketing Cloud for tasks like sending email campaigns. It’s best to limit access to the Studio for those marketers who aren’t working directly with data, to avoid data emergencies.
Learning the differences in permissions for Automation Studio is essential for maintaining privacy and efficiency and keeping everything organized.
Businesses wishing to quickly adapt to market trends and the projected data source increase coming in the next 12 to 18 months must consider effective automation. Automation Studio is a powerful tool for your trusted marketing team – ideally, with prior Salesforce experience.
Typically, Automation Studio users are Salesforce admins and marketing automation teams, but marketers themselves may also use it if they work with SQL queries, which will be discussed below.
Manage access settings through the Automation Studio setup page. Under “users,” you can give or restrict access to Automation Studio or some of its functionality. You can also give access to some of the Automation Studio functionality or define access to Migration Utility.
You’ll find Automation Studio under the Permissions tab. Some of the permissions include:
These permissions can be given or revoked at any time and are clearly presented to avoid confusion.
Let’s say you wish to analyze some purchase history information regarding customers who last purchased from you a more than a year ago. You wonder why they’ve stopped buying and suspect they could benefit from a reminder about your goods and services. With Automation Studio, you can create and run an automation to collect the data you need and move it to your desktop. It just takes a few steps:
image source: https://tidbitsforu.com/file-transfer-activity/
image source: https://tidbitsforu.com/file-transfer-activity/
After the automation is set up, it must be run. Click on “Run Once,” and choose the steps to run. You can also select the option to run one step of the automation if you want to test only a part of it first.
In the “Activity” tab of your automation, you can opt to receive a notification when your automation has finished or if an error occurred. This ensures you’re kept up to date on your automations and can easily ensure they’re running smoothly.
There are a number of powerful use cases for automations in Automation Studio. If you have an interesting or novel way of using automations, please send us your ideas at [email protected], and we may include your case in one of our next articles.
After watching this video you’re going to find out how to recreate this scenario in Automation Studio in Salesforce Marketing Cloud.
Structured Query Language (SQL) is a standardized language that allows quick and easy creation, maintenance, and retrieval of databases. It helps take an idea and put it into a relational database – essential for effective marketing.
According to the criteria you set, SQL Query collects the data extension and view information and includes these in an extension. Use SQL to build the query used in creating new automation with SFMC Automation Studio. SQL queries are reserved for advanced segmentation needs.
If you want to segment the data using SQL Queries, you first need to create a data extension — or a table — which later is populated with segmented data. Write and run the SQL Query. When it’s complete and validated, you must find your target data extension. Keep in mind that this must be created in advance. You can choose from three options how you want to add the data to your target data extension: append, update, or overwrite.
The major drawback to SFMC is that users must have a working knowledge of SQL language in order to leverage its functionality. It takes time to learn to use SQL effectively, which costs time and effort.
Due to the complex nature of SQL, file transfers, and/or Secure File Transfer Protocol, technical expertise is a must when developing automations. Automation Studio can be hard to understand and use for non-technical marketers. Beyond that, the UI is complex as well.
Much like the rest of the tools offered by Salesforce, to effectively use Automation Studio requires familiarity and an above-average understanding of automation systems. Automation Studio is not within reach for everyone, especially if you need a fast and smooth integration.
For the lack of a better description, some aspects of Automation Studio may be difficult to understand. For example, Admin Security configuration is an involved process. Let’s say you don’t want marketers to have access to Automation Studio, but they need to schedule campaigns, and it can be configured that way. However, the more specific your needs are, the more difficult it becomes.
For cases like that and more, DESelect Segment offers a simple and reliable alternative.
Example of a SQL query in Automation Studio
DESelect Segment sought to get ahead of common issues users were having with Salesforce Marketing Cloud Automation Studio. Your business can benefit from automation, but it can be overwhelming to get started and maintain.
We work in conjunction with SFMC to bridge the gaps and eliminate their limitations. DESelect’s drag-and-drop feature for your segmentation — which can be used immediately for email campaigns and other marketing applications — bypasses the need for advanced requirements, specialized knowledge, or coding experience.
In the case of SQL, DESelect Segment offers no-code alternatives to SQL. While you use DESelect to create a segment, an SQL query is created in the background, so you can always use it in Automaton Studio afterward.
Moreover, there’s no need to create a target data extension in advance. With DESelect Segment, you can create one anytime.
For teams that require specialized access and permissions, DESelect makes it easy: a marketer doesn’t need access to Automation Studio to schedule campaigns, since it can be done directly through the app.
This means you don’t have to dive into the technical process of figuring out how the user permissions in Automation Studio work, while also maintaining the integrity of your client and customer information.
While Automation Studio is a fantastic tool in Salesforce Marketing Cloud, it has its learning curve and requirements. It can be used to schedule marketing campaigns, load and transform data, and manage all of your automation — but it takes some specific know-how. It allows a variety of possibilities in terms of automating your marketing processes and opens the door to advanced segmentation, reporting, and data integration. However, this can be made all the more effective with the time-saving and user-friendly features of DESelect Segment.
Companies that utilize DESelect can launch more effective marketing campaigns almost 25% faster than companies using Salesforce Marketing Cloud alone. And, as always, DESelect is backed by a top-notch customer service team who can answer all your questions and keep your business moving.
DESelect is dedicated to offering marketing enablement solutions to help marketers achieve their goals efficiently and independently in Salesforce Marketing Cloud. Reach out to a certified DESelect consultant for more information.