Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Segmentation by Date Variable

Avatar

Level 3

8/23/13

I need to check the performance of recently published Articles during this week.

 

We are passing the Article Title in to evar1/sprop1 and Article Pulish Date into evar2/sprop2. There is no way to build a segment [in SC or Discover] with a date based  rule using the custom traffic / conversion variables.  IN my case, i would like to create a segment where Publish Date is greater than [something] or - even better - Publish is within some rolling (e.g. Last Week) period.

 

 

I know  - there are no date-based variables and all sprop / evars are text. But how else can i build a report showing Article Titles, some KPIs during this week (or any other time frame) if these Articles were published during a specific (perfectly - rolling) date range?

 

The only possible way to pull such report is through Data Warehouse. But even with DW, i can't automate it since i have to change the segment definition for the Publish Dates each time.

 

So, to make the long story short :-) Could you please add some way of segmenting the date-based variables? PLease let me know if such as way is already in place!

Thanks!