AFL Platform Update - 16th March 2026

AFL Warehouse 1.3 Update [16/03/2026]

Match Periods Table

This update adds the FIXTURES.MATCH_PERIODS table which returns the periods that occurred in each match, along with their actual start and end times (essential when working with match transaction timings).

Matches table additions

This update adds the following columns to the FIXTURES.MATCHES table and the FIXTURES.MATCHES_BY_SQUAD view:

• Coin toss result and decision
• Match Attendance
• G.B.P for both squads
• Phase Name (i.e. Home & Away, Finals)
• Tier Code (AFLTIER1, AFLTIER2)

Match Player Stats Zero Id Fix

A fix has been applied to the STATISTICS.MATCH_PLAYER_STATS table to remove rows assigned to Player Id 0 (zero). These rows are in fact Squad Stats that were appearing in the Player Stats table in error.

Calculated Metrics View

A new view, REFERENCE.CALCULATED_METRICS has been added to the warehouse which returns the metric glossary entries for calculated metrics only. This makes it easier to identify them from the regular metrics that have actual statistic values.

AFL API 1.68 Update [23/03/2026]

note

In general, all new metrics added to the AFL API are also available from the AFL Warehouse. Any exceptions will be highlighed in the release notes.

Last Disposal Against Metric

This update adds the 'Last Disposal Infringement Against' metric, which returns the number of times the lasso rule is applied. This metric is available at both Player- and Squad-level.

Metric	Description
LAST_DISPOSAL_AGAINST Last Disposal Infringement Against	When the ball goes out of bounds via a disposal and possession is awarded to the opposing team

45 Kick Retention Metrics

This update adds 15 metrics that return how many 45 kicks resulted in possession retention or not. They are available at both Player- and Squad-level.

Metric	Description
KICK_DIRECTION_45_RETAIN Forty-Five Kick Retained	45 Kicks that resulted in a possession to a teammate
KICK_DIRECTION_45_LOSS Forty-Five Kick Loss	45 Kicks that resulted in a possession to an opposition player
KICK_DIRECTION_45_RETAIN_SCORE Forty-Five Kick Retained Score	45 Kicks retained that resulted in a score during the given chain
KICK_DIRECTION_45_LOSS_PUNISH Forty-Five Kick Loss Punished	45 Kicks that resulted in a possession to an opposition player who converted this into a scoring chain
KICK_DIRECTION_45_STOPPAGE Forty-Five Kick Stoppage	45 Kicks that resulted in a stoppage before any possession has been won
KICK_DIRECTION_45_INBOARD_RETAIN Inboard Forty-Five Kick Retained	Inboard 45 Kicks that resulted in a possession to a teammate
KICK_DIRECTION_45_INBOARD_LOSS Inboard Forty-Five Kick Loss	Inboard 45 Kicks that resulted in a possession to an opposition player
KICK_DIRECTION_45_INBOARD_STOPPAGE Inboard Forty-Five Kick Stoppage	Inboard 45 Kicks that resulted in a stoppage before any possession has been won
KICK_DIRECTION_45_INBOARD_RETAIN_SCORE Inboard Forty-Five Kick Retained Score	Inboard 45 Kicks retained that resulted in a score during the given chain
KICK_DIRECTION_45_INBOARD_LOSS_PUNISH Inboard Forty-Five Kick Loss Punished	Inboard 45 Kicks that resulted in a possession to an opposition player who converted this into a scoring chain
KICK_DIRECTION_45_OUTBOARD_RETAIN Outboard Forty-Five Kick Retained	Outboard 45 Kicks 45 Kicks that resulted in a possession to a teammate
KICK_DIRECTION_45_OUTBOARD_LOSS Outboard Forty-Five Kick Loss	Outboard 45 Kicks 45 Kicks that resulted in a possession to an opposition player
KICK_DIRECTION_45_OUTBOARD_STOPPAGE Outboard Forty-Five Kick Stoppage	Outboard 45 Kicks 45 Kicks that resulted in a stoppage before any possession has been won
KICK_DIRECTION_45_OUTBOARD_RETAIN_SCORE Outboard Forty-Five Kick Retained Score	Outboard 45 Kicks 45 Kicks retained that resulted in a score during the given chain
KICK_DIRECTION_45_OUTBOARD_LOSS_PUNISH Outboard Forty-Five Kick Loss Punished	Outboard 45 Kicks 45 Kicks that resulted in a possession to an opposition player who converted this into a scoring chain