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!

Alerts - Orders above a certain discount %

Avatar

Level 2

Hi Everyone,

I'm trying to build the following alert but I'm falling short, maybe I'm not seeing a simple solution in front of my eyes.

Tigger an hourly alert when :

Total discount on an order >= (revenue * 110%)


E.g. :
If an order has 200€ worth of merchandise, where 140€ is revenue and 60€is total discount ==> Do not trigger.
If an order has 200€ worth of merchandise, where 85€ is revenue and 115€is total discount ==> Do trigger.

Thus each hour an order like the last one is made, an alert should be sent.

NB : The total discount dimension and revenue dimension are "real dimensions", not calculated ones.

Is it possible to do with the current alert system?
I tried to implement a workaround similar to this one : Adobe Analytics Alerts  or Creating Hourly Alert when Revenue = 0  from urs.boller but with no success yet.

Thanks !

7 Replies