Tournament Data Winrate Extraction Methods

I get winrate data by extracting match results from tournament sources (Melee and MTGO). Here's how it works:

Data Collection Process:

Tournament Entries → Each deck registration includes:

• Player, archetype, and decklist
• Overall match record (wins/losses/draws)
• Final tournament rank

Match-Level Data → For many tournaments, I also capture:

• Individual round pairings
• Match results between specific decks
• Whether matches were mirrors (same archetype)

How Winrates Are Calculated:

Archetype Winrate = Wins ÷ (Wins + Losses)

• Draws are excluded from the calculation
• Mirror matches can be optionally excluded (default: yes)

Matchup Winrate = Head-to-head wins for Archetype A vs Archetype B

• Based on actual recorded matches between the two archetypes
• Requires sufficient sample size for statistical relevance

Data Quality:

The database stores:

• tournaments table: Source (Melee/MTGO), date, format
• tournament_entries table: W/L/D records per deck
• matches table: Individual match results with pairings

When I provide statistics, I can show you the exact source breakdown using get_sources(), which tells you what percentage of data came from Melee vs MTGO tournaments.

Important: All winrates are calculated from actual tournament results in the database, not from external APIs or estimates. The data quality depends on what tournament organizers publish (MTGO typically has complete round-by-round data, while some Melee events may only have final standings).

Is there a specific matchup or archetype winrate you'd like me to analyze?