First, I am not sure if this belongs to general questions forum as it probably requires a bit of editing of the piwik internal code, so if I am posting this into a wrong section of the website I am sorry and redirect me kindly.
My problem is that I need to measure the time spent on a page by a visitor, or the whole time spent on website for the start (that should be easier).
Piwik in its current version doesn’t do that properly, it only measures the time passed between two actions, however I need it to measure the time even if the visitor displays only one page and leaves right after. There is no need for extreme accuracy though, an interval of 10 seconds would do fine.
I’ve naturally done some research so I know (and I hope I am right) that actions time is stored in ‘piwik_log_link_visit_action’ table under time_spent_ref_action, whole time spent on the website of a visit is in ‘piwik_log_visit’ table under ‘visit_total_time’ as a difference between ‘visit_first_action_time’ and ‘visit_last_action_time’ so I guess these two are the values I need to update manually to achieve this.