Automation Studio ⚡

Overview

Automation Studio is SFMC's workflow automation engine. Unlike Journey Builder (which automates subscriber experiences), Automation Studio automates backend data operations — things like running SQL queries, importing files, exporting data, and triggering batch sends on a schedule.

Automation Studio vs Journey Builder

Automation structure

An automation consists of:

• Steps — sequential stages. Step 2 only starts when all activities in Step 1 are complete.
• Activities — the actual work done within a step. Activities within the same step run in parallel.

Example structure

Trigger types

Schedule options

Scheduled automations support:

• Hourly — every N hours, starting at a specific time
• Daily — specific days of the week at a specific time
• Weekly — specific day of the week
• Monthly — specific day of the month

Activity types

SQL query activity

The SQL Query activity is the most-used activity in Automation Studio. It runs a T-SQL query against your DEs and System Data Views and writes results to a target DE.

Setting up a query activity

• 1
  Create the target DE first

  The target DE must already exist before you run the query. Its schema must match the fields your SELECT statement returns — same field names and compatible data types.
• 2
  Write and test your SQL

  In the Query Activity, write your SELECT statement. Use the Validate button to check syntax. Always test with a narrow date range first to ensure it returns the expected data.
• 3
  Choose the target action

  Overwrite replaces all target DE data each run. Add appends new rows. Update updates existing rows. Add/Update upserts (most common for segment DEs).

-- Target DE: Segment_ActiveUK
-- Action: Overwrite (fresh each run)
-- Schedule: Daily at 6am

SELECT
    s.SubscriberKey,
    s.EmailAddress,
    s.FirstName,
    s.LastName,
    s.Country
FROM [Master_Subscribers] s
INNER JOIN [_Open] o
    ON s.SubscriberKey = o.SubscriberKey
    AND o.EventDate >= DATEADD(day, -90, GETDATE())
WHERE
    s.Country = 'UK'
    AND s.OptInStatus = 'Subscribed'

Import activity

The Import File activity imports a CSV or tab-delimited file from SFMC's SFTP server into a Data Extension. This is the standard mechanism for receiving nightly data feeds from CRM systems, e-commerce platforms, and data warehouses.

Import configuration

File transfer activity

File Transfer activities move, rename, or transform files on SFTP. Common uses:

• Move a processed file to an archive folder after import
• Decrypt a PGP-encrypted file before importing it
• Compress/decompress files
• Transfer files between SFMC's SFTP and an external SFTP server

Common automation patterns

Pattern 1: Daily segment refresh + send

Pattern 2: Nightly CRM data feed

Pattern 3: Journey entry refresh

Pattern 4: Weekly performance report

Monitoring & error handling

Activity history

In Automation Studio, click an automation to see its Activity History — a log of every run with status (Complete, Error, Running), start/end times, and error messages. Check this regularly for scheduled automations that might be silently failing.

Common errors and fixes