oceandao icon indicating copy to clipboard operation
oceandao copied to clipboard

[DAO Ops]: DAO-Info-Graphic numbers to MarCom

Open malvonme opened this issue 2 years ago • 3 comments

Goal:

The MarCom needs the most recent figures /KPIs around OceanDAO to update their info-graphic (attached) here are the recent ones (Post R17):

  • 309,630,914 OCEAN Voted
  • 73 Town Halls held
  • 399 proposals submitted
  • 1434 Voters (Note: UNIQUE VOTING WALLETS, slightly different)
  • 124 projects funded (Alternative: 240 Grants received)

Useful links for this is the current OceanDAO Votes Excel Sheet: https://docs.google.com/spreadsheets/d/1e4xb6m-aKcBhwob_p7ereSFneXFPpDjUbSjz13smmHI/edit?usp=sharing

And a dedicated Airtable view for the relevant specs: https://airtable.com/shryY5WeqhU33tOfN/tblEXgVZeoHb89aKB

And could be a repeatable, @idiom-bytes, conclusion of each round?

DoD:

  • [x] Numbers are updated after Round concluded
  • [x] Numbers are shared with MarCom

download_-_2022-03-30t104410.456.jpg

malvonme avatar May 17 '22 12:05 malvonme

Hi @malvonme,

I've been trying to provide the summaries in places that are easily accessible and working wherever possible to improve those. However, summarizing the summaries would require perhaps more work, and some of these worfklows (like the spreadsheet) is something we should be moving away from the spreadsheet and into a database so we can improve this further.

An example is the OceanDAOVotes spreadsheet. I usually spend a few minutes updating this each round and copying from this summary to provide the results elsewhere.

Screenshot from 2022-05-17 07-16-57

Instead of automating this, I propose we improve our tickets & workflows, then find someone else that can help us update this information and report it so we don't have to be the only ones that can do it.

Once we migrate more of this stuff over to DBs and better storage locations, then we can improve summaries, and even automate this reporting in a dashboard somewhere.

Timeline: This is unlikely to be a short term outcome.

idiom-bytes avatar May 17 '22 14:05 idiom-bytes

Resolved / discussed in Slack. Thank you for the elaborated response!

malvonme avatar May 17 '22 14:05 malvonme

Is this completed? Can we close it?

idiom-bytes avatar Aug 10 '22 22:08 idiom-bytes