SIT: A look at Trends Over Time

Sanya Sardana & Stuti Goyal
6th July, 2020

Geographic Reach

      location_name No_of_District No_of_Blocks No_of_units
1    Andhra Pradesh             10           31       75579
2             Assam             10           21      304092
3             Bihar             28          173      176920
4      Chhattisgarh              5            9       33784
5             Delhi              1            8      126817
6           Gujarat             14           21      255173
7           Haryana              3            5       23257
8  Himachal Pradesh             12           20       32382
9   Jammu & Kashmir             20          107      151003
10        Jharkhand              5           21      106596
11        Karnataka              7           24      110147
12   Madhya Pradesh              4           17      838502
13      Maharashtra             16           32      297979
14           Odisha             10           10      169687
15        Rajasthan             10           12      123777
16       Tamil Nadu              2            2       21834
17        Telangana              9           11       47668
18    Uttar Pradesh             45           99      400267
19      Uttarakhand              2            4       37206
20      West Bengal             12           16       77337
21          Overall            225          642     3410007

#Village Profile- to be added

SMS Sent per Unit:Non-ECE

Trends over Time plot of chunk unnamed-chunk-2

A sudden spike in the SMS Sent/Unit is seen in May
We see that SMS Sent/Unit is increasing from the start of SIT from ~1 SMS Sent/Unit in April to ~9 SMS Sent per Unit in July
Trend of SMS Sent/Unit looks to be cyclical over 1 week and spikes on most Sundays

SMS Sent per Unit:Non-ECE

Day-wise Trends plot of chunk unnamed-chunk-3

Median number of SMS Sent/Unit is highest on Sunday(~10) as compared to median SMS sent per unit (~7)

SMS Sent per Unit:Non-ECE

Program-Wise Trends over Time plot of chunk unnamed-chunk-4

          program_bucket No_of_units
1                Content         171
2 Government Partnership     1319209
3           Hamaara Gaon      675968
4                  Other       11425
5             Read India      166720
6    Stand Alone Program        3437
7                  Urban       67626
8               Vertical      439741

Hamara Gaon consistently has entered the highest no. of SMS Sent/Unit out of all programs
Standalone programs show the second highest trend consistently of SMS Sent/Unit
Government Partnerships show a spike in SMS Sent/Unit towards end June

SMS Sent per Unit:ECE

Trends over Time plot of chunk unnamed-chunk-6

SMS Sent/Unit steadily increases from ~3 messages in April to ~5 messages in end May
SMS Sent/Unit has a steady trend from end May onwards(~5)

SMS Sent per Unit:ECE

Program-Wise Trends over Time plot of chunk unnamed-chunk-7

Vertical programs consistently enter the highest SMS Sent/Unit
Spike in SMS Sent/Unit from April to May is observed in Government Partnership program
Dip in SMS Sent/Unit is observed in Urban program towards end June

WhatsApp Sent per Unit:Non-ECE

Trends over Time plot of chunk unnamed-chunk-8

Whatsapp Sent/Unit shows high growth from ~1 in April to ~6 in the beginning of May
WhatsApp Sent/Unit grows steadily from ~6 in May to ~7 in mid-June
Spike in WhatsApp sent/Unit is observed in last week of June(from ~6 on 21st June to ~13 on 28th June)
Whatsapp Sent/Unit follows a cyclical trend of 1 week wherein a spike is observed on Sundays

WhatsApp Sent per Unit:Non-ECE

Day-wise Trends

Median number of WhatsApp messages sent per unit is highest on Sunday(~10) as compared to median WhatsApp sent per unit (~7)

WhatsApp Sent per Unit:Non-ECE

Program-Wise Trends over Time plot of chunk unnamed-chunk-10

Standalone program consistently has entered the highest no. of WhatsApp Sent/ Unit
Spike in WhatsApp Sent/Unit can be attributed to spike in WhatsApp sent/Unit in Government Partnership towards end June

WhatsApp Sent per Unit:ECE

Trends over Time plot of chunk unnamed-chunk-11

WhatsApp sent/unit shows a steadily increasing trend from ~4 in April to ~5 by 6th July
WhatsApp sent/unit is slightly higher(~6) in the week of 22nd June-29th June

WhatsApp Sent per Unit:ECE

Program-Wise Trends over Time plot of chunk unnamed-chunk-12

Increase in Whatsapp Sent/unit in the week of 22nd June-29th June can be attributed to spike in Whatsapp Sent/unit(from ~7 to ~11) in Urban program
Vertical program shows a cyclical trend over 1 week wherein maximum no. of WhatsApp sent/unit is on Sunday
Hamara Gaon program shows a cyclical trend over 1 week wherein minimum no. of WhatsApp sent/unit is on Sunday

Feedback Calls per Unit:Non-ECE

Trends over Time plot of chunk unnamed-chunk-13

A sudden spike in the Feedback Calls/unit is seen in from April 20th
We see that no. of Feedback Calls/unit is steadily increasing from ~4 on April 20th to ~6 on May 11th
Feedback calls exhibit a stable trend from May 11 onwards (~6)
Spikes in Feedback calls/unit is seen on Sundays
Feedback calls/Unit increase slightly for most program in the first week of June

Feedback Calls per Unit:Non-ECE

Program-Wise Trends over Time plot of chunk unnamed-chunk-14

Hamara Gaon and Urban program consistently have entered the highest Feedback Calls/unit
Spike in Feedback calls on Sundays can be attributed to Urban program
Government Partnerships show a spike in the no. of Volunteers who were given a feedback call per unit towards end June

Feedback Calls per Unit:ECE

Trends over Time plot of chunk unnamed-chunk-15

A sudden spike in the Feedback Calls/unit is observed on Sundays
No. of feedback calls/unit ranges mostly between 5-6

Feedback Calls per Unit:ECE

Program-Wise Trends over Time $plot of chunk unnamed-chunk-16$

Vertical program consistently has the highest no. of Feedback Calls/unit
Urban programs show the second highest trend consistently of Feedback Calls/unit
Feedback calls/unit drop after June 8th in the Urban program
Spike in Feedback calls/unit on Sunday can be attributed to Urban programs
Feedback calls/Unit increases in the week of June 22-29th

Response Rate:ECE

Trend Over Time plot of chunk unnamed-chunk-17

Response rate follows a cylical trend of 1 week and peaks on most Sundays
Response rate ranges from 70-80% till end June. It increases to ~85% in the last week of June
Response rate is higher from June 22-June 29(~85%)

Response Rate:ECE

Day-wise trend plot of chunk unnamed-chunk-18

Median response rate is higher on Sundays(~81%) as compared to other days of the week(~75%)

Response Rate:ECE

Program-wise trend plot of chunk unnamed-chunk-19

June 22-June 29, response rate seems to increase for most programs
For GP program, a cyclical trend of 1 week is being followed wherein a spike is observed on most Sundays
For Hamara Gaon program, a cyclical trend of 1 week is being followed wherein a drop is observed on most Sundays
Response rate of Urban program drastically drops from April 20(~75%) and drops (to ~60%) on June 15

Feedback Trends:Non-ECE

plot of chunk unnamed-chunk-20

Positive responses/Unit follow a cylical trend of 1 week and spike on Sundays. This spike corresponds with the cyclical trend of No. of feedback calls made/unit which also spikes on Sundays
Positive response(Whatsapp)/Unit follows a zig-zag trend(possibly because Digital WhatsApp content is shared on alternate days)
Positive response(Whatsapp)/Unit appears to have increased in the last week of June(~5) and is slightly more than Positive response(SMS)/Unit(~4)

Appendix

State-wise Trends

SMS Sent per Unit:Non-ECE plot of chunk unnamed-chunk-21

State-wise Trends

WhatsApp Sent per Unit:Non-ECE plot of chunk unnamed-chunk-22

State-wise Trends

SMS Sent per Unit:ECE plot of chunk unnamed-chunk-23

State-wise Trends

WhatsApp Sent per Unit:ECE plot of chunk unnamed-chunk-24

State-wise Trends

Feedback Calls Made:Non-ECE plot of chunk unnamed-chunk-25

State-wise Trends

Feedback Calls Made:ECE plot of chunk unnamed-chunk-26