Symptom
Created a Timestamp related attribute, but while using it in segmentation model, it is not showing any result.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP Marketing cloud
Reproducing the Issue
- Create a custom field with Field type: "Timestamp"
- Enable the field as attribute in segmentation
- Now use the attribute in segmentation model to filter
- You can notice the empty result
Cause
The custom field is created with field type "Timestamp" but in segmentation configuration the semantics is in "Date"
Resolution
While creating custom field with "Timestamp" type then the attribute's semantics should be in "Date and Time".
Date and Time
- This semantic type requires an attribute that has the data type SECONDDATE, a numeric type with at least 14 digits, or a character type with at least 14 characters.
- Note that the attribute field in the database must follow the pattern YYYYMMDDhhmmss, unless you are using data type SECONDDATE.
- This type does not support milliseconds. Note that free text search through attributes of semantic type Date and Time is not supported. The search field in the preview is hidden for such attributes.
You can achieve it by following steps: Segmentation Configuration -> Segmentation Profile -> Attribute -> Edit the Semantics
See Also
Keywords
Semantics, Timestamp, Attribute, Segmentation configuration, Date. , KBA , CEC-MKT-SEG , Segmentation , Problem
Product
Attachments
Pasted image.png |