breedx2 / futel-usage-viz

Some graphs showing usage data
0 stars 0 forks source link

make viz for open signal phone #6

Closed kra closed 3 years ago

kra commented 3 years ago

events are initial menu accessed from open signal phone hold the phone menu accessed from open signal phone hold the phone menu accessed from any other futel phone hold the phone incoming menu accessed

events are 2019-07-01 through 2020-11-30

this should be a priority and hopefully completed in december 2020 this will allow us to present an engagement report to open signal and racc this will be important for future fundraising and may help us convince open signal to keep the phone active

kra commented 3 years ago

open signal pickups name hold_the_phone_main extension 660

open signal hold the phone content name peoples_homes name conversations name missed_connections extension 660

other futel phone hold the phone content name peoples_homes name conversations name missed_connections extension not 660

incoming hold the phone menu name hold_the_phone_incoming extension any (should only have the incoming extension)

names may change over the course of the implementation, maybe graph these and then check? Check by grepping the metrics with various unmunging/denormalization, check fully by looking at source history?

kra commented 3 years ago

I think this issue is resolved when the various existing issues are resolved, plus the data

breedx2 commented 3 years ago

The above breakdown is SUPER HELPFUL. Thanks! Making progress on this, have noticed these two interesting event names:

@kra should we ignore or map these to one of the above?

breedx2 commented 3 years ago

Another small clarification - above it says "other futel phone hold the phone content" and extension not 660...and since the data doesn't have an extension field, one is divinated from the channel field. It looks like there are a few general forms of channel data:

I am guessing those last 3 are inbound? @kra For the purposes of "other futel phone" content, do you wanna also exclude the last 3 formats, or do you just want everything non-opensignal-handset?

kra commented 3 years ago

give me access and I will commit an example without bothering to branch

kra commented 3 years ago

last 3 are inbound but it might not be reliable and we can probably avoid all that with UI

kra commented 3 years ago

early metrics had the name of "peoples-homes" instead of "peoples_homes" run file through this to normalize everything to peoples_homes

cat metrics* | sed 's/peoples-homes/peoples_homes/'

breedx2 commented 3 years ago

Yup, what you're describing is encompassed by #2 . :metal:

breedx2 commented 3 years ago

The viz is there. Maybe we could close this and open other new issues for specific tweaks.