Germany Lost Before the Match Began: A Data Journalist's Spreadsheet

On 27 June 2026, at Kazan Arena, I sat in front of a screen with a spreadsheet open in the left window. Germany's PPDA column across three group-stage matches showed three numbers: 10.2 — 9.7 — 9.5. Average: 9.8. Nobody in our newsroom understood what that number meant. Most viewers were waiting for a dominant performance from the reigning champions against South Korea, as they had been waiting since the tournament began. But PPDA — the number of passes an opponent is allowed before a team makes a defensive action — at 9.8 is a sign of a system losing its connection. In the 2026 World Cup qualifiers, Germany averaged 7.5. That number does not spike for random reasons. It spikes because the midfield no longer holds the pressing structure, and that gap is simply waiting for a team that knows how to exploit it. I wrote a short pre-match analysis predicting Germany would face severe difficulty. Nobody in the newsroom believed it. Some context is necessary to understand why that number mattered so much. PPDA (Passes Per Defensive Action) is one of the foundational metrics of modern football analysis — it measures the intensity and effectiveness of a pressing system. The lower the number, the more aggressively a team pressures its opponent. The higher the number, the more space and time a team concedes. In qualifying, Joachim Löw's Germany pressed at 7.5 PPDA — among the most proactive sides in Europe. In the finals, they held 68 percent of possession against Mexico, yet their PPDA was 10.2 — a paradox: plenty of the ball, no pressure when it was lost. The paradox had a cause. After injuries to key players and a decline in central midfield, Löw switched to a 4-2-3-1 with two deep-lying midfielders, prioritizing possession over high pressing. That was a tactical decision, not an accident. But it opened a large gap between midfield and defence — precisely the space Mexico and Sweden, the first two opponents, kept attacking with quick counter-attacks. Germany beat Sweden 2-1 with a stoppage-time winner from Toni Kroos, but the metrics did not improve. A goal in the 95th minute does not change the structure of a cracking system. This is the first point I want to make clear, because many people confuse result with process. The scoreline against Sweden was 2-1, which looked like a display of character. But tracking data from that match shows Germany allowed 14 shots — the most they had conceded in a World Cup group-stage game since 2026. Goalkeeper Manuel Neuer made six saves. A champion does not allow opponents to bombard its goal like that, even in victory. Media record results; spreadsheets record truth. Data never lies, but it holds on to the questions nobody asked. The question nobody asked in the press conference after Germany vs Sweden was: why would a team with 72 percent possession allow 14 shots? The answer lies in how Germany lost the ball. Across the three group matches, their turnover rate in the opponent's half was 18.4 percent — higher than the 12.7 percent they maintained in qualifying. Every time they lost the ball in that zone, only two central midfielders remained behind, and the distance between the two lines stretched to 22 metres. That is a fatal gap at World Cup level. I spent two weeks after the tournament rebuilding the model. I pulled data from three sources: FIFA tracking metrics, Opta event data, and team press-conference transcripts. Then I ran a simple regression model to test the correlation between PPDA and match outcomes. The result showed that across the 64 matches of the 2026 World Cup, PPDA had a negative correlation with goals conceded (coefficient -0.41) — the higher a team's PPDA, the more likely it was to concede. Germany sat in the tournament's highest PPDA bracket — and conceded four goals in three matches. That does not prove causation, but it is a strong enough signal to warn anyone paying attention. By the South Korea match, I knew what was coming. Not because I had prophetic powers, but because the spreadsheet had drawn the path. South Korea played defensive counter-attacking football, dropped their block deep, ceded possession, and waited for transitions. Against a Germany side that had lost its pressing structure and exposed the gap between the lines, it was an ideal matchup. South Korea's two goals in the 90+2nd and 90+6th minutes came from exactly the situation I had logged in my spreadsheet: Germany pushed forward for a winner, lost the ball, and South Korea countered directly into the space behind the midfield. Germany had lost before the match began — I have the spreadsheet to prove it. But wait. I must stop here, because there is a great temptation any data analyst is prone to: turning correlation into causation and turning a spreadsheet into a prophecy book. If I concluded that 'high PPDA means certain defeat,' I would have betrayed my own method. Across the 64 matches of the 2026 World Cup, at least five games saw the higher-PPDA team win — including France vs Argentina in the round of 16, where France won 4-3 despite inferior pressing metrics. Data is not a trump card. It is a map, and every map has blurred regions its maker cannot control. What separated Germany and France at the 2026 World Cup was not PPDA. It was adaptability. Didier Deschamps' France accepted playing lower, ceding more possession, and countering with Kylian Mbappé's pace. Germany had no Plan B. Löw stuck to his possession philosophy until elimination. That was a human and decision-making problem, not a model problem. I did not predict the shock. I only read the map that everyone else chose to forget. The story of the 2026 World Cup is not a story about a shock. It is a story about a team that lost the connection between its lines, and a coaching staff that failed to see the signal. In 19 years of following football and esports, I have learned one thing: the biggest failures do not come from a lack of data, but from having data that nobody wants to read. When I spoke with Korean colleagues after that match, someone asked me: 'How did you know?' I told them I did not know. I was just tracking a metric nobody wanted to watch. PPDA is not glamorous like a goal. It does not appear in highlight reels. It does not create viral moments. But it is the sigh of a system slowly dying — and if you sit in front of the screen long enough, you will hear it. The silence of the stands does not make data cleaner — it makes data truer. There is one behind-the-scenes detail I have never shared publicly. The night before Germany vs South Korea, I received a message from a friend working in a K League club's analysis department. He asked whether I had seen anything unusual in Germany's pressing metrics. I said yes, and he replied: 'Then you already understand.' We said nothing more. But we both knew what was coming. It was a moment when data created a connection between two people in two different countries, two different cultures, and two different leagues. I grew up in Poland — a country where football always comes attached to stories of fate. Poles believe in destiny, in moments that cannot be explained. But when I moved to South Korea and began working in sports data, I learned a different way of seeing: fate is a name we give to patterns we have not been patient enough to decode. Germany did not lose to South Korea because of fate. Germany lost because a metric had been screaming since March, and nobody in the press room wanted to hear it. That is why I chose this profession. Not to predict shocks, but to point out that sometimes a shock is written into a column of numbers nobody bothered to open. In the context of modern football, clubs have more data than ever. But more data does not mean more understanding. The problem is not the volume of numbers, but the questions we ask them. You can have a team's entire tracking dataset, but if you do not ask the right question, the numbers are just a heap of digits. I once watched a K League head coach dismiss his data department's report because 'I have seen it with my own eyes.' His team lost three straight, and only then did he open the report. It reminded me of my own story: in 2026, in an all-male press room, a senior male reporter cut off my question and said women know nothing about tactics. That night I stayed back, analysed the entire match tracking dataset, and wrote a 2,000-word long-form piece. It was shared nearly 1,000 times — seven times the official match report. Data is the strongest weapon against prejudice, not because it is elegant, but because it cannot be bent by a condescending remark. Back to Germany and the 2026 World Cup. After the tournament, the German Football Association (DFB) launched an internal review and concluded the team lacked a 'Plan B' in its tactical approach. The 36-page report was published in late 2026. It did not mention PPDA once. It spoke of 'structural changes to the squad' and 'a lack of connection between the lines.' Same problem, expressed in a different language — one that officials could understand. This is the biggest lesson I took from the 2026 World Cup: data only has value when it is translated into a language decision-makers can understand. A good analyst is not the person with the most numbers, but the person who knows how to pick one number and stand up to defend it in the right place, at the right time. I still keep that spreadsheet on my hard drive. Occasionally, before a big match, I open it again. Not to brag that I was right. But to remind myself that data always has limits — that a number can point to a trend but can never explain the whole story. A model cannot replace people. It only helps people see more clearly what is happening in front of them. That is why I never conclude with absolute statements like 'this team will certainly win' or 'that team will certainly lose.' I only say: data points to this, and if everything else stays equal, the outcome will tend that way. But everything else always changes. A player gets injured the night before. A coach makes an unexpected tactical call. A single moment of individual genius. Data cannot measure those things. And precisely because it cannot, it keeps its humility. Looking ahead, I believe the biggest question for modern football is no longer 'how do we get more data,' but 'how do we keep data from becoming an empty ritual.' When every club has a data department, competitive advantage will no longer come from owning data but from the ability to ask questions. The club that asks the right question will win. The club that merely copies another's model will lose. And that is the signal of the next cycle: over the coming years, I predict a wave of clubs appointing a 'chief questioning officer' — someone whose job is not to analyse data but to pose hard questions to it. This is a new role, not yet officially named, but I believe it is coming. Because when everyone has the same spreadsheet, the winner will be the one who knows how to read it differently. For now, I sit in front of my screen, with a spreadsheet open. And I am still waiting for Germany's next match — not to see whether they win, but to see whether their PPDA has returned to 7.5.