我在Firebase中使用过滤器的新受众群体解决了这个问题:
用户属性/ App Store“不包含”“manual_install”
我发现所有直接应用安装以及所有Firebase测试实验室安装都属于此参数.
如果您只想删除少数用户,那么您可以添加此过滤器(尚未尝试过):
用户属性/用户ID“不等于”(或“不包含”)your_ID
这仅适用于Firebase Analytics,仅适用于创建受众群体后发生的事件.
对于BigQuery,我使用以下查询来排除测试设备:
SELECT
user_dim.user_id AS userId,
FORMAT_UTC_USEC(user_dim.first_open_timestamp_micros) AS tsFirstOpen,
user_dim.device_info.device_category AS dCaterogy,
user_dim.device_info.mobile_brand_name AS dBrand,
user_dim.device_info.device_model AS dModel2,
user_dim.device_info.platform_version AS dOSver,
user_dim.device_info.user_default_language AS dDefLanguage,
user_dim.geo_info.continent AS geoCont,
user_dim.geo_info.country AS geoCounty,
user_dim.app_info.app_version AS appVer,
FROM
TABLE_DATE_RANGE(YOUR_TABLE_NAME.app_events_, TIMESTAMP('2016-06-23'), TIMESTAMP('2016-10-01'))
WHERE
// Remove all testing devices
NOT (user_dim.user_id == "YOUR_USER_ID" OR
user_dim.user_id == "YOUR_USER_ID") AND
NOT user_dim.app_info.app_store == "manual_install" AND
user_dim.user_properties.key == "first_open_time"
GROUP BY
tsFirstOpen,
userId,
dCaterogy,
dBrand,
dModel2,
dOSver,
dDefLanguage,
geoCont,
geoCounty,
appVer
ORDER BY
appVer DESC,
tsFirstOpen DESC