The next big feature Denise and I are focusing on is with the update page (draft/scheduled posts). Anyway, I did some stats on popular entry properties (logprops) which are those things that you can change on your entry. Mood, location, music, etc.
mysql> select lpl.name, round(count(*)/2726795*100,4) as 'pct'
from logprop2 lp, dw_global.logproplist lpl
where lp.propid = lpl.propid group by 1 order by 2 desc;
+---------------------------------+---------+
| name | pct |
+---------------------------------+---------+
| opt_backdated | 94.3205 |
| import_source | 93.6952 |
| commentalter | 61.6888 |
| picture_keyword | 50.8513 |
| current_moodid | 47.2920 |
| taglist | 42.5932 |
| current_music | 22.9734 |
| current_mood | 15.8868 |
| opt_preformatted | 7.0147 |
| used_rte | 5.9983 |
| current_location | 5.8955 |
| revnum | 5.2326 |
| revtime | 5.2326 |
| xpost | 2.7042 |
| pingback | 1.4610 |
| opt_screening | 0.9731 |
| opt_nocomments | 0.8044 |
| hasscreened | 0.6988 |
| adult_content | 0.4056 |
| useragent | 0.3082 |
| opt_noemail | 0.1677 |
| sms_msgid | 0.0780 |
| qotdid | 0.0635 |
| adult_content_reason | 0.0579 |
| copyright | 0.0010 |
| adult_content_maintainer_reason | 0.0001 |
| adult_content_maintainer | 0.0001 |
| syn_id | 0.0000 |
| syn_link | 0.0000 |
+---------------------------------+---------+
29 rows in set (18.98 sec)Some of these are straight up imports from LJ (qotdid, copyright?) and don't apply to us. If you filter out the useful ones, you get a really clear picture of which options are often used. Note that this is from the Alpha Centauri cluster only, but I expect it's representative of the entire userbase since we randomly distribute users.
To break this down by feature:
* Set userpic: 51%
* Current mood (id): 48%
* Crossposted: 43%**
* One or more tags: 42%
* Current music: 22%
* Current mood (text): 15%
* Preformatting: 7%
* Current location: 5%
* Comment screening: 1%
* Comments disabled: 0.8%
* Adult content set: 0.4%
* Comments no email: 0.16%
* Adult content reason: 0.05%
That should cover all of the widgets down below. I think this means we could pretty easily split up the options into groups:
* High usage: Userpic, Mood, Tags, Crosspost**, Music
* Low usage: Preformatting, Location, Comment Options, Adult Content
** The Crosspost values differ from the SQL output to the final data. This is because xpost can ONLY be set on entries that were NOT imported. The SQL query pulls data across all posts: including imports. If you factor out imported posts, 43% of all posts on this cluster have been crossposted, hence, the feature is far more popular than suggested by the query itself.