Build a Live Visitor Dashboard in Metabase

Better Sol generates a fully typed client alongside your Solana program. This workflow uses that client to listen for on-chain transactions — token transfers, program calls, state changes — and writes each event in real time to a Supabase table. Your business team can then query transaction history, loyalty point balances, or NFT ownership directly in SQL without touching the blockchain.

Known Agents captures a detailed record of every AI bot and crawler that visits your site. This workflow runs every Monday morning, pulls the past week's bot traffic summary from Known Agents, and appends a new row to a Google Sheet — total visits by bot, scraper vs. legitimate crawler split, and any newly blocked agents. Your content and SEO teams get a clean weekly report without touching a dashboard.

Pull your Known Agents bot traffic data into Metabase so you can see charts and trends over time in one place. You get a clear picture of which AI crawlers hit your site most, when they come, and how often. This helps you make smarter decisions about blocking or monetizing bot traffic.