Publisher Scout – Projektdokumentation

APIs & Schnittstellen

🗄️ MySQL API (IONOS)

https://entdecken.info/api.php

API Key:ou-sql-2025-xK9mPqR7vL3n

DB:dbs15317957 @ IONOS MySQL 8.0

Aktionen:query (GET), execute (POST), create_table

Tabellen:publisher_prospects, spyfu_ad_history

📁 File Gateway

https://entdecken.info/gateway.php

Key:ou-gw-2025-xR7mPqK9vL3nJ

Aktionen:list, read, write, delete, health

Auth:X-Gateway-Key Header oder ?key= Param

Security:Path-Traversal-Schutz, Self-Protect

🔍 Serper.dev (Google Search)

https://google.serper.dev/search

API Key:a54353d410155c050e99b4491f0c28619493e498

Header:X-API-KEY

Credits:2.500 free, dann $1/1K

Features:Google SERP, lokale Märkte (gl/hl)

🕵️ SpyFu API

https://www.spyfu.com/apis/

Auth:Basic MjliYzdlOGMt...QlhKWVpW

ID:29bc7e8c-8b0c-4af0-8f88-894e97ccaa45

Endpoints:getBulkDomainStats, getTopCompetitors, getSeoKeywords

Kosten:$0.20-$5.00 CPM je Endpoint

🤖 Claude API (via Proxy)

https://entdecken.info/claude-proxy.php

Zweck:CORS-Bypass für AI Scout Agent

Model:claude-sonnet-4-20250514

Tool:web_search (via Claude API)

🗃️ MongoDB API

https://mongodb-api-orpin.vercel.app

API Key:ou-api-2024-xK9mPqR7vL3nJ

DB:Online_United @ MongoDB Atlas

Collections:SaleDetail(489K), trafficDetail(1.4M), Publisher(7.3K)...

Endpoints:/api/query, /api/aggregate, /api/schema...

🔐 Portal Auth

https://entdecken.info/auth.php

User DB:team.online-united.eu (dbs15288273)

Auth:JWT Token (24h), Session Storage

Schutz:auth-gate.js auf allen Seiten

Dateien auf entdecken.info

Lade...

Datenbank-Schema: publisher_prospects

Spalte	Typ	Beschreibung
id	INT PK	Auto-Increment
domain	VARCHAR	Publisher-Domain (unique)
website_name	VARCHAR	Name der Website
market	VARCHAR	Zielmarkt: DE, FR, UK, US, IT, ES, NL, PL, PT, INT, CA
publisher_type	VARCHAR	Blog, Vergleichsseite, OTA, Reiseportal...
cities_covered	TEXT	Rome, Barcelona, London, Paris, Munich, Hamburg...
mentions_turbopass	TINYINT	1 = erwähnt Turbopass, 0 = nicht
affiliate_ready	TINYINT	Hat bereits Affiliate-Links
est_monthly_traffic	INT	Geschätzter organischer Traffic/Monat (SpyFu)
ppc_spend_monthly	DECIMAL	PPC-Budget/Monat in USD (SpyFu)
ppc_keywords_count	INT	Anzahl PPC Keywords (SpyFu)
organic_keywords_count	INT	Anzahl organische Rankings (SpyFu)
domain_strength	INT	SpyFu Domain Strength (0-100)
priority	VARCHAR	A (hoch), B (mittel), C (niedrig)
contact_email	VARCHAR	Kontakt-E-Mail (Contact Scraper)
contact_name	VARCHAR	Ansprechpartner
notes	TEXT	Notizen, Titel, Kontext
outreach_status	VARCHAR	Pipeline: new → contacted → responded → active
data_source	VARCHAR	spyfu_ppc, spyfu_seo, google_serp, ai_agent, serper_google
created_at	TIMESTAMP	Erstellungsdatum
updated_at	TIMESTAMP	Letzte Änderung

Roadmap

MySQL DB & API

publisher_prospects Tabelle, REST API auf entdecken.info

SpyFu Integration

PPC/SEO Domains, Bulk Domain Stats Enrichment, Competitors

AI Scout Agent

Claude-powered Keyword-Scanner mit web_search, 22 Tasks

Portal & Auth

Login via team.online-united.eu, JWT, geschützte Seiten

File Gateway

HTTP-basiertes File-Management, direkte Deployments

Serper.dev Google Search

Multi-Sprachen-Scan (DE, IT, ES, NL, PT, PL), 105 neue Domains

SpyFu Enrichment Wave 2

Domain Stats für die 105 neuen Serper-Domains

Contact Scraper

E-Mail & Kontaktdaten von allen Prospect-Domains extrahieren

Outreach Pipeline

Status-Management, E-Mail-Templates, Tracking

Generalisierung

System für alle ONLINE UNITED Kunden adaptierbar machen

Architektur-Übersicht

┌─────────────────────────────────────────────────────────────┐
│                    entdecken.info (IONOS)                     │
│                                                               │
│  ┌──────────┐  ┌──────────┐  ┌────────────┐  ┌───────────┐  │
│  │index.html│  │prospects │  │scout-agent │  │project-   │  │
│  │  Portal  │  │  .html   │  │   .html    │  │docs.html  │  │
│  └────┬─────┘  └────┬─────┘  └─────┬──────┘  └─────┬─────┘  │
│       │auth.php      │              │               │         │
│       │              │              │               │         │
│  ┌────┴──────────────┴──────────────┴───────────────┴──────┐ │
│  │                    api.php (MySQL REST)                   │ │
│  │                    gateway.php (File Ops)                 │ │
│  │                    claude-proxy.php (AI)                  │ │
│  └──────────────────────┬───────────────────────────────────┘ │
└─────────────────────────┼─────────────────────────────────────┘
                          │
          ┌───────────────┼───────────────┐
          ▼               ▼               ▼
   ┌─────────────┐ ┌───────────┐  ┌──────────────┐
   │ IONOS MySQL │ │ Serper.dev│  │  SpyFu API   │
   │ dbs15317957 │ │Google SERP│  │Domain Stats  │
   └─────────────┘ └───────────┘  └──────────────┘
          │
          ▼
   ┌─────────────┐    ┌──────────────────────┐
   │ MongoDB API │    │ team.online-united.eu│
   │Vercel/Atlas │    │    User Auth DB      │
   └─────────────┘    └──────────────────────┘

Vollständige API-Referenz (gesichert)

🗄️ MySQL API (Prospect-Datenbank)
        URL: https://entdecken.info/api.php

        API Key: ou-sql-2025-xK9mPqR7vL3n (via ?apiKey= param)

        DB Name: dbs15317957

        DB Host: IONOS MySQL 8.0

        Actions: query (GET), execute (POST), create_table (POST)

        Tables: publisher_prospects (294 rows), spyfu_ad_history

        GET: /api.php?apiKey=KEY&action=query&sql=SELECT...

        POST: /api.php?apiKey=KEY&action=execute → {"sql":"UPDATE..."}
      
📁 File Gateway
        URL: https://entdecken.info/gateway.php

        Key: ou-gw-2025-xR7mPqK9vL3nJ (via ?key= oder X-Gateway-Key header)

        GET list: ?key=KEY&action=list&dir=.

        GET read: ?key=KEY&action=read&file=path.txt

        POST write: ?key=KEY&action=write → {"path":"f.txt","content":"..."}

        POST delete: ?key=KEY&action=delete → {"path":"f.txt"}

        GET health: ?key=KEY&action=health

        Security: Path-Traversal-Block, Webroot-Only, Self-Protect
      
🔍 Serper.dev (Google Search API)
        URL: https://google.serper.dev/search (POST)

        API Key: a54353d410155c050e99b4491f0c28619493e498

        Header: X-API-KEY: [key]

        Body: {"q":"search query","gl":"de","hl":"de","num":10}

        Credits: 2.500 free, dann /1.000 queries

        Response: {"organic":[{"title":"","link":"","snippet":""},...]}
      
🕵️ SpyFu API
        Base URL: https://www.spyfu.com/apis/

        Client ID: 29bc7e8c-8b0c-4af0-8f88-894e97ccaa45

        Client Secret: C2BXJYZV

        Base64 Auth: MjliYzdlOGMtOGIwYy00YWYwLThmODgtODk0ZTk3Y2NhYTQ1OkMyQlhKWVpW

        Header: Authorization: Basic [base64key]

        Endpoints genutzt:

          /domain_stats_api/v2/getBulkDomainStats?domains=a.com,b.com (/bin/sh.40 CPM)

          /domain_stats_api/v2/getLatestDomainStats?domain=x.com (/bin/sh.50 CPM)

          /competitors_api/v2/seo/getTopCompetitors?domain=x.com (/bin/sh.20 CPM)

          /competitors_api/v2/ppc/getTopCompetitors?domain=x.com (/bin/sh.20 CPM)

        Response fields: strength, monthlyOrganicClicks, monthlyBudget, totalOrganicResults, totalAdsPurchased
      
🗃️ MongoDB API (ONLINE UNITED Hauptdaten)
        URL: https://mongodb-api-orpin.vercel.app

        API Key: ou-api-2024-xK9mPqR7vL3nJ (via ?apiKey= param)

        DB: Online_United @ MongoDB Atlas

        Endpoints: /api/health, /api/collections, /api/schema,

          /api/query (GET), /api/count, /api/distinct, /api/aggregate (POST)

        Collections: SaleDetail(489K), trafficDetail(1.4M), Publisher(7.3K),

          Advertiser(61), Campaign(452), weekTableDetail, monthBrutto/NettoTableDetail

        GitHub: matthias123OU/mongodb-api, Vercel Hobby auto-deploy
      
🤖 Claude Proxy (AI Agent Backend)
        URL: https://entdecken.info/claude-proxy.php (POST)

        Zweck: CORS-Bypass für Claude API Aufrufe aus Browser

        Model: claude-sonnet-4-20250514

        Tool: web_search_20250305 (web_search)
      
🔐 Portal Authentication
        Login URL: https://entdecken.info/auth.php (POST)

        User DB: dbs15288273 @ db5019641116.hosting-data.io

        DB User: dbu1345084

        Source: team.online-united.eu users table

        Auth Type: JWT Token (24h expiry), sessionStorage

        Protection: auth-gate.js eingebunden auf jeder geschützten Seite
      
☁️ Google Cloud
        Organisation: online-united.de

        Projekt 1: Gemini Project (gen-lang-client-0373708587) → Gemini API

        Projekt 2: OU-Publisher-Scout (ou-publisher-scout) → Custom Search (discontinued!)

        Gemini Key: AIzaSyCM8g0Y1WDdXsnEd6q7weQbQmZRkEVqTLY

        CSE Key: AIzaSyD7x0zysZsM9bWrHFlYsy_r-Qqqatomcx0 (⚠️ 403 - Custom Search JSON API für neue Kunden eingestellt)

        CSE cx: 844ffe60165e44368 / e33da83690bde454e

        ⚠️ Google Custom Search JSON API ist seit 2025 für neue Kunden nicht mehr verfügbar.

        Alternative: Serper.dev (aktiv genutzt)

Publisher Scout Docs

🗄️ MySQL API (IONOS)

📁 File Gateway

🔍 Serper.dev (Google Search)

🕵️ SpyFu API

🤖 Claude API (via Proxy)

🗃️ MongoDB API

🔐 Portal Auth

MySQL DB & API

SpyFu Integration

AI Scout Agent

Portal & Auth

File Gateway

Serper.dev Google Search

SpyFu Enrichment Wave 2

Contact Scraper

Outreach Pipeline

Generalisierung

🗄️ MySQL API (Prospect-Datenbank)

📁 File Gateway

🔍 Serper.dev (Google Search API)

🕵️ SpyFu API

🗃️ MongoDB API (ONLINE UNITED Hauptdaten)

🤖 Claude Proxy (AI Agent Backend)

🔐 Portal Authentication

☁️ Google Cloud