adactivity_checkpoint
This table is aggregated at the event level and contains all ad events, i.e. ad activity
| Field Name | Type | Description | Example |
|---|---|---|---|
| checkpoint | date | ||
| game_id | int | ||
| user_id | string | ||
| player_id | string | ||
| ad_sdk_name | string | Name of the ad provider e.g. "MoPub" | MoPub |
| ad_type | string | Type of Ad, e.g. "Video" | interstitial |
| ad_placement | string | Placement/ identifier of ad within the game, e.g. "end_of_game" | missionEnd |
| ad_impressions | int | number of ads where ad_action is "show", i.e ads shown to a player | 24 |
| ad_clicks | int. | number of ads where ad_action is "clicked", i.e ads clicked by a player | 0 |