Loading

Marketing Cloud Personalization | Empty String Values Not Overwriting Existing UserAttributes in User ETL

Udgivelsesdato: May 1, 2026
Beskrivelse

When updating UserAttribute values via User ETL, if the corresponding column in the CSV file is empty (blank), the existing value is not overwritten with an empty string. The import process runs successfully, but the attribute value remains unchanged.

This occurs in the following scenario:

  1. A UserAttribute item attribute:aaa already has a value set for a given user.

  2. The attribute:aaa column in the CSV file imported via User ETL is empty (blank).

  3. After the import, the user's attribute:aaa value remains unchanged — the original value is retained.

 

Løsning

The Marketing Cloud Personalization User ETL feature does not support overwriting attribute values with empty strings. To intentionally clear an attribute value, consider the following workarounds.

  1. Use a substitute value: Instead of an empty string, use a substitute value with a specific meaning.

    • Examples: - (hyphen), 0 (zero), N/A — set a string or numeric value that is meaningful as data.

  2. Pre-process the data before import:

    • Before importing, run a pre-processing step to convert empty strings in the CSV file to the substitute value.

    • This ensures the attribute is updated to the intended state in Marketing Cloud.

Vidensartikelnummer

005132161

 
Indlæser
Salesforce Help | Article