Cosas de Desarrolladores

Buen día. Con base a este foro https://moodle.org/mod/forum/discuss.php?d=336086 he probado unas consultas en MySQL para obtener estadísticas básicas del uso de Moodle App. Lo ideal sería que pueda reflejar en Google Analitycs pero por ahora no encuentro dicha solución.  Lo he probado en moodle 3.2:

- Uso de Moodle App, clics por año y mes

SELECT DATE_FORMAT(FROM_UNIXTIME(m.timecreated),'%Y') as Year, DATE_FORMAT(FROM_UNIXTIME(m.timecreated),'%M') as Month, count(*) FROM mdl_logstore_standard_log m WHERE m.origin='ws' GROUP BY DATE_FORMAT(FROM_UNIXTIME(m.timecreated),'%Y'), DATE_FORMAT(FROM_UNIXTIME(m.timecreated),'%M') ORDER BY DATE_FORMAT(FROM_UNIXTIME(m.timecreated),'%Y'), DATE_FORMAT(FROM_UNIXTIME(m.timecreated),'%M');

- Uso de Moodle App, usuarios únicos por año y mes SELECT DATE_FORMAT(FROM_UNIXTIME(m.timecreated),'%Y') as Year, DATE_FORMAT(FROM_UNIXTIME(m.timecreated),'%M') as Month, count(distinct m.userid) as distinct_users FROM mdl_logstore_standard_log m WHERE m.origin='ws' GROUP BY DATE_FORMAT(FROM_UNIXTIME(m.timecreated),'%Y'), DATE_FORMAT(FROM_UNIXTIME(m.timecreated),'%M') ORDER BY DATE_FORMAT(FROM_UNIXTIME(m.timecreated),'%Y'), DATE_FORMAT(FROM_UNIXTIME(m.timecreated),'%M');