Author Topic: Uninstall Survey Parser  (Read 3385 times)

jitspoe

  • Administrator
  • Autococker
  • Posts: 18802
Uninstall Survey Parser
« on: September 16, 2012, 08:57:12 PM »
Anybody want to help out with this?  It should be fairly simple for anybody looking to do a little script/program.  Basically, I want a program to parse through the uninstall surveys and generate stats based on why people uninstalled.

Examples:

Quote
date: 2012-09-13
ip: 123.4.5.6
build: 35
useragent: Mozilla/5.0 (Windows NT 6.2; rv:15.0) Gecko/20100101 Firefox/15.0.1
responses: norun
whyuninstall: The game did not find a OpenGL driver. :'(

OS: Win 8 Preview Edition 32 Bit
CPU: Intel Celeron T3100 (2x 1,9 GHz)
RAM: 3 GB DDR3
Graphics: Mobile Intel(R) 4 Series Express Chipset Family

Greetings from Germany
Nico

needchange:

--------
date: 2012-09-14
ip: 123.45.6.78
build: 35
useragent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20100101 Firefox/15.0.1
responses: nosingleplayer
whyuninstall:
needchange:

--------
date: 2012-09-14
ip: 12.34.56.78
build: 35
useragent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; GTB7.4; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; eSobiSubscriber 2.0.4.16)
responses: diffversion norun noserver nofun badgraphics badsound badcommunity difficultmaps gotowned bored notime loginproblems kicked nosingleplayer other
whyuninstall:
needchange:

--------

Ultimately what I'd like to get is %'s of each reason for uninstalling a particular build, so I'd like to find all the build 35's and get a breakdown of what % uninstalled for nosingleplayer, norun, etc.  Sometimes "build:" is blank.  Also, a lot of people are just idiots/jerks and check everything, so if there's more than 12 responses, ignore it.  The whyuninstall/needchange fields are open-ended and are often blank, so maybe a summary of all the non-blank ones at the end would be nice.

I guess php would probably be best for this, but just about anything would work.

If you want to get fancy, you could get OS stats from the useragent and exclude/merge entries from the same IP, but that's not critical at this point.
« Last Edit: September 17, 2012, 02:20:23 PM by jitspoe »

capo

  • VM-68
  • Posts: 249
Re: Uninstall Survey Parser
« Reply #1 on: September 17, 2012, 06:01:53 AM »
My php skills aren't the strongest. But I'll give it a shot, even though we have a love/hate relationship.

T3RR0R15T

  • Map Committee
  • Autococker
  • Posts: 2593
Re: Uninstall Survey Parser
« Reply #2 on: September 17, 2012, 09:24:37 AM »
Is it a file or comes it from a database?

jitspoe

  • Administrator
  • Autococker
  • Posts: 18802
Re: Uninstall Survey Parser
« Reply #3 on: September 18, 2012, 11:53:23 AM »
File for now.

Payl actually wrote a little parser for it.  Here are the results, if anybody is curious:

nofun 506  16%
gotowned 223   7%
norun 453  14%
kicked 175   6%
loginproblems 174   6%
noserver 173   5%
badcommunity 172   5%
badgraphics 408  13%
difficultmaps 147   5%
other 653  21%
nosingleplayer 590  19%
bored 331  11%
badsound 279   9%
diffversion 263   8%
notime 261   8%

As I suspected from browsing the results, no single player is the biggest complaint (aside from other, which is usually people not checking the appropriate box)

T3RR0R15T

  • Map Committee
  • Autococker
  • Posts: 2593
Re: Uninstall Survey Parser
« Reply #4 on: September 18, 2012, 02:12:15 PM »
Wow, never thought that so many players want a single player. We can make maps and create a story, but thats only one part. The other is the bot ki, that need to be tweaked for it.
We have a hr4 pack now, so bad graphics should be lower in the future. Maybe nofun is because of bad graphics, kicks or login problems. Can you parse it to get all results from nofun + something else?
The other big thing is norun. What can we do for it? Maybe add something, that creates a crashdump. But would that really help to find the reason?

Foxhound

  • Autococker
  • Posts: 952
Re: Uninstall Survey Parser
« Reply #5 on: September 18, 2012, 02:22:48 PM »
:D looks like you need a single player *cough* OR HORDE MODE.


Of course this means bot AI should be next. (+ no Aimbot)


 




please

ic3y

  • Committee Member
  • Autococker
  • Posts: 1398
Re: Uninstall Survey Parser
« Reply #6 on: September 19, 2012, 08:35:48 AM »
Release bot source

jitspoe

  • Administrator
  • Autococker
  • Posts: 18802
Re: Uninstall Survey Parser
« Reply #7 on: September 19, 2012, 08:52:19 AM »
norun is usually due to opengl issues, I think.

Zorchenhimer

  • Autococker
  • Posts: 2614
Re: Uninstall Survey Parser
« Reply #8 on: December 14, 2012, 03:38:45 AM »
:D looks like you need a single player *cough* OR HORDE MODE.

When I lived in a dorm (back when I started playing) my roommate and I would start a server with just the two of us on the same team and up the grenade spawns.  Then add ~30 bots to the other team and set the respawn time to ~5 seconds.  So much fun was had.  Most rounds ended in both of us dying, but once in a blue moon we won, and when we did it was so very satisfying.  There was one map that we always played on, but I can't remember the name.


(Yes I know this thread is three months old. Quiet)