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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Creating Hourly Alert when Revenue = 0

refergusonclt
Level 2
Level 2

How do I create an alert with the following requirements:

  1. Revenue = 0
  2. Alert checks hourly
  3. Alert only checks on Weekdays (not Saturdays and Sundays)

When I choose the Revenue metric, there are 4 choices:

  1. anomaly exceeds
  2. is above or equals
  3. is below or equals
  4. changes by %

For anomaly exceeds, I can choose between 5 threshold options:

  1. 90% threshold
  2. 95% threshold
  3. 99% threshold
  4. 99.75% threshold
  5. 99.99% threshold

Thanks!

1 Accepted Solution
ursboller
Correct answer by
Community Advisor
Community Advisor

you can do it by a workaround using a calc metric.

steps to go:

1) segment „workday hits“ with definition „Hits“ and „weekday/weekend“ equals „weekday“.

2) calc metric „workday revenue“ with following formula:

IF

   “workday hits“ {metric „page views“}

   GREATER THAN

   static number “0“

THEN

  metric „revenue“

ELSE

  static number „1“

3) Alert on „workday revenue“

Condition: is below or equals “0“

Explanation:

the calc metric returns only the revenue if you have hits (page views), otherwise it will always return „1“.

and if checking for “0“ in revenue, you should get an alert if revenue is 0.

AddOn: you can expand the segment to only working hours (that‘s what i did ...)

hope that helps ...

View solution in original post

1 Reply
ursboller
Correct answer by
Community Advisor
Community Advisor

you can do it by a workaround using a calc metric.

steps to go:

1) segment „workday hits“ with definition „Hits“ and „weekday/weekend“ equals „weekday“.

2) calc metric „workday revenue“ with following formula:

IF

   “workday hits“ {metric „page views“}

   GREATER THAN

   static number “0“

THEN

  metric „revenue“

ELSE

  static number „1“

3) Alert on „workday revenue“

Condition: is below or equals “0“

Explanation:

the calc metric returns only the revenue if you have hits (page views), otherwise it will always return „1“.

and if checking for “0“ in revenue, you should get an alert if revenue is 0.

AddOn: you can expand the segment to only working hours (that‘s what i did ...)

hope that helps ...

View solution in original post