Platform

Meridian

An SEO intelligence platform that replaces sprawling spreadsheets with unified, URL-level analytics — pulling data from Google Search Console, GA4, Ahrefs, and AI search engines into a single actionable view.

Role

Creator & Developer

Timeline

2025 – Present

Team

Solo project

The challenge

Managing SEO at scale means juggling data across Google Search Console, GA4, Ahrefs, and multiple AI search engines. The typical workflow involves exporting CSVs into a 3,000-row spreadsheet, manually cross-referencing URLs, and hoping nothing gets missed. It's slow, error-prone, and impossible to keep current.

The approach

Meridian aggregates all SEO data sources into a single PostgreSQL database with a unified URL-level schema. A React frontend provides instant filtering, sorting, and visualization. API integrations pull fresh data automatically, eliminating manual exports and giving the team a single source of truth that's always current.

Process

4 phases from audit to launch.

01 Data Architecture Designed a unified URL-level schema that normalizes data from GSC, GA4, Ahrefs, and AI search engines into a single queryable structure.

02 API Integrations Built automated data pipelines for Google Search Console, GA4, and Ahrefs APIs with scheduled syncs and incremental updates.

03 Frontend Dashboard React-based interface with advanced filtering, sorting, column customization, and data visualization for URL-level analytics.

04 AI Search Tracking Added monitoring for AI search engine citations and visibility, tracking how content appears in AI-generated responses.

Meridian is a purpose-built SEO intelligence platform.

Outcomes

3,000+

URLs tracked

Data sources unified

Real-time

Data freshness

Single source of truth

Tools & Disciplines

React Node.js PostgreSQL REST APIs Claude Code