player_checkpoint

This is the main table and it’s aggregated at the player level, containing the daily summary stats for each player.

Field Name	Type	Description	Example
checkpoint	date
game_id	int
user_id	string
player_id	string
event_count	int	number of events of any type for that player that day	3
is_paying	boolean	flag indicating whether the player has ever made a payment (since we have history of it) (true/null)	TRUE
is_paying_today	boolean	flag indicating whether the player has made a payment on the checkpoint date (true/null)	TRUE
is_converting_today	boolean	flag indicating whether the checkpoint date is the first time the player is making a payment (since we have history of it) (true / false [paid today but not for the 1st time] / null [did not pay today, hence can't be converting today])	TRUE
first_paid	date	date of the player's first payment	2020-01-01
revenue_usd	float	total amount of the player's payments that day, in USD cents	99
transaction_count	int	number of payment transactions that day	1
transaction_num_count	int	number of transactions with transaction number that day	1
transaction_num_min	int	minimum transaction number that day	1
transaction_num_max	int	maximum transaction number that day	1
origin	string	how the player came into the game, e.g. acquired, organic	organic
install_ts	date	date the player installed the game	2020-01-01
cohort_week	date	first day of the week the player installed the game	2020-01-01
cohort_month	date	first day of the month the player installed the game	2020-01-01
install_publisher	string	information about installation regarding publisher	TikTok
install_site	string	information about installation regarding site	13456
install_campaign	string	information about installation regarding campaign	Earn ALL the rewards
install_adgroup	string	information about installation regarding advertisement group	Example_v433
install_ad	string	information about installation regarding advertisement	Test+moreinfo+randomstring
install_keyword	string	information about installation type as a keyword	download+mytest
country_code	string	country code for the player's country based on events (please note this may change day on day if the player is travelling)	IT
ios_id	string	IOS id	XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX
ios_idfa	string	IOS identifier for advertisers	XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX
ios_idfv	string	IOS identifier for vendor	XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX
android_id	string	Android id	XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX
google_aid	string	Android advertising id	XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX
limited_ad_tracking	boolean	if True, it means the player does not want to be targeted, preventing attribution of installs to any advertising source	true
logon_gamecenter	boolean	whether the player is logged to Apple's Game Centre	true
sdk_version	string	SDK version	unity 5.1.11
engine_version	string	engine version	unity 2019.3.7
os_version	string	device's OS version	ios 15.5
manufacturer	string	device's manufacturer	apple
device	string	device model	iPhone8,1
platform	string	platform e.g. ios, android	ios
first_build	string	first game build the user was 'seen' with	1.0.1
build	string	game build	1.0.1
builds	string	game builds string array	1.0.1, 1.0.2
app_versions	string	app_versions string array (ios_app_version for ios and android_app_version for android)	1.0.1, 1.0.2
connection_type	string	connection, e.g. lan, wwan, wifi, offline	wwan
jailbroken	boolean	whether the player has jailbreaking (process of removing all restrictions imposed on an IOS device) enabled	false
session_count	int	number of unique sessions for that player that day	4
session_length_min	int	minimum session length that day	2
session_length_max	int	maximum session length that day	12
session_length_sum	bigint	total playtime for that player that day	24
session_length_sum2	bigint	sum of each squared session length that day	576
session_num_min	int	minimum session number that day	1
session_num_max	int	maximum session number that day	3
error_debug_count	int	number of debug level errors that day	43
error_info_count	int	number of info level errors that day	2
error_warning_count	int	number of warning level errors that day	2
error_error_count	int	number of error level errors that day	1
error_critical_count	int	number of critical level errors that day	0
ab_test_id	string	A/B Testing experiment identifier in case the player is participating in an A/B Test	ABCDefghIJKLmnopLKJIhgef
ab_test_title	string	A/B Testing experiment name in case the player is participating in an A/B Test	Test button size
ab_test_variant_id	string	A/B Testing variant identifier in case the player is participating in an A/B Test	ctrl
ab_test_variant_name	string	A/B Testing variant identifier in case the player is participating in an A/B Test	MyBaseline
ab_admission_date	string	Date the player was enrolled in the A/B Test	2025-01-01
ad_impressions	int	number of ads shown that day	5
ad_clicks	int	number of ads clicked that day	2
ad_ilrd_count	int	number of ad events having publisher revenue greater than 0	4
ad_ilrd_revenue	float	ad revenue attributed from the publisher data (in cents)	1
validated_revenue_usd	float	total amount of the player's validated payments that day, in USD cents	99
validated_transaction_count	int	number of validated payment transactions that day	1
completed_session_count	int	number of unique sessions (with a session_end event) for that player that day	4
user_id_ext	string	External ID that can be used to identify already existing players	largeRevenueUser#1