Create custom date range based on day of week? | Community
Skip to main content
July 21, 2023
Question

Create custom date range based on day of week?

  • July 21, 2023
  • 1 reply
  • 1349 views

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?

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

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 23, 2023

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

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:

 

 

First Day of Year - Second Saturday of the Year

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

 

Which results in:

 

 

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...)

RachelHa3Author
April 5, 2024

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).

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
April 6, 2024

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.