Internally, we are discussing making it easier for us to tell if post activities came via the mobile version of the site. We already have a column in the
PostHistory table called
ApplicationId that indicates whether the activity (mostly creating and editing) on a post was from the Android or iOS app. We use this data to track things like whether questions posted with an app are shorter than average.* This seems like useful data, so I'm proposing adding this column to the public data.
In order to make the data user-friendly, I'd also like to create a
ApplicationTypes table with these columns:
Idint = ApplicationId from PostHistory
Namevarchar(10) = 'ios', 'android', 'mobile', 'full'
Descriptionvarchar(300) = whatever detailed description might be helpful
One potential concern is that we would be revealing some information about our users that was not public in the past. You could, for instance, identify the 17 people who used Apple devices on Android Enthusiasts and the 101 Android users who have infiltrated Ask Different. You could also determine which of those people did it for the hat. But I think the value of having this information outweighs the potential cost.
* The answer on SO:
source avg_body N ------- -------- ------- web 1319 8718569 android 723 2295 ios 693 898