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