Question:

Q13. Create a dashboard that maps community participation in governance. On average, how long does it take for a new wallet to become active in Osmosis governance? Do wallets that are active in governance vote on every proposal? Or do they only vote on select proposals?

Approach:

This essay seeks to estimate the average time to become a voter on Osmosis Governance from ordinary users.

Furthermore, the voting pattern of voters based on the proposals on Osmosis governance established in the next part of essay.

• Voter and non voter users

   Introducing voters from osmosis.core.fact_governance_votes
   Then group users in osmosis.core.fact_transactions into two buckets that are in the first table or not.
  

• First activity

   Select min(BLOCK_TIMESTAMP) from osmosis.core.fact_transactions
  

• First voting activity

   Select min(BLOCK_TIMESTAMP) from osmosis.core.fact_governance_votes
  

• Time difference between first action and first vote

   DATEDIFF(day,transaction_time, vote_time)
  

• Share of voters on each proposal

   count(distinct VOTER)/total_voters for each proposal
  

Results:

Key findings 1:

• According to the donut, only 36.7% of active wallets on Osmosis participated on Governance voting.
• From the voter wallets, most of the voters became active in voting under 24 hour.
• Despite the voters activated below 24 hour, the second largest bucket of voters belong to over 1 month. This means about 43.2k of voters became active on governance after 1 month.

Key findings 2

• The share of participation on each proposal demonstrate the voting pattern of voters on Osmosis governance.
• The proposal no 207 captures the highest share of voters by 31.5% of whole voters.
• Many of the proposal on Osmosis Governance have share of voters below 1% as shown in the graph.
• Daily share of voters reveals the highest participation on April 23th, April 8th and May 13th.