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

9 replies
4083 views
Translate All

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

ChetanyaJain-1Accepted solution

Community Advisor

@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

Translate

S

SindheAuthor

Level 2

Doesn't this require Data Distiller license?

Translate

Anil_Umachigi

Adobe Employee

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

Translate

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

Translate