Project

General

Profile

Actions

Design/UX #17018

open

Analytics for Profile Fields & Features

Added by Sara Cannon 4 months ago. Updated 4 months ago.

Status:
New
Priority name:
Normal
Assignee:
Category name:
-
Target version:
-
Start date:
2022-10-12
Due date:
% Done:

0%

Estimated time:
Deployment actions:

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

Actions #1

Updated by Boone Gorges 4 months 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

Actions

Also available in: Atom PDF