​

​

I built an automated SEO dashboard to turn Google Search Console data into clear, actionable SEO opportunities.

​

The project uses Google Search Console, its API, Google Apps Script, Google Sheets and Looker Studio. Rather than manually exporting Search Console data and working through large spreadsheets, the system automatically retrieves the data, processes it and identifies areas that may be worth investigating.

​

The dashboard focuses on metrics including clicks, impressions, CTR and average position, while combining query and page-level data to provide a more useful view of SEO performance.

​

I also created rules to identify different opportunity types, including CTR opportunities, striking-distance keywords and lower-visibility terms, and added prioritization and historical comparisons to make it easier to decide what to work on and track changes over time.

​

The final result is a repeatable workflow that moves from:

​

Search Console data → Automated processing → SEO opportunities → Prioritized work queue → Visual reporting

​

The project gave me hands-on experience with SEO analysis, Search Console data, APIs, Apps Script, data processing and dashboard development, while focusing on the part of SEO I enjoy most: using data to find problems and opportunities, then deciding what to do next.

​