Level 1

0% to

Level 2

Tip /

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

View all

## Creating Hourly Alert when Revenue = 0

refergusonclt
Level 2

Likes

7 likes

Total Posts

14 posts

1 solution
View profile

refergusonclt
Level 2

Likes

7 likes

Total Posts

14 posts

1 solution
View profile
refergusonclt
Level 2

09-05-2018

How do I create an alert with the following requirements:

1. Revenue = 0
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!

#### Accepted Solutions (1)

ursboller
MVP

Likes

512 likes

Total Posts

1,012 posts

254 solutions
View profile

ursboller
MVP

Likes

512 likes

Total Posts

1,012 posts

254 solutions
View profile
ursboller
MVP

09-05-2018

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“

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 ...