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.

NOTE
Updating the schema after validation deletes customer attributes. See Update the schema (also deletes attributes).

To validate the schema

  1. In Customer Attributes, click the attribute source to edit.

  2. On the Edit Customer Attribute Source, click File Upload.

  3. On the File Upload and Schema Validation page, click Actions > View/Edit Schema

    Edit a schema

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

    Edit schema page in Experience Cloud

Actions

  • 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: Create your FTP account to upload your data via FTP (optional).

  • 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.

recommendation-more-help
872fc4ed-f5f7-4b59-a6f8-4ddabe5aac1f