Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Exclude Today in Rolling Date Range

Avatar

Avatar
Boost 1
Level 1
Matt_Payne-adidas
Level 1

Like

1 like

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Boost 1
Shape 1
View profile

Avatar
Boost 1
Level 1
Matt_Payne-adidas
Level 1

Like

1 like

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Boost 1
Shape 1
View profile
Matt_Payne-adidas
Level 1

31-08-2021

Description -
Exclude Today in Rolling Date Range, ie 'This month' that excludes today. Could be 'as simple' as a checkbox much like how 'include unspecified' is for a breakdown via Filtering.


Why is this feature important to you -

Always looking at Campaign to date performance and 'today's performance is negatively performing typically because conversion propensity is higher in the evenings.

How would you like the feature to work -

In the date range selector as a cta box, could be in the advanced settings with the 'rolling dates' feature.

Current Behaviour -

Today's performance is always incuded when looking at 'Q3' date range when in the middle of it (say aug 30th)

 

3 Comments

Avatar

Avatar
Seeker
Level 8
jeff_bloomer
Level 8

Likes

168 likes

Total Posts

248 posts

Correct reply

19 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Ignite 40
Coach
View profile

Avatar
Seeker
Level 8
jeff_bloomer
Level 8

Likes

168 likes

Total Posts

248 posts

Correct reply

19 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Ignite 40
Coach
View profile
jeff_bloomer
Level 8

31-08-2021

@Matt_Payne-adidas,
I can appreciate where you're coming from.  Just for everyone else's benefit, this is something that can currently be accomplished by using the Advanced Settings to quickly use rolling dates.  For instance, select THIS MONTH in the list of presets, and then under the rolling dates, change the END to the Start of current day.  You can use this approach for just about any date range, custom or otherwise, but I would agree this would be good for improving productivity if you're using/updating date ranges on a frequent basis.

jeff_bloomer_0-1630427281610.png

 

Avatar

Avatar
Boost 1
Level 1
Matt_Payne-adidas
Level 1

Like

1 like

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Boost 1
Shape 1
View profile

Avatar
Boost 1
Level 1
Matt_Payne-adidas
Level 1

Like

1 like

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Boost 1
Shape 1
View profile
Matt_Payne-adidas
Level 1

31-08-2021

Thanks for the Response, @jeff_bloomer ! 

Indeed it would be of time-saving benefit to set the date-range to that of the length of the known campaign against commercial campaign calendars without 'today' being reported when within that range, for the reasons as stated above (negative skew of CVR, Traffic etc).

The current methodology is as exactly as you show above and it's useful up-to until the final day of the campaign.

Cheers, M

Avatar

Avatar
Seeker
Level 8
jeff_bloomer
Level 8

Likes

168 likes

Total Posts

248 posts

Correct reply

19 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Ignite 40
Coach
View profile

Avatar
Seeker
Level 8
jeff_bloomer
Level 8

Likes

168 likes

Total Posts

248 posts

Correct reply

19 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Ignite 40
Coach
View profile
jeff_bloomer
Level 8

03-09-2021

Hi @Matt_Payne-adidas!

Agreed.  The same would go for the option with the checkmark as well.  Once you get to the first of the new month, campaign, etc., you would have to update your Date Range(s) regardless.  In other words, on that first day, would have to replace them with a Date Range like "Last Month," "Last Week," or a Custom Range to include the final day to ensure full reporting.


I still like the idea, though.  Whether or not it gets picked up and implemented, I would advise proactively creating a drop-down of both the current Date Range, as well as the final Date Range, so you don't have to do a bunch of dragging to replace one or more Date Ranges.  It will be a lot easier to just go to each affected section and swap the Date Range when relevant.


Here's a modifier to the request, though.  It would be really cool if we had the ability to set up a trigger in the report so that we could FORCE a swap on the first day of a new campaign.  I know we have some more latitude to do things like this in Report Builder, but having the ability to set simple date triggers and even include some simple variables inside our text descriptions would make the automation of reused reports/dashboards a lot easier to use and distribute on a monthly basis.


@ericmatisoff - What do you think?  Worthy of a separate ideas post?