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