App Monitoring - Outgoing SMS States

medic / cht-app-monitoring-data-ingest

GNU General Public License v3.0

1 stars 0 forks source link

App Monitoring - Outgoing SMS States #24

Open freddieptf opened 2 years ago

freddieptf commented 2 years ago

Create a data source exposing outgoing sms states:

pending
duplicate
sent
failed

eljhkrr commented 2 years ago

Explore impact data warehouse db (dwh_impact) which most likely has useful base views

kennsippell commented 2 years ago

attn @freddieptf to https://github.com/medic/app-services-team/pull/330 before working on this ticket. If your task here was just the datasource, I believe the PR should solve it. If you agree, you can re-assign ticket to me.

kennsippell commented 2 years ago

@freddieptf I've completed the Data Ingestion tool + it is now running daily. This includes a messaging section within that doc. Is that what we were planning to use for this? Do you want to handle connecting that to Superset?

freddieptf commented 2 years ago

@kennsippell it's already on superset , we can close this issue

eljhkrr commented 2 years ago

[ ] Accuracy check - PIH shows 200 messages delivered per day
[ ] Timestamp on error details table can be simplified to date

freddieptf commented 2 years ago

These are aggregate counts we get from the api https://medic.slack.com/archives/C03CYKC7NUD/p1652194000824769

eljhkrr commented 2 years ago

Let's use postgres data to get the discrete message count for each day

eljhkrr commented 1 year ago

Updated outgoing SMS widget: Zazic PIH