I'll generate a win percentage matrix for the top 20 Modern decks over the last 3 weeks. Let me start by getting the meta report to identify the top decks.
Now I'll get the matchup win rates for all combinations of these top 20 decks:
Due to the large number of matchup combinations (20x19 = 380 unique matchups), I'll need to query this efficiently. Let me use a database query to get all matchup data at once:
Let me fix the query - I need to use the proper date comparison:
Let me check the schema more carefully and try a simpler query first:
Good, the data is there. Now let me try the matchup query with a corrected approach:
Let me fix the HAVING clause:
The query returned 0 rows. Let me check if the archetype names are correct in the database:
Good! The archetype names match. Now let me check the matches table structure:
Ah! The result field contains 'WIN', 'LOSS', 'DRAW', not 'W', 'L', 'D'. Let me fix the query:
Perfect! Now let me get the sources and format this into a matrix:
Perfect! Now let me create a comprehensive win percentage matrix. Due to Discord's character limit, I'll format this as a readable table with the top decks:
Here are the win percentages for the top 20 Modern decks. Each cell shows Deck A's win % vs Deck B (excluding draws):
Key Matchups:
Boros Energy (12.5% meta):
• vs Jeskai Blink: 52% | vs Amulet: 53% | vs Prowess: 53% | vs Affinity: 55% | vs Domain Zoo: 58% | vs Simic Ritual: 60%
Jeskai Blink (12.7% meta):
• vs Boros: 48% | vs Simic Ritual: 34% | vs Yawgmoth: 23% | vs Samwise: 27% | vs Dimir Frog: 70% | vs Azorius Control: 58%
Amulet Titan (8.7% meta):
• vs Tron: 82% | vs Prowess: 59% | vs Affinity: 58% | vs Simic Ritual: 25% | vs Neobrand: 25%
Prowess (8.5% meta):
• vs Simic Ritual: 72% | vs Blue Belcher: 69% | vs Domain Zoo: 37% | vs Amulet: 41% | vs Neobrand: 27%
Affinity (7.6% meta):
• vs Tron: 66% | vs Simic Ritual: 65% | vs Dimir Frog: 70% | vs Goryo: 61% | vs Amulet: 42%
Domain Zoo (6.0% meta):
• vs Prowess: 63% | vs Yawgmoth: 73% | vs Boros: 42% | vs Simic Ritual: 38%
Simic Ritual (4.2% meta):
• vs Neobrand: 85% | vs Izzet Cutter: 8% | vs Amulet: 75% | vs Jeskai: 66% | vs Prowess: 28% | vs Affinity: 35%
Notable Polarized Matchups:
• Amulet vs Tron: 82% (Amulet favored)
• Neobrand vs Prowess: 73% (Neobrand favored)
• Neobrand vs Ruby Storm: 82% (Neobrand favored)
• Yawgmoth vs Jeskai Blink: 77% (Yawgmoth favored)
• Simic Ritual vs Izzet Cutter: 92% (Simic favored)
• Ruby Storm vs Ramp Eldrazi: 87% (Ruby favored)
Most Balanced Matchups (~50%):
• Jeskai vs Prowess: 50.0%
• Jeskai vs Tron: 50.0%
• Boros vs Yawgmoth: 50.0%
• Broodscale vs Neobrand: 50.0%
Sources:
Data from 57 tournaments (Nov 17 - Dec 8): 51% MTGO, 49% Melee. Recent events: Modern Challenge 32, Modern Challenge 32, Modern Challenge 64