We would like to use Live.getLastVisitsDetails with a set of parameters.
We run into the following problem:
The structure of the output of a CSV file is not consistent, because the number of columns changes with the amount of actions in a visit, or custom variables etc..
A lot of BI tools are not able to handle XML files as a source file.
What are the options to export data in CSV, in a fixed column count, where you would create a new line for every action, event etc? All data that is part of the nested structure (like visitorId, idVisit, idSite, etc…) should be repeated in the lines.
I think it would be a valuable feature for connecting Piwik to any other BI tool.
thanks for the suggestion.
What BI tools are you looking to integrate with Piwik?
It would be possible to change the output of
Live.getLastVisitsDetails or maybe create a new API
Live.getLastActionsDetails or so, that will return one action per line.
Alternatively we are currently discussing to release on the Marketplace a new plugin that will let you export the
log_* tables as CSV. This could maybe solve the issue of integrating Piwik data with BI tools (although I can't confirm yet as the plugin is not released).
Tableau would be one of them.
Thing is, some data is encrypted / stored in a different encoding. One needs to decrypt / translate those values first. Second, data from log_* tables is enriched in the piwik code base before providing it via API.
In some cases the data from the export log* tables plugin would an option for people not wanting to connect directly to the database.
In some cases one needs more info than just the data available in the log* tables.
How it would be possible to access to database from Piwik in order to integrate with Google Data Studio?
Thanks in advance,