PDA

View Full Version : Mods stats


hambil
04-18-2009, 05:17 PM
There are a few stats, largely surrounding installs, I'd love to be able to get.

1) Total unique installs across all mods (in other words, if one users installs 5 of my mods I want it to count as 1 in said stat)
2) Installs per version (e.g. 20 members using version 1.0, 40 using 1.1.5, etc...)
3) % of replies by installed users vs. not installed users.

None of these ask for or need a specific user name, and all the data needed appears to be already being tracked.

Hasann
04-21-2009, 04:26 PM
I don't think those will be included :/

hambil
04-21-2009, 06:52 PM
Why?

Lynne
04-21-2009, 07:16 PM
I don't know what the database looks like here, but I really doubt they keep all the info saved per version. And you are a coder, you know what would have to go into providing some of those stats and that it really might not be the best way to use server resources. (I'm guessing that - but as I said, I don't know what they have done to the database here.)

nexialys
04-21-2009, 07:32 PM
And you are a coder, you know what would have to go into providing some of those stats and that it really might not be the best way to use server resources.

not a good thing to say to Hambil, he can bring in everything needed for all his requests... rofl

the point is not to be in the situation where to evaluate what would be server-side, if hambil suggest it, i'm sure he knows what the issues would be... the point is to see if the admins are interested to see this implemented... all solutions are codable...

Lynne
04-21-2009, 07:58 PM
I guess what I was saying is that unless there are some special columns added to the database, I'm guessing it would be quite server intensive to get all those stats. I know I recently implemented something on my site that is similar to what he is wanting (not the same, but similar in that you are looking through lists of who downloaded what and matching things up) and it can be server intensive depending on how it is implemented. Perhaps I worded my reply wrong cuz I certainly was not trying to insult anybody. I just know I can't evaluate this cuz I don't have the information needed to do so.

nexialys
04-21-2009, 08:04 PM
i would just say a word for what we just need... cached data... :)

Lynne
04-21-2009, 08:07 PM
.... which would need to be coded, and like you said, it is a matter of whether the admins think it is worth putting the time and effort into.

hambil
04-21-2009, 09:12 PM
Well, the data is certainly already being pulled. For example, when I look at a thread for my mod every reply has whether the user has my mod installed, and what version. So it's just a matter of adding a couple variables in a hook and a template mod to present them.

As for the unique across all mods stat, again, the data is already being pulled. The total installs for each of my mods and my total overall installs in listed on my profile page. At worst it would be a matter of adding an additional join or where clause to an exiting query, which is how the original data is getting pulled out anyway.

In short, none of the requested stats should require any new queries or have any impact of server load. They would of course require a minimum amount of hook coding and some small template edits.

Paul M
04-21-2009, 09:12 PM
1) Total unique installs across all mods (in other words, if one users installs 5 of my mods I want it to count as 1 in said stat)
2) Installs per version (e.g. 20 members using version 1.0, 40 using 1.1.5, etc...)
3) % of replies by installed users vs. not installed users.

1. Possible, but I dont really see what use it is.

2. Possible, and actually would be useful information.

3. More difficult, and I really cant see what use it is.

(4) I would also like to see installs split by month as well as by version.

So, 2 and 4 are likely at some point, but I dont know when, 1 is unlikely, 3 is very unlikely.

hambil
04-21-2009, 09:21 PM
1 helps me track how well my brand is working. The more 'cross mod' users I am getting the better a job I am doing of marketing my 'brand'.
3 helps me understand what mods I need to do a better job of 'marketing' in terms of getting the users to click install. Some people may never click install, and that is always there choice, but many just might need more reminding, or bugs fixed, or more attention in some way by me. You know this one Paul, it's why you put 'please click install' in the display as your mods install, and why you do a number of other things.

Not sure, as stated above, how it would be difficult since all the data is there and it's just a % that can be done with a simple counter of unique users in one of the postbit hooks that are obviously already heavily modified and very familiar to you anyway.

3 is also a stat I can calculate by hand if I wanted, so it's not hidden data or anything secret. It's just a pain to do by hand if you have a very long mod thread.

4, added by you, would also be helpful to track fall off rates (or growth rates) for mods, as well as potentially detect other patterns.