--- title: "Customer Consent Update" slug: "customer-consent-update" updated: 2024-11-13T21:06:55Z published: 2024-11-13T21:06:55Z canonical: "docs.relaynetwork.com/customer-consent-update" --- > ## 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 Consent Update The Customer Consent Management Data Extension can be used to update consent of phone numbers. Consent management is used to modify consent for existing Relay connections. Customer can choose to opt in and later request to opt out. At a later time the same Customer may want to opt back in. This data extension formats the data for Relay batch file or Relay API triggered customer consent changes. 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 Worksheet. *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 Consent Management.xls)Customer Consent Management27.00 KB[](https://cdn.us.document360.io/6738087b-455d-402f-b70a-a44a4231547e/Images/Documentation/Customer Consent Management.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 Customer Consent Management SQL Query and select the edit icon (pencil). | ![](https://cdn.us.document360.io/6738087b-455d-402f-b70a-a44a4231547e/Images/Documentation/edit-consent-update.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-consent-update.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-consent-management.png) | #### **Data Fields** | **Field Name** | **Data Type** | **Notes** | | --- | --- | --- | | PHONE_NUMBER | Text (10) | Primary Key. **Required**. Uniquely identifies a Client’s Customer | | CONSENT_TYPE | Text (100) | **Required**. The Customer’s consent to the phone number. Valid values include ‘express’, ‘written’, and ‘stop.’ |