Design/UX #17018
openAnalytics for Profile Fields & Features
0%
Description
Hello! Can I get some database queries for some stats on the following?
- Can you pull links to the top 25 most active profiles?
- under your profile, you see the stat “Your profile is X% complete”. Can you pull % of profiles 100% complete, % of profiles below 75% complete, % of profiles below 50% complete, and % of profiles below 25% complete
- % of profiles Using IM Link, How many have added IM link in the past 2 years, in the past 3 months
- % of profiles Using Flickr ID, How many have added Flickr ID in the past 2 years, in the past 3 months
- % of profiles Using Delicious ID, How many have added Delicious ID in the past 2 years, in the past 3 months
- % of profiles Using ORCID ID, How many have added an ORCID ID in the past 2 years, in the past 3 months
- % of profiles Using Google Scholar, How many have added Google Scholar in the past 2 years, in the past 3 months
- % of profiles Using Blog URL, How many have added Blog URL in the past 2 years, in the past 3 months
- % of profiles Using RSS Feed, How many have added an RSS Feed in the past 2 years, in the past 3 months
- % of profiles Using the status update, How many have added a status update in the past 2 years, in the past 3 months
Thank You
Related issues
Updated by Boone Gorges about 2 years ago
Hi Sara - Happy to help get some of this data for you.
- Can you pull links to the top 25 most active profiles?
What is "active"? Is it "most visited"? "Most frequently updated"? "Has the most content filled in"?
- under your profile, you see the stat “Your profile is X% complete”. Can you pull % of profiles 100% complete, % of profiles below 75% complete, % of profiles below 50% complete, and % of profiles below 25% complete
These numbers are generated on the fly, using some heuristics described at https://redmine.gc.cuny.edu/issues/3012#note-4. I wrote a script that walked through each user on the site and calculated. It seems that the vast majority of users have very little filled in at all. It might be interesting to take a cross-section of users who are most recently active, or most frequently active, but this is at least a starting point.
0%: 16,165 / 39,743 (40%)
10%: 16,673 / 39,743 (41%)
20%: 3,130 / 39,743 (7%)
30%: 1,884 / 39,743 (4%)
40%: 981 / 39,743 (2%)
50%: 426 / 39,743 (1%)
60%: 235 / 39,743 (0%)
70%: 132 / 39,743 (0%)
80%: 78 / 39,743 (0%)
90%: 31 / 39,743 (0%)
100%: 8 / 39,743 (0%)
- % of profiles Using IM Link, How many have added IM link in the past 2 years, in the past 3 months
- % of profiles Using Flickr ID, How many have added Flickr ID in the past 2 years, in the past 3 months
- % of profiles Using Delicious ID, How many have added Delicious ID in the past 2 years, in the past 3 months
- % of profiles Using ORCID ID, How many have added an ORCID ID in the past 2 years, in the past 3 months
- % of profiles Using Google Scholar, How many have added Google Scholar in the past 2 years, in the past 3 months
- % of profiles Using Blog URL, How many have added Blog URL in the past 2 years, in the past 3 months
- % of profiles Using RSS Feed, How many have added an RSS Feed in the past 2 years, in the past 3 months
I don't have the ability to determine when people added the data. As you'd probably guess, things like IM, Flickr, Delicious have been defunct for years, and all existing instances are probably ancient. Here are current raw numbers for each (again, out of ~39,000 user accounts):
- IM: 272
- Flickr ID: 227
- Delicious ID: 194
- ORCID ID: 152
- Google Scholar: 161
- Blog URL: 804
- I don't see an RSS field, but the Website field has: 2343
- % of profiles Using the status update, How many have added a status update in the past 2 years, in the past 3 months
The first number is unique user IDs. The second is a raw number of how many status updates have been posted.
All time: 511 2529
Since 2020-10-12: 53 81
Since 2022-07-12: 8 8
Updated by Boone Gorges almost 2 years ago
- Status changed from New to Reporter Feedback
- Target version set to Not tracked
Updated by Colin McDonald over 1 year ago
- Related to Design/UX #17385: Profile CV & Account Settings added