Deliver attestation-based impact metrics by project

[ccerv1]

What is it?

Current assumptions:

Core Schema:

• toProjectId: Identifier for the project receiving the attestation.
• fromUserId: Identifier for the user submitting the attestation.
• isUserDelegate: Boolean indicating if the user is a delegate or badge holder.
• rating: Rating score provided by the user (scale of 1-5).

Derived Metrics

• number_of_attestations_to_project: Total attestations a project receives.
• number_of_delegate_attestations_to_project: Attestations received from delegates or badge holders.
• average_rating_to_project: Average rating across all evaluators.
• average_delegate_rating_to_project: Average rating from delegates.
• weighted_delegate_rating_to_project: Weighted average rating from delegates, factoring in voting power.

[ccerv1]

https://plaid-cement-e44.notion.site/Impact-Attestations-Data-b8b1c79a624c46ad94305c74def64783

"id": "0x4a40d2754663421d856744ffcd06e18094b55e5543e49a8f4c6ef59ee503973d"
"recipient": "0x3e95B8E249c4536FE1db2E4ce5476010767C0A05"
"attester": "0x7484aABFef9f39464F332e632047983b67571C0a"
“projectRegUID”: “0xf7248ad55667beaa6babe4700b52f5c868f60bdcb0e552f31369f78a22c7f1a6”
"revoked": "false"
"time_created": "1726695594"
"metadataurl": "https://gateway.pinata.cloud/ipfs/QmWEdqQdLZXH3KnmbxyoGmnK6GRUFNXX7K4dadTWFS2xEW"
"feeling_if_didnt_exist": "Extremely Upset"
"userFid": "9848"

[ccerv1]

Two blockers:

• https://github.com/voteagora/agora-next/issues/556#issuecomment-2407252522
• won't have actual attestations flowing until after Oct 14

[ccerv1]

Included here with initial ~60 attestations that meet requirements: https://github.com/opensource-observer/insights/pull/60