Alerts to monitor avg GMV (or) Revenue

Set up alerts on 7 day moving average of your category's GMV.

Problem	Alert	Action	Impact
GMV (or) Revenue Monitoring	Category Manager is alerted when the GMV (or) Revenue drops below targets.	Managers can tweak pricing, placement, or deploy promotions to achieve sales targets.	Active management of GMV (or) Revenue will help category managers plan for and achieve sales targets before it is too late.

‍

Step-by-step guide:

Step 1: Choose an Alert type

Choose the Alert on a value breaching a threshold.

‍

Step 2: Write an SQL query to fetch a value

Sample Query - to calculate revenue(or)GMV of the orders captured in your category for last 7 Days.

" Code Display Example


SELECT SUM(order_details.amount) AS gmv
FROM
orders_details LEFT JOIN products
ON order_details.product_id = products.product_id
WHERE products.category_id = #{{your_category_id}}
AND order_details.return_flag = FALSE
AND created_at BETWEEN DATEADD(Day,-7, GETDATE()) AND GETDATE()

‍

Step 3: Configure Alert Condition

Alert Frequency: 24 Hrs
Column: gmv
Operator: <
Value: #{{critical_threshold}}

‍

Step 4: Configure Team and Assignees

Team is responsible for this alert (optional) - Sales Team
Person assigned to the incidents (optional) - Category Manager

‍

Step 5: Configure Alert and Incident Details

Alert name: GMV Target Alert
Configure Incident Tile: GMV for last 7 days in #{{your_category_id}} category has dropped below targets.
Default Incident Priority: Medium

‍

Step 6: Setup Notifications

Channel: email
id: #{{}}
Escalation:
- Duration: 2 Days
- Member: Senior Category Development Manager
- Channel: email - #{{senior managers email}}