4 ms·
To talk about UXWizz specifically, I try to implement only core stats (to not bloat the platform). But because you have access to the MySQL database directly, y
by XCSme 5y ago
To talk about UXWizz specifically, I try to implement only core stats (to not bloat the platform). But because you have access to the MySQL database directly, you can always create your own graphs on top of it or run a query to find the time spent on a specific page.
To give a concrete example, a such query would be, which would show all pages and the average time-on-page, ordered descending by time:
SELECT MIN(page), AVG(TIME_TO_SEC(timediff(last_activity, date))) as avg_time
FROM ust_clientpage
GROUP by page_hash
ORDER BY avg_time DESC;