Playback statistics

Special fields

%play_count%

Returns how many times this tracks has been played. If the track has not been played yet, the field does not exist.

%first_played%

Returns the date and time when the track was first played. If the track has not been played yet, the field does not exist.

%last_played%

Returns the date and time when the track was last played. If the track has not been played yet, the field does not exist.

%played_per_day%

Returns the average of how many times per day track has been played, based on time first played, time last played and times played (average daily playcount between %first_played% and %last_played%). If the track has not been played yet, the field does not exist.

%added%

Returns the date and time at which track has been added to Media Library. Even if the track has not been played yet, the field exists, logically.

%rating%

Returns Rating Value (can be integer from 1 to 5). If the track has not been rated yet, the field does not exist.

The format of the returned values for both %first_played% and %last_played% are

 YYYY-MM-DD hh:mm:ss

The different parts of the format have the following meaning:

YYYY: year (four digits)
MM: month (two digits)
DD: day of month (two digits)
hh: hour (two digits)
mm: minute (two digits)
ss: second (two digits)