Here lies Analytics

Hey everyone! I’ve been analyzing game data from Turret Queen (from players that didn't opt-out) and wanted to share:

Tough Spots

I plotted where and when players tend to lose their lives. It’s interesting to try to make sense of it!
Here is where people die the first, second, and third times: Here I broke it down into the time of death as well: This one is a bit weird, but I ranked the top 5 moments of the game where people lost, by grouping every death timer into 5-second splits, counted, ranked, then cross-referenced it with the positions, and got this: (Now I notice it is kind of hard to see the colors here, I'm sensing a pattern with me :confused:)

Enemy Fire vs. Collisions

It turns out that enemy shots are a bigger threat than running into them. Total deaths caused by enemy shots: 102.0 Total deaths caused by collisions with enemies: 70.0

Turrets!

I found out which powerups are grabbed the most (which is basically a tie). That kind of confirms the fact that they are hard to see and identify. But also that I was able to balance the powerups that appeared without using any random function. Total of Powerup 1: 427 Total of Powerup 2: 432 Total of Powerup 3: 406 The strongest turret ever built had a total sequence of 22 Powerups!!!
Specifically:
Powerup1: 3, Powerup2: 15, Powerup3: 4 Worthy of note, the ship only holds 10 powerups at once, and the game only counts the same consecutive powerup But if you are fast enough, you can grab more powerups during the turret assembly.

Top 5 constructed turrets:

| powerup1| powerup2 | powerup3 | how many | | -------- | ------- | -------- | -------- | | 1 | 1 | 1 | 195 | | 1 | 2 | 1 | 32 | | 1 | 1 | 2 | 25 | | 2 | 1 | 1 | 23 | | 3 | 1 | 1 | 17 |

When Players Quit

I looked at how many times players die before they decide to quit or restart.

| Deaths | Session Count | |---|---| | 3 | 22 | | 1 | 15 | | 2 | 8 | | 6 | 3 | | 21 | 1 | | 10 | 1 | | 13 | 1 |

Average deaths per session: 3.057 Average victories per session: 0.076 The game was only beat 4 times.
Maaaybe I need to fix something. (sarcasm)

Death Maps

Cool heatmaps: Game over man, game over

A bit on how this was done: - Data was sent via a AWS lambda - Saved on a dynamoDB instance - Exported the whole thing to a few csv files - Used some magic python libs on jupyter to plot these graphs

Anyway, from the data and feedback, it is apparent that the moment the first enemy shot appears is way too punitive. Also the time between losing the first life and then the 3rd is way to short, also confirming the feedback of multiple players, that the game becomes very hard after the first life is lost.

Thanks for playing. I hope you all enjoy looking at tables and graphs as much as I do! If anyone wants to know more, let me know, I would love to share.

PS: I was writing this and inadvertently closed the tab and lost the whole thing, had to write it all over again (its 2AM) so please forgive any weirdness. (I could not find the draft on my user page even thought I saved it)