---
title: "Customer Deactivation"
slug: "customer-deactivation"
updated: 2024-11-13T21:07:43Z
published: 2024-11-13T21:07:43Z
canonical: "docs.relaynetwork.com/customer-deactivation"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.relaynetwork.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Customer Deactivation

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.* | [](https://cdn.us.document360.io/6738087b-455d-402f-b70a-a44a4231547e/Images/Documentation/Customer Deactivation.xls)Customer Deactivation27.50 KB[](https://cdn.us.document360.io/6738087b-455d-402f-b70a-a44a4231547e/Images/Documentation/Customer Deactivation.xls) |
| 2 | - Open Journey Builder > Automation Studio. | ![](https://cdn.us.document360.io/6738087b-455d-402f-b70a-a44a4231547e/Images/Documentation/journey-builder-automation-studio.png) |
| 3 | - Select the Activities tab and open the list of SQL Queries. | ![](https://cdn.us.document360.io/6738087b-455d-402f-b70a-a44a4231547e/Images/Documentation/activities-tab-sql-queries.png) |
| 4 | - Select the Relay Deactivation SQL Query and select the edit icon (pencil). | ![](https://cdn.us.document360.io/6738087b-455d-402f-b70a-a44a4231547e/Images/Documentation/edit-deactivation.png) |
| 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.) | ![](https://cdn.us.document360.io/6738087b-455d-402f-b70a-a44a4231547e/Images/Documentation/query-example-deactivation.png) |
| 6 | - Click through to save the updated query. - Schedule the automation. | ![](https://cdn.us.document360.io/6738087b-455d-402f-b70a-a44a4231547e/Images/Documentation/schedule-deactivation.png) |

#### **Data Fields**

| **Field Name** | **Data Type** | **Notes** |
| --- | --- | --- |
| CCID | Text (100) | Primary Key. **Required**. Uniquely identifies a Client’s Customer |