Community dashboards and analytics for Guild

Featured dashboards and queries
...or search for moreCheck out these dashboards for up-to-date analytics about Guild and other related projects.
Total number of pins collected
...see SQL queryTotal POAP sales via FeeCollector
...see SQL queryAbout Guild
Guild.xyz is the infrastructure for platformless access management. Create portable memberships, social structures around on- & off-chain requirements and build unique user journeys across apps!
We started out as a simple bot for connecting Ethereum with Discord, inspired by our own needs for better token-gating and general access management of internet native groups.
Over time, Guild.xyz evolved to be integrated with multiple platforms like Discord, Telegram, Twitter, Google Workspace, GitHub in addition to 17 chains and several web3 protocols such as POAP, Mirror, Lens and Snapshot. Supporting a diverse set of communities like: Arbitrum, Zerion or Lil Nouns.
From https://help.guild.xyz/en/articles/6934383-introduction-to-guild.
Dune Analytics
Explore and fork thousands of queries and dashboards
Dune Analytics is a powerful tool that allows anyone to easily query, visualise and share smart contract data for free. You can explore thousands of queries and dashboards created by the community.
SELECT SUM(token_a_amount) AS dai_bought
FROM dex.trades
WHERE block_time > now() - interval '24 hours'
AND token_a_symbol = 'DAI';