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
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...
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
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...
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,
we were just having a separate discussion about the fact that the various isMobile or displayMobile fields predate the launch of apps and are likely to create artifacts if used to filter app-specific events. IMO there should be a default field in the event capsule for {desktop site, mobile site, app} applied to all events. Further breakdowns by client or device should be generated as usual from the UA field.
Dario
On Jul 25, 2014, at 8:00 AM, Dan Garry dgarry@wikimedia.org wrote:
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...
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 _______________________________________________ Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
there should be a default field in the event capsule for {desktop site, mobile site, app}
+1
On Fri, Jul 25, 2014 at 4:22 AM, Dario Taraborelli < dtaraborelli@wikimedia.org> wrote:
Dan,
we were just having a separate discussion about the fact that the various isMobile or displayMobile fields predate the launch of apps and are likely to create artifacts if used to filter app-specific events. IMO there should be a default field in the event capsule for {desktop site, mobile site, app} applied to all events. Further breakdowns by client or device should be generated as usual from the UA field.
Dario
On Jul 25, 2014, at 8:00 AM, Dan Garry dgarry@wikimedia.org wrote:
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...
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 _______________________________________________ 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
Should we bug this? Seems like a useful discussion to track so we can make any needed fixes.
-Toby
On Fri, Jul 25, 2014 at 6:34 AM, Aaron Halfaker ahalfaker@wikimedia.org wrote:
there should be a default field in the event capsule for {desktop site,
mobile site, app}
+1
On Fri, Jul 25, 2014 at 4:22 AM, Dario Taraborelli < dtaraborelli@wikimedia.org> wrote:
Dan,
we were just having a separate discussion about the fact that the various isMobile or displayMobile fields predate the launch of apps and are likely to create artifacts if used to filter app-specific events. IMO there should be a default field in the event capsule for {desktop site, mobile site, app} applied to all events. Further breakdowns by client or device should be generated as usual from the UA field.
Dario
On Jul 25, 2014, at 8:00 AM, Dan Garry dgarry@wikimedia.org wrote:
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...
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 _______________________________________________ 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
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
On Fri, Jul 25, 2014 at 2:22 AM, Dario Taraborelli < dtaraborelli@wikimedia.org> wrote:
IMO there should be a default field in the event capsule for {desktop site, mobile site, app} applied to all events. Further breakdowns by client or device should be generated as usual from the UA field.
+2