ProductionAnalytics & DataAI Integration

MarketCheck Analytics

Comprehensive analytics platform with AI-powered SEO recommendations and CRM integration

Overview

MarketCheck Analytics is an internal analytics and business intelligence platform that serves as the operational hub for a B2B data company. It combines Google Search Console data, CRM pipeline management (synced from Copper CRM), AI-powered SEO recommendations, and executive reporting into a unified dashboard.

The AI SEO system identifies underperforming pages (high impressions, low CTR) from Google Search Console data, scrapes the live WordPress sites for current metadata, and uses Claude to generate improved titles and meta descriptions with reasoning. Accepted recommendations are automatically applied to the target WordPress sites.

The CRM integration syncs deals to Supabase, providing sales analytics, pipeline forecasting, team leaderboards, and personalised "My Deals" dashboards. A comprehensive security audit covered all API routes, serverless functions, and database migrations.

Data Sources

Daily Automations

Dashboard Views

0 critical

Security Audit

Key Features

AI SEO Recommendations

Claude analyses underperforming pages and generates improved titles/descriptions. Accepted recommendations are automatically applied to WordPress.

Google Search Console Dashboard

KPI cards, traffic trend charts, sortable query tables with position trend arrows, and top pages — with UK/USA/Combined site selector.

Executive Dashboard

Won revenue trends, pipeline health indicators, team leaderboards with medal icons, new deals analysis, and top converting UTM campaigns.

My Deals (Personal Sales)

Per-salesperson dashboard with pipeline stats, action-required alerts (overdue, going cold, stuck in stage), trends, and stage duration benchmarking against team averages.

CRM Pipeline Management

CRM deal sync with close date correction, lost deal reason editor, and forecast charts.

Automated Daily Pipelines

Scheduled serverless functions sync analytics data, generate AI recommendations, and sync CRM data — all fully automated.

Technology Stack

Frontend

Next.js 15TypeScriptTailwind CSSshadcn/uiRecharts

Backend

Supabase (PostgreSQL)Supabase Auth (Google OAuth)Netlify Functions

AI

Anthropic Claude (SEO recommendations)ICP-aware prompts

Integrations

Google Search Console APICRM integrationAutomated WordPress management

Infrastructure

NetlifyEncrypted credential storageScheduled functions (cron)

Architecture

Next.js application with role-based access. Scheduled serverless functions sync data from Google Search Console and CRM into Supabase. AI recommendations pipeline: identify underperforming pages, scrape current metadata, generate Claude suggestions, and auto-apply to WordPress.

•Next.js dashboard (Netlify)

•Supabase PostgreSQL (analytics data, CRM deals, SEO recommendations)

•Google Search Console API

•CRM integration (deal sync)

•Claude API (SEO recommendation generation)

•Automated WordPress management

•Scheduled serverless functions (daily automation)

View More Projects

Explore the full portfolio of web platforms, data pipelines, and AI-powered tools.

Back to Portfolio