Customer Deactivation

Updated on 13 Nov 2024
1 Minute to read

Print
Share
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback

The Customer Deactivation Data Extension can be used to deactivate accounts and remove all phone number associations. This process does not change consent when removing the phone numbers. This data extension formats the data for Relay batch file or Relay API triggered customer deactivations. The Relay Custom Activity in SFMC Journey Builder does not source data from this data extension.

Setting Up the Automation

Step #	Description	Salesforce Marketing Cloud
1	Complete the SQL Mapping Worsksheet. Note: For details on each data field and the required format, please see the Data Fields section below this table.	Customer Deactivation 27.50 KB
2	Open Journey Builder > Automation Studio.
3	Select the Activities tab and open the list of SQL Queries.
4	Select the Relay Deactivation SQL Query and select the edit icon (pencil).
5	Edit the SQL Activity shell. All tablename.fieldname entries must be updated (or removed) based on your entries in the mapping worksheet. The Test table name must be replaced with the actual table name where the data will be pulled from. (If more than one table is used to obtain data, a properly coded SQL 'join' statement can be used.)
6	Click through to save the updated query. Schedule the automation.