Month | send_hour | send_minute | opens | sent_messages |
Dec-13 | 6 | 40 | 412,639 | 2,840,609 |
Dec-13 | 6 | 50 | 462,340 | 3,483,407 |
Dec-13 | 6 | 60 | 179,751 | 1,306,442 |
Dec-13 | 7 | 0 | 73,722 | 542,949 |
Dec-13 | 7 | 10 | 61,500 | 446,251 |
Dec-13 | 7 | 20 | 19,644 | 138,006 |
Dec-13 | 7 | 30 | 7,599 | 54,839 |
Dec-13 | 7 | 40 | 7,281 | 53,831 |
Dec-13 | 7 | 50 | 3,664 | 27,625 |
Dec-13 | 7 | 60 | 2,273 | 15,229 |
Dec-13 | 8 | 0 | 347 | 2,367 |
Dec-13 | 8 | 10 | 4,279 | 28,790 |
Dec-13 | 8 | 20 | 4,830 | 30,853 |
Dec-13 | 8 | 30 | 845 | 4,666 |
Nov-13 | 6 | 40 | 429,676 | 2,664,656 |
Nov-13 | 6 | 50 | 460,861 | 3,222,928 |
Nov-13 | 6 | 60 | 176,842 | 1,212,390 |
Nov-13 | 7 | 0 | 74,331 | 535,237 |
Nov-13 | 7 | 10 | 76,548 | 517,437 |
Nov-13 | 7 | 20 | 16,007 | 110,360 |
Nov-13 | 7 | 30 | 32,812 | 208,787 |
Nov-13 | 7 | 40 | 26,034 | 188,754 |
Nov-13 | 7 | 50 | 4,115 | 24,235 |
Oct-13 | 6 | 40 | 543146 | 3386838 |
Oct-13 | 6 | 50 | 577983 | 4073873 |
Oct-13 | 6 | 60 | 158810 | 1095816 |
Oct-13 | 7 | 0 | 59696 | 413251 |
Oct-13 | 7 | 10 | 30745 | 214236 |
Data Points : |
send_hour & send_minute : Hour & Minute when the email was sent |
opens : Number of Users who opened the email |
sent_messages : Total number of emails sent |
**Unique open_rate : Opens/Total number of emails sent |
Question : |
Please perform a root cause ananlysis and suggest the possible reason behind the sudden drop in Dec 2013 |