I automatically collected stats about my Gmail account…here’s what I found
Back in December, I started automatically collecting stats about my personal and work Gmail accounts every hour…of every day….of every week. It started as pure curiosity to see if the Gmail API was easy to work with in AppScript (it is), but turned into figuring out things like how much email I churn through, and when the busiest times of the day were.
Median received email for the last 3 months….
I wonder what that looks like for “unread” email in my inbox?
Emails from my own domain?
What about emails from External addresses (not my domain)?
So..it looks like people from other organizations email me during “daylight” hours, whereas there’s a steady flow of email from within my domain (which includes automated process emails of course too).
I also collected stats about emails from a particular product to see what that looked like.
This one i had to do a MAX() count on, instead of median, because there was a problem with this particular dimension that i needed to work out.
What about Spam?
I also collected info about my sent items, to see what i was generally sending email during the day.
But if i reduce to just working hours, my work account looks like this:
By the way, it’s easy to figure out when a metric is from a weekday & working hour in datastudio …the code looks like this:
WHEN HOUR(Audit_Date) > 7 AND HOUR(Audit_Date) < 18 AND WEEKDAY(Audit_Date) > 0 AND WEEKDAY(Audit_Date) < 6 THEN TRUE
Basically, get the HOUR and WEEKDAY of the given date, and if those are Mon-Fri 8–5, then the dimension value is TRUE. Then we can create data controls to filter the report by those things.
I still need time to dig into all this. I can already tell certain patterns (not everything was included in this post) about my activity. I tend to send emails in the morning, and then right after lunch. But, even though there’s a steady stream of email coming into my inbox, I tend to keep it fairly well pruned and managed. That fits with how i prefer to do things too. Im not a first-in-first-out emailer. I’ll judge things based on priority, or ability for me to quickly get it off my plate, and then also try not to keep others waiting on me for simple things.
What this doesn’t capture is chat activity. I do have google calendar activity though…which is for another blog. I’ve been collecting that since before i started collecting gmail stats.
If you’re interested in the code that i used to do this, here’s the repo.
Appscript to pull stats from gmail and store in a google sheet - usaussie/appscript-gmail-stats
If you need instructions on how to use the appscript, check out my other medium articles like this one when i first posted about this process of collecting gmail stats.