progression_checkpoint
This table is aggregated at the event ID level and contains all Progression Events (such as level complete and level fail)
| Field Name | Type | Description | Example |
|---|---|---|---|
| checkpoint | date | ||
| game_id | int | ||
| user_id | string | ||
| player_id | string | ||
| attempt_num | int | maximum attempt number to complete that particular event id (event_id e.g. "Fail:Universe1:Planet1:Quest1") | 6 |
| score | int | average score for that particular event id (event_id e.g. "Fail:Universe1:Planet1:Quest1") | 70 |
| score_count | int | number of score measurements recorded while trying that particular event id (event_id e.g. "Fail:Universe1:Planet1:Quest1") | 2 |
| score_min | int | minimum score obtained while trying that particular event id (event_id e.g. "Fail:Universe1:Planet1:Quest1") | 50 |
| score_max | int | maximum score obtained while trying that particular event id (event_id e.g. "Fail:Universe1:Planet1:Quest1") | 91 |
| score_sum | int | sum of all the scores obtained while trying that particular event id (event_id e.g. "Fail:Universe1:Planet1:Quest1") | 141 |
| progression_status | string | either Start, Complete or Fail (the level) | Complete |
| progression_1 | string | first progression level aggregation as per the game, e.g. Universe1 | Universe1 |
| progression_2 | string | second progression level aggregation as per the game, e.g. Planet1 | Planet1 |
| progression_3 | string | third progression level aggregation as per the game, e.g. Quest1 | Quest1 |