Export Analytics statistics metrics for Kaltura?

linlma · July 28, 2015, 5:07am

Hello everyone,

If I want to export Kaltura statistics information, like who played which video, shall I export some tables in Kaltura data warehouse? I want to get statistics information just as when we see from Analytics Tab. Appreciate if anyone could provide a bit more details what information to be export.

regards,
Lin

jess · July 28, 2015, 11:26am

Hello,

You can use KMC to export the data into CSV or else you can use the API. See example here:
https://github.com/kaltura/platform-install-packages/blob/Jupiter-10.17.0/RPM/scripts/postinst/dwh_stats.php

linlma · July 28, 2015, 5:42pm

Thanks Jess,

For the PHP script, I can run it standalone?
Could you show me how to export from KMC manually?

regards,
Lin

jess · July 28, 2015, 6:05pm

KMC - just go to the analytics tab and you’ll see 'export as CSV’
Script - yes, you can run it from the shell and get an array with the results.

linlma · July 28, 2015, 6:40pm

Cool, thanks Jess!

regards,
Lin