BigQuery统计的活跃设备数与Google Play Console差异过大求助

我尝试统计不同安卓应用版本的当前设备数，先后使用两段BigQuery查询代码，但统计结果与Google Play Console的数据存在显著差异，调整代码后仍有10万的差距，恳请技术指导。

初始代码 #

with not_removed as (
select distinct user_pseudo_id as total_distinct_users
FROM table_name 
where event_name not in ("app_remove")
)

,
demo as
(SELECT 
          user_pseudo_id,
          app_info_version,
          operating_system
          
          
FROM churn_analysis.user_demographics
where user_pseudo_id in (select * from not_removed)
)

select app_info_version ,count(distinct user_pseudo_id) as launched_users
from demo
where operating_system='Android'
group by app_info_version
order by launched_users desc

调整后代码 #

with removed as 
(
select distinct user_pseudo_id as total_distinct_users
FROM `table_name` 
where event_name in ("app_remove")

)
,

not_removed as (
select distinct user_pseudo_id as total_distinct_users
FROM `table_name` 
where user_pseudo_id not in (select * from removed)
)

,
demo as
(SELECT 
          user_pseudo_id,
          app_info_version,
          operating_system
          
          
FROM churn_analysis.user_demographics
where user_pseudo_id in (select * from not_removed)
)

select app_info_version ,count(distinct user_pseudo_id) as launched_users
from demo
where operating_system='Android'
group by app_info_version
order by launched_users desc

内容的提问来源于stack exchange，提问作者analyst92