Amazingly, there are over *10+* teams implementing JAM:

[https://jamcha.in/clients](<https://jamcha.in/clients>)

Some teams are starting to pass the first few tests with available [test vectors, ](<https://github.com/w3f/jamtestvectors/>)are asking detailed questions about the [JAM Gray Paper](<https://graypaper.com>) in the [GP Chat Room](<https://matrix.to/#/#graypaper:polkadot.io>) and [JAM Chat Room](<https://matrix.to/#/#jam:polkadot.io>).

With Devcon 7 in Thailand in November (tickets going on sale again July 30 [here](<https://tickets.devcon.org/>) ). and sub0 proposed to happen in LATAM, we would like propose a JAM0 event to bring these teams together.

We have at least \*SIX\* *serious implementors* who are interested in going to Devcon 7 and can connect their JAM implementations with each other. This proposal aims to support their Devcon tickets and get the bulk of each team's travel budget reimbursed, up to $7.5K/team (with travel receipts, like 3-4 people/team on average). As of Fall 2024, "serious implementors" should be pretty close to passing "JAM Milestone 1" and not be in "just learning" mode, be able to pass "Block Import" tests (when available) or at least passing most all test vectors available and know \_exactly\_ where they are bottlenecked, and basically be ready to network their implementations with other teams with [QUIC](<https://hackmd.io/@polkadot/jamsnp>) at an event like this.

Budget: (estimated $118,313=19K DOT*$6.227/DOT)

- $75,000 Travel (10 teams x $7.5K/team)
- $43,313 Venue + Food for JAM Implementors + core devs working on PolkaVM + related tooling

Any unused budget from securing will be applied to a similar JAM0 event at sub0 (also focussed on _implementers+protocol devs_). 

Everyone will be required to follow the [official W3F rules](<https://jam.web3.foundation/rules>) and [unofficial "Rules" (from Gav)](<https://hackmd.io/@polkadot/jamprize>).

<h3>Venue:</h3>

We are collaborating with OneBlock on this, see [OpenGov Ref #897](https://polkadot.polkassembly.io/referenda/897). The final venue will be announced in August. We will set up a JAM0 Matrix room for teams to follow along.

<h3>Teams:</h3>

See below. If you are a serious implementor (or a protocol dev), please comment below!

JAM0 Event @ Devcon 7 

Colorful Notion successfully onboarded the Polkadot ecosystem into Dune under <a href="https://polkadot.polkassembly.io/referenda/366">OpenGov 366</a>, which has been operational for over one year now, and showcases the majority of the Polkadot ecosystem.&nbsp; Colorful Notion wishes to renew its efforts to cover 4 additional quarters (Q2 2025 - Q1 2026), to ensure that Polkadot continues to be ingested and maintained on Dune as well as Google Cloud BigQuery (GC Web3) for an additional 4 quarters.&nbsp;
You can see much of our work in the Highlighted Tweets below, as well as in on the <a href="https://wiki.polkadot.network/general/dashboards/dune-analytics/">Polkadot wiki</a>.&nbsp;&nbsp;
We have drafted a proposal <a href="https://docs.google.com/document/d/1dLbwJvhZ4IYIh0gQT-5D63uc5NzCLDWMr3jbEOUtCFI/edit?tab=t.0#heading=h.v6is2ta0txr1">here</a> covering 2 out of the 4 quarters so that Polkadot stakeholders (parachains) may provide valuable feedback on how to modulate our plans in the next year.&nbsp; &nbsp;
Whereas the previous year focussed on the heavy workload of onboarding the relay chain, system chains, parachains, the next 6-12 months will be more maintainance focussed on the key migration of both the Kusama and Polkadoy relay chains into Kusama Hub and Polkadot Hub thereafter.
Our primary question for stakeholders is: What would you like to see happen in Dune + Google BigQuery from us?
Please share your thoughts here! 
Highlighted Tweets <a href="https://x.com/Polkadot/status/1864626032218620265">https://x.com/Polkadot/status/1864626032218620265</a> TVL on Polkadot DEX @hydrationnet reaches ATH ✅
<a href="https://x.com/Polkadot/status/1866395426695622914">https://x.com/Polkadot/status/1866395426695622914</a> NeuroWeb adds 2.4M Knowledge Assets in November, another ATH. @NeuroWebAI is an AI blockchain secured by Polkadot, designed to incentivize knowledge creation &amp; connectivity through Knowledge Mining. Miners get rewarded for contributing knowledge and trusted data to the AI.
<a href="https://x.com/Polkadot/status/1868621889419219045">https://x.com/Polkadot/status/1868621889419219045</a> Utilization of @Bifrost Liquid Staked DOT (vDOT) is at an ATH. vDOT allows holders to participate in Polkadot-based DeFi, while still collecting staking rewards.
<a href="https://x.com/Polkadot/status/1870121359080133039">https://x.com/Polkadot/status/1870121359080133039</a> Extrinsics on Phala Network &rarr; ATH 👀 Phala is an L1 secured by Polkadot focusing on privacy-preserving computation. Phala&rsquo;s AI agents autonomously perform tasks like monitoring data, triggering smart contracts, and interacting w/ dapps. Follow @phalanetwork to learn more ✅
<a href="https://x.com/Polkadot/status/1881633036443455685">https://x.com/Polkadot/status/1881633036443455685</a> Stablecoin Adoption on Polkadot &rarr; ATH USDC + UDST = $114,000,000 Parachains with the most? 1️⃣ AssetHub 2️⃣ @hydrationnet 3️⃣ @MoonbeamNetwork
<a href="https://x.com/Polkadot/status/1846578533784523246">https://x.com/Polkadot/status/1846578533784523246</a> What they said: "DeFi is ded" What happened: "StellaSwap's incentive campaign goes supernova" TVL of major pairs, including xcUSDC and xcUSDT, have reached ATH @StellaSwap
<a href="https://x.com/Polkadot/status/1849056523214819352">https://x.com/Polkadot/status/1849056523214819352</a> Mythical Games seamlessly integrates NFTs into titles like NFL Rivals, allowing players to own &amp; trade digital assets like skins&mdash;without even knowing they&rsquo;re NFTs. @EnterTheMythos has issued, burned or transferred 12,000,000+ NFTs since migrating from Ethereum to Polkadot 👀
<a href="https://x.com/Polkadot/status/1850891487774490847">https://x.com/Polkadot/status/1850891487774490847</a> Liquid Staked DOT on Bifrost (vDOT) continues to expand across the ecosystem, showcasing Polkadot's interoperability. vDOT holders can participate in Polkadot-based DeFi, while still collecting staking rewards. @Bifrost
<a href="https://x.com/Polkadot/status/1851914236215107660">https://x.com/Polkadot/status/1851914236215107660</a> Knowledge Assets added to @NeuroWebAI reach a record high. What are Knowledge Assets? A container that can describe any digital or physical object, abstract concept, or really any "thing" - here with information integrity &amp; ownership supported by blockchain &amp; decentralized.
<a href="https://x.com/Polkadot/status/1831626673499906106">https://x.com/Polkadot/status/1831626673499906106</a>
<a href="https://x.com/Polkadot/status/1870121359080133039">https://x.com/Polkadot/status/1870121359080133039</a> Month by month, participation in Polkadot OpenGov continues to rise 💪 Chart: the number of votes cast (without conviction) by month.
<a href="https://x.com/Polkadot/status/1839626708577657151">https://x.com/Polkadot/status/1839626708577657151</a> The number of Tokenized T-Bills in the @centrifuge Liquid Treasury Fund continues to grow&hellip; So what? T-Bills are backed by the government. Now, they&rsquo;re on-chain. No banks, no brokers. Just direct access through the decentralized blockchain. Centrifuge, secured by Polkadot.
<a href="https://x.com/filippoweb3/status/1888138037223141839">https://x.com/filippoweb3/status/1888138037223141839</a> The DEX @hydrationnet is approaching 1B in cumulative volume since Feb 2024 👀 source @Dune 
<a href="https://x.com/Funkmeister380/status/1886043801333940662">https://x.com/Funkmeister380/status/1886043801333940662</a> @colorfulnotion analysed @wormhole bridging into @MoonbeamNetwork -- surprisingly large number of chains, mostly USDT and USDC 
<a href="https://x.com/yaronski/status/1872071494429503918">https://x.com/yaronski/status/1872071494429503918</a> bar chart comparison of the 7 referenda's results queried for conviction-free GLMR support on @Dune thanks to @colorfulnotion 
<a href="https://x.com/colorfulnotion/status/1860922090423267666">https://x.com/colorfulnotion/status/1860922090423267666</a> @enterthemythos really does have almost 100K MAUs doing NFTs, 14K MAUs doing the Marketplace Verified on @dune -- check it out 
<a href="https://dune.com/substrate/mythos">https://dune.com/substrate/mythos</a> <a href="https://x.com/BillLaboon/status/1838866222403731951">https://x.com/BillLaboon/status/1838866222403731951</a> The month is not quite over, but assuming no major changes in the next week, Polkadot Treasury spending (light blue bar) for September is at its lowest level of 2024 and net outflow (yellow line) is close to breakeven. 
<a href="https://x.com/Polkadot/status/1877668081276699003">https://x.com/Polkadot/status/1877668081276699003</a> No fluff, just data. Check the Polkadot 2024 Dashboard on @Dune for the answer. <a href="https://dune.com/substrate/2024">https://dune.com/substrate/2024</a> / by @colorfulnotion 
<a href="https://x.com/TheKusamarian/status/1829836537439387791">https://x.com/TheKusamarian/status/1829836537439387791</a> How much MYTH will you be Airdropped? &rarr; <a href="https://dune.com/substrate/mythos-airdrop-v4">https://dune.com/substrate/mythos-airdrop-v4</a> @LeemoXD ↯ 
<a href="https://x.com/hydration_net/status/1850949746372067542">https://x.com/hydration_net/status/1850949746372067542</a> vDOT much hydrated The upcoming launch of our Money Market will deliver the next piece in the DeFi lego 
<a href="https://x.com/replghost/status/1841463066850205785">https://x.com/replghost/status/1841463066850205785</a> Amazing! The work of a dedicated @Polkadot community member to take the initiative to bring clarity and transparency to the ecosystem. We need people to step up like this, see a problem and solve it. And of course, the dashboard is made possible by the Dune integration completed earlier this year, thanks to @colorfulnotion 
<a href="https://x.com/Polkadot/status/1840861209341673944">https://x.com/Polkadot/status/1840861209341673944</a> Have you checked your wallet lately? 👀 Starting today, 10M Myth Tokens will be distributed to over 450K DOT wallets, as approved by the community in 🗳️ OpenGov Ref 643. 
<a href="https://x.com/Polkadot/status/1824015053542035818">https://x.com/Polkadot/status/1824015053542035818</a> Interconnectivity between Polkadot parachains continues to grow&hellip; Open HRMP Channels ⬆️ HRMP is a protocol that enables and secures cross-chain communication on Polkadot and passes all messages via the Relay Chain 🔄 Polkadot enables an interoperable, and scalable multichain ecosystem, laying the groundwork for the future of Web3 
<a href="https://x.com/colorfulnotion/status/1821897712473927967">https://x.com/colorfulnotion/status/1821897712473927967</a> Holy 1337 Batman! @enterthemythos is NAILING it with over 8K active users in a day doing real NFT action. This is NOT hype, check it out: <a href="https://dune.com/substrate/mythos">https://dune.com/substrate/mythos</a> The first charts we've built about a @polkadot parachain that makes us smile about GROWTH. 😀😍🥰 
<a href="https://x.com/Polkadot/status/1821495038104195210">https://x.com/Polkadot/status/1821495038104195210</a> 👀 what do you see in this chart? &hellip;right answers only&hellip; 
<a href="https://x.com/Polkadot/status/1818539332233277585">https://x.com/Polkadot/status/1818539332233277585</a> Hydration's Omnipool TVL is at an ATH after tripling in recent months 👀 Omnipool combines all assets in a single pool to allow users to provide only one asset to earn yield while also exponentially enhancing efficiency 🙌 Trade at size, with ease @hydrationnet 🌊
<a href="https://x.com/CryptoCappex/status/1814235269496787163">https://x.com/CryptoCappex/status/1814235269496787163</a> Delegates from the first #Polkadot DV cohort voted on average in 67% of all completed OpenGov referendums. ChaosDAO ~100% Saxemberg and Kukabi &gt;75% The average participation of the second cohort is 61% in the completed referendums, should it be higher? 🗳️
<a href="https://x.com/0xLurpis/status/1813784553909314003">https://x.com/0xLurpis/status/1813784553909314003</a> . @Bifrost just spent 23 $KSM to purchase a coretime and renew the @kusamanetwork slot for 28 days for the first time. Based on the price of $KSM, securing the parachain on Kusama for one month only costs $524. Even in the lowest-cost month in 2024, the average cost of @ethereum 's L2 rollup was $38k, which is 73x higher than the shared security cost of Kusama. Data Source: <a href="https://dune.com/queries/2863300/4788854">https://dune.com/queries/2863300/4788854</a>
<a href="https://x.com/colorfulnotion/status/1808927242803892637">https://x.com/colorfulnotion/status/1808927242803892637</a> Holy Snowbridge-is-working Batman! Someone sent $2,186,127 (695 ETH) from @ethereum to @polkadot Asset Hub (tx) @colorfulnotion's Snowbridge dashboard: <a href="https://dune.com/substrate/snowbridge">https://dune.com/substrate/snowbridge</a> Move your ETH assets to Polkadot here: <a href="https://app.snowbridge.network">https://app.snowbridge.network</a> and join the WETH top holders on Polkadot Asset Hub: <a href="https://assethub-polkadot.subscan.io/foreign_assets/f1846f14a52715c2a09df52ef8f077c52977dcfd">https://assethub-polkadot.subscan.io/foreign_assets/f1846f14a52715c2a09df52ef8f077c52977dcfd</a> and beyond =)
<a href="https://x.com/filippoweb3/status/1808490340912926806">https://x.com/filippoweb3/status/1808490340912926806</a> Hey, Polkadot has 10 users, it's a dead chain🤔 Me👇 Polkadot secured 35 M transactions in June 2024 alone and 300 M transactions in the past year across 50 L1 chains Source @DuneAnalytics
<a href="https://x.com/filippoweb3/status/1805865609881698305">https://x.com/filippoweb3/status/1805865609881698305</a> The Polkadot Wiki has a new section about @DuneAnalytics , explore Polkadot's data👇 Thanks to @colorfulnotion for the integration
<a href="https://x.com/AstarNetwork/status/1796291000928731174">https://x.com/AstarNetwork/status/1796291000928731174</a> Track your favourite dApps and current staking rewards on the new @DuneAnalytics dashboard! 🗳️ The next voting period for dApp staking starts in 15 days!
<a href="https://x.com/marvin_tong/status/1791859775690649709">https://x.com/marvin_tong/status/1791859775690649709</a> "I heard Phala is the OG in computing and coprocessors, but is it a bit SPAMMY? 🤔" 🙄 All books are open, verify by yourself: <a href="https://dune.com/substrate/phala">https://dune.com/substrate/phala</a>
<a href="https://x.com/StellaSwap/status/1785972721870094770">https://x.com/StellaSwap/status/1785972721870094770</a> Our public dashboard on @DuneAnalytics is LIVE! 🎉 You can now access key metrics on StellaSwap on Dune that include; ⭐️ Daily Vols. ⭐️ Pool Breakdown ⭐️ Swap Volume Accounts ⭐️ Active Accounts ⭐️ Swap Txn ⭐️ Unique Accounts 👉 <a href="https://dune.com/substrate/stellaswap">https://dune.com/substrate/stellaswap</a> Special thanks to @Funkmeister380 @colorfulnotion 🔥
&nbsp;<a href="https://x.com/0xTaylor_/status/1780638978749907352">https://x.com/0xTaylor_/status/1780638978749907352</a> $MYTH airdrop just got a LOT better, LFG!!! Great work @johnwastaken @StakePlusCrypto @ChaosDAO You can check your drop here: <a href="https://dune.com/substrate/mythos">https://dune.com/substrate/mythos</a> Thanks to @colorfulnotion for the @DuneAnalytics dashboard
<a href="https://x.com/giottodf/status/1771761334809428146">https://x.com/giottodf/status/1771761334809428146</a> You can follow the distribution of DED on Dune 🙂 <a href="https://x.com/Polkadot/status/1828424728840704161">https://x.com/Polkadot/status/1828424728840704161</a> L1s secured by Polkadot are more active than ever 💪 Monthly Runtime Upgrades by Chain ⤵️
<a href="https://x.com/colorfulnotion/status/1825026730060546542">https://x.com/colorfulnotion/status/1825026730060546542</a> By linking Polkadot Staking Dashboard to @duneanalytics dashboards (developed by us @colorfulnotion ), everyone can have a deep look into their staking activity.
<a href="https://x.com/TheDotsMagazine/status/1781559738393678096">https://x.com/TheDotsMagazine/status/1781559738393678096</a> The $MYTH airdrop dashboard has been updated! Now it has 30k more eligible addresses (mine is one of them) 🎉 Check your wallet address here: <a href="https://x.com/TheDotsMagazine/status/1770793708885065915">https://x.com/TheDotsMagazine/status/1770793708885065915</a> $DED SNAPSHOT RECAP 🐦 The snapshot was taken on March 18 at Block 19,952,000. All eligible wallets have already recievied 0.001 DOT on Asset Hub 💀 Polkadot Treasury was NOT included in the snapshot. At Block 19952000 the Treasury had 38,603,060 DOT 🪂 Airdrop date - TBA
<a href="https://x.com/colorfulnotion/status/1770622358686253500">https://x.com/colorfulnotion/status/1770622358686253500</a> Now on Dune: @hydradx Dashboards showing trading volumes, omnipool asset, account trading patterns, liquidity analytics and more! Please star / share, stay hydrated! 
<a href="https://x.com/Dune/status/1770087920994603325">https://x.com/Dune/status/1770087920994603325</a> Starting today @Polkadot @kusamanetwork and 6 top #parachains are now live on Dune! Our mission is to make crypto data accessible, and we're thrilled to help the #Polkadot ecosystem in partnership with @colorfulnotion ⚡ Start your data journey👇 
<a href="https://x.com/mewwts/status/1770126851630883162">https://x.com/mewwts/status/1770126851630883162</a> So excited to have @Polkadot on Dune 
<a href="https://x.com/NilesLawrence/status/1770119471316779389">https://x.com/NilesLawrence/status/1770119471316779389</a> We're excited to finally announce this partnership and support a brand new ecosystem of builders! @Polkadot @kusamanetwork @AstarNetwork @bifrost @InterlayHQ @centrifuge @hydradx
<a href="https://x.com/WatanabeSota/status/1770098518138691852">https://x.com/WatanabeSota/status/1770098518138691852</a> oh wow! "Dune alongside AssetHub for Polkadot, Astar, Bifrost, Hydradx, Interlay, and Centrifuge parachains!"
<a href="https://x.com/Polkadot/status/1770106456668242247">https://x.com/Polkadot/status/1770106456668242247</a> 📊 Dune is bringing the data! @DuneAnalytics has added support for six parachains and both Polkadot &amp; @kusamanetwork Relay Chains via a collab w/ @colorfulnotion . Dune users can query data and unearth previously inaccessible on-chain activity ✔︎

Dune+GC Web3 x Polkadot (Q2 2025-Q1 2026) FEEDBACK REQUESTED

This video details how Polkadot OpenGov proposers can use utility.batch with treasury.spend call with USDC + USDT!  Its meant to inform proposers and OpenGov voters.

* [Video: utility.batch treasury.spends with USDC + USDT](https://www.youtube.com/watch?v=ak-me8G-MMo)
* [Slides: utility.batch treasury.spends with USDC + USDT](https://docs.google.com/presentation/d/1onXYeGm4cFJlktsWJWi0YirNuYsQ5oe4/edit#slide=id.g27a15e6ec76_0_18)
* [Cheat Sheet:  utility.batch treasury.spends with USDC + USDT](https://docs.google.com/spreadsheets/d/167TVq-PCqGVHI1MEP8EeaGc1zz2F5mmZgtcWCw2Ylgo/edit?gid=1373159512#gid=1373159512)

Instead of using EMA7+EMA30 guesswork (which predictably gets unpredictable results, especially this week 😅) and asking for annoying topups later when DOT falls, this process saves everyone from all that guesswork and gets stable results.

Instead of proposers getting paid everything up front (too risky for OpenGov Treasury) or paid retroactively if  it passes (too risky for proposer), proposers  can deliver milestone by milestone with this FAIR utility.batch.

If proposers fail to deliver, OpenGov can use treasury.voidSpend to cancel the proposal execution. 

This means: NO MORE TOP UPS!   


![image](https://i.ibb.co/TMQT0qM/4113-sourabhniyogi-1723034589635.png)

Note: this is not a declaration from OpenGov or a Wish-for-change, just an educational video.  

We hope someone will make a better video but I think its urgent that everyone know about and use this for efficient Treasury spends.

Also note from [@replghost](https://polkadot.polkassembly.io/user/replghost) from this [tweet](https://x.com/replghost/status/1821736106444124320) -- ** DO NOT USE ** your relay chain multisig  to request USDC or USDT funds from the treasury at the current time. You need to set up a separate AssetHub multisig to receive stablecoin funds from the treasury.   

Polkadot OpenGov TOP-UP KILLER: utility.batch treasury.spends with USDC + USDT

Truth Seeking Adam: <a href="https://twitter.com/AdamSteeber1/status/1773459241484857616">https://twitter.com/AdamSteeber1/status/1773459241484857616</a> Community Leadership TheKus: <a href="https://twitter.com/gldncalf/status/1772721225573318785?s=46&amp;t=Vvxou2ROV_fySLPwF-FGvg">https://twitter.com/gldncalf/status/1772721225573318785?s=46&amp;t=Vvxou2ROV_fySLPwF-FGvg</a>
Adam and Jay demonstrate exemplary behaviors that deserve to be recognized. They didn't have to go the extra mile to be curious or helpful, but they did go the extra mile. So I hope some of the toxicity we see in OpenGov can be replaced with the kind of behavior manifested above.

Tip for Adam Steeber + Kusamarian concerning #514 Conor Daly - 2024 Indianapolis 500 Sponsorship

This tip is for [Hector Bulgarini's Analysis on Proposal #379: NFT XCM](<379#X3ST121Z0R0p9CvsmyNj>) which follows this [template:](<https://twitter.com/giottodf/status/1746401243403043295?s=46&t=qKV5hT_Ds4kNwzNTZpvU4w>)

- Abstract: what it's about, this is important so that people can decide if they should keep reading or not most likely if it's outside of their circle of competence they will move on to the next proposal at this stage

- Prior art: how things are currently being done without this proposal being in existence

- Projected prior art: how the future would look like without this change / innovation / addition / proposal

- Context: how this is relevant in the bigger context, related to what is already there, what is currently being planned by other parties, what is currently being done, etc

- Why: why is it needed? What is the business case?

- Trade-offs: what are the trade-offs compared to alternative solutions that may already exist or may not yet exist but are different? Including theoretical only










Tips for [DOT Experts](https://t.me/dotxpert) are intended to reward experts who provide detailed analyses for OpenGov voters to make political decisions. DOT Experts should never express political preferences, and instead characterize decisions in terms of tradeoffs.

Background:

- Hector did work on [Trappist](<https://www.youtube.com/watch?v=1eJwzbtqZYs>) which concerns XCM NFT Interoperability.

- [Proposal #379: NFT XCM](<379>) aims to make **XCM NFT Interoperability** production grade across all parachains in the Polkadot ecosystem.


## Request for DOT Experts!

Ready to help OpenGov voters make informed political decisions?

Join the [DOT Experts Telegram Group](https://t.me/dotxpert)

DOT Experts Tip for Hector Bulgarini for Proposal #379: NFT XCM

[Dune](https://dune.com/browse/dashboards) is the industry leader in highly shareable dashboards widely used by industry leaders, data analysts, marketers, and builders across the broader Web3 ecosystem. For example here is [Brian Armstrong sharing a Dune dashboard about Base](https://twitter.com/brian_armstrong/status/1690158283632586752), compared to [Moonbeam sharing dolpha.com](https://twitter.com/MoonbeamNetwork/status/1702721492834755061), [Astar sharing subscan](https://twitter.com/WatanabeSota/status/1731863081943277787) or [Polkadot sharing DotLake](https://twitter.com/Polkadot/status/1722980186189070760):

<table>
<tr>
<td>
<img src="https://cdn.polkaholic.io/366/366-coinbase.png" alt="Polkadot" width="400">
</td>
<td>
<img src="https://cdn.polkaholic.io/366/366-moonbeam.png" alt="Polkadot" width="400">
</td>
</tr>
<tr>
<td>
<img src="https://cdn.polkaholic.io/366/366-astar.png" alt="Polkadot" width="400">
</td>
<td>
<img src="https://cdn.polkaholic.io/366/366-polkadot.png" alt="Polkadot" width="400">
</td>
</tr>
</table>
 
Common to the above is that Web3 ecosystem participants want to share on-chain data, which Dune is optimized for, better than a block explorer ([Subscan - #311](https://polkadot.polkassembly.io/referenda/311)) or expensive dashboards ([Dolpha.com - #341](https://polkadot.polkassembly.io/referenda/341)). Colorful Notion has built [substrate-etl - #248](https://polkadot.polkassembly.io/referenda/248), here proposed to be ingested by Dune as *substrate-etl 2.0* in 2024.

## Proposal - Onboard Polkadot + Kusama Data on Dune (12 months, 3/15/24-3/14/25)

Colorful Notion proposes to onboard the Polkadot + Kusama relay chains by mid-March 2024, available for the community for at least _2 years_. This proposal funds the _first_ year after a PoC is completed in early 2024, for 3/15/24 - 3/14/25. Onboarding Polkadot will be Dune’s second non-EVM ecosystem integration, after Solana. Separate from this OpenGov proposal, Colorful Notion has negotiated pricing for all parachains with Dune, beyond the Polkadot and Kusama Relay Chain. This will enable Polkadot + Kusama Substrate data to be represented in Dune for both relay chains (using "polkadot" and "kusama") and all Polkadot parachains in an official integration with hourly indexing. 

# Demonstration: Polkadot Staking Dashboard

In December 2023, Colorful Notion developed a proof of concept with key Dune engineers for the Polkadot Relay Chain with a few representative datasets. Here is one of the first Polkadot dashboards built in Dune: 

[https://dev.dune.com/mkchungs/polkadot-staking-validator](https://dev.dune.com/mkchungs/polkadot-staking-validator)

<img src="https://cdn.polkaholic.io/366/366-staking.png" alt="Polkadot" width="100%">


Once data is ingested from Colorful Notion’s substrate-etl into Dune, this dashboard can be rapidly constructed within a couple hours from SQL knowledgeable engineers such as Colorful Notion cofounder [@mkchungs](https://polkadot.polkassembly.io/user/mkchungs). Here is one query:

<img src="https://cdn.polkaholic.io/366/366-staking-rewards.png" alt="Polkadot" width="100%">

Any on-chain dataset from Polkadot or Kusama involves writing a query such as the against some substrate-etl 2.0 dataset. Colorful Notion’s commercial terms have been developed to allow for a certain amount of storage ingesting a certain number of chains so that “Dune wizards” can query these tables, views, and materialized views and produce shareable charts like the above. 

Everyone with a Dune account can query and build these dashboards in Dune. While Google BigQuery can be connected to open source Apache Superset (and we have, see our W3F grant work on [Deep Account Analytics](https://github.com/w3f/Grants-Program/pull/1286) and inkubator-supported [ChainIDE + Polkaholic.io WASM Contract Explorer Integration](https://github.com/use-inkubator/Grant-Milestone-Delivery/blob/master/deliveries/chainide-polkaholic-integrated-wasm-contract-explorer-integration-milestone_1.md)), Dune is more usable and more shareable. 

Whereas much of 2022 involved developing Polkaholic.io and 2023 involved substrate-etl 1.0 bringing data into Google BigQuery, Colorful Notion will have 2024 involve robust ingestion of Polkadot and Kusama data into Dune and ensuring the community can use it to support blockchain analytics and marketing.

# Proposal Details


[Full Proposal](https://docs.google.com/document/d/1UMpD152JmvHm6O9Q76TlF8GR1O_FRJydjf7bndClj-k/edit)

[Cost Breakdown](https://docs.google.com/spreadsheets/d/1c7-3kdfAjWdtWTkx2anEQgYpToUiWo3vav1WrapFuEI/edit#gid=1479719106)

[Slides](https://docs.google.com/presentation/d/1wulreQof9V7QwCTuJZ9e64eDHhzAtqTS/edit#slide=id.g2a79f725924_0_8)

**Requested Amount:** 325,000 DOT [$1,968,200]

# December 2023 Decision For DOT Tokenholders: Dune Now or late 2024?

Colorful Notion has been advocating a Polkadot Data Alliance Bounty along with Parity Data throughout much of 2023 (see [this from CN](https://docs.google.com/document/d/1ryC6dxcd9tiQsB7KiCc2BY_TwBJ5jKloGfCyVAGCkKo/edit#heading=h.gjdgxs) and [this from Parity Data](https://docs.google.com/document/d/1fA5ARHy-frzgZC66rniKZ5o7CSbDvCTkS--kWaMzuMs/edit#heading=h.foftxwdr3st2)). In November, we finally decided to submit #248 and reach out to Dune as an outstanding goal of both teams. From the DOT Tokenholder point of view, once it is accepted that an ecosystem wide Dune integration is desirable and both teams are competent (as we do), we believe the decision is largely a tradeoff between Dune NOW vs Dune LATER:

<img src="https://cdn.polkaholic.io/366/decision.png" alt="Polkadot" width="100%">

A simplified comparison is as follows:

<img src="https://cdn.polkaholic.io/366/366-comparison.png" alt="Polkadot" width="100%">

Which boils down to the following choice:

* If you believe you want a Dune Integration NOW (early 2024), vote Aye on #366.
* If you believe you want a Dune Integration LATER (or don’t want it at all), vote Nay on #366.

We believe the answer is to integrate Dune NOW to support marketing and general ecosystem growth.

# About Colorful Notion

Colorful Notion is led by [Sourabh Niyogi](https://forum.polkadot.network/u/sourabhniyogi) and [Michael Chung](https://forum.polkadot.network/u/mkchungs). We have been active in the Polkadot ecosystem over the last 2 years and look forward to building with others in Polkadot 2.0’s “map reduce” ubiquitous computing future. 


## Updates 

* 12/21/2023 - [AAG #93 - et-l brute?](https://www.youtube.com/watch?v=3jlA51DLz2o) 
* 12/22/2023 - PoC of Polkadot Relay Chain completed -- see [Polkadot Proof-of-Concept Dashboard](https://dune.com/sourabhniyogi/polkadot-proof-of-concept)
* 1/3/2024 - Happy New Year 2024! Basic CN-Dune terms are being developed by Dune General Counsel; Partially redacted summary of Terms used for MSA draft may be posted here, _with permission_.
* 1/4/2024 - CN received MSA from Dune. Publicly sharable CN-Dune terms are included below for transparency:

![image](https://i.ibb.co/Rb5Nb3V/4113-sourabhniyogi-1704397042754.png)

* 1/5/2024 - 3 Order forms developed for MSA.
* 1/9/2024 - [Relay Chain/Parachain tables](https://docs.google.com/spreadsheets/d/1eG14AFNpJBx8Ng46XIy19hM1R_POcT94t5mvfWaQoFE/edit#gid=1994869400) (shared with Dune permission)
* 1/11/2024 - MSA finalized
* 3/19/2024 - Dune public announcement: https://twitter.com/DuneAnalytics/status/1770087920994603325

# Ongoing Dashboard development in Q2 2024: 

[Polkadot Wiki PR](https://github.com/w3f/polkadot-wiki/pull/5933)

## Polkadot Relay Chain

Polkadot Governance:
* General: https://dune.com/substrate/polkadot-gov
* Refs: https://dune.com/substrate/polkadot-referendum	

Polkadot Staking: https://dune.com/substrate/polkadot-staking	

## Polkadot Parachains:

AssetHub: https://dune.com/substrate/assethub		

Interlay: https://dune.com/substrate/interlay		

Astar: https://dune.com/substrate/astar-dapp-staking		

Bifrost: https://dune.com/substrate/bifrost		

HydraDX: https://dune.com/substrate/hydradx		

Centrifuge: https://dune.com/substrate/centrifuge		

Moonbeam: https://dune.com/substrate/moonbeam-governance	

Stellaswap: https://dune.com/substrate/stellaswap	

Acala: https://dune.com/substrate/acala		

Unique: https://dune.com/substrate/unique		

Phala: https://dune.com/substrate/phala		

Neuroweb: https://dune.com/substrate/neuroweb		

Manta: https://dune.com/substrate/manta		

Mythos: https://dune.com/substrate/mythos

Collectives: https://dune.com/substrate/collectives		

Nodle: https://dune.com/substrate/nodle		

Invarch: https://dune.com/substrate/invarch	

## Kusama Relay Chain 

Kusama Staking: https://dune.com/substrate/kusama-staking	

Kusama Governance:
* General: https://dune.com/substrate/kusama-gov
* Refs: https://dune.com/substrate/kusama-referendum	

## Kusama System Chains / Other

Coretime: https://dune.com/substrate/coretime_kusama		

DED: https://dune.com/substrate/dotisded


For the latest of ongoing ingestion status and dashboard catalyst, see this [public sheet](https://docs.google.com/spreadsheets/d/1eG14AFNpJBx8Ng46XIy19hM1R_POcT94t5mvfWaQoFE/edit#gid=2015037)

substrate-etl 2.0: Polkadot + Kusama Data on Dune (12 months, 3/15/24-3/14/25)

<h1 id="proposalsummary">Proposal Summary</h1>
We propose to run $144K in Twitter ads in the end of Dec 2023-Mar 2024 timeframe to:
<ol>
<li>Increase awareness of On-brand Polkadot narratives :</li>
</ol>

&nbsp;

&nbsp;

<ul>
<li>
DOT 2.0 BUSINESS IS ABOUT CORETIME: cf <a href="https://twitter.com/PolkadotInsider/status/1727495973138759785">Lastik</a>
</li>
<li>
DOT 2.0 IS BREAKTHROUGH TECH: cf <a href="https://twitter.com/bkchr/status/1712419542977118289">PolkaVM</a>, <a href="https://twitter.com/rphmeier/status/1707098462347514328">CoreJam</a>
</li>
<li>
DOT ECO HAS GREAT REWARDS cf <a href="https://twitter.com/PolkadotInsider/status/1719013455561375935">Polkadot Staking APRs</a>
</li>
<li>
DOT IS FOR THE ENTERPRISE: cf <a href="https://twitter.com/Polkadot/status/1701148275233915165">Mythical</a>, <a href="https://twitter.com/Polkadot/status/1724842104994607252">Frequency</a>, <a href="https://twitter.com/energywebx">EnergyWebX</a> &hellip; and by <a href="https://twitter.com/shawntabrizi/status/1666287029963878400">Parachains</a>
</li>
<li>
DOT IS A STARFISH NOT A SPIDER: cf <a href="https://twitter.com/filippoweb3/status/1727698546097365159">Fillipo</a> + <a href="https://twitter.com/Web3foundation/status/1725121561055670755">Decentralized Futures</a>
</li>
<li>
DOT SUPPORTS USERS + PARACHAIN GROWTH: cf <a href="https://twitter.com/Polkadot/status/1727650420678422532">KodaDot</a>, <a href="https://twitter.com/Apillon/status/1724075559393575063">Apillon</a>
</li>
</ul>

&nbsp;

&nbsp;

<ol>
<li>Generate engagements on <a href="https://twitter.com/polkadot">Polkadot Twitter Account</a> (presently 1.4MM followers), Polkadot Parachains, and select Polkadot True Believers (see <a href="https://docs.google.com/document/d/1U99BS6NK18bYmmizOkThAVabb4pzKecEbF24GovxF_Y/edit?pli=1#heading=h.i2yswqq8b1a1">Appendix B</a>)</li>
</ol>
<h1 id="campaignsummary">Campaign Summary</h1>
The Campaign will be run as follows:
<ul>
<li>
Ad Spend: $144K [80.9%]
</li>
<li>
Strategy: Learning / Experimentation Oriented, Optimizing for Cost Per Follower
</li>
<li>
Time Period: Min 6 Weeks, Max 12 Weeks (late Dec 2023 until April 2024). Campaign End date extended due to delays in <a href="../user/polkadot">@polkadot</a> approval.
</li>
<li>
Campaign Target: English-Speaking Countries ( US, CA, GB, IE, AU, NZ), Selected Influencers + their followers (see Appendix C), Followers of other ecosystems (see Appendix D)
</li>
<li>
Campaign Management Systems: Twitter Ads (Direct) and <a href="https://www.addressable.io/">Addressable.io</a> - We use two campaign management systems to A/B Test and learn the value of Addressable.io&rsquo;s Web3-specific behavior targeting system targeting crypto users compared to running campaigns directly with Twitter Ads.
</li>
</ul>
<h1 id="valuetodotholders">Value to DOT Holders:</h1>
<ol>
<li>
Increase awareness of On-brand Polkadot Narratives via Twitter Channel
</li>
<li>
Increase the number of engagements of the main Twitter Polkadot account and Polkadot parachains (85%) and Polkadot True Believers (15%)
</li>
<li>
Demonstrate Decentralized Marketing: (1) funding from OpenGov (2) run by the community rather than ecosystem leader Parity;
</li>
</ol>
<h1 id="proposaldetailscommunityinvolvementrequested">Proposal Details: COMMUNITY INVOLVEMENT REQUESTED</h1>
Requested Amount: 35,395 DOT ($178K with EMA30 $5.029/DOT)
<a href="https://docs.google.com/document/d/1U99BS6NK18bYmmizOkThAVabb4pzKecEbF24GovxF_Y/edit?pli=1">FULL PROPOSAL DETAILS</a>
<h1 id="updates">Updates</h1>
<ul>
<li>Week of January 15/22, 2024: With the help of Evan Thomas, secured W3F Legal+Security support for Polkadot promotion</li>
<li>January 30, 2024: Started running traffic with <a href="../user/polkadot">@polkadot</a> sourced tweets</li>
<li>February 10, 2024: <a href="https://docs.google.com/presentation/d/1fUFcp9VnNHBPZpIuZDoMAiWrYz-e3kU2/edit#slide=id.g1dd65562061_0_2312">2/10/24 Transparency Report #1</a>
<li>April 2, 2024: <a href="https://dune.com/substrate/324-opengov">Dune Dashboard covering activity until 3/31/24</a>
<li> April 27, 2024: Dune Dashobard update covering activity until 4/30/24 finalized 
</ul>

Increase Awareness of Polkadot On-Brand Narratives via Twitter Ads

[substrate-etl](https://github.com/colorfulnotion/substrate-etl) is a large scale index of Polkadot + Kusama and their parachains based on [Polkaholic.io](https://polkaholic.io), a multichain block explorer/indexer.  Using this data warehouse, anyone can query decoded blocks, extrinsics, events, calls across both ecosystems.  

We onboarded Polkadot Data into Google Public Datasets, announced in September 2023:

* [Enhancing Google Cloud’s blockchain data offering with 11 new chains in BigQuery](https://cloud.google.com/blog/products/data-analytics/data-for-11-more-blockchains-in-bigquery-public-datasets)
* [Polkadot - Harness the power of Polkadot's BigQuery Public Dataset](https://twitter.com/Polkadot/status/1707052392712212676)

The substrate-etl index results in two large datasets (crypto_polkadot and crypto_kusama) covering the 2 relay chains and over 70 parachains.  This represents Polkadot/Kusama alongside other Web3 ecosystems and supports complex large scale analyses with SQL using BigQuery's lightning-fast query performance on extremely large datasets.   Having substrate-etl enables Dune-like analytics to guide business intelligence, inform engineering decision making, and showcase ecosystem growth. 

Power users include [Parity Data](https://forum.polkadot.network/t/select-from-polkadot/2593) (led by [Karim Jedda](https://forum.polkadot.network/u/karim) and [Pavla Mijic](https://forum.polkadot.network/u/pavla)), [Subwallet/DotInsights](https://twitter.com/dotinsights_xyz), [Web3metrics](https://web3metrics.com),
[Dolpha.com](https://dolpha.com/), [ChainViz](https://chainviz.app/) and many data analysts within parachains and outside the ecosystem.

# Quick Start

For a full guide, see [substrate-etl](https://github.com/colorfulnotion/substrate-etl), but you can get started with the following Analytics Hub links:

* [Polkadot on Google Analytics Hub](https://console.cloud.google.com/bigquery/analytics-hub/exchanges/projects/974572213039/locations/us/dataExchanges/polkadot_18bca7589e7/listings/polkadot_and_polkadot_parachains_18bca877a0a)
* [Kusama on Google  Analytics Hub](https://console.cloud.google.com/bigquery/analytics-hub/exchanges/projects/974572213039/locations/us/dataExchanges/polkadot_18bca7589e7/listings/kusama_and_kusama_parachains_18bca8f79fb)

# Roadmap

In addition to continuing support for substrate-etl/Polkaholic.io for existing and future chains, our plans for 2024 are to:
* chart a course within the [Decentralized Futures](https://futures.web3.foundation/) for 2024, supporting Web3 Foundation's [Data Analysis Tools for Substrate-based Blockchains](https://github.com/w3f/Grants-Program/blob/master/docs/RFPs/data_analysis_tools.md) (e.g. [traces](https://github.com/w3f/Grant-Milestone-Delivery/pull/1038) and [staking](https://github.com/w3f/Grant-Milestone-Delivery/pull/1045)), chart a course for substrate-etl + Polkaholic APIs to support [Dune Analytics Style Data Service for Polkadot/Kusama](https://forum.polkadot.network/t/dune-analytics-style-data-service-for-polkadot-kusama/271/1) with leading teams in the ecosystem 
* develop + support a [Polkadot Builder Collective](https://forum.polkadot.network/t/polkadot-builder-collective/4755/5) with a "builders supporting builders" orientation
* build support for CoreJam+CorePlay+DA and extend support for [ink!/WASM contracts](https://github.com/use-inkubator/Grant-Milestone-Delivery/blob/master/deliveries/chainide-polkaholic-integrated-wasm-contract-explorer-integration-milestone_1.md)
* extend substrate-etl to support raw + fully-decoded EVM datasets (transactions+logs), enabling [Substrate+EVM hybrid chain analytics](https://forum.polkadot.network/t/substrate-vs-evm-ecosystem-comparison/4454), as more parachains incorporate [hybrid chain designs](https://www.rob.tech/blog/hybrid-chains/)

# Proposal Details

Requested: 99,025 DOT

[Proposal Details here](https://docs.google.com/document/d/1F9nqhD-cBY43DlP5oDSRR1YvKvY2yraNSKOraxP3_xU/edit#heading=h.v6is2ta0txr1)

[Proposal Costs here](https://docs.google.com/spreadsheets/d/1c7-3kdfAjWdtWTkx2anEQgYpToUiWo3vav1WrapFuEI/edit#gid=1947784429)

# About Colorful Notion

Colorful Notion is led by [Sourabh Niyogi](https://forum.polkadot.network/u/sourabhniyogi) and [Michael Chung](https://forum.polkadot.network/u/mkchungs), based in the SF Bay Area.  We have been active in the Polkadot ecosystem over the last 2 years and look forward to building with others in CoreJam/Polkadot 2.0’s “map reduce” ubiquitous computing future. 

We are grateful for everyone who has helped us and hope we can pay it forward by helping others

substrate-etl Retroactive funding: Q3+Q4 2022-Q1+Q2 2023

**Detailed Proposal:**

[https://docs.google.com/document/d/1_ao-Hk-GxIPUDpWijDK4KXUjst0rglZZBzIuMGG7aVQ/edit#](https://docs.google.com/document/d/1_ao-Hk-GxIPUDpWijDK4KXUjst0rglZZBzIuMGG7aVQ/edit#)

**Short Description:**

Support Colorful Notion’s Polkaholic.io open source XCM/Multichain block explorer, indexing of all Polkadot + Kusama + parachain data with a special emphasis on XCM Transfers / Messages, made available in UI/API/CDN/BigQuery form to support  Polkadot ecosystem’s multichain initiatives.

**Proposal Summary:**

Colorful Notion proposes to:
- Expose and maintain public archive of all the raw data indexed by Polkaholic.io (blocks, extrinsics, events and traces) available in CDN form and then in BigQuery form and indexed data (specifically and especially XCM transfers and XCM messages) in API form
- Continue to index all Polkadot chains to the fullest extent possible to generate and maintain the archive with APIs, which may be relied upon by large scale archival systems.  These APIs maintain Value transfers/XCM transfers according to DEX info on top  “defi” parachains
- Model XCM Transfers and Messages across the entire Polkadot/Kusama ecosystem
- Enhance Polkaholic.io indexing as the Polkadot ecosystem expands: New parachains, new pallets generating XCM extrinsics/messages  with new XC Assets, support for ERC20/PSP22/ERC721/PSP34 assets, XCMv3, and new bridges

Polkaholic.io - Polkadot XCM/Multichain Block Explorer (Q2+Q3 2022)

https://polkadot.polkassembly.io/treasury/171

do not use - Replaced by #171

Summary: Polkadot Hub needs a custom Etherscan integration for PolkaVM/revive Smart Contracts. The proposed $1MM Etherscan-as-a-Service integration provides Web3/Solidity developers seamless tools for deploying and interacting with PolkaVM contracts first on Westend Hub and then on Polkadot Hub, aiming for increased developer+user growth of Polkadot Hub in 2025-2026. Problem: Polkadot Hub needs a PolkaVM Block Explorer Polkadot Hub (also known as Asset Hub or &ldquo;Plaza&rdquo;) is now positioned in the Polkadot 2.0 Roadmap as the primary home for user-facing and developer-facing smart contract activities as well as staking, governance and managing programmable assets. Historically, EVM contracts have been deployed in the Polkadot ecosystem in <a href="https://moonscan.io/">Moonbeam</a> and <a href="https://astar.blockscout.com/">Astar</a> through the &ldquo;<a href="https://github.com/polkadot-evm/frontier">Frontier</a>&rdquo; pallet, but with key breakthrough <a href="https://forum.polkadot.network/t/announcing-polkavm-a-new-risc-v-based-vm-for-smart-contracts-and-possibly-more/3811">PolkaVM</a> (a RISC-V-based virtual machine also at the heart of <a href="https://graypaper.com">Polkadot JAM</a>) there is a new Polkadot Hub+Cloud roadmap: <a href="https://forum.polkadot.network/t/contracts-on-assethub-roadmap/9513">Contracts on AssetHub Roadmap</a> <a href="https://forum.polkadot.network/t/contracts-update-solidity-on-polkavm/6949/7">Solidity on PolkaVM</a> <a href="https://www.youtube.com/watch?v=GPuTt10dxKI">Contracts on Polkadot Introducing Project Revive</a>
These are a part of numerous <a href="https://x.com/alice_und_bob/status/1863979132062748954/photo/1">Polkadot 2.0 innovations</a> from <a href="https://www.rob.tech/blog/plaza/">Plaza: A Batteries-Included, Scalable Polkadot System Chain</a> (<a href="https://x.com/rphmeier/status/1802809037186089243">summary</a>)) to CoreVMs + CorePlay JAM Services. This roadmap enables 4th generation Web3 developers to access Polkadot in both high-performance ways in &ldquo;old&rdquo; ways (Solidity-based Smart Contracts on Polkadot Hub) and &ldquo;new&rdquo; ways &ndash; enabled by Polkadot JAM Services, not with yet another EVM Chain but with PolkaVM, revive and Polkadot 2.0 innovations at its foundations. This proposal concerns giving Web3 developers the best blockchain service available: <a href="https://etherscan.io/eaas">Etherscan as Service</a>, with dominant usage in the Ethereum ecosystem (Ethereum, Base, Optimism, Arbitrum, &hellip;) in addition to Moonbeam users in the Polkadot ecosystem.&nbsp; Etherscan&rsquo;s feature set is comprehensive and difficult for other block explorers to match. For an overview, see <a href="https://www.youtube.com/watch?v=ve1fouiC3v0">Diving deeper with EVM block explorers</a>. Our key motivation is simple: Give Users + Developers the industry-leading explorer for Polkadot Hub: Etherscan &ndash; but fully customized for PolkaVM + revive-pallet innovations. <a href="https://forum.polkadot.network/t/contracts-on-assethub-roadmap/9513/19">Alex Thiessen</a> (Parity Contracts team lead, also proponent of <a href="885">OpenGov #885 - Should we allow EVM compatible contracts on Asset Hub?</a>) indicates unequivocal support of Etherscan here: 
<img src="https://i.ibb.co/6BM05qz/image.png" alt="image.png" /> Solution: Etherscan as a Service (EAAS) Custom Integration The vast majority of Smart Contract Developers write contracts in Solidity and deploy compiled EVM byte code to an EVM chain &ndash; most commonly Ethereum and Ethereum rollups but also Polkadot rollups (Moonbeam, Astar).&nbsp; With the revive pallet deployed on Polkadot Hub, these Solidity contracts will be compiled to PolkaVM instead of EVM, and interpreted by the revive-pallet on Polkadot Hub instead. Widely used REMIX tooling has&nbsp;already been customized for PolkaVM at <a href="https://remix.polkadot.io/">https://remix.polkadot.io/ </a>and enables compilation and deployment to Polkadot Hub in 2025, but is available on WestEnd Hub now: See <a href="https://contracts.polkadot.io/deploy-your-first-contract">Deploy Your First Contract</a> to see how simple and familiar this is to everyday Solidity developers. In the same way, this proposal strives to have Etherscan also be simple and familiar as REMIX is to users and developers alike. This is enabled by a set of JSON-RPC methods necessary for indexers to do their work &ndash; our <a href="https://hackmd.io/FEHH1zuWR3aGPJUBWAS8Iw">tests</a> indicate Westend Hub is ready for Etherscan integration in early 2025 and after all systems are fully tested, can proceed to Polkadot Hub as soon as pallet-revive is deployed in mid-2025.&nbsp; &nbsp; However, a custom integration is required to fully address PolkaVM.&nbsp;
Here is a full link to the detailed proposal:
<a href="https://docs.google.com/document/d/1SfYggOIZpTIYlpdFUiP45EAjVRr4rC4h_pI6bK3YpBg/edit?tab=t.0#heading=h.v6is2ta0txr1">Etherscan-as-a-Service x Polkadot Hub - PolkaVM Block Explorer (1 Mainnet, 1 Testnet)</a>
The proposal provides adequate budget ($1MM) for the Etherscan team to address + support the PolkaVM + revive custom integration fully.&nbsp; &nbsp;Colorful Notion is taking on project management of the integration through 2025 into early 2026. Key Benefits:
(1) Technical: Fully functional PolkaVM-based Westend and Polkadot Hubs, supported by robust secure infrastructure from industry leader. (2) Developer Impact: Seamless Etherscan interface for PolkaVM/revive contracts on Polkadot Hub will attract leading Web3 teams deploying on Polkadot Hub. Tools for contract interaction and code verification match EVM. (3) User Impact: Dapp deployment on Polkadot Hub can support an order of magnitude growth in usage, driven by the above. Budget: $1,000,000 USDC Services:&nbsp;
<ul>
<li>1 TestNet EAAS Integration: Westend Hub hosted at westend-hub.polkadot.io (or similar) Expected coverage: Q2 2025 &mdash; Q1 2026 ( 1 year )</li>
<li>1 MainNet EAAS Integration: Polkadot Hub hosted at hub.polkadot.io (or similar) Expected timeline: Q3 2025 &mdash; Q2 2026&nbsp; ( 1 year )</li>
</ul>
 Merry Christmas🎄🎅 and Happy New Year 2025! 🍺🎉🤗&nbsp; We look forward to making 2025 a great success together!
 
&nbsp;

Etherscan-as-a-Service x Polkadot Hub - PolkaVM Block Explorer (1 Mainnet, 1 Testnet)  

![image](https://i.ibb.co/ftX1D5L/4113-sourabhniyogi-1715938738239.png)

This is "Big Tipper" track tip for OnlyDefiGuy of up to 6000 USD (1000 USDC+2000 USDT+3000 USDC). 

[OnlyDefiGuy](https://twitter.com/onlydefiguy) had the courage to [face the dragon](https://twitter.com/OnlyDeFiGuy/status/1790348520202919936) on behalf of Dotizens,
sharing his expert report on #684 [here](https://polkadot.polkassembly.io/post/2303) in this [doc](https://docs.google.com/document/d/1kGECKw28q-gvNX67BopuDXQB2AqOx1B6V9VAaFc40X8/edit)

We should value this kind of courage and expertise. It clearly requires skin as thick as a dragon when proposals are this contentious.

This "Small Spender" tip attempts to [Create a Multistage Payout Proposal](https://wiki.polkadot.network/docs/learn-guides-treasury#creating-a-multistage-payout-proposal-with-validfrom) with [3 `treasury.spend`](https://polkadot.js.org/apps/?rpc=wss%3A%2F%2Fpolkadot-public-rpc.blockops.network%2Fws#/extrinsics/decode/0x1a000c130503000100a10f0001000b0098f73e5d010300010100586fd1cdd673dec2a5c3dea4f1f2efab11c15c6008698c3adb139a876bc0354e01406f4001130503000100a10f0001000b0030ef7dba020300010100586fd1cdd673dec2a5c3dea4f1f2efab11c15c6008698c3adb139a876bc0354e0140964601130503000100a10f0001000b007cd2a772050300010100586fd1cdd673dec2a5c3dea4f1f2efab11c15c6008698c3adb139a876bc0354e0140bd4c01):

1. at block [21,000,000](https://polkadot.subscan.io/block/21000000), pay 1000 USDC (est. May 30)
2. at block [21,403,200](https://polkadot.subscan.io/block/21403200), pay 2000 USDT (est. Jun 27)
3. at block [21,806,400](https://polkadot.subscan.io/block/21806400), pay 3000 USDC (est. Jul 25)

This multistage payout mechanism could be used by Big/Medium/Small Spender proposers for meeting time-based milestones or product-based milestones. It can almost certainly can be used for DOT payments as well. 

Assuming this passes (and the staged payout mechanics works in Polkadot), we imagine someone could submit a `treasury.voidSpend` on the 3rd payment (or 2nd payment). This is not because we believe OnlyDefiGuy doesn't deserve 3000 USDC (we do, because dragon fighting is _hard work_), but because it is clear the community learning this "voiding skill" can be explored to significant effect.

Or maybe OnlyDefiGuy will fight off enough dragons by then =)

Note: 
* #780 is in DOT but exceeds the 250 DOT Small Tipper track limit (150+300+599 = 1049 > 250 DOT)
* #781 is in DOT but exceeds the 1000 DOT Big Tipper track limit (150+300+599 = 1049 > 1000 DOT) -- this is expected to FAIL when the proposal is enacted (if 781 passes) 
* #782 is in USD but should not exceed the 1000 DOT Big Tipper track limit (1000+2000+3000=6000 USD < 1000 DOT). This does not use the asset conversion pallet but instead uses a 10 USD / DOT assumption so 100+200+300 DOT = 600 DOT < 1000 DOT will mean this will SUCCEED if the proposal is enacted (if 782 passes)

![image](https://i.ibb.co/vLrtcxL/4113-sourabhniyogi-1715938763699.png)

DOT Experts Tip for OnlyDeFiGuy for Proposal #684 Chainalysis analytics solutions in USD

Hello all,&nbsp;
I have wrote all my thoughts regarding proposal #684 in the below document. I know it's passing at the moment, but I could not let this go through without putting something on paper.&nbsp;
I have linked this document below for the community to review. If you would like to offer feedback or have a futher discussion about this prospoal I am happy to. You can contact me on Twitter. @OnlyDeFiGuy&nbsp;
I will be voting NAY on this proposal and I would recommend others do the same.&nbsp;
Regards,&nbsp;
OnlyDeFiGuy
<a href="https://docs.google.com/document/d/1kGECKw28q-gvNX67BopuDXQB2AqOx1B6V9VAaFc40X8/edit?usp=sharing">https://docs.google.com/document/d/1kGECKw28q-gvNX67BopuDXQB2AqOx1B6V9VAaFc40X8/edit?usp=sharing</a>

Report : Proposal #684 Chainalysis analytics solutions on Polkadot Relay Network

Our team at Colorful Notion tabulated this dashboard <a href="https://dune.com/substrate/polkadot-and-kusama-decentralized-voices">Decentralized Voices on Dune</a> this past month (see also <a href="https://forum.polkadot.network/t/decentralized-voices-the-story-so-far/7076/9">forum post</a>) and to the best of our knowledge these Polkadot DVs aren't getting paid to do the kind of quality analyses they do, including commenting on this forum. &nbsp; There are a LOT of proposals, and doing this work is not easy. &nbsp; They act as general purpose "DOT experts", which we believe is tip worthy.
This tip is for Decentralized Voices OpenGov voters who have put in a LOT of time and energy this month, and sheer courage. &nbsp;
You can disagree with them, glorify or vilify them. &nbsp;About the only thing you can't do is ignore them. &nbsp; Because they change things. &nbsp;They push Polkadot forwards. &nbsp;While some may see them as the crazy ones, we see people who should be recognized for their courage and for trying to make a difference. &nbsp; Because the people who are crazy enough to think they can change Polkadot, are the ones who do.
<h2 id="thankyoudecentralizedvoices">Thank you Decentralized Voices!</h2>
PS This is not an April fools joke. &nbsp;But if any DV doesn't think they deserve a tip, kindly send it to another DV who does, or send it back to the Treasury.&nbsp;

Tip for 7 Polkadot Decentralized Voices

REJECT

<h1>Where:</h1>
Valia Hotel Bangkok Address 95, 370, 22 Sukhumvit 24, Khwaeng Klongton, Khet Klongtoey, Bangkok 10110, Thailand&nbsp;
<h1 id="update">When:&nbsp;</h1>
From Nov 11-16 (from sub0 JAM Day through Devcon 7 and the day after):
<ul>
<li>11 November - (Monday, after <a href="https://sub0.gg/" target="_blank" rel="noopener">sub0</a>, pre-Devcon 7) &mdash; Valia Room &mdash; 7-8:30pm Dinner @ 7-8:30 [meet and greet] </li>
<li>12 November (Tuesday, during Devcon 7, heavy day) &mdash; Valia Room &mdash; 10:30am Coffee Break &mdash; 12:30-2pm Lunch &mdash; 3:30pm Coffee Break&nbsp; &mdash; 6:30-8:30 Dinner </li>
<li>13 November (Wednesday, during Devcon 7, light day) &mdash; Meeting Room 1&nbsp; &mdash; 10:30am Coffee Break &mdash; 3:30pm Coffee Break </li>
<li>14 November (Thursday, during Devcon 7, light day) &mdash; Meeting Room 2 &mdash; 10:30am Coffee Break &mdash; 3:30pm Coffee Break </li>
<li>15 November (Friday, during Decon 7, heavy day) &mdash; Valia Room &mdash; 10:30am Coffee Break &mdash; 12:30-2pm Lunch &mdash; 3:30pm Coffee Break &mdash; 6:30-8:30 Dinner </li>
<li>16 November (Saturday, post-Devcon 7, light day) &mdash; Valia Room&nbsp; &mdash; 10:30am Coffee Break &mdash; 12:30-2pm Lunch &mdash; 3:30pm Coffee Break</li>
</ul>
The Valia Hotel venue will be available for JAM Implementation teams to work and network together on 9am - 9pm for all days. Colorful Notion is the primary sponsor, Gossamer is sponsoring Dinner on Friday!
<h2 id="jamimplementers">JAM Implementers</h2>
<img src="https://i.ibb.co/PCCmkxg/image.png" alt="image.png" />
There are over TWENTY teams implementing JAM:
<a href="https://jamcha.in/clients">https://jamcha.in/clients</a>
Some teams are starting to pass the first few tests with available <a href="https://github.com/w3f/jamtestvectors/">test vectors, </a>are asking detailed questions about the <a href="https://graypaper.com">JAM Gray Paper</a> in the <a href="https://matrix.to/#/#graypaper:polkadot.io">GP Chat Room</a> and <a href="https://matrix.to/#/#jam:polkadot.io">JAM Chat Room</a>.
<h3 id="venue">Venue</h3>
<a href="https://www.valiahotelbangkok.com/meetings-venues/">Valia Hotel Bangkok</a>
<img src="https://i.ibb.co/ZN1rMzH/4113-sourabhniyogi-1722514781427.png" alt="image" />
95, 370, 22 Sukhumvit 24, Khwaeng Klongton, Khet Klongtoey, Bangkok 10110, Thailand (<a href="https://maps.app.goo.gl/rGsGhLvRpQUvYGBNA">map</a>)
<img src="https://i.ibb.co/hHqGp6n/4113-sourabhniyogi-1722514065247.png" alt="image" />
<ul>
<li>Walk: 20 minute walk to Devcon 7</li>
<li>Taxi: 9min taxi</li>
<li>Shuttle: Complimentary shuttle between Valia Hotel and QSNCC during Devcon 7. Departing from the hotel 08:00hrs, 09:00hrs, and 10:00hrs. and Pick-up from QSNCC 15:00hrs., 16:00hrs., 17:00hrs., and 18:00hrs.</li>
</ul>
If you are a JAM Implementation team, and would like to attend the JAM0 Implementers events, contact <a href="mailto:sourabh@colorfulnotion.com">sourabh@colorfulnotion.com</a> (sourabhniyogi on TG+Matrix)

JAM0 @ Bangkok - November 11-16, 2024 (after sub0)

<img src="https://i.ibb.co/fYQZ6PN/4113-sourabhniyogi-1720836384071.png" width=200/>

[Asset Hub](https://forum.polkadot.network/t/assethub-vision/6934) is a Polkadot system chain slated to hold major assets (including DOT, USDT and USDC) in Polkadot’s [Minimal Relay Chain architecture](https://github.com/polkadot-fellows/RFCs/blob/main/text/0032-minimal-relay.md), as well the potential developer friendly locus for [contract-pallets](https://polkadot.polkassembly.io/referenda/885) and consumer-friendly ["Plaza"](https://www.rob.tech/blog/plaza/). 

This proposal concerns [dotswap.org](https://dotswap.org), an Asset Hub DEX UI, developed by [MVP Workshop](https://mvpworkshop.co/) with support from [Colorful Notion](https://x.com/colorfulnotion):

* [Dotswap.org V1 Alpha](https://dotswap.org/) 
* [Dotswap.org V2 Video Overview (with voiceover)](https://drive.google.com/file/d/1gTOqJ60jmij-v5BibbYBzp0d1DmhlvYg/view) 

MVP Workshop and Colorful Notion are 2 long-term Polkadot ecosystem teams who have worked together successfully this Spring and seek to work together for the rest of 2024. This proposal concerns retroactive funding for dotswap v1 for Q1/Q2 2024, and support for v2 development and hosting dotswap.org for Q3/Q4 2024.

[dotswap.org](https://dotswap.org) aims to be a full-fledged interface for users to manage Asset Hub-related assets, with key functionality of swapping assets using a new assetConversion pallet on Asset Hub, as well as basic gateway between Asset Hub and the Relay Chain (v1) and major parachains (v2) and Ethereum (via [Snowbridge](https://polkadot.subsquare.io/referenda/944)). Following the [Asset Hub Vision](https://forum.polkadot.network/t/assethub-vision/6934) and the new [Polkadot app](https://x.com/Polkadot/status/1811342289735655651), we envision dotswap.org to be accessible for _everyone_, from beginners to lightweight traders rather than just advanced traders and Polkadot experts.

## Details

Using the working v1 implementation and v2 mockups, in June a usability testing session was conducted with 15+ members active in the Polkadot OpenGov community. Results are compiled here:

* [Report](https://docs.google.com/document/d/1r3QPm9ET5hoQ49rBcg-M2LBaQWQmfZeq4MaQAnHiKgs/edit)
* [Raw data](https://docs.google.com/document/d/1rpfl0Q0LFePfpbGwANewZ6ncbqD6h-RVMjVBL3srcxA/edit )

Based on the above user feedback, we have compiled the following roadmap and budget:
* [Roadmap](https://docs.google.com/spreadsheets/d/10Zclvxk_in2-PDiIGxgLGht3jG9BKVWDgxBYm_2DrpM/edit)
* [2024 Budget](https://docs.google.com/spreadsheets/d/14LQQAPdQLtPo94bhAYe28FewQEGucBudPIalrrMetlI/edit)


## Dotswap v1 Feature Summary

The Dotswap.org v1 feature enables a basic asset swap dashboard centered around Asset Hub.

#### Dashboard

Enables users to see all their assets on Asset Hub and the Relay Chain.

![image](https://i.ibb.co/tKcr2k2/4113-sourabhniyogi-1720833608192.png)

#### Swap

Enables users to swap assets on assethub with the new “AssetConversion” pallet, and also add and remove liquidity to Uniswap v2 style liquidity pools
 
![image](https://i.ibb.co/gZ5dDs0/4113-sourabhniyogi-1720833698159.png)

#### Cross-Chain Transfers

Enables users to move assets between Asset Hub and the Relay Chain

![image](https://i.ibb.co/SVwwMSh/4113-sourabhniyogi-1720833793665.png)

## Dotswap v2 Feature Summary

The basic functionality is expanded upon in Dotswap v2, summarized below, with much of the functionality below demonstrated in the [Dotswap.org V2 Video Overview (with voiceover)](https://drive.google.com/file/d/1gTOqJ60jmij-v5BibbYBzp0d1DmhlvYg/view) 

#### Feature: Foreign Asset Support (WETH/WBTC/…, MYTHOS/…)

Through Snowbridges and standard parachain channels, Asset Hub will have assets from:
* Ethereum eg WETH + WBTC + PEPE + SHIB (possible now, tested [here](https://x.com/colorfulnotion/status/1808927242803892637))
* Any parachain e.g. MYTHOS (possible soon, testing in progress as of July 2024) 

The dashboard will simply show foreign assets and enable all the same operations:

![image](https://i.ibb.co/8KHqzD2/4113-sourabhniyogi-1720837784243.png)

#### Feature: DOT/X + X/USD Graph presentation

Recent swap activity for any assets (measured against DOT or USD) will be accessible from the Swap page and Dashboard page. A third-party API call be used to fetch the graph data, cached from BigQuery / Dune on a regular basis:

![image](https://i.ibb.co/wdtZ6Q4/4113-sourabhniyogi-1720837101513.png)

#### Feature: Pool Volume + APY presentation

While liquidity pool providers are a tiny portion of any DEXes user base, they are critical to its healthy functioning. In v2 we add standard functionality to show a liquidity pool provider their Asset Hub pool contributions, their USD value, the recent APR (based on 7d or 30d average activity), TVL, as well as easy access to add and remove liquidity to any pool.

![image](https://i.ibb.co/RNXhyBg/4113-sourabhniyogi-1720837177684.png)

#### Feature: Info Bubbles / Tutorial Bubbles

To give newbie/non-expert Polkadot users a walkthrough of Dotswap.org functionality, each major section will have a small tour. This is intended to provide users with comfort with Polkadot’s multi chain peculiarities:

![image](https://i.ibb.co/pW8Ng7r/4113-sourabhniyogi-1720837420625.png)

#### Feature: Local Transfer features

To make it easy to send assets between addresses within Asset Hub, the basic transfer functionality of polkadot.js is encapsulated so that “everything can be done in one place”.

![image](https://i.ibb.co/drTjgV2/4113-sourabhniyogi-1720837381207.png)

#### Feature: Cross-chain to/from HydraDX + Moonbeam + Mythos

In v2, dotswap will be extended to support cross chain transfers to and from top defi parachains (Hydration [Substrate] and Moonbeam [EVM] + Mythos). Initial viability testing has been conducted already for top assets for Hydration and Moonbeam and will be extended to support Mythos for the [upcoming airdrop](https://dune.com/substrate/mythos).

![image](https://i.ibb.co/gy9Sxbs/4113-sourabhniyogi-1720837632031.png)

#### Feature: Asset Admin and Create Pool

Historically, creators/minters of assets on Asset Hub have had to use polkadot.js to create new assets and set up new pools. In v2, dotswap.org will be extended to support all major methods:
* assets.create - a user can create a new assetID
* assets.setMetadata - a user can set the name, symbol and decimals of an assetID
* assets.setTeam - a user can set the issuer, freezer, admin an assetID
* assets.mint - if an issuer, the user can mint some amount of an assetID to any beneficiary
* assets.burn - if an admin, the user can burn some amount of an assetID
* assetConversion.createPool - the user can create a pool for assets where there is no existing pool, and the user has at least some of that asset

For each of the above operations, a dedicated modal will be provided for seamless interaction. While this advanced feature is not for everyone, it is a significant feature of Asset Hub to be able to create new assets, pools and have them be fee-paying.

## Requested Funding / Budget 

We request 77,903 DOT (est $468.2K based on EMA7 $6.01) for Dotswap v1.x + v2.x through OpenGov with utility.batch in 3 payments: (see [preimage](https://polkadot.js.org/apps/?rpc=wss%3A%2F%2Fpolkadot-public-rpc.blockops.network%2Fws#/extrinsics/decode/0x1a000c130503000100a10f0001000b0035061495f203000101002c8feeab5bd9a317375e01adb6cb959f1fea78c751936d556fa2e36ede425a4700130503000100a10f0001000b00bfc98d30e503000101002c8feeab5bd9a317375e01adb6cb959f1fea78c751936d556fa2e36ede425a47019a7d5b01130503000100a10f0001000b0079ab90c1ec03000101002c8feeab5bd9a317375e01adb6cb959f1fea78c751936d556fa2e36ede425a47019cb46f01))

* 26,672.21 DOT for dotswap.org for v1/v1.1 (delivered June/July 2024), upon enactment
* 25,199.67 DOT for dotswap.org v1.2/v2 (delivered Sept 2024), at block [22,773,146](https://polkadot.subscan.io/block/22773146) around Oct 1, 2024
* 26,032.61 DOT for dotswap.org v2.1/v2.2 (delivered Nov/Dec 2024), at block [24,097,948](https://polkadot.subscan.io/block/24097948) around Jan 1, 2025

[Budget breakdown](https://docs.google.com/spreadsheets/d/14LQQAPdQLtPo94bhAYe28FewQEGucBudPIalrrMetlI/edit?gid=0#gid=0)


## Full proposal

[Detailed Proposal Writeup](https://docs.google.com/document/d/1rNJSJY6qzaSbRBY3l8Md615IAZC6sy4z6NBYUVEcqfE/edit).


## Key Benefits of Dotswap.org

With OpenGov support of this development plan, Dotswap.org will:

* Provide a place for everyone (non-advanced traders) to swap/transfer/create their assets across the ecosystem, starting with Asset Hub and the Relay Chain but to Ethereum (via Snowbridge) and major parachains and then others
* Begin to set up a user-friendly destination for lightweight trading for major assets (DOT/USDT/USDC), parachain assets (e.g. MYTH), and user-generated assets 

![image](https://i.ibb.co/CssXQ0x/4113-sourabhniyogi-1720836886289.png)

Dotswap.org: Asset Hub DEX UI v1+v2 2024 Development+Hosting by MVP Workshop+Colorful Notion

Colorful Notion proposes to run $720K in On-Brand Twitter ads to Increase awareness of On-brand Polkadot messages from the Twitter accounts of Polkadot, Polkadot Parachains + Projects ecosystem-wide.

This is a follow-on to [OpenGov Ref #324](https://polkadot.polkassembly.io/referenda/324) and increases spend from $50K/mo (see <a href="https://dune.com/substrate/324-opengov">Polkadot OpenGov Ref #324 Transparency Report (March 31, 2024)</a>) to $90K/mo, promoting messages Polkadot-ecosystem wide in a larger range of countries. The ongoing #324 campaign has been boosting tweets from the following accounts:

<img src="https://cdn.polkaholic.io/577/577-tweets-q1.png" width="80%"/>

This 577 Campaign is proposed to continue to be run as follows:

- **Ad Spend**: $720,000 [85% of Requested Amount]
- **Strategy**: Optimizing for High Reach and High Engagement (eCPE)
- **Time Period**: May 1, 2024 - December 31, 2024 ( 8 months )
- **General Campaign Target**: English-Speaking, High GDP Countries 
(US, GB, AU, NZ, CA, IE, JP, KR, DE, FR, IT, ES, NL, BE, NO, FI, DK, CH, AT, LU, SE, PT, AE, SG)
- **Specific Campaign Targeting**: Based on campaign message, with advisements from DF-funded Distractive + the OpenGov community, using "Follower Lookalike Targeting" from both Campaign Management Systems 
- **Campaign Management Systems**: Twitter Ads Direct (66%) for High Reach campaigns and Addressable.io (33%) for Highly Targeted (KPI-optimized, usually for lower eCPE) campaigns (discretionary allocation based on Campaign needs) 

At this level of spend, throughout the 8-month campaign run, we anticipate:

- **1 BILLION** Twitter impressions (at average of $0.792 CPM) 
- Reach: 10MM+ crypto twitter users in the General Campaign Target
- Frequency: 100 impressions/user on average 

As of March 31, 85% of the $144K allocated from #324 has been spent ($120.7K of $144K) with the remaining 15% expected to be exhausted by the end of April. 

Key Benefits to DOT Tokenholders:
* Robustly increase awareness of On-brand Polkadot Messages for mass crypto retail users (to both Polkadot AND parachains/projects) and builders (on both 1.0 parachains + 2.0 new technology [JAM, CoreTime, and so on])
* Demonstrate Decentralized Marketing at scale, funded by OpenGov

<a href="https://dune.com/substrate/324-opengov">Polkadot OpenGov Ref #324 Transparency Report (March 31, 2024)</a>

# Do you want to see the Polkadot ecosystem marketed via Twitter Ads? 

If you do, please comment on [OpenGov Ref #577](https://polkadot.polkassembly.io/referenda/577) indicating your support .. and vote! 5 Decentralized Voices in #577 with 30MM+ NAYs [and a DOT Activist not voting] ensure that this will not be renewed. 

## Objections raised by DVs and the broader community .. and our proposal adjustments!

### Overall spend of $200K/month is too much!

We adjusted the proposal. Instead of increasing $50K/mo spend to $200K/mo, we increased to $90K/mo spend. Its an 80% increase. 

### That is still too much money!

No, $90K/mo is not. Polkadot is a $10B market cap company. Crypto Twitter has not yet taken over by Farcaster, Subsocial, Mastodon in sufficient numbers. The reach of 10MM+ Twitter users is there. Most of those people can be targeted with Addressable and Twitter direct at scale. 

### How dare you promote DED!

It was _definitely_ reasonable at the time to promote a 100% community generated token in Dec/Jan: ***Because I am not an omniscient God**, I could not predict what would happen in March back in Dec/Jan. However, it is no longer reasonable as of mid-March. 

As to memecoins, I hate them too. Unfortunately, they are a part of what happens in Web3. BTC, DOGE, SHIB are all memecoin. They attract users. We have to relax and bring real people into the ecosystem to have fun. Polkadot is capable of everything.

### Do not promote giotto tweets. He is a _______

Done! Promoting giotto content was useful in December in January but there is no need anymore as he is a DED activist rather than a DOT activist. Lets keep our blood pressure low and stay healthy and breathe the fresh air! 

### Lack of transparency

This report should cover it! All the raw data is in a table. You can query it. If you have an idea on how to weight the future marketing, please share! 

### This is all very random! You should have a meticulous plan in Month 1 of what should happen in Month 4.

False! Invention happens in the Polkadot ecosystem at extremely high rates. Ecosystem wide marketing of Polkadot cannot be a single campaign promoting _one thing_. You cannot know in December what will happen in April. One day its CoreJam, another day its JAM. That's part of the reason why we love Polkadot.

That said, you can have very focussed campaigns promoting ONE thing each month, e.g Polkadot+AI in April, Polkadot+Gaming in May, Polkadot+SocialNetworking in June, etc. But then the AI people not getting any voice in the other 11 months makes little sense. There is nothing wrong with a focussed based approach being combined

### You are not a marketing professional!

False. I've done advertising startups my whole career. I've done $150MM of TAC in my life, $144K is nothing. I bought from Twitter's Mopub had Twitter as a advertiser in previous startups I've founded. But in this context, I understand what Twitter+Addressable is doing very well, and because the colorful notion team is doing ecosystem wide Dune integration, we follow most activity in the ecosystem closer than non-Polkadot people could.

### Lack of closed-loop optimization 

It is true that almost of the activity is for pure awareness, and is optimized for eCPE. But Web3 people do not like being tracked! 

### Everything should be in bounties. Or a collective.

No. While I agree that having more people look at something and advise on how to improve something is definitely useful, adding a bunch of curators or having N other people in a collective would not help. If I screwed up in executing in 324, someone can say what I did wrong. At the end of the day, 1 person has to push a button and N people can complain about it after the fact but NOT marketing at all makes little sense. 

### Distractive should do it instead.

Probably! Distractive is extremely capable and has wonderful positive people. I have met with them and should this pass or fail, we are super happy to work with them collaboratively. This data has been provided to Distractive's Katie Butler and the entire universe. 

### How dare you use your own account to run ads and promote yourself! 

This is not a serious objection. Whereas the TheKus #298 ran ads that was "Follow the Kus!" and showcased The Kus in dozens of video content (which I love and see nothing wrong with), I did not. Our ads were like these:

* [Polkadot2.0-JAM](https://twitter.com/colorfulnotion/status/1767980037821849678)
* [Defi](https://twitter.com/colorfulnotion/status/1761798738639732754)
* [Founder](https://twitter.com/colorfulnotion/status/1761466562543014385)
* [Indy500](https://twitter.com/colorfulnotion/status/1761455313751097351)
* [Founder](https://twitter.com/colorfulnotion/status/1739124055423537232)

In addition, we see no problem promoting @colorfulnotion's Dune dashboards. After all, Colorful Notion has been active in Polkadot analytics for the last 2 years and will continue to be a Polkadot ecosystem agent for the next 2 years with #366. If you think these are ads are somehow problematic, that's just too bad.

### Thank you Addressable!

Tomer, Lev and Andres at Addressable were extremely valuable to make this campaign work and have a great platform. They have special skills with Twitter Ad Ops that very few Web3 teams will be able to replicate. Everyone in Web3 marketing should do campaigns with Addressable. Great platform, awesome people.

### Thank you OpenGov + DOT Token holders!

Polkadot OpenGov is completely decentralized. Lead proposer Sourabh Niyogi would like to thank Polkadot OpenGov for the opportunity to get back and do some good old advertising work and get to know some fabulous Polkadot people better. 

## Requested Amount

97,747.61 DOT 

<a href="https://docs.google.com/document/d/16nigURcG9ZWO-u3jN8VVnCcY0xc8pH_eEGaWe0ob6oI/edit">Detailed Proposal</a>

### TRANSPARENCY REPORT ON DUNE

<a href="https://dune.com/substrate/324-opengov">Polkadot OpenGov Ref #324 Transparency Report (March 31, 2024)</a>

<a href="https://dune.com/substrate/324-opengov"><img src="https://i.ibb.co/3R0Lh5C/4113-sourabhniyogi-1712162841009.png" width=800/></a>

Increase Awareness of Polkadot On-Brand Messages via Twitter Ads (5/1/24-12/31/24)

This is a placeholder concerning [DOT Experts Tip for OnlyDeFiGuy for Proposal #684 Chainalysis analytics solutions](https://polkadot.subsquare.io/referenda/781).  SmallTipper is wrong for a 150+300+599 DOT treasury spend as it is the sum of all treasury spends that decides the track.  

Ignore - superceded by 781

This tip is for [OnlyDefiGuy's Analysis on Proposal #432: Bifrost vDOT liquidity loan](<../post/2094>) which follows this [template:](<https://twitter.com/giottodf/status/1746401243403043295?s=46&t=qKV5hT_Ds4kNwzNTZpvU4w>)

- Abstract: what it's about, this is important so that people can decide if they should keep reading or not most likely if it's outside of their circle of competence they will move on to the next proposal at this stage

- Prior art: how things are currently being done without this proposal being in existence

- Projected prior art: how the future would look like without this change / innovation / addition / proposal

- Context: how this is relevant in the bigger context, related to what is already there, what is currently being planned by other parties, what is currently being done, etc

- Why: why is it needed? What is the business case?

- Trade-offs: what are the trade-offs compared to alternative solutions that may already exist or may not yet exist but are different? Including theoretical only




Tips for [DOT Experts](<https://t.me/dotxpert>) are intended to reward experts who provide detailed analyses for OpenGov voters to make political decisions. DOT Experts should never express political preferences, and instead characterize decisions in terms of tradeoffs.

Background:

- [OnlyDefiGuy](<https://twitter.com/onlydefiguy>) is a large trading entity of Bifrost

- [Proposal #432: Bifrost vDOT liquidity loan](<432>) is a liquidity injection for Bifrost




## Request for DOT Experts!

Ready to help OpenGov voters make informed political decisions?

Join the [DOT Experts Telegram Group](<https://t.me/dotxpert>)