Skip to main content

Purpose

Returns a pre-payment AI ranking score for the marketing website. Visitors see their β€œAI Visibility Score” before signing up.

Architecture

Internal Services

ServicePurpose
get_or_create_ranking_scoreDatabase lookup/insert for score
generate_competitor_scoresCreates 4 fake competitor scores
generate_platform_statusesAssigns LOW/MEDIUM to 8 platforms

Code Location

src/website/ranking_score/
└── routes.py    # All logic in single file

Database Schema

-- In supabase_ranking database (separate from main)
CREATE TABLE pre_payment_rankings (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  website_url TEXT UNIQUE NOT NULL,
  score INTEGER NOT NULL,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

Rate Limiting

  • 5 requests per minute per IP address
  • Prevents abuse of the public endpoint