I bet you all think that me and my spreadsheets take a rest when there's no new Moon data to look at?

Well guess again, I've been furiously collecting data on governance polls to see if Moon week made any difference to vote participation.

Spoiler: It did, it increased it a shit ton

—————————————————————————————————————————————————–

I should probably start off with something that I see a lot of people confused about:

• It's the winning poll option that has to pass the governance threshold, not the total Moons that voted.

Moon Week was implemented in round 15. One of the reasons for it was to help improve voter participation in the governance polls.

So did it work? Lets take a look at the data.

Some points of clarification first:

• The polls listed are taken from the pinned comment in the Moon proposal posts by u/communitypoints. There are some notable exceptions, such as the Moon week poll and the meme ban, these were standalone polls so I didn't include them.
• The numbers are taken from the poll data on the post, the amounts are usually rounded to 2 significant figures.
• The threshold for polls to pass have changed over time. It's based on the number of Moons that voted in previous polls, with a minimum value of 10% of the total Orbiting Moons. Polls earlier than round 7 had higher thresholds but the polls have updated to show the 10%. (I think it started at 50%, then dropped to 20%, then dropped again)
• The threshold discrepancy doesn't matter much as I'm looking at the users more than the Moons and I don't think any polls passed before round 7 anyway.
• I paraphrased some of the titles to get them to fit, but you get the idea.
• For a list of the passed proposals that are in effect, take a look at the Moon Wiki Page
• Not all these are governance polls, but I didn't think it matters as I vote on them all anyway.

Here's the data

Rounds 1-6

https://preview.redd.it/onhbgwc7pob71.png?width=1135&format=png&auto=webp&s=1a24c95d2d45956be7ecaf74de88d0a9db814224

(No polls in round 3)

As I stated above, these thresholds are whack, so ignore them.

Rounds 7,8,9

https://preview.redd.it/r3d3ebv8pob71.png?width=1136&format=png&auto=webp&s=6d4fe53c8717ef74f590a5c3de508b9057180f58

Rounds 10, 11, 12

https://preview.redd.it/1bvd7znapob71.png?width=1136&format=png&auto=webp&s=19370d37c48d31d75166b1dd72676772d5de914b

Rounds 13, 14, 15

https://preview.redd.it/gcee3q3cpob71.png?width=1134&format=png&auto=webp&s=a0e16f16944eea277956136c826803cba7241df1

Then I had to figure out how to compare the data.

Over time the number of users voting has increased, as has the amount of Moons that users have each round. Its impossible to tell which users have voted in which polls, a single poll or all the polls.

So I made a column showing "% of user votes on .CSV with vault". This is the one we are most interested in. I know what this means to me, but its difficult to convey.

This is the number of user votes, divided by the number of users with vaults on that rounds Moon distribution .csv

So I took the average % for each round and plotted it.

Moon week was implemented for round 15, this is how it has affected poll participation.

​

https://preview.redd.it/7gfxg4udpob71.png?width=1013&format=png&auto=webp&s=22439781975c732ec8d0cd765a523a3026961774

Through the frikkin roof.

So what else does all this data tell us?

If we take a look at all the passed proposals from the data above. From round 7 onwards.

​

https://preview.redd.it/mpmxx2cfpob71.png?width=922&format=png&auto=webp&s=fd1d67a4dd40deabab6f8eb74e71a214546324f5

To get a poll to pass you roughly need:

• On average 21% of the number of users with vaults from that rounds karma .csv to vote
• The winning option to get at least 80% of the Moons.

​

Now lets take a look at the polls that nearly passed, but fell short of the threshold:

​

https://preview.redd.it/vp7oraygpob71.png?width=922&format=png&auto=webp&s=b2a87ee29836345e9c4f1dca3d928c4de3775a48

All these polls got 1 option to >80% of the threshold.

All but two of them got less than 80% of the Moons for one option and only one got over 21% of the users voting from that rounds karma .csv

So close but yet so far.

In conclusion

Moon week is a great success. Thanks to the Mods for implementing it and maintaining the posts over the week. Also thanks to us users for voting it in.

Its likely that if some of the polls I've listed that almost passed were run again with the benefit of Moon week then they have a much better chance of passing.

Some of them have been ruled out by admin though, such as hiding balances and reducing the membership Moon price. There is plenty of talk about those things in the meta sub.

Also, the OP of the gif karma reducing poll said he won't post it again, so no backsies. (This has already seen the benefit of Moon week though)

​

*Disclaimer:

• This is not financial advice.
• I didn't look at the wording of polls, any bias from how its laid out, the titles or the poll options. Just the numbers.
• I'm not a data scientist, just an engineering nerd with a spreadsheet obsession whilst I wait for GT7 to release.

​

TL;DR Moon Week good, poll participation is up and I fucking love spreadsheets.