codyschneiderx/seo-ai-search-dashboard

This is a dashboard template for tracking how your website performs in both traditional search engines (like Google) and AI-powered search tools (like ChatGPT, Perplexity, and Gemini). It is designed to be handed to an AI coding assistant, which then connects it to your data sources and brings the dashboard to life. The dashboard has three tabs with sixteen panels. The first tab focuses on AI Search Performance, showing how many visitors came from AI engines versus traditional Google searches, broken down by source. The second tab covers SEO metrics from Google Search Console, including keyword rankings and click-through rates. The third tab is about paid advertising, highlighting wasted ad spend. Under the hood, the template relies on a service called Graphed, which connects to Google Analytics 4, Google Search Console, and Google Ads via standard login flows, then stores all that data in a fast query engine. Sixteen pre-written SQL queries in the repo pull the data for each panel. You would use this if you run a website and want a live, integrated view of where your traffic comes from, whether AI search tools are sending you visitors, and how your SEO and ad spending are performing, all in one place. Instead of juggling separate analytics tabs, the dashboard assembles everything automatically. The primary language is HTML, with SQL queries driving the data layer. The full README is longer than what was provided.