cqusyc’s gists

cqusyc / gist:46b20250b2629de3c91583092d274de2

Last active August 15, 2019 09:12

Unity2018.4.1f + admob 3.18.1

	(Filename: ./Runtime/Export/Debug.bindings.h Line: 45)
	2019-08-15 12:09:37.066 24406-25415/? E/Unity: Function SoundChannelInstance *SoundChannel::operator->() const may only be called from main thread!

	(Filename: Line: 19)
	2019-08-15 12:09:37.066 24406-25415/? E/Unity: Function SoundChannelInstance *SoundChannel::operator->() const may only be called from main thread!

	(Filename: Line: 19)
	2019-08-15 12:09:45.314 24406-25436/? I/Unity: HandleRewardedAdRewarded event received for 10 coins

	(Filename: ./Runtime/Export/Debug.bindings.h Line: 45)

cqusyc / gist:b1432d6594d3b76248aaa4a30002f464

Last active August 8, 2019 07:49

unity 2018.4.5f1 + admob3.18.1

	2019-08-08 15:03:23.936 4303-4303/? W/UnityMain: type=1400 audit(0.0:66916): avc: denied { read } for name="gpuclk" dev="sysfs" ino=21004 scontext=u:r:untrusted_app:s0:c512,c768 tcontext=u:object_r:sysfs:s0 tclass=file permissive=0
	2019-08-08 15:03:23.966 4303-4303/? W/UnityMain: type=1400 audit(0.0:66917): avc: denied { read } for name="gpuclk" dev="sysfs" ino=21004 scontext=u:r:untrusted_app:s0:c512,c768 tcontext=u:object_r:sysfs:s0 tclass=file permissive=0
	2019-08-08 15:03:23.995 4219-4303/? D/Unity: GL_AMD_compressed_ATC_texture GL_AMD_performance_monitor GL_AMD_program_binary_Z400 GL_EXT_debug_label GL_EXT_debug_marker GL_EXT_discard_framebuffer GL_EXT_robustness GL_EXT_texture_format_BGRA8888 GL_EXT_texture_type_2_10_10_10_REV GL_NV_fence GL_OES_compressed_ETC1_RGB8_texture GL_OES_depth_texture GL_OES_depth24 GL_OES_EGL_image GL_OES_EGL_sync GL_OES_EGL_image_external GL_OES_element_index_uint GL_OES_fbo_render_mipmap GL_OES_fragment_precision_high GL_OES_get_program_binary GL_OES_packed_depth_stencil G

cqusyc / gist:ae13240da491f8e42309b9872119de60

Created April 9, 2019 08:26

link map

cqusyc / lost_users_level_tap_count.sql

Created March 29, 2019 06:35

[查询流失用户某等级的点击水壶分布] #BigQuery #MergeGarden

	SELECT
	A.user_pseudo_id,
	sum(A.tap_count) as tap_count
	FROM
	(
	SELECT user_pseudo_id, event_params.value.int_value AS tap_count, event_timestamp
	FROM
	`analytics_195246954.events_*` AS T,
	T.event_params
	WHERE

cqusyc / lost_users_level_compound.sql

Created March 29, 2019 06:33

[查询流失用户某等级的合成菜品分布] #BigQuery #MergeGarden

	SELECT /* 查询最高菜品等级 */
	user_pseudo_id,
	COUNT(user_pseudo_id) as user_count /* 只要已解锁的最高菜品等级 */
	FROM
	`analytics_195246954.events_*` AS T,
	T.event_params
	WHERE
	event_name = 'af_compound_food'
	AND event_params.key = 'level'
	AND event_params.value.int_value = 2

cqusyc / lost_users_level_stage_progress.sql

Created March 26, 2019 14:06

####[查询流失用户，某等级下最高stage.progress] #BigQuery #MergeGarden

	SELECT C.user_pseudo_id, D.stage, E.wave FROM
	(
	SELECT
	A.user_pseudo_id, max(A.event_timestamp) as event_timestamp
	FROM
	(
	SELECT
	user_pseudo_id,
	event_timestamp,
	event_params.value.int_value as stage

cqusyc / users_level_shop_buy_count_maxLevel.sql

Created March 22, 2019 13:14

[查询注册用户某等级的商店购买菜品分布+最高等级] #BigQuery #MergeGarden

	SELECT /* 归并购买相同的菜品等级，按用户计数 */
	A.user_pseudo_id,
	COUNT(A.user_pseudo_id) as user_count
	FROM (
	SELECT /* 查询最高菜品等级 */
	user_pseudo_id, event_timestamp
	FROM
	`analytics_195246954.events_*` AS T,
	T.event_params
	WHERE

cqusyc / users_level_shop_buy_count.sql

Last active May 31, 2022 00:55

[查询注册用户某等级的商店购买菜品分布] #BigQuery #MergeGarden

	SELECT /* 归并购买相同的菜品等级，按用户计数 */
	user_pseudo_id,
	COUNT(user_pseudo_id) as user_count
	FROM (
	SELECT /* 查询最高菜品等级 */
	user_pseudo_id, event_timestamp
	FROM
	`analytics_195246954.events_*` AS T,
	T.event_params
	WHERE

cqusyc / users_level_tap_count.sql

Created March 22, 2019 12:32

[查询注册用户某等级的点击水壶分布] #BigQuery #MergeGarden

	SELECT
	A.user_pseudo_id,
	sum(A.tap_count) as tap_count
	FROM
	(
	SELECT user_pseudo_id, event_params.value.int_value AS tap_count, event_timestamp
	FROM
	`analytics_195246954.events_*` AS T,
	T.event_params
	WHERE

cqusyc / users_level_compound.sql

Created March 22, 2019 12:25

[查询注册用户某等级的合成菜品分布] #BigQuery #MergeGarden

	SELECT /* 查询最高菜品等级 */
	user_pseudo_id,
	COUNT(user_pseudo_id) as user_count /* 只要已解锁的最高菜品等级 */
	FROM
	`analytics_195246954.events_*` AS T,
	T.event_params
	WHERE
	event_name = 'af_compound_food'
	AND event_params.key = 'level'
	AND event_params.value.int_value = 2