Layer3 is a web3 platform that connects users to blockchain opportunities by guiding and verifying on-chain actions. With support for EVM Layer 2s, Solana, Cosmos, and Bitcoin, Layer3 required a reliable and scalable solution to manage the increasing complexity of blockchain data across multiple chains.

Dune Sim streamlined Layer3’s blockchain data with 98% faster queries and seamless multichain scaling.

How Dune Sim helps Layer3: One API, Multichain Incentives

 is a web3 platform designed to simplify onchain interactions for users. Layer3 provides a set of protocols that enable token distribution, identity verification and incentive mechanisms across 50+ blockchain networks, including 

The primary vehicle Layer3 relies on to drive attention and distribution is the 

 platform. Quests in Layer3 are designed as bite-sized, interactive experiences where users perform a series of actions in exchange for rewards. To be able to distribute rewards, Layer3 teams first need a tool that can help them verify user’s transactions onchain. 

To achieve this, the Layer3 team relied on legacy tools like 

, along with dozens of APIs from various sources. This setup posed several challenges for the team: latency, vendor management and unreliable data. To break it down, here are some specific problems their developers faced:

"Solana requests often took 2–30 seconds to respond, causing delays in verifying user actions."

"Many APIs didn’t provide raw transaction data or logs, forcing the team to build workarounds to extract the needed information."

"API downtime was a frequent problem, disrupting campaigns and leading to gaps in data retrieval."

"Managing separate APIs for each chain added complexity and consumed engineering time."

Integrating Dune Sim addressed these pain points and significantly enhanced Layer3’s backend operations. 

The transition was seamless, requiring minimal changes to their existing infrastructure.

"We replaced hundreds of requests with a single request to Sim. It’s fast, reliable, and lets me focus on building."

Integrating Dune Sim provided Layer3 with a unified multichain API for accessing all the blockchain data they need, solving all of their operational challenges mentioned above.

The integration led to significant performance improvements, reducing Solana query times 

from 3–30 seconds to under 500 milliseconds, 

. Sim's API also offered comprehensive data access, including 

raw transaction data, logs, and event details

, eliminating the need for custom workarounds. By consolidating multiple APIs into a 

, Layer3 also simplified its backend operations,

of Dune Sim allowed Layer3 to quickly integrate new blockchains, often 

, so they can stay ahead in a rapidly evolving ecosystem.

“With response times far better than alternatives and support for a wide breadth of chains, 

we were able to both launch and sustain high RPS on Solana and many other EVM chains

By using Dune Sim, developers at Layer3 now have a faster and more reliable process to verify transactions onchain, both by requiring less API keys to manage, as well as faster response time.

Switching providers can be challenging, but for Layer3, integrating Dune Sim was quick and seamless. The team fully evaluated Sim alongside their existing setup with minimal effort, even with just one engineer managing blockchain data. With Sim's developer-friendly design and Dune's dedicated support team, the migration was 

 is a real-time, multichain developer platform that makes blockchain data instantly accessible across 50+ chains. It features lightning-fast response times and is reorg-aware.

Book a call for your customized solution:

OP Labs contributes to the Optimism protocol, an extension to Ethereum that scales both its technology and values. Optimism enables orders of magnitude of improved performance and scalability to Ethereum while doubling down on its commitment to public goods. 

OP Labs’ mission is to scale the world computer through innovation and open source design. As a core contributor to the Optimism protocol, they faced two important challenges: defining a North Star metric to guide the Optimism ecosystem's growth and evaluating their grant program's effectiveness. In both instances, they turned to Dune for solutions.

How Dune helps OP Labs to power ecosystem growth and transparency 

The Foundation team at Optimism Collective first hypothesized that the key to their ecosystem’s growth was not simply the number of wallets or transactions, but rather the expansion of active builders. However, tracking this metric proved challenging. Traditional methods, such as counting distinct contract creators, were fraught with noise and inconsistency. As Michael Silberling, a Data Analyst at OP Labs and a well-known data analyst in web3, put it - “Every raw metric is as bad as it is misleading”. The challenge was to find a rigorous way to measure the desired metric – active developers, i.e. humans deploying apps that people use on Optimism – in a way that was resistant to noise and spam.

quickly conduct iterative exploratory analysis

, providing the tools necessary to filter out the noise and focus on the real, active developers that met their criteria. This was possible from the start, as the data was readily available for analysis on Dune via our 

, expansive data. Dune has 35,000 decoded data tables across 13 different chains and they are growing every hour with an automated decoding process and help from the community. Without Dune, the team would have had to set up their own customized Ethereum ETL pipeline, find a node to connect to, and let things run; a process that would have taken a significant amount of time.

“Without Dune, we need to build another Dune internally.” – Michael Silberling

Dune's robust platform allowed OP Labs to identify and filter out things like self-destruct contracts, repeated deployments of the same contracts, and small contracts deployed around big announcements like airdops. Thus, OP Labs was able to establish a clear, reliable metric for tracking active builders, a critical factor in the growth of the Optimism ecosystem. This metric now informs both daily operations and larger strategic decisions within the organization. With the “

” feature, the data team is able to keep the important data always fresh and up to date. 

Optimism North Star Metric Compared to Other Chains

Distributing Grants More Effectively via Building Measurement Pipeline with Dune’s API 

The second challenge was evaluating the effectiveness of the 

 to incentivize activity and growth within the ecosystem. While the team knew the grant amount and could track when tokens were claimed by a recipient, they lacked visibility into what happened once the tokens left the recipient's address.

First, the data team at OP Labs used Dune to build '

', custom data abstraction layers that allowed them to track and analyze the movement and impact of the granted tokens. Then, they wrote simple 

 into their measurement process. By combining Dune's data with information from DefiLlama and a public Notion page for grant metadata, the team was able to 

This data-driven approach provided a clearer picture of the impact of the grants, including incremental transactions and ETH fees associated with each OP distributed. The insights derived from this analysis are shared publicly with the Optimism community on a monthly basis, fostering transparency and engagement. These updates can be found on the Optimism governance forum.

Dune has enabled OP Labs to track and evaluate the effectiveness of their Optimism grants, providing valuable insights that drive strategic decision-making and community engagement.

Dune has proven to be an invaluable asset for OP Labs, effectively replacing the need for full-time data engineers, which has streamlined operations and optimized resource allocation. More importantly, Dune's platform enabled the data team to generate critical insights that shape the strategy and direction of Optimism, fostering a collaborative environment with other functional teams within the Optimism Collective.

 to propel your organization forward. For a custom solution designed for your unique business needs, 

. Use Dune’s data to inform your strategic decisions and grow your ecosystem.

1inch is a leading DeFi project empowering Web3 users with technological innovations. 1inch provides access to hundreds of liquidity sources across multiple blockchains. Its main components are the 1inch Aggregation Protocol, the 1inch Liquidity Protocol, the 1inch Limit Order Protocol and the 1inch Wallet – a fast and secure mobile application for storing, receiving, sending and swapping crypto assets.

How Dune helps 1inch to Make Data Transparent and Accessible

 is a leading decentralized finance (DeFi) platform that empowers Web3 users by aggregating liquidity from hundreds of sources across multiple blockchains. Their core products, including the 1inch Aggregation Protocol, 1inch Liquidity Protocol, 1inch Limit Order Protocol, and 1inch Wallet, offer users the best rates for token swaps. As 1inch continues to grow, their partnership with

 has been instrumental in achieving data transparency and optimizing on-chain metrics.

When 1inch first started using Dune, their primary focus was to make data transparent and easily accessible for users. They wanted to build a clear system to track on-chain metrics across different blockchains and create user-friendly dashboards for each of their products. By having easy-to-consume insights, both technical and non-technical teams at 1inch could make better decisions, faster.

, co-founder of 1inch, "Dune has allowed us to turn complex data into actionable insights, which makes it possible for all our teams to work more efficiently. Transparency and ease of use were key factors when we chose Dune as a partner."

The collaboration between 1inch and Dune led to some major improvements. One of the biggest wins was being able to streamline their workforce. Instead of relying on a large data engineering team, 1inch could manage all their analytics needs through Dune’s platform.

A major breakthrough came from using Dune Spellbooks, which allowed the team to drastically reduce code complexity. Instead of writing long, complex SQL queries, they could now do the same tasks with just 30-50 lines of code, saving them a lot of time and effort.

Additionally, by integrating the Dune API, 1inch brought real-time analytics into their internal tools. This allowed them to monitor data continuously and make informed decisions on the fly, improving the agility of their operations.

1inch saw improved efficiency across the board, as data became more accessible and teams were able to make decisions faster. The ease of access to real-time data allowed the organization to become more agile and responsive to market changes.

Dune’s charts also had a huge impact on 1inch’s data visualization capabilities. All of their on-chain metrics are now covered comprehensively, and the data is presented in visually appealing dashboards. This helps with both day-to-day operations and long-term strategic planning.

For a closer look at how 1inch is using Dune, check out their dashboards:

1inch is continuing to push the envelope with Dune’s tools. The team is currently working on research related to cross-chain data and chain abstraction, and they’re planning to update their Dune dashboards as they roll out new product features. With Dune as a key partner, 1inch is excited about exploring new ways to leverage on-chain data for even greater transparency and user experience.

As 1inch continues to innovate, Dune will remain an essential part of their data strategy.

Polygon Labs develops open source software for Ethereum scaling architecture for Polygon protocols. The existing Polygon network is home for some of the biggest Web3 projects, such as Aave, Uniswap, and OpenSea, and well-known enterprises, including Robinhood, Stripe, and Adobe. With 1.24M+ smart contracts deployed and 225.74M+ unique addresses, Polygon is one of the most thriving ecosystems in Web3. 

Polygon Labs develops open source software for Ethereum scaling architecture for Polygon protocols. The existing Polygon network is home for some of the biggest Web3 projects, such as Aave, Uniswap, and OpenSea, and well-known enterprises, including Robinhood, Stripe, and Adobe. With 1.24M+ smart contracts deployed and 225.74M+ unique addresses, Polygon is one of the most thriving ecosystems in web3. 

How Dune helps Polygon highlight user engagement and on-chain insights

Amplifying Public Engagement: the Reddit Collectible Avatars dashboard

When Reddit launched its Polygon-based "Collectible Avatar" in July 2022, it made a significant impact. The success of the Reddit Avatars played a crucial role in onboarding more people into the Polygon ecosystem, contributing to growth and brand building. However, the lack of visibility into detailed stats like “Collectible Avatar Holders Distribution” made it challenging to measure the success of the launch and its contribution to the Polygon ecosystem.

The data team from Polygon Labs swiftly addressed this challenge by using Dune. They created an 

 within just hours. Dune's contract decoding functionality helped reduce the knowledge barrier on getting relevant information from a smart contract. Together with the existing queries and 

 made by the community, Dune enabled the team to make this quick turnaround possible.

“My turnaround for these dashboards is 75% faster thanks to  Dune.” – Peter Liem, Data Analyst at Polygon Labs

The Reddit Avatars dashboard not only provided internal teams with fast access to launch data but also offered external communities the same visibility. This transparency fostered community engagement and led to citations from major news outlets and research institutions.

Accelerating Data Insights: Tracking Validator Rewards

Polygon Labs wanted to track the percentage of transaction fees going to validators. However, data required to perform this analysis was not readily available.

Dune provided data on priority fees for EVM chains, which wasn’t readily available anywhere else. The data team developed 

 that Polygon Labs could easily access and integrate into their workflow.

The solution not only served an immediate need but also enhanced financial transparency within the organization. The team can now easily track payouts to validators.

Flexible, downloadable query result for the finance team

Overall, Dune enabled Polygon Labs to achieve a 75% faster turnaround time on data insights, significantly accelerating their decision-making process.

 can accelerate your data insights, enhance financial transparency, and stimulate growth in your ecosystem. 

 for solutions customized to your unique business needs.

CoW Protocol finds the lowest price for your trade across all exchanges and aggregators (including Uniswap and 1inch) and protects you from MEV. The team works at the forefront of DeFi to make markets more efficient and fair – by building the ultimate batch auction settlement layer across EVM compatible blockchains.

COW Protocol finds the lowest price for your trade across all exchanges and aggregators (including Uniswap and 1inch) and protects you from MEV. The team works at the forefront of DeFi to make markets more efficient and fair – by building the ultimate batch auction settlement layer across EVM compatible blockchains.

How Dune helps COW Protocol to understand user behavior with automated payments 

Empowering CoW Protocol’s Data-Driven Growth Strategy

CoW Protocol, a prominent player in the aggregator ecosystem had a general understanding of their market share but desired more-specific user analytics and competitor analysis. They needed a deeper understanding of their users' behavior and how they interacted with their products in order to strategize effectively for growth.

To address this challenge, CoW Protocol turned to Dune. First, they set up a 

, which enabled them to gain deeper insights into active users by segments, user retention, and LTV (life-time-value).

Snippet of CoW’s User Analytics Dashboard

. This dashboard was used for a month-to-month review of CoW Protocol’s status. The entire team would come together monthly to examine the aggregator ecosystem, why a number went a certain way, and what they should do based on the data next month.

Snippet of CoW’s Monthly Report Dashboard

By building their analytics on Dune, the team uncovered several key insights. CoW Protocol discovered that while their user base was small, they had the highest retention rates of their competitive set, with users returning month after month. This learning informed their growth strategy and highlighted the need to focus on attracting new users while maintaining their high retention rates.

The monthly report dashboard also fostered a data-driven culture within the company. By sharing the report with the rest of the company, more teams became aware of their performance. This approach allowed for more informed decision-making and strategy development, contributing to CoW Protocol's growth in the aggregator ecosystem.

Automating CoW’s Solver Rewards System and Alert System

CoW Swap is a decentralized application (dApp) built on top of CoW Protocol. The platform allows users to exchange digital assets directly (peer-to-peer) and via existing decentralized exchanges and aggregators. Unlike traditional DEXs, CoW Swap users sign an intent to trade two tokens at a specified limit price, which is then handed off to third-party solvers. These solvers compete for the user's order by trying to offer the best possible price. The Protocol grants the solver that can offer the best execution price the right to settle the user's order, and rewards them for doing so.

To automate the process of calculating solver rewards, CoW Protocol uses Dune’s powerful data platform. CoW first uploads its internal data to Dune 

. Then, the team uses a combination of internal database and on-chain data from Dune to accurately calculate the rewards. The calculated data is then sent back to CoW to distribute the reward payment. This entire process is conducted on a weekly basis, ensuring regular and timely payments.

Illustration of Solver Rewards System Flow

One of the key aspects of this system is its transparency. The calculated reward data is not only used for distribution but is also made publicly accessible and verifiable. This transparency is crucial as it allows anyone to monitor the performance of each solver and gain insights into the overall operation of the protocol.

In theory, solvers can be malicious and trick the protocol (though they will be slashed for doing so). To combat fraud, CoW Protocol implemented a robust alerts system with Dune queries to monitor malicious behavior solvers. The alerts system is designed to trigger whenever a certain threshold is met. The alerts are sent to the protocol's Slack channel, ensuring immediate attention and action.

CoW Protocol’s integration with Dune has been instrumental in automating its workflows, enhancing its understanding of users and strategic planning, and ensuring transparency. This comprehensive utilization of Dune's robust data platform has empowered CoW to optimize operations and guide data-driven growth in the aggregator ecosystem.

Automating production workflows with reliable data is one of the many ways ambitious DeFi teams depend on Dune for accuracy and transparency. 

 on Dune to discover how our data solutions can solve a variety of use cases for your business. For a customized solution tailored to meet your needs, please 

. Experience the Dune difference and elevate your organization to new heights.

Make onchain data work for you.

The data platform for onchain analysts, AIs and devs.

Join the largest community exploring onchain data

Access onchain data from any environment

Bring the world's best onchain data to your own warehouse

Customer Stories

"If it's not on Dune it's not real"

"Dune has by far the largest and most comprehensive dataset on the market"

"Without using Dune your project is blind"

Build across chains.
Ship without setup.

Hear the latest

Create off-the-chart growth