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 !