tinyjo: (webdesigner - chez geek)
Emptied of expectation. Relax. ([personal profile] tinyjo) wrote2004-03-31 01:48 pm

Support stats

I have discovered http://www.supportoffice.org/my/touchdata.php - it's great! I've imported the data into SQL so that I can get loads of funky data out of it (although curse the designers of SQL server for making life difficult for anyone who doesn't want to use middle-endian dates (I think that's what they're called). I probably haven't set a setting somewhere but it's very annoying!


Category     RequestsTouched Touches     ScreenedAnswers Answers     ICs         
------------ --------------- ----------- --------------- ----------- ----------- 
All          152             226         18              59          148
clients      2               2           0               1           1
communities  14              14          12              2           0
embedding    2               4           0               1           3
general      48              63          2               12          48
styles       61              101         4               28          69
syn          12              25          0               8           17
userpics     1               1           0               1           0
web-ui       12              16          0               6           10


So, these are my stats for this month, barring a late spurt this evening (a possibility actually as it's a night in). I was surprised that I have all my answers approved in web-ui, clients and userpics but I guess this is probably because I tend not to guess in those categories. I only write answers in them rarely and they tend to only be when I'm pretty sure of the answer. In a category like styles, even though I generally am pretty sure of the answer I'll sometimes need a resubmit to correct for spelling or add a last minute FAQ addition or something just because of the frequency of my work there. Still, I'm pleased to see that my screened count is quite low for all the categories I've got supporthelp in. Actually, that's something else I could analyse for - number of requests where I left a screened and not also an answer.
...
OK, the 12 comms requests where I have screened, I don't also have answers and on one styles request. So that's pretty good, I think. I wonder what the styles request was... it was this one where I left a screened instead of an IC. So I've been approved or self-approved on all the requests I've answered in categories where I have SH which is reassuring. I have been self approving more often lately, but not always.

So anyway. You can tell that comms is the category I'm trying to learn because I'm answering there not getting approved that much while I learn. Also, I'm still a screenie so I can't tell when a better answer has already been submitted - I'll have to get over that barrier when I do eventually get I1s. In G/UNK there was enough other stuff to answer and in categories like embedding and syn there often wasn't a good answer there so it's not been a problem before but I've heard that a lot of bunnehs hang out in comms so I may have to force myself to leave answers I know won't get approved as a learning tool. I wish I could swap see screened for see ICs only but that would be weird, I guess. I'm going to do a graph later of my support activity over the whole time I've been doing it because I'm sad like that.

[identity profile] angelsk.livejournal.com 2004-03-31 04:59 am (UTC)(link)
How did you get that out of the mass of data?!?! It scared me.

I've not done that much this month - but I'm curious: http://www.supportoffice.org/my/touchdata.php?site=lj&ljuserid=824842

[identity profile] tinyjo.livejournal.com 2004-03-31 05:17 am (UTC)(link)
I saved the source as a CSV file, imported it into a SQL server database and then ran queries on it. Hang on a bit and I'll do some for you....

[identity profile] angelsk.livejournal.com 2004-03-31 05:26 am (UTC)(link)
How do you save a CSV? And where do you get a SQL server db?

[identity profile] tinyjo.livejournal.com 2004-03-31 06:45 am (UTC)(link)
If you view the source using your browser you can save the file anywhere you like. Select "All files" as filetype and manually add the .csv extention.

I'm at work at the minute so I stuck it into a table on one of my development databases. I'm too cheap to pay for SQL on my webhost :)

[identity profile] tinyjo.livejournal.com 2004-03-31 05:19 am (UTC)(link)
Hmmm. I would do it for you except I can't view your data - you must have to be logged into S0 as you to get it. If you save the source as CSV and mail it to me I'll run the queries for you...

[identity profile] angelsk.livejournal.com 2004-03-31 05:30 am (UTC)(link)
ok - emailing

...and speaking of support?

[identity profile] shepline.livejournal.com 2004-03-31 06:14 am (UTC)(link)
This reminds me... how are you getting on my style/filtering problem. Did you get the files I sent you okay once we got it past cursed MailMarshall?

...just I'm missing not being able to access my friends filters and browse back through my past months :(

Re: ...and speaking of support?

[identity profile] tinyjo.livejournal.com 2004-03-31 06:46 am (UTC)(link)
You ought to try to learn how it works yourself really - after all, I never actually gave you the code for those pages :P I have got a fix for the friends one because I'm a softy and I'll write you an email explaining the theory so that you can do the archives yourself - it'll be good for you :)

Re: ...and speaking of support?

[identity profile] shepline.livejournal.com 2004-03-31 09:02 am (UTC)(link)
That seems very reasonable. I did try to fix it, I had ideas, I tried things, I put them back when they didn't work but to no available. I think I got stuck as to whether it was the lj style or the asp pages that was at fault. I didn't think it was the former because I didn't change things in there unless I was sure what it was and it works for you, so...

But you're right. I find that I learn these things best if I get shown one thing that will allow get me so far, but then I can apply that knowledge and fix it on my own.

Thank ye for your past and future kindnesses! ^__^

[identity profile] peetm.livejournal.com 2004-04-16 10:28 am (UTC)(link)
Great link - thanks for sharing!

BTW, being a newbie, I notice you've a 'permanent account' - how does one get one of these?

Ta

[identity profile] tinyjo.livejournal.com 2004-04-18 10:12 am (UTC)(link)
I managed to get mine the last time they sold some off - about a year and a half ago, if memory serves. They're explained here (http://www.livejournal.com/support/faqbrowse.bml?faqid=38) :) You might want to stick [livejournal.com profile] news on your friends list if you think you might want one - that's where sales are announced - but don't hold your breath.

[identity profile] peetm.livejournal.com 2004-04-18 10:21 am (UTC)(link)
Thanks for the explanation, and the info/links.