calculations.matches_10_overperformance

Joins parsed scores with expected goals to compute side-, total- and goal-difference overperformance (positive = scored more than expected).

Lineage

flowchart LR
m5[/matches_5_score/] --> me[/calculations.matches_10_overperformance/]
m9[/matches_9_expected_goals/] --> me
me --> mart[/mart.matches/]
click m5 "/calculations/matches_5_score/" "Open"
click m9 "/calculations/matches_9_expected_goals/" "Open"
click mart "/mart/matches/" "Open"

Columns

Column	Description	Formula
event_id	Bet365 event identifier.	s.event_id
event_date	Event date.	s.event_date
event_partition_key	ClickHouse partition key.	s.event_partition_key
overperformance_home_scored	Home goals scored vs expected.	s.score_home - eg.stats_goals_expected_home
overperformance_home_conceded	Home conceded vs expected (away minus expected_away).	s.score_away - eg.stats_goals_expected_away
overperformance_away_scored	Away goals scored vs expected.	s.score_away - eg.stats_goals_expected_away
overperformance_away_conceded	Away conceded vs expected.	s.score_home - eg.stats_goals_expected_home
overperformance_goals_total	Total goals vs expected.	s.score_total - eg.stats_goals_expected_total
overperformance_goal_difference_home	Home-side goal difference vs expected.	(s.score_home - s.score_away) - (eg.stats_goals_expected_home - eg.stats_goals_expected_away)
overperformance_goal_difference_away	Away-side goal difference vs expected.	(s.score_away - s.score_home) - (eg.stats_goals_expected_away - eg.stats_goals_expected_home)