Skip to main content
Level 1
April 15, 2026
Question

Experience Event the Data Does not have a unique timestamp from the source

  • April 15, 2026
  • 3 replies
  • 49 views

We have Data coming from the source all the data relates to an event but we are not getting a timestamp from the source that is unique for each event it is same for couple of events relates to the different user what should we use for mapping in this case is it now() or timestamp for data prep

3 replies

KumarRishii
Level 5
April 16, 2026

Use timestamp() in Data Prep to create a proper event-level timestamp.

DavidKangni
Community Advisor
Community Advisor
April 16, 2026
  • if you are looking for datetime use now()
  • if you are looking for epoch use timestamp()

Thanks,

David

David Kangni
Level 2
April 17, 2026

Hey Vineeth,

I don’t think “timestamp” should be used to identify an event, it should be done using _id, while timestamp is used to record when the event occured.

so, I would do this;

timestamp = Date(sourcetimeStamp, “YYYY:MM:DD HH:MM:SS”, now()), this will parse the source timestamp to the ISO format and use now() as fallback.

I would create a _id using stable fields like field like this _id = sha256(userId, “|”, eventType)

reference: https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/functions