I got inspired by the amazingly long and descriptive @davidw's post about The data to help you become a better Stacker ⚡ and decided to write this one.
I'll be not even near to reach that kind of complexity and quality, but it inspired me to dive deeper and better understand which territories are worth posting (generically speaking - each post could be a different case itself) Let's see if I'm right!
My main issue was mainly related to the KPIs displayed on top territories, all that data isn't giving me what it was looking for. So I took that raw data from last month and started playing with it. I excluded all new and archived territories, and also those with zero revenue, and then followed this process:
{rank}, it's only the result of multiplying all KPIs, so not really worth looking at it.- I started defining the
{fee}for each territory - Then a glimpse into the
{profitability}dividing{spent}by{revenue}. - From there, I wanted to know the average
{engagement}rate, dividing the number of{comments}by the number of{posts}for each territory. I thought it's kind of helpful to know hoe many comments in average one could expect... more or less! {revenue/post}could be an interesting metric for territory owners- The
{worthiness}it's the result of{revenue/post}less{fee}kind of evaluate the risk of posting on a territory. When negative means that there's a high risk that the stack you spend for posting there will probably not return. - and finally the
{stackrate}and{spendrate}, calculated respectively taking{stacked}and{spent}and divide them by number of{comments}.
This is basically what I got after few interactions:
Available on https://airtable.com/appbITVfFIwEhKLXU/shr9wZyoIRnhjtnSF/tblgVT25tg1f4uLSO/viwkSe10W68yfNAH6
You could read any row as:
If I post in {territory} I'll probably need to respond to {engagement} comments, and I'll maybe earn {worthiness} sats.
This is probably not really an accurate output, as I assume the fee for posting might have changed already in some territories in the past month. All columns are displaying average values, and it will be probably be obsolete in the next week, so do not take it too seriously. It served the only purpose to share this post here in ~meta for obvious reasons, and hopefully get some more insights out of the default data.
It will be nice to have this data live somehow. But yeah... Just an idea!
Hope you enjoyed the ride! It could be fun to build better KPIs for SN. What do you think?
{engagement}is the most interesting metric I have found. Having a hit on the number of comments per post is for me a fascinating, an intriguing fact that need to be valorized more.{worthiness}and{revenue per post}despite such impressive activity (I see posts in those territories pretty frequently). I'm also surprised that ~art has such a high rank. I need to check it out. Great job!{engagement}rate it has. Congrats @antic and @elvismercury for keeping up with the hard work!DON'T MISS THIS OPPORTUNITYBUY AN ARCHIVED TERRITORY TODAY!