SFMC Automation: Log Changes to the All Subscribers Status Field

Subscriber Status in Marketing Cloud

Subscriber Change of Status Audit Logging

Automation workflow activities

Automation Setup

Step 1: Data Extract

Data Extract Properties
  • Account IDs: your specific Business Unit MID
  • Character Encoding: UTF-8
  • Column Delimiter: Comma
  • Format: CSV
Data Extract Configuration

Step 2: File Transfer — Move File from Safehouse

Step 3: File Transfer — Manage File (unzip)

Step 4: Import File

  • File Location: ExactTarget Enhanced FTP Import Directory
  • File Naming Pattern: StatusChange.csv
  • Date Format: English (United States)
  • Delimiter: Comma
  • Bad Data Behavior: Skip rows with bad data
  • Import Options: Respect double quotes ( “ ) as a text delimiter
  • Mapping: Map by Header Row
  • Destination: StatusChangeAuditLog_DE

Step 5: SQL Activity

SQL to add SortOrder column to the data

Step 6: SQL Activity

SQL to create the delimited string

Automation Output

--

--

--

I am a certified Salesforce Marketing Cloud Consultant at Bower House Digital in Melbourne, Australia.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Salting Your Spark to Scale

One Page Resume Cloud Challenge

Breaking Into Web Development(I) :Introduction

Java8 Optional API

Understanding Docker

Using “WITH” in SQL

What is css grid — a brief introduction

Why cloud is not ‘basically’ a data center!

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Charlie Fay

Charlie Fay

I am a certified Salesforce Marketing Cloud Consultant at Bower House Digital in Melbourne, Australia.

More from Medium

Creating a custom Approval History list using Visualforce and Apex.

Migrating from Salesforce to Zoho CRM — An Affordable Alternative with Infinite Potential for…

Dynamic Change in Color for KPIs & Adding Up/Down Direction Symbols

Salesforce Implementation Cost in 2022: A Guide to Get Optimal ROIs