I'll simply start by sharing some graphs with you - thanks to rootshell for reminding me to do this, it is one of wikiloops ingredients to stay transparent towards the community, so here are some numbers for you:
Now, let me add a bit of review to those statistics,
and also make mention of some noteworthy things about the wikiloops project in 2023 which might not be obvious from the stats.
I have always added one more metric to my transparency reports, called "human time spent having fun on wikiloops" - the calculation goes like this:
Take 512k visitors who have spent an average of nine minutes and 55 seconds on wikiloops, and you'll end up with 3289 days, or 9 years total visit time in 2023.
It's a somehow inspiring number to think about, you can read it as "9 people were surfing wikiloops at any second of the year",
but it also sheds some light on how much focus time on creating music wikiloops allowed for.
One of the few graphs that do not look overly good is the cost vs revenue graph. What we are seeing there is a mix of things:
- google sending less potentially interested people, decreasing the number of potential future supporters
- inflation hitting all of us, making people more spend-cautious, and also increasing wikiloops server cost significantly
- the USD to EUR exchange rate is also directly affecting wikiloops revenue
These factors are pretty much outside of my control, we already have taken some steps to make sure we can turn the trend around in 2024,
and I do hope posts like this one here may promote the "gold" support status a little.
Let me put it this way:
We are offering wikiloops for roundabout 80 Euros (that's currently $88 for you) operation cost per day.
Somehow the price to value ratio of being a gold supporter seems quite good to me - I hope you would agree on that,
and I hope it once more becomes obvious that wikiloops is basically a non-profit organization,
which also explains why our paying members are referred to as "supporters" rather than "customers".
This might be only interesting for people with some development or IT background, it does belong in this report never the less.
Since I have been joined by senior karuma in late 2022, we have turned the complete backend code of wikiloops upside down and inside out.
What had organically grown to be a giant collection of spagetthi code needed cleanup,
so we took the following steps to make this project future-proof:
- setting up version controll
- untangling database access and controller logic, and separating html generation to twigs templating engine
- introducing automatic deployment via a gitHub pipeline
- introducing dependency injection
- upgrading and review of included third party packages
- migrating the project towards the symfony framework
We deliberately chose not to roll out the latest changes before 2024 to make sure we would not disturb the festive season,
but we will switch to symfony routing and add a first set of automated tests to the deployment pipeline next - improving security and automating quality controll.
On the visible side of wikiloops, the redesigned track search engine probably stands out in 2023,
but the whole new member registration procedure and the membership upgrade purchases have been re-designed as well, leading to a noticeable increase in new member registrations.
We did not track how many hours karuma and me have spent on these changes in 2023, my rough guess would be something close to 1000 hours in 2023.
That is a giant investment in terms of time, and expertised people like my friend and mentor-in-code karuma are not only hard to come by, but also quite expensive to hire...
so, on top of what we have seen in those graphs up there, there was this silent investment in the wikiloops engine room (those familiar with below screen should note the number of commits and changed code):
Let me mention and thank the volunteers who have been tending to the wikiloops community and which are a bit more visible on the surface than karuma and me:
Here's once more to Shi, TeeGee and wjl - it would not be wikiloops without you guys, so thank you all for taking care!
I'd also like to give explicit thanks to Shamika - I have deliberately added the graph displaying the forums uprise in activity this year, and I believe Shamika played a role in that :)
Also, I'd like to thank those of you who engaged in bug reports and helped us fix whatever needed fixing after the upgrade to version 14. That feedback helps big time, so, thanks again for getting in touch when things seem odd or ceases to work.
Well, as you can tell, it simply would not work without supporting members, which generate close to 90% of wikiloops annual budget.
530 individuals supported wikiloops in 2023 - thank you, you made it happen!
We also would like to thank our long-term sponsor and favorite online merchant for musical instruments thomann for their continued support.
I sometimes have doubts if anyone really reaches the end of such long-text articles... you obviously did, thanks for your time :)
Feel free to comment or feedback on this thread, or reach out to me directly if you care.
wikiloops is about collaboration, so, let's look forward to where the journey continues in 2024!
Yours Richard
Now, let me add a bit of review to those statistics,
and also make mention of some noteworthy things about the wikiloops project in 2023 which might not be obvious from the stats.
A bit of evaluation
I have always added one more metric to my transparency reports, called "human time spent having fun on wikiloops" - the calculation goes like this:
Take 512k visitors who have spent an average of nine minutes and 55 seconds on wikiloops, and you'll end up with 3289 days, or 9 years total visit time in 2023.
It's a somehow inspiring number to think about, you can read it as "9 people were surfing wikiloops at any second of the year",
but it also sheds some light on how much focus time on creating music wikiloops allowed for.
A word on the budget
One of the few graphs that do not look overly good is the cost vs revenue graph. What we are seeing there is a mix of things:
- google sending less potentially interested people, decreasing the number of potential future supporters
- inflation hitting all of us, making people more spend-cautious, and also increasing wikiloops server cost significantly
- the USD to EUR exchange rate is also directly affecting wikiloops revenue
These factors are pretty much outside of my control, we already have taken some steps to make sure we can turn the trend around in 2024,
and I do hope posts like this one here may promote the "gold" support status a little.
Let me put it this way:
We are offering wikiloops for roundabout 80 Euros (that's currently $88 for you) operation cost per day.
Somehow the price to value ratio of being a gold supporter seems quite good to me - I hope you would agree on that,
and I hope it once more becomes obvious that wikiloops is basically a non-profit organization,
which also explains why our paying members are referred to as "supporters" rather than "customers".
Technical improvements
This might be only interesting for people with some development or IT background, it does belong in this report never the less.
Since I have been joined by senior karuma in late 2022, we have turned the complete backend code of wikiloops upside down and inside out.
What had organically grown to be a giant collection of spagetthi code needed cleanup,
so we took the following steps to make this project future-proof:
- setting up version controll
- untangling database access and controller logic, and separating html generation to twigs templating engine
- introducing automatic deployment via a gitHub pipeline
- introducing dependency injection
- upgrading and review of included third party packages
- migrating the project towards the symfony framework
We deliberately chose not to roll out the latest changes before 2024 to make sure we would not disturb the festive season,
but we will switch to symfony routing and add a first set of automated tests to the deployment pipeline next - improving security and automating quality controll.
On the visible side of wikiloops, the redesigned track search engine probably stands out in 2023,
but the whole new member registration procedure and the membership upgrade purchases have been re-designed as well, leading to a noticeable increase in new member registrations.
We did not track how many hours karuma and me have spent on these changes in 2023, my rough guess would be something close to 1000 hours in 2023.
That is a giant investment in terms of time, and expertised people like my friend and mentor-in-code karuma are not only hard to come by, but also quite expensive to hire...
so, on top of what we have seen in those graphs up there, there was this silent investment in the wikiloops engine room (those familiar with below screen should note the number of commits and changed code):
Volunteer support
Let me mention and thank the volunteers who have been tending to the wikiloops community and which are a bit more visible on the surface than karuma and me:
Here's once more to Shi, TeeGee and wjl - it would not be wikiloops without you guys, so thank you all for taking care!
I'd also like to give explicit thanks to Shamika - I have deliberately added the graph displaying the forums uprise in activity this year, and I believe Shamika played a role in that :)
Also, I'd like to thank those of you who engaged in bug reports and helped us fix whatever needed fixing after the upgrade to version 14. That feedback helps big time, so, thanks again for getting in touch when things seem odd or ceases to work.
Thanks to our supporters and our sponsor Thomann
Well, as you can tell, it simply would not work without supporting members, which generate close to 90% of wikiloops annual budget.
530 individuals supported wikiloops in 2023 - thank you, you made it happen!
We also would like to thank our long-term sponsor and favorite online merchant for musical instruments thomann for their continued support.
Here's to many jams on wikiloops 2024
I sometimes have doubts if anyone really reaches the end of such long-text articles... you obviously did, thanks for your time :)
Feel free to comment or feedback on this thread, or reach out to me directly if you care.
wikiloops is about collaboration, so, let's look forward to where the journey continues in 2024!
Yours Richard
+17