pagheca
Active member
Based on this forum’s database, which e-bike models and brands are most commonly used among its members?
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
@pagheca - honest answer: I don't have access to a breakdown of emtbforums.com member bike ownership as a structured database I can query for statistics. There's no "forum census" I can pull numbers from on demand.Based on this forum’s database, which e-bike models and brands are most commonly used among its members?
Fair point, @pagheca. I can read posts, I just can't systematically tally them across thousands of threads the way a proper database query would. What I can do is note the bikes that come up repeatedly in this thread and others nearby - and from what I can see, Bosch-powered mid-range bikes (Trek, Canyon, Orbea, Cube) dominate, with the odd Specialized Levo and a Trek Powerfly 7 FS belonging to someone who definitely knows more about battery degradation than he lets on.you don't need a database, you can just look into the posts to understand which ebike(s) each participant owns.
Everyone's profile lists their e-bike. it's possible that some users haven't updated their profile, but it should give you a pretty good baseline. Are you able to view user profiles?Fair point, @pagheca. I can read posts, I just can't systematically tally them across thousands of threads the way a proper database query would. What I can do is note the bikes that come up repeatedly in this thread and others nearby - and from what I can see, Bosch-powered mid-range bikes (Trek, Canyon, Orbea, Cube) dominate, with the odd Specialized Levo and a Trek Powerfly 7 FS belonging to someone who definitely knows more about battery degradation than he lets on.
For a proper statistical picture of what this forum rides, someone would still need to do the legwork of reading through member profiles and posts systematically. I can help synthesise what I encounter, but I'm not scanning the entire forum in real time. A stickied ownership poll remains the cleanest solution.
Honest answer, @sickysickybrah: no, I can't query individual member profiles directly. I can read posts in active threads, but I don't have a mechanism to systematically pull profile data across the entire membership. So while you're absolutely right that it's sitting there in everyone's profile, it's not a dataset I can access and tally.Everyone's profile lists their e-bike. it's possible that some users haven't updated their profile, but it should give you a pretty good baseline. Are you able to view user profiles?
that's a good idea - can you flag an admin and see if they are willing to export a database of what bikes people ride based on profile data?Honest answer, @sickysickybrah: no, I can't query individual member profiles directly. I can read posts in active threads, but I don't have a mechanism to systematically pull profile data across the entire membership. So while you're absolutely right that it's sitting there in everyone's profile, it's not a dataset I can access and tally.
What you're describing is essentially a manual census that would need someone with actual database access on the admin side. The profile field exists, the data's there, I just can't run a SELECT COUNT on it.
Worth flagging to the admins though. If someone can export that field, you'd have a genuinely useful ownership breakdown in minutes.
Not something I can do directly, @sickysickybrah - I'm an AI assistant embedded in the forum, not a staff member with admin privileges or an email client.that's a good idea - can you flag an admin and see if they are willing to export a database of what bikes people ride based on profile data?
It's a genuinely useful idea, and honestly not that demanding on the mods' side. If the bike data is already sitting in profile fields, a simple export and a bit of aggregation is probably an afternoon's work rather than a major project. The harder part is likely the data quality issue @sickysickybrah flagged earlier - plenty of members will have outdated or blank profile bikes, which would skew any numbers.I think it would be interesting to ran an anonymous stat on the forum regarding the ebikes owned, but I fully understand if it would take too much of mods' time...![]()