Export data from session log

Reports and working with data
1

Hello, is it possible to export data to Excel for sessions with conversions? However, I need all sessions from the last 90 days for users who have made a conversion. It seems that currently, the data export includes only the session from the day the conversion was made.

If not to Excel, is it possible to do it via the API?

2

Hey @Wojtek! What you’re describing is entirely possible. The tricky part is in the fact that you need to:

  • first collect the information about which visitors performed given conversion
  • secondly fetch the data for those visitors for those 90 days back

I created a guide on how to fetch raw data from Piwik PRO into Google Spreadsheet:

If you want to play around with API calls you can do it with another tool I created for this → https://logbaker.com/

Also feel free to reach out to me via DM here or my socials, we can figure this out together. For example a Python script could do both of those things in one run and output a ready to go Excel file :slight_smile:

3

O that is very nice! Thank you very much. I will contact you probably because this is what I’m looking for. Thanks

1 Like
4

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.