Analyze any Web3 protocol or product using SQL (in 5 minutes)

The video provides a guide on how to start analyzing any Web3 protocol from scratch using a custom dashboard on Dune. Key points include:

  1. Getting Started: The video is aimed at users who may not have any background in Solidity or knowledge of specific protocols. It suggests starting with a basic guide on Dune's tables and SQL concepts if you're a complete beginner.
  2. Using the Dashboard: The dashboard helps users analyze protocols by inputting a contract address and selecting a blockchain. It provides contract metadata, API descriptions, and insights into how functions and events are related.
  3. Understanding Contracts: The video walks through how to identify the main contract of a protocol (e.g., Seaport by OpenSea) by checking which contract has the most transactions. It then explains how to analyze the ABI (Application Binary Interface) to understand the functions and events of the contract.
  4. Analyzing Usage: The video demonstrates how to analyze contract usage trends over time, including function calls and event emissions. It highlights the importance of understanding user behavior and retention by examining new vs. returning users.
  5. Studying Protocol Integrations: For more advanced users, the video covers how to analyze contract composability, or how different contracts interact with each other. It uses examples like how aggregators (e.g., Blur, Gem) interact with Seaport.
  6. Exploring Contract Dependencies: The video shows how to identify and analyze lower-level contracts that handle specific functions, such as token transfers, by using the example of Seaport's interaction with the Conduit contract.
  7. Conclusion: The dashboard is presented as a powerful tool for understanding Web3 protocols without needing extensive technical knowledge. Users are encouraged to provide feedback or suggestions for improvement.

Overall, the video aims to empower users to analyze Web3 protocols effectively, using a dashboard that simplifies complex blockchain data and interactions.

Transcript