Piwik data dictionary

Support & Bugs
1

Hi Guys,

I am new using Piwik but already find it amazing. I intend to apply statistical scorings on de data captured and loaded in MySQL so I need to understand the data model behind Piwik. Does anyone have a data dictionary that explains al the tables and coluns?

Another question: is that possible to get the data captured and apply mathematical calculations before they are loaded in MySQL?

Sorry if someone already posted these questions here but I could not find them.

Many Thanks,

Douglas.

2

the data is mostly self-explanatory. IF you have questions you can ask. Yes you can do algorithms on the data before it’s saved, by creating a custom plugin. Look at example plugin such as AnonymizeIP or Provider for example how to play with tracking data.