{"action":"closed","issue":{"url":"https://api.github.com/repos/learningtapestry/analytics/issues/300","repository_url":"https://api.github.com/repos/learningtapestry/analytics","labels_url":"https://api.github.com/repos/learningtapestry/analytics/issues/300/labels{/name}","comments_url":"https://api.github.com/repos/learningtapestry/analytics/issues/300/comments","events_url":"https://api.github.com/repos/learningtapestry/analytics/issues/300/events","html_url":"https://github.com/learningtapestry/analytics/issues/300","id":296123173,"number":300,"title":"We should store originally_captured_at or a total_time_spent field of some kind","user":{"login":"rradonic","id":488309,"avatar_url":"https://avatars0.githubusercontent.com/u/488309?v=4","gravatar_id":"","url":"https://api.github.com/users/rradonic","html_url":"https://github.com/rradonic","followers_url":"https://api.github.com/users/rradonic/followers","following_url":"https://api.github.com/users/rradonic/following{/other_user}","gists_url":"https://api.github.com/users/rradonic/gists{/gist_id}","starred_url":"https://api.github.com/users/rradonic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rradonic/subscriptions","organizations_url":"https://api.github.com/users/rradonic/orgs","repos_url":"https://api.github.com/users/rradonic/repos","events_url":"https://api.github.com/users/rradonic/events{/privacy}","received_events_url":"https://api.github.com/users/rradonic/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"rradonic","id":488309,"avatar_url":"https://avatars0.githubusercontent.com/u/488309?v=4","gravatar_id":"","url":"https://api.github.com/users/rradonic","html_url":"https://github.com/rradonic","followers_url":"https://api.github.com/users/rradonic/followers","following_url":"https://api.github.com/users/rradonic/following{/other_user}","gists_url":"https://api.github.com/users/rradonic/gists{/gist_id}","starred_url":"https://api.github.com/users/rradonic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rradonic/subscriptions","organizations_url":"https://api.github.com/users/rradonic/orgs","repos_url":"https://api.github.com/users/rradonic/repos","events_url":"https://api.github.com/users/rradonic/events{/privacy}","received_events_url":"https://api.github.com/users/rradonic/received_events","type":"User","site_admin":false},"assignees":[{"login":"rradonic","id":488309,"avatar_url":"https://avatars0.githubusercontent.com/u/488309?v=4","gravatar_id":"","url":"https://api.github.com/users/rradonic","html_url":"https://github.com/rradonic","followers_url":"https://api.github.com/users/rradonic/followers","following_url":"https://api.github.com/users/rradonic/following{/other_user}","gists_url":"https://api.github.com/users/rradonic/gists{/gist_id}","starred_url":"https://api.github.com/users/rradonic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rradonic/subscriptions","organizations_url":"https://api.github.com/users/rradonic/orgs","repos_url":"https://api.github.com/users/rradonic/repos","events_url":"https://api.github.com/users/rradonic/events{/privacy}","received_events_url":"https://api.github.com/users/rradonic/received_events","type":"User","site_admin":false}],"milestone":null,"comments":3,"created_at":"2018-02-10T18:44:09Z","updated_at":"2018-03-06T15:11:27Z","closed_at":"2018-03-06T15:11:27Z","author_association":"CONTRIBUTOR","body":"The captured_at field for raw messages gets updated every time new raw messages come in from the importer, so we can't use (updated_at - captured_at) to get the total time spent on a page.\r\n\r\nWe also can't do (updated_at - created_at) since created_at stores the time that the raw message got imported into PostgreSQL which happens when the importer gets run, and not the time that the user started looking at the page.\r\n\r\ncaptured at stores the time the user started looking at the site most recently, so if they look at the page for at 13:00 for 10 seconds we store 13:00, and if they move to another tab and go back to our tab at 13:04 for 10 more seconds and then close the tab, captured_at will say 13:04 and there's no more record of 13:00 anywhere, we're losing the original time the user started looking at the page."}}
{"actor":{"display_login":"rradonic"}}