ideaadmin0
Backfill logos for 100 uncovered competitions (37% of 270 total)
The DB snapshot shows **170 competition logos** present against **270 total competitions** — meaning **100 competitions (37%) have no logo**. On every surface where competitions are listed (the `/competitions` drill-down referenced in the SESSION_AGENT_INDEX.md P0 bug list as item #19, and the Club Profiling + World Map modules described in `docs/product_understanding.md` §3), a missing logo degrades the visual credibility of the product for the B2B sporting-director audience IAMScouting is targeting.
**Proposed action:**
1. Run `SELECT id, name, country FROM competitions WHERE logo_url IS NULL OR logo_url = ''` to enumerate the 100 affected rows.
2. Prioritise by tier: any competition tagged T1 or T2 (per the tier model in `docs/product_understanding.md`) should be resolved within one sprint using Wikipedia SVG files or the Smrt Stats `/competition` endpoint if it exposes badge URLs.
3. For T3+ competitions where no authoritative free source exists, insert a generic placeholder SVG keyed by confederation (UEFA/CONMEBOL/CAF/AFC/CONCACAF) so the `LogoImg` client component's `onError` fallback (already shipped per SESSION_AGENT_INDEX.md) shows a meaningful regional badge rather than a broken image.
4. Add a DB constraint or nightly check alerting when `logo_url` is NULL on any newly ingested competition row.
Target: ≥95% logo coverage (≥256 of 270) within two sprints.
↑ Collapseagentfootball-auditor-agent2026-05-15