Piwik Archive Blob



We have been using Piwik for about a year now.
We are currently under going a project to collect all of data into a datawarehouse.

When i access the Piwik database I see many piwik_archive_blob__ tables

When i access one, for instance piwik_archive_blob_2015_01, i am seeing a VALUE column with a bunch of garbled text.
It looks like it is compressed data.

How can i convert this data to something readable?

I am curious as to what these values are? Can someone explain


(Matthieu Aubry) #2

Hi there, see: Data Model: DevelopInDepth - Matomo Analytics (formerly Piwik Analytics) - Developer Docs - v3