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!

Create custom date range based on day of week?

Avatar

Level 1

Is it possible to create a custom rolling date range in Adobe Analytics based on days of the week?

 

For example:

First Day of Year - First Saturday of the Year

First Day of Year - Second Saturday of the Year

 

Is there a way to make this rolling so that if my panel is using a date range 1/1/2021-12/31/21 it would auto-detect dates of 1/1/21-1/2/21 and 1/1/21-1/9/21? Or if my panel date range is 1/1/22-12/31/22 it would use dates 1/1/22-1/1/22 and 1/1/22-1/8/22?

3 Replies

Avatar

Community Advisor

You can do some rolling custom ranges... for instance, I created 6 custom date ranges for "1 week ago (M-S)", "2 weeks ago (M-S)", up to "6 weeks ago (M-S)"

 

So that we could do up to a 6 week lookback for custom Monday to Sunday weeks (rather than our standard Sunday to Saturday weeks).

 

So I took a look at your definitions, and as long as you are using the standard Saturday to Sunday setup... these should work:

 

First Day of Year - First Saturday of the Year

Jennifer_Dungan_0-1690084302396.png

Note that I changed the "End" definition to "Start of" rather than "End of", to ensure that this didn't go into the second week.

 

 

Which results in:

Jennifer_Dungan_1-1690084333356.png

 

 

First Day of Year - Second Saturday of the Year

Similar to the logic of the first (except that I did plus 2 weeks):

Jennifer_Dungan_2-1690084647379.png

 

Which results in:

Jennifer_Dungan_3-1690084700010.png

 

 

Unfortunately,  the logic doesn't work with relative dates... it is still locked to Jan 1-7 as those are "relative" to this year... and we will have to wait about 5+ months to see if the logic works next year without relative dates....

 

 

Depending on what you are trying to do.. sometimes you can get much better control by using Report Builder and using Excel formulas to set up date calculations, then use the "Date from Cells" to pull data based the calculated dates (but this does mean taking your data out of the Adobe environment...)

Avatar

Level 1

I appreciate your solution, however this doesn't fulfill my need of basing the relative date range on days of the week. Like you pointed out, the ranges you recommended won't work year to year since they aren't configured to end on that week's end of week but rather by adding a number of weeks to the start of the year (which coincidentally is a Saturday in 2024, but won't be in 2025).

Avatar

Community Advisor

I know, sadly this is about the closest you can do... I totally understand that it won't be "monday to sunday" each year.

 

You will have that control in Report Builder, but that means taking your report outside of Adobe...

 

I wish I had a better solution for you.