Dominik, Thanks for your invitation to comment. We work with the current stats log in Excel, as follows: id username deviceid (IMEA) Action_type Action_details timestamp Requests for statistical changes, if possible: - Parse the "details" field so that data elements like "Id=E103a;Type=Video;Title=E103a-Prepositions;" or "Url="" appear in separate columns (i.e. "E103a", "Video", "E103a-Prepositions", or "http://...", "Completed" and put this field on the end so that we don't have to worry about variable line length (or add spacers to the other fields so that data appears in consistent columns) - Change the formatting of the timestamp so that it is easier to parse in Excel or databases (e.g. 08/01/12 11:32:40 instead of Wed Aug 01 11:32:40 GMT+05:30 2012) NOTE: please don't remove the time from the time stamp, as the difference between PLAY_ITEM_START and PLAY_ITEM_END allows us to observe how many minutes of video watching a class experiences - Update NED server stats download to include a date range, so we don't have to download all the stats every time - Add a filter to download stats for a range of users, e.g. only ap01-ap99, ideally, a dialog/check box (with select all) to download stats for selected users We run two pivot table reports in Excel from the NED stats - number of videos downloaded by user per month and number of videos played by user per month. To generate the reports, we apply formulas to parse the month and then check whether the Action_type field is either "DOWNLOAD_COMPLETED" or "PLAY_ITEM_END". We're also interested in figuring out "total time used during the school day", which we can calculate by formula, but it's tricky (first you have to sort to get the login and exit time for each user together, then you have to calculate the time difference) . If it would be possible to record "total time logged in" when we app_exit that would be useful. A sample is enclosed, with the three pivot tables (Play, Download, TimeLoggedIn) and the statistics.csv raw data with the formulas used to create the tables. |
Finally, we'd LOVE to get a stat showing us whether or not a TV-out cable is connected when a video is played. Cheers, Matt P.S. Please let me know if you would like me to enter any of these as tickets in http://projects.developer.nokia.com/NED On 25-Sep-2012, at 1:03 PM, Dominik Frankowski wrote:
|