Complicated Segment Question

Question

I believe what I'm trying to accomplish is possible, but I'm having trouble setting it up in Workspace.  What I want is for the segment to look back from today minus 60 through 120 days to identify a population of customers that had a specific payment method.  Once the population is identified, I want to look back the past 60 days on that same population to see how it has fared in the last 60-days.  The tricky part is identifying the population in one date range (minus 60-120 days from today) and then showing metrics for that population in another date range (minus 1-60 days from today) within the same segment.

Jennifer_Dungan · Accepted Answer

I would suggest using 2 segments not one, particularly since you are trying to compare the 2 time frames...

Or you can have one segment for the specific payment method, then just have 2 custom date ranges for "last 60 days" vs "120-60 days ago"....

The Date Ranges should be easy:

and

You can use these date ranges in your columns, or as your Breakdown:

And then use one genetic "Payment Method X" segment.. you you can add these data ranges into two separate Payment Method segments "Payment Method X - Last 60 Days" and "Payment Method X - 120 - 60 Days Ago"

Why do you need both ranges in a single segment? That would be no different than just pulling 120 Days ago to Yesterday... the segment will only return one group of data...

yuhuisg · Answer

Instead of using segments, would a Cohort Table help you? I assume that you want your segment for the purpose of running a report, not for activation (i.e. by publishing the segment to Experience Cloud for use in other Adobe products).

The only thing about the Cohort Table's results that you won't like is that you start from your end point, i.e. 60+60 days ago, and see what percentage of that old cohort has been retained up to today.

Sign up

Login with SSO

Login to the community

Login with SSO