Level 10

Solved

Subtraction on profile attribute in segment builder

6 replies
1002 views
Translate All

I have got profile attribute with end date of subscription. How to subtract this attribute from current day in segment builder?

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

PratheepArunRajAccepted solution

Adobe Champion, Community Advisor, UG Leader

Dear @michael_soprano ,

Why do you want to subtract the same from the current day?

Are you trying to create an audience based on their subscription start and end date?

If Segment UI is not helping, try creating the segment using Segment API with PQL.

A similar sort of question was asked in the RTCDP community, and the person who raised the question came up with an answer by himself (thanks to him). Checkout.

Link: https://experienceleaguecommunities.adobe.com/t5/real-time-customer-data-platform/create-audience-where-profiles-having-an-active-subscription/m-p/731961#M1245

Thank You, Pratheep Arun Raj B (Arun) | NextRow Digital | Terryn Winter Analytics

Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics

Harveer_SinghGi1

Adobe Champion, Community Advisor, UG Leader

Hi @michael_soprano ,

I don't believe you can subtract DateTime attributes like you are expecting in AEP segments. What you can do is use one of the Time constraints to validate the segments against these fields like if the subscription date is today or in next 15 days etc. See if one of these time constraints can serve your segmentation requirements.

Cheers!

Translate

PratheepArunRaj

Accepted solution

Adobe Champion, Community Advisor, UG Leader

Dear @michael_soprano ,

Why do you want to subtract the same from the current day?

Are you trying to create an audience based on their subscription start and end date?

If Segment UI is not helping, try creating the segment using Segment API with PQL.

A similar sort of question was asked in the RTCDP community, and the person who raised the question came up with an answer by himself (thanks to him). Checkout.

Link: https://experienceleaguecommunities.adobe.com/t5/real-time-customer-data-platform/create-audience-where-profiles-having-an-active-subscription/m-p/731961#M1245

Thank You, Pratheep Arun Raj B (Arun) | NextRow Digital | Terryn Winter Analytics

Translate

Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics

TylerKrause

Adobe Champion

Nice reference @pratheeparunraj!

I have tooled the the logic that was referenced to this use caseThis would return any records that have an endDate of 5 days prior.

I think that this should accomplish what @michael_soprano is trying to do!

"expression": {
"type": "PQL",
"format": "pql/text",
"value": "select 'insertYourSubscriptionPathHere' from 'routeitHere' where SECONDS_BETWEEN(XXX.endDate, now) / 86400 = 5"
}

Translate

RiteshY18

Community Advisor

@michael_soprano if possible move the event attribute as it is time-series type and the profile will store on one value not the historical - hence would not give you the expected segmentation..

Translate

brekrut

Adobe Employee

are you looking for profiles which have an upcoming subscription end date which is N days from current date?

Translate

kautuk_sahni

Adobe Employee

@michael_soprano Did you find the suggestions helpful? Please let us know if you require more information. Otherwise, please mark the answer as correct for posterity. If you've discovered a solution yourself, we would appreciate it if you could share it with the community. Thank you!

Translate

Kautuk Sahni

Sign up

Login with SSO

Login to the community

Login with SSO