Bounce Rate and Exit Rate columns in Install mysql piwik DB

General questions
1

HI Team,

We need to calculate bounce rate and exit rate of website page, We installed piwik DB using mysql having tables like piwik_log_visit , action table as well.

We are able to view the bounce and exit rate of website on reporting dashboard but unable to find columns in piwik db table. We search these columns in all the table

Is Piwik provide any columns to calculate these values in db or we need to calculate using track data? If yes then please give the details about that.

Also How to track visitor session in Piwik_session table?

Thanks,

2

Hi there,

please use the API to get the bounce rate and other values: Reporting HTTP API: API Reference - Matomo Analytics (formerly Piwik Analytics) - Developer Docs - v3