Is it possible to calculate age from date of birth using Data Prep or inside a condition in a journey?

Forum|Forum|2 years ago
April 12, 2023
4 replies
3957 views

@1961013 , @danny-miller There is a date of birth field in profile. The requirement is to create segments based on age. Is it possible to calculate the age from date of birth within AEP?

Experience Platform

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by ChetanyaJain-1

@sindhe, the computed attributes feature (in beta currently) will be super helpful in your case.

https://experienceleague.adobe.com/docs/experience-platform/profile/computed-attributes/ca-api.html#:~:text=Computed%20attributes%20are%20functions%20used,segmentation%2C%20activation%2C%20and%20personalization.

You can define a field "age" at the profile level, define the computation, and leave it.

Anil_Umachigi

Adobe Employee

@sindhe Data prep may not be right option here, assuming this profile dataset is not ingested on daily basis. Data prep runs only during data ingestion.

One way i would think of doing this is

set a ageAsOfToday field in the schema
Run a query service job (scheduled every night) which updates this field for all profiles.
Use this field in segment which will be evaluated everyday with accurate age info

S

SindheAuthor

Level 2

Doesn't this require Data Distiller license?

Anil_Umachigi

Adobe Employee

@sindhe Probably, depends on how your license is set up.

B

birthariya

Level 3

You can use data prep to calculate age but the this will not be recalculated unless you ingest the record again.
I would either, based on requirement, use Query Service or just create segments to qualify users in certain age groups