Validate the schema

The validation process lets you map display names and descriptions to uploaded attributes (strings, integers, numbers, and so on). A schema is created based on these settings. The schema is used to validate all future data uploaded to this data source. The mapping process does not alter the original data.

Updating the schema after validation deletes Customer Attributes. See Update the schema (also deletes attributes).

Customer Attribute Source > Create New Customer Attribute Source > View/Edit Schema

Edit a schema

On the Validate Schema page, each row of the schema represents a column of the uploaded CSV file.

Validate schema page in Experience Cloud

  • Add Data: Upload new attribute data to this data source.

  • View/Edit Schema: Map display names to the attribute data, as described in the next step.

  • FTP Setup: Upload the data via FTP.

  • ID Lookup: Enter a Customer ID (CID) from your .csv to look up Experience Cloud information for the ID. This feature is useful for troubleshooting why attribute data is not displaying for a visitor:

    • ECID (Experience Cloud ID): Displays if you are using the latest Experience Cloud ID Service. If you are on the MCID service but no IDs are listed here, Experience Cloud has not received an alias for that CID. Meaning, the visitor has not logged in, or your implementation is not passing that ID through.

    • CID (Customer ID): The attributes associated with this CID. If you are using a prop or eVar to upload CIDs (AVID), and you see attributes displayed but no AVID, this indicates that the visitor has not logged in to your site.

    • AVID (Analytics visitor ID): Displays if you use a prop or eVar to upload CIDs. If those IDs are being passed to Experience Cloud, any visitor IDs associated with the CID you entered are displayed here.

You can also upload data via FTP after you create a Customer Attribute source and an FTP account in Experience Cloud. You create one FTP account per attribute source. The uploaded files are stored in the root folder of that account. The data must be in .csv format, with a second .fin file to indicate that the upload is complete.

The names you apply to strings, integers, and numbers are used to create Analytics metrics.

  • Attribute: Attribute data read from the uploaded .csv file.

  • Type: The data type, such as:

    • String: A sequence of characters.

    • Integers: Whole numbers.

    • Numbers: Can have up to two decimal places.

  • Display Name: A friendly name for the attribute. For example, you can change an attribute customer age to Customer Since.

  • Description: A friendly description of the attribute.