for Competitive, I’d like to know how many games I have played in each role, so I can keep the roles equally played. Thanks!
keeping track of hours on each role would be good too 
4 Likes
more stats is always good
1 Like
that’s my philosophy!
I actually do that myself. I have a Google sheet where, prior to this season, I tracked every comp match, including:
Day of week, Date, Time of queue entry, W/L/D, Starting SR, Ending SR, change in SR, Map played, role played, and whether I found the match through LFG or Solo queue. Tracking these stats let me derive all sorts of other interesting tidbits of information. I can see my W/L/D record (and win pct) by time of day, day of week, by map, by role, by solo and LFG queues. It’s not life changing, but it’s fairly interesting to look over from time to time.
I had to change it for the role queue system. So now I’m actually tracking it on three different “mini” sheets, one for each role. But since all the columns still line up, it doesn’t mess with any of my derived stats.
The only downside is that I have to alt-tab out of OW after each comp match to update the sheet. No big deal.
Here, take a look:
h
ttps://docs.google.com/spreadsheets/d/1r_0-pNf3XWbOZpUZ696aF0MShD2YVVP_r40i9tAvAns/edit?usp=sharing
Make sure you scroll the tab list all the way to the right to select the more recent seasons. You’ll notice that in early seasons, it was extremely rudimentary. It got more and more advanced as I played more seasons, drilling down to the data I wanted to collect.
You don’t have to do anything to the tables on the right side of the sheet. They all update automatically as you fill in the data on the left side of the sheet.
Look at Season 17’s tab for how I ended it last season. I haven’t started the mini beta season yet, but I made a tab for it already, called “Season 18” though I know that’s not quite right. You can see how I split out the different roles into different mini-tables. The most important thing is not to add or remove any columns, or the data on the right side won’t auto-update correctly. It’s also not lost on me that the sheet shows how horribly hardstuck I’ve been in bronze all this time. Yeah, I suck.
Hope it’s useful. Enjoy.
2 Likes
One more thing… if you decide to use it, there’s a keyboard shortcut that might be useful.
When entering the time of queue entry, select the cell, and press CTRL+Shift+; which will automatically stamp the current time into that cell.
1 Like
awesome! kaawumba might’ve been interested but like he said, past data isn’t as worth as much since role queue 
oh well
hey Kaawumba, thanks for all the hard work, check out this guy’s data, didn’t know if you two already shared data. cheers!
Seriously, I don’t there’s any revelations to be had in tracking data the way that I have been. I use spreadsheets a lot in my job (no, seriously A LOT), and I am a sick puppy who actually enjoys working with them, so I thought I’d apply some of those skills to Overwatch. So it’s all really for my own sick, twisted enjoyment.
Honestly, all humility aside, the coolest part of my spreadsheet is all the derived stats, which get put together with array formulas. Had to look some of that stuff up when I designed it. One oddball data point I’ve come up with is how good my win pct is when playing matches between 5pm and 6pm, then drops off a cliff at 6pm, regardless of the day of the week. I have no explanation for that.
1 Like
a good stat I’d like to have is my win percentage on each map. even as detailed as objective progression. Unless I track stats like you, I wouldn’t know if Bastion is a good pick to attack hanamura. If I had the stats I would know.
It would be awesome if Overwatch kept these kind of stats for me. I remain hopeful 
You can feel free to copy/paste my spreadsheet into your own, erase my data, and start using your own (use the Season 18 spreadsheet, which accounts for role queuing). Play enough matches, and it will tell you what your W/L/D pct is for a given map. You could even track that over several seasons if you wanted to create a “Meta Sheet” that tabulated everything across all comp seasons. It’d be a pain to update a meta sheet like that every season, but it’s possible.’
But I have found that the way people play each map can vary wildly over the course of 2 or 3 seasons. When Bastion, for example, might have been a great pick on one map, then suddenly everyone figures out how to counter him on that map, and suddenly he’s not such a good pick.
I tried to collect stats on win pct by hero for a while, but the problem with that is sometimes I might switch off. For a while, I was playing Orisa on defense and Rein on attack, so it got difficult to capture a W/L/D record for ONE hero in a case like that. It made the entire spreadsheet a pain in the ***, and less fun to deal with, so I just stuck with capturing the Role that I played. You’ll notice in the later seasons, I could select a role I called “It’s Complicated,” for when I played more than one role in that match, which was EXCEEDINGLY rare in my matches. And now with role queue, I don’t expect I’ll ever change roles, so I don’t bother tracking that anymore.
1 Like