| Table of Contents |
|---|
Purpose
...
All metrics must be continuous and are calculated based on input period.
Input period:
- previous day (last 1
- current day)
Successful/unsuccessful SMS submissions stats
Fetch records from VERIFICATION.sms_logs, where:
- status not in ('Accepted', 'Enroute')
...
Calculate successful ratio:
- count(status='Delivered')/count(*)
Undelivered SMS
Fetch records from VERIFICATION.sms_logs, where:
- status not in ('Accepted', 'Enroute')
...
Calculate Undelivered SMS qty:
- count(status<>'Delivered')
SMS delivery latency
Fetch records from VERIFICATION.sms_logs, where:
- status = 'Delivered'
- now()-inserted_at<=inputed_period
- type
...
- define groups:
- '<=2 min': status_changed_at - inserted_at<=2 min
- '2 - 5 min': status_changed_at - inserted_at<=5 min
- '5 - 30 min': status_changed_at - inserted_at<=30 min
- else '>30 min'
- count(*) - sms qty in each group
...