--- title: "Customer Data (CCA)" slug: "customer-data-cca" updated: 2024-11-13T21:05:20Z published: 2024-11-13T21:05:20Z canonical: "docs.relaynetwork.com/customer-data-cca" --- > ## 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 Data (CCA) The Customer Data Data Extension can be used to add or update customer data within Relay. Customer data is used to validate customers attempting to form connections, to personalize messaging and to aid in audience segmentation and branding. This data extension formats the data for Relay batch file or Relay API triggered customer data updates. 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 Data.xls)Customer Data31.00 KB[](https://cdn.us.document360.io/6738087b-455d-402f-b70a-a44a4231547e/Images/Documentation/Customer Data.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 Data SQL Query and select the edit icon (pencil). | ![](https://cdn.us.document360.io/6738087b-455d-402f-b70a-a44a4231547e/Images/Documentation/edit-batch-cca.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-cca.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-cca.png) | #### Data Fields | **Field Name** | **Data Type** | **Notes** | | --- | --- | --- | | CCID | Text (100) | Primary Key. Required. Uniquely identifies a Client’s Customer | | PRODUCT_GROUP | Text (100) | Required. The product group Id assigned to the Customer. A Customer can only be assigned to a single product group. | | SECONDARY_ACCOUNT_ID | Text (100) | Optional. Alternate account number used for validation when CCID contains characters or symbols OR CCID is unknown to Customers. | | FIRST_NAME | Text (100) | Optional. The first name of the Customer | | MIDDLE_NAME | Text (100) | Optional. The middle name of the Customer | | LAST_NAME | Text (100) | Optional. The last name of the Customer | | ADDRESS1 | Text (100) | Optional. Identifies the first line of the Customer address | | ADDRESS2 | Text (100) | Optional. Identifies the second line of the Customer address. | | CITY | Text (100) | Optional. Identifies city of the Customer address. | | STATE_PROVINCE | Text (2) | Optional. [Identifies s](http://address.DATE)tate or province of the Customer address | | POSTAL_CODE | Text (100) | Optional. Identifies postal code of the Customer address | | COUNTRY | Text (2) | Optional. Identifies country of the Customer address. | | DATE_OF_BIRTH | Date | Optional. Identifies the date of birth of the Customer. Format: yyyy-mm-dd | | SSN_LAST4 | Text (4) | Optional. Contains the last 4 digits of the Customer social security number. | | GENDER | Text (1) | Optional. Identifies the gender of the Customer. | | EXT_xxx | Text (100) | Optional. Client defined, extensible properties to be stored with the Customer record. Each extensible property must be prefixed with EXT_. Custom EXT_ properties are provided by the Client Zero or more EXT_ properties can be provided Different EXT_ properties can be provided for each Customer The maximum length of each EXT_ property is 100 characters |