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.
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}}
Blazing-fast operations minus all the constant firefighting👨🚒Learn how to set up a control tower for your operations in under 15 minutes ️🔥
...with Locale for modern ops teams |