---
title: "MarketCheck Analytics"
url: https://hurricane.works/ai/projects/mc-stats/
description: "Comprehensive analytics platform with AI-powered SEO recommendations and CRM integration"
status: "Production"
categories: ["Analytics & Data", "AI Integration"]
---

# MarketCheck Analytics

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

**Status:** Production

## 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.

## 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 15
- TypeScript
- Tailwind CSS
- shadcn/ui
- Recharts

### Backend
- Supabase (PostgreSQL)
- Supabase Auth (Google OAuth)
- Netlify Functions

### AI
- Anthropic Claude (SEO recommendations)
- ICP-aware prompts

### Integrations
- Google Search Console API
- CRM integration
- Automated WordPress management

### Infrastructure
- Netlify
- Encrypted credential storage
- Scheduled 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)