I'm unsure, but I think the actual issue may be caused by the API fallback; if you can't use the mobile API for some reason, the app uses the standard API instead. This is an issue in China where the mobile API is blocked. This would account for those that had registered on Android but didn't have event_displayMobile = 1 due to using the standard API.

Dan


On 24 July 2014 22:45, Pine W <wiki.pine@gmail.com> wrote:

I believe that Android will run on desktops. Would Android desktops account for the nonzero number?

See http://www.pcworld.com/article/2048220/hybrid-hijinks-how-to-install-android-on-your-pc.html

Pine

On Jul 24, 2014 5:37 PM, "Dan Garry" <dgarry@wikimedia.org> wrote:
Hi!

So I've been rooting around in ServerSideAccountCreation and I've noticed some inconsistencies in the data. The final two clauses in the WHERE in the following query should be mutually exclusive (registered on Android app, and registered not on mobile), but the number returned is nonzero.

SELECT count(*)
FROM ServerSideAccountCreation_5487345
WHERE timestamp >= 20140722000000
AND timestamp <= 20140723000000
AND userAgent like 'WikipediaApp%'
AND event_displayMobile = 0

I'm sure you guys get data inconsistencies like this all the time, but I thought I should at least report it so you're aware.

Thanks,
Dan

--
Dan Garry
Associate Product Manager for Platform and Mobile Apps
Wikimedia Foundation

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics


_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics




--
Dan Garry
Associate Product Manager for Platform and Mobile Apps
Wikimedia Foundation