Method
My method for collecting this data is downloading Verizon's bill. One can see their text message usage from this. If I were better at coding, I would try to write an application that extracted the text message data (date time, number, person, content). But, I am not a good coder at all. And I do not want to download someone else's app...who knows what they would do with my information!
Also, my work shift is Tuesday through Saturday, 1600 to 0000; I have a forty-five-minute commute. Any texts in that commute time are sent from Google Voice!
High-Level Results
This table speaks for itself. A small decrease of texts in August and almost the same amount!
Month Name |
Received | Sent | Total Result |
July | 1691 | 2154 |
3845 |
August | 1743 | 2084 |
3827 |
When Are My Active Hours?
I received and sent at least one text message every hour during the month of August. I must be a robot because I do not sleep! With that said, it looks like I usually fall asleep between 0400 to 0500 and then wake up at 1100. Although, I still send a lot of messages between 0500 to 1100...what the heck!
I communicate the most at 0100, although most people reply at 1100. Apparently, they sleep at 0100.
Hour |
Received | Sent | Grand Total |
00 |
61 | 93 |
154 |
01 |
148 | 250 |
398 |
02 |
51 | 64 |
115 |
03 |
9 | 17 |
26 |
04 |
1 | 9 |
10 |
05 |
4 | 2 |
6 |
06 |
4 | 7 | 11 |
07 |
13 | 12 | 25 |
08 |
29 | 39 | 68 |
09 | 83 | 87 |
170 |
10 | 88 | 78 |
166 |
11 | 190 | 192 |
382 |
12 |
149 | 165 | 314 |
13 |
98 | 117 | 215 |
14 |
67 | 76 |
143 |
15 |
56 |
65 |
121 |
16 |
68 | 79 |
147 |
17 | 99 | 108 |
207 |
18 |
35 |
46 | 81 |
19 |
90 | 80 | 170 |
20 |
86 |
99 |
185 |
21 | 99 |
127 |
226 |
22 | 116 |
152 |
268 |
23 | 99 |
120 |
219 |
Grand Total | 1743 | 2084 |
3827 |
What Happens During the Weekdays?
Mondays and Thursdays were my most active days to text overall. During these two days, 38.61% of my texts were received and 38.24% of my texts were sent.
Weekday |
Received | Sent | Grand Total |
Sunday |
195 | 252 | 447 |
Monday |
328 | 400 | 728 |
Tuesday |
198 | 233 | 431 |
Wednesday |
278 | 317 |
595 |
Thursday | 345 | 397 |
742 |
Friday | 211 | 278 |
489 |
Saturday | 188 | 207 |
395 |
Grand Total | 1743 | 2084 |
3827 |
I texted on Mondays at a different peak hour of 2300. This means for the whole week, about 65% of my texts during 2300 were on Monday, even though they were only 20% of my total texts on Monday.
Thursdays’ peak time is more consistent with the rest of the week. At 1200, I received 17.4% and sent 17.63% of my texts for Thursday. During this time period on Thursday, the texts make up 40% of the entire weeks’ 1200 (time) texts.
Monday |
||
Hour |
Received | Sent |
01 |
2 | 6 |
12 |
3 |
4 |
22 |
43 |
66 |
23 | 65 |
78 |
Thursday |
||
Hour |
Received | Sent |
01 |
40 | 60 |
12 | 60 |
70 |
22 | 19 |
23 |
23 | 6 |
9 |
As we can see, I do not have a consistent sleep schedule. Mondays have an entirely different off-peak time and I somehow text a bunch on Thursdays at noon. I wonder what is so interesting on Thursdays!?
Top 10 Communicators
Brandon 1 and Colin make up 35% of my texts received and 39% of my texts sent. Holy cow I text them a ton!
Oh and my mom is number 9! Hi mom!
Rank |
Person | Received | Sent | Grand Total |
1 |
Brandon 1 | 315 | 435 | 750 |
2 |
Colin | 297 | 381 | 678 |
3 |
Rob |
317 |
332 |
649 |
4 |
Eva | 169 | 216 | 385 |
5 |
Brandon 2 | 172 | 64 |
236 |
6 | Cody | 80 | 135 |
215 |
7 | Tyler | 83 | 98 |
181 |
8 | Chris | 70 | 92 |
162 |
9 | Mom | 53 | 77 |
130 |
10 | John 1 | 19 | 51 |
70 |
Brandon 1 and Colin have the same peak days as the entire week: Monday and Thursday.
By combining Brandon 1’s and Colin’s texts, I know that 40% of my texts that I receive and are from/to them on Mondays. On Thursdays, 23% of my texts are from them and 30% of texts are to them.
I do text Brandon 1 and Colin during similar peak hours as the rest of the week: 2300 on Mondays and 0100 on Thursdays.
Brandon 1 |
||
Weekday |
Received | Sent |
Sunday |
47 | 65 |
Monday |
57 | 81 |
Tuesday |
43 | 46 |
Wednesday | 38 |
58 |
Thursday | 38 |
50 |
Friday | 38 |
51 |
Saturday | 54 |
84 |
Grand Total | 315 |
435 |
Colin |
||
Weekday |
Received | Sent |
Sunday |
25 | 30 |
Monday |
72 | 83 |
Tuesday |
29 | 34 |
Wednesday | 54 |
62 |
Thursday | 51 |
64 |
Friday | 60 |
93 |
Saturday | 6 |
15 |
Grand Total | 297 |
381 |
Weekday |
Hour | Brandon 1 | Colin | ||
Received |
Sent | Received |
Sent |
||
Monday |
01 | 0 | 0 | 2 | 5 |
23 | 14 | 16 | 19 |
21 |
|
Thursday |
|||||
01 |
20 | 25 | 4 | 9 | |
23 | 0 | 1 |
0 |
0 |
The Averages
Although Brandon and Colin’s peak weekdays and times were Monday & Thursday and 2300 and 0100, I wonder what the rest of the week looks like? The highest average, if you will.
On average, I received 249 and sent 297 texts during the week & received 72 and sent 87 texts per hour.
On Monday and Thursday, I had the highest average of received and sent texts.
During the hours of 1100 and 1200, I had the highest average amount of received texts, while 0100 and 1100 had the highest average sent.
Type |
Received | Sent |
Hour |
72.63 |
86.83 |
Weekday | 249.00 |
297.71 |
Conclusion
I think the overall conclusion is I am crazy for keeping track of all of this data. What will I do with it? Make these reports! I think this small case study allowed me to explore what my data can do. It also gives me a better idea of how to answer any questions I have about it.
When I get around to it, I think it will be interesting to see the rankings of everyone and how they change over time. As some may know, life moves forward and people come in and out of your life. I can see that in action through my text messaging, which is very interesting to me.
Come on over to the Google Sheet to check out the Pivot Tables and raw data.