I admin over a web site with very seasonal and cyclical patterns (even within in a single week), as most eCommerce sites are so I am hoping this is not a difficult thing to do.
I want to set up daily alerts that monitor transactions on every day either on a month over month or better yet a year over year basis. Meaning if the transactions change by more than 25% when compared to the same day of last month ( e.g. 4/5/18 and 3/8/18) or 1 year ago (e.g. 4/5/18 and 4/6/17) send an alert
So is there a way I can build an alert (maybe using calculated metrics functions and segments) that will only trigger based on a threshold compared to the same day month over month or year over year?
Do you mean right click and “Add time period column”? I don’t see an option when I right click the metric value or the metric label for a “Compare date Range” in the menu
When I do that it still doesn’t work. I created a new work space. Dragged in the dimension the yesterday dimension (4/16/18), added our Orders metrics and then right clicked and selected Add time period column. I created a custom rolling date for Yesterday YoY, selected that and it shows zero (0) orders for 4/17/17. If I use the Yesterday YoY separately it works fine and shows the proper number of orders for 4/17/17
And it doesn’t seem to matter what time range I have set for the overall workspace to make sure both dates are included. I still get zero (0)
Thanks at least that’s something but ideally as I mentioned I need a daily alert more due to the fact we operate multiple web sites all with releases and changes occurring at different times. But I’ll think about your suggestion to see if there is an adaptation of that I can use.
What I don’t understand is year over year is one of the most common type of trend reports used for Ecommerce organizations so I do not understand why it would have to be so difficult to set up a daily year over year comparison alert in Adobe given they have been doing this for 15 years or more.
There may be a simpler solution requiring setting up of fewer segments .. but in the interim the following should give you what you need.
There are Day of Week, Day of Month, and Month of Year dimensions you could use. eg. the following would Give you the first Fridays in each month, which would give you the month on month alert or alternatively include the Month of Year to give you a year on year.