decentraland-dao/transparency

A set of tools to collect and process Decentraland's data into actionable insights.

A set of tools to collect and process Decentraland's data into actionable insights.

How it works:

• All data is collected from public sources (e.g. blockchain or indexing services).
• The scripts run on daily bases and publish the raw data in CSV and JSON formats.
• The data also funneled into Google Sheet and Google DataStudio for further analysis.

Design Principles

• Accessible: Publish the data in many formats.
• Auditable: Open source code and public workflow logs.
• Simple: Easy to understand, easy to contribute.

Third Party Providers

• Infura: Blockchain provider.
• Snapshot: Off-chain voting.
• Catalyst's API: POIs and members Names.
• CovalentHQ: Transfers and balances.

Data Sources

• Proposals
• Members
• Votes
• Projects
• Balances
• Transactions
• Curations
• API

Outputs Formats

• Transparency Page
• Google Data Studio
• Google Sheets
• Raw Data in CSV and JSON
• Run Logs

Contributing

Feel free to create a Github issue with your suggestions or find us at the DAO's Discord Server

The commands you need to setup and use the environment are:

# Install dependencies
npm install
npm link typescript

# Set up your environment variables
cp .env.example .env
pico .env

# Run script that exports files to ./public/
npx ts-node export-xxxxx.ts

# Upload CSV to spreadsheet
npx ts-node upload.ts SHEET_NAME ./public/xxxxx.csv

# Add a job the daily process that collects and publishes data
pico .github/workflows/pull-data.yml

# Run tests
npm run test

Copyright & License

This repository is protected with a standard Apache 2 license. See the terms and conditions in the LICENSE file.

transparency's Issues

[TEST] Discord Webhook integration

Testing issue notifications delivery to our Discord channel

Voter Cohort Analysis Dashboard

To show voter retention rate over last 12m
ref: https://twitter.com/DisruptionJoe/status/1703878805184450760/photo/1

Change Snapshot integration to comply with new ratelimits

Minor enhancement: link to user profile on the discussion section

Currently, user names or avatars in the comments sections are not links. I think that for consistency, it would be good to be able to go to that user's profile as it is the case with the "Details" section

Minor bug on the "discussion" section

When a forum comment contains a link to a user, that link leads to a 404: the link should go to /balance/?address=... instead of /u/someone. See for example: the comment on https://governance.decentraland.org/proposal/?id=659ab8a0-18d6-11ed-96c7-2fa07c6df25b