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

Make your customized Badges in a few minutes!

Hyperledger Aries ACA-Py Agents Setup and Running Tutorials — Part I I I— Dev Environment Setup

Robotic Process Automation- Making Lives Simpler and Convenient

How I built a remote-control switch for my boost pump using Raspberry-pi and Node.js: Part 1

Starting to feel like a real game

Given an array of meeting time intervals intervals where intervals[i] = [starti, endi], return the…

A Week in the Life of a Baltimore School Getting Back to Class

How I built the Optimizely C SDK Wrapper using the Go SDK in a week (part 2)

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

How to create horizontal tabs uses of selected radio group button in Lightning Web Component — LWC…

Connected app in Salesforce for absolute beginners

Salesforce Session Id in cookies

Top 30 Salesforce Interview Questions For Freshers In 2022

Salesforce Consulting Services: A Comprehensive Walk-through