@RMastop opened this Issue on May 22nd 2015 Contributor

Hi,

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,
Richard

@mattab commented on May 24th 2015 Member

Hi @RMastop

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).

@RMastop commented on June 3rd 2015 Contributor

Hi @mattab

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.

@avargasd commented on April 16th 2018

Good morning!

How it would be possible to access to database from Piwik in order to integrate with Google Data Studio?

Thanks in advance,

Adriana

Powered by GitHub Issue Mirror