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

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