Hi #PratheepArunRaj, You are right. For the BEFORE condition, it has Custom Date with days, weeks, months and years. And it is not giving the feature of checking the condition I am talking about (subscriptionDate < current timestamp). Anyways, a quick update on creating the segment using PQL which I...

@PratheepArunRaj In the current Audience Builder UI, there is no rolling window capability at the right-hand side of the condition when we use BEFORE and AFTER. That is the main issue. By the way, I am trying another option of creating this segment using PQL (create Segment API), where I could see a...

Hi @DavidRoss91, For last 3/4 years, I have been handling this type of requests/requirementsusing data distiller Query Service Only ORhave an additional field "status" and requesting data source to derive and set the value or adding computed field mapping in the dataflow during ingestion (as suggest...

Hello Team, We are seeking help in creating segments/audiences to identify members who are having active subscription. We have subscription data stored as event where it has subscription start date (data type - datetime) and subscription end date (data type - datetime). One profile will have only on...

@SaurabhCh3 - From the path of your phone field (_abc.uGuestPrimary.phone.number), what I can understand is that you have an object "uGuestPrimary" as an object which has another object called "phone". This "phone" object has a field "number". So, for this, you need to create internal objects using ...