1 of 12

#366: substrate-etl 2.0�Polkadot+Kusama on Dune

Sourabh Niyogi + Michael Chung�Colorful Notion

(12 months, 3/15/24-3/14/25)

2 of 12

Dune Dashboards are about Marketing Success

Hand-built�

Hand-built�from subscan

3 of 12

#366 Goal:

Market Polkadot/Kusama Parachain’s Success�with Data, using Dune��ANYONE can build dashboards in a few hours

4 of 12

Dec 2023 Proof of Concept 1:

Polkadot Dashboard

5 of 12

Dec 2023 Proof of Concept 2:

Staking Dashboard

6 of 12

Dec 2023 Proof of Concept 3:

DOT Ordinals Dashboard

7 of 12

Why Dune Dashboards?

  • Marketing Teams in Ecosystem

Share success with community

  • Data Analysts/Dune Wizards in Ecosystem

Build dashboards quickly in mature Dune dashboards, no starting from scratch�

  • Token holders

Track success of Polkadot/Kusama + parachains

Polkadot ECOSYSTEM INVESTING IN �MARKETING INFRASTRUCTURE ��If 2024 is a blessed year (2.0 bull run)�we do NOT want to delay this key vehicle!

8 of 12

substrate-etl 1.0 Dependents

Revenue from Dependents:$60K W3F Grant [Deep Account Analytics]

DotInsights

Pendulum

#209

#341

#79

9 of 12

December 2023 Decision:

Now or Later?

Colorful Notion

Parity Data Bounty

MAYBE Funded by Data Alliance Bounty in late 2024?

#366 by Direct Spend �in December 2023!

10 of 12

Colorful Notion �(Dune Now!)

Parity Data via Data Bounty�(Dune Later?)

Speed of Delivery?

Decision pending on #366

Conditioned on Data Bounty formally passing first. Currently the Bounty is on hold.

Feasible Today?

Yes. PoC has been proven and researched.

Unclear

Scope/Timeline

Relay Chain (Q1), Major Parachains (Q2), Rest (Q3/Q4)

Execution timeline uncertain, potentially late 2024.

Cost to Treasury

$1,968,200

(Dune +GCP + Integration cost + FTEs included)

$1,000,000 - At least $1,000,000 [Dune+GCP] + the cost of 4 FTEs (est $568,200)

Pro

Entrepreneurs with a sense of urgency.

Potentially $400K less.

Con

Cost $400k more.

Less dedicated, given additional tasks from Parity. More uncertainty

Driven by

Making sure Dune integration is powerful for renewal in one year�DOT Appreciation, Coin Market Cap #11 => #8

Being an effective bounty curator, while also managing other internal tasks at Parity.

TL;DR Summary

Fast, ready now, but expensive

Slower, not ready now, but cheaper

Question: Is it worth delaying Dune Integration by 9-12 months to save $400K?

11 of 12

Colorful Notion 2024:�Our decentralized future is be a

decentralized organ in the �Polkadot organism

12 of 12

Merry Christmas!