Build a Live Analytics Dashboard for Wallet Transactions

[minhyeong112]

Time Estimate

• I have added a time estimate label

Background Information

• @v4d33m 's Base Pay Shift analysis sheet is awesome
• building on this, we should have a live dashboard that refreshes automatically with live information from GnosisScan
• here is a simple prototype that I built with Airtable and DataFetcher (no-code tools for us plebeians) that pulled from 0x9051eda96db419c967189f4ac303a290f3327680 and got 668 transactions
• the idea is that we could use this to IMMEDIATELY demo our "main offering" ¹
• I would just replace the "WXDAI" with the unit "XP" so that 1 XP is roughly worth 1 USD of work
• Once we're happy with the look of the dashboard, I would recommend hosting it somewhere like "leaderboard.ubq.fi" or "analytics.ubq.fi" or whatever

Completion Criteria

• dashboard is live and displays accurate transaction data from GnosisScan grouped/sorted/aggregated in various useful ways (by wallet/contributor/github handle, over time) and with all the good stats from @v4d33m 's Base Pay Shift analysis sheet

• dashboard can be used throughout a 1-minute intro video with the following rough script:

[Opening Scene: Screen Recording of a GitHub Issues Page]
Narrator (Voiceover):
This is your current GitHub Issues page.

[Camera slowly zooms or pans across the cluttered, unprioritized issues list. No visual hierarchy. Just standard GitHub.]

[Cut to: Sleek, redesigned Issues page — same layout, but every issue now has three tags: two white tabs labeled “Priority” and “Time,” and one green tab labeled “XP”.]
Narrator:
This… is your Issues page with Ubiquity OS.

[Quick animation: someone updates the “Priority” and “Time” values — the “XP” tag updates automatically.]
Narrator:
Add a priority. Add an estimated completion time. Ubiquity OS does the rest — calculating XP, a metric you can use for bounties, gamification, or just tracking contribution value.

[Cut to: a developer clicking "Close Issue." Their XP increases instantly on a small HUD overlay.]
Narrator:
Every closed issue adds XP to the developer’s profile. But that’s not all.

[Quick montage: A comment gets upvoted → XP increase. A pull request gets approved → XP increase. A code review is submitted → XP increase.]
Narrator:
Comments, reviews, approvals — all meaningful activity earns XP.

[Cut to: New dashboard — clean, colorful analytics panel showing developers, total XP, graphs of progress over time, leaderboards, etc.]
Narrator:
The result? A full-stack analytics dashboard for your engineering org. Track contributions. Benchmark performance. Incentivize the right things.

[Zoom in on a leaderboard or bar graph that shows devs climbing in XP.]
Narrator:
With Ubiquity OS, development isn’t just tracked — it’s quantified.

[Final scene: Logo animation — “Ubiquity OS” with tagline below:]
Tagline: Build better. Together.

• dashboard specs below:

Ubiquity OS — Frontend Dashboard Spec (GitHub UI Extension)

This spec focuses solely on the frontend dashboard interface for Ubiquity OS. "XP" would simply replace the existing "WXDAI" units.

Goal

Deliver a lightweight but powerful GitHub-native dashboard that makes developer contribution data visible, gamified, and actionable. The dashboard supports both developers and managers by surfacing metrics around impact, engagement, and performance.

Dashboard Locations

1. Organization-Level Dashboard (/orgs/[org]/xp-dashboard)
2. Repository-Level Dashboard (/repos/[org]/[repo]/xp-dashboard)
3. Contributor Profile Overlay (opens on contributor click)

---

Overview Panel

This is the main landing view for both org- and repo-level dashboards. It summarizes contribution activity over a selectable time range.

Includes:

• Total XP (timeframe + all-time)
• XP by category (Coding, Reviewing, Spec Writing, Comments)
• Leaderboard: top contributors by XP
• Velocity trend chart: XP earned over time
• Engagement overview: active contributors, PRs reviewed, comments made

XP Categories

Each activity maps to one of several standardized XP categories:

Category	Description	XP Source
Spec Writing	Issues authored with spec/design labels	XP for creating and content quality
Coding	Merged PRs where user is assignee	XP based on issue priority + estimated time
Reviewing	PR reviews, approvals, change requests	XP per review and comment weight
Commenting	Comments on issues or PRs	XP for helpful or upvoted comments

Contributor View

Drill-down modal or side panel for individual contributors.

Includes:

• Total XP (timeframe + all-time)
• XP by type (bar or donut chart)
• Weekly XP trendline
• Recent contributions (linked to GitHub)
• Most active repos or categories
• Optional badge/streak system for consistency

Admin & Config Panel (Managers Only)

A separate settings interface available via external dashboard or modal:

• Adjust XP weight by category
• Configure labels for categories (e.g., what counts as "Spec")
• Set XP-to-bounty payout ratio (if applicable)
• Export XP data (CSV or JSON)
• Connect external bounty boards or task managers

Repo-Level Analytics

When viewing a specific repository, the dashboard shows:

• XP earned within this repo
• Contributor leaderboard scoped to this repo
• Active XP categories in this repo
• Weekly velocity of contributions

Design Considerations

• Fully styled to match GitHub’s native light/dark mode
• Minimal, readable typography using GitHub UI conventions
• Smooth animated transitions on XP updates and charts
• Color-coded tags and charts for fast visual scanning
• Real-time updates powered by GitHub webhooks

Filters and Controls

• Date range selector (Last 7/30/90 days, custom)
• Repo selector (at org level)
• Sortable tables by XP, name, last activity
• Category toggles for filtering views
• Export data (button in bottom-right corner)
• "Open Full Dashboard" for expanded analytics (external app link)

---

Relevant Links

simple prototype

Footnotes

1. 2025 Marketing Narrative:
   Our core offering is straightforward: performance analytics for your software engineering team. While GitHub provides surface-level metrics like commit counts and pull requests, UbiquityOS dives deeper, delivering AI-powered qualitative insights that measure the actual impact of every contribution. Instead of raw numbers, you get meaningful performance data that highlights each developer’s strengths, identifies skill gaps, and lays the groundwork for a stronger, data-driven engineering management.
   But our platform goes far beyond analytics. UbiquityOS acts as an AI-powered manager, streamlining your daily administrative management with intelligent task-talent matchmaking, automated proposal submissions, and transparent payment mechanisms, including integrated payment cards for cashing out rewards, to support teams from start to finish. Developers can self-assign tasks, receive AI-driven assistance with full repo context, and stay organized with automated issue deduplication—ensuring nothing slips through the cracks. For teams that prefer immediate and flexible payments, UbiquityOS integrates seamlessly with Ubiquity virtual payment cards, enabling real-time payouts upon task completion. Everything is configurable, so whether you need just performance analytics or a fully automated AI development manager, UbiquityOS adapts to fit your workflow—putting you in control every step of the way. ↩

[ubiquity-os]

Note

The following contributors may be suitable for this task:

devpanther

79% Match ubiquity/pay.ubq.fi#100

0x4007

77% Match ubiquity/.github-private#7

[minhyeong112]

in an effort to continue building out the prototype, I added all transactions (~1200 transactions in total) from 3 wallets to the GnosisScan Transaction Airtable Database:
0x9051eDa96dB419c967189F4Ac303a290F3327680 UbiquityOS Q4'24
0x44Ca15Db101fD1c194467Db6AF0c67C6BbF4AB51 UbiquityOS Q3 24
0x054ec26398549588f3c958719bd17cc1e6e97c3c UbiquityOS-OLD

Excluded for now (should I pull these in? @v4d33m ):
0xefC0e701A824943b469a694aC564Aa1efF7Ab7dd ubq.eth
0xf95d1352467773676d5435a9ada94a3701efdb6c treasury

@v4d33m since you dove deep into the Base Pay analysis sheet, can you please take a look at this database and give me a quick sanity check? the goal is to reproduce a live version your Base Pay analysis sheet. I think this could become the MVP for a "dev analytics dashboard" offering as part of UbiquityOS (note: this basic prototype still works) rfc @0x4007

[0x4007]

In the future perhaps consider Replit?

We would load the data all from our database, which simplifies things.

This should be removed from your prototype because it skews the data really badly. Not sure what it is supposed to be.

---

I think this is a great idea and its something that we can hack together over a coffee when you come to UbiquiBar. Getting it working should be quick. Making it pretty is something I can do over the course of an afternoon.

[minhyeong112]

consider Replit?

will play with this, thanks!

hack together

looking forward to it! Adding more detail about what I think would be cool to have on the dash to the spec now!