Did you know only 12.6% of submissions ever make it to 1,000 supporters or beyond? Or the fact that 86% of projects reaching 5K go on to make it 10K? You'll find those answers and more in Part 2: Milestones.
Plus, as an additional feature, I'll throw in some Fun Facts such as... who submitted the most builds? Which projects JUST made or missed a given milestone...
Click here for a popup on what makes up the data:
Question 1:
What percentage of submissions end up at each of the milestones?
Items of note:
- 87.4% achieve fewer than 1K supporters (44.2% don't get to 100)
- the 87.4% comes from adding the 44.2% who submitted a project but did not make it to 100, and the 43.2% who made it 100 but no further
- Only 3.8% of submissions make it to 10K
- The majority of projects making it to 5K go on to 10K (88%)!
- this comes from dividing those that went on to 10K (460) by the total who reached 5K (60) or 10K (460) or 460/520
- 5K seems to be the magic number then where, odds are, you're going to make it to 10K
Question 1 chart data:
(a table view of the data used for the chart)
Question 2:
What percentage of submissions reach/passthru a given milestone?
In other words, say we're asking how many made it to 1K; this would include those that ended up at 1K (like the above chart) AND those that kept going to 5K and 10K.
Items of note:
- 12.6% make it to 1K or above
- 4.3% make it to 5K or above
Question 2 chart data:
(a table view of the data used for the chart)
(a table view of the data used for the chart)
Build-a-haulics: Users with the most submissions
Just Made It: Fewest number of supporters over a milestone
Missed It by that Much: Closest to a milestone without actually achieving it
Patience is a Virtue: Most days to reach a milestone
* not sure how some of these went longer than the max, but indeed they did
up next: The B-I-G 10K
Posts
Did you account for name changes on the users with most submissions?
ReplyDeleteYou may have to re-track all the projects for each user towards the top of the community pages.
I didn't use the user name as you're right, that can be changed. Each user has a unique ID which you can see in the URL when you're on a profile. I used that. Also, this data covers Jan 1, 2020 - Feb 20, 2024 so I'm not claiming these are the ALL-TIME users with the most submissions... just those over the past four years.
DeleteThanks for asking!
Oh, and as I mentioned in Part 1: Introduction, it only includes submissions that have completed their journey... expired or reached 10K. I realize that's not quite fair for counting submissions but I can't include those for all the other analysis as it would skew the results. I suppose I could have used two different data sets but I wasn't inclined to do so. :)
DeletePerhaps I need to call out the dates covered and only completed submissions on each post?
Regarding the user who exceeded the number of max days (791 vs 789) I can confirm you have a little bit of time after reaching zero days where votes are still accepted. It is usually around 24 hours i.e hits 0 days, then 23 hours, then down to minutes, then displays 0 minutes until the idea gets moved to expired - this appears to be manually done. Its possible this is what happened in this case.
ReplyDeleteThat seems perfectly plausible... thanks for the explanation!
DeleteIsn't the percentage of builds that reach 5k and also go on to reach 10k 88%? I got that by dividing 3.8%/(3.8% + 0.5%) or 460/520.
ReplyDeleteYou are absolutely right and I've corrected it... from 86% to the new number of 88%. Thanks for helping this non-statistician!
Delete