I am not able to setup a Piwik server that users can access in production due to system requirements (Microsoft stack).
Any pointers to anyone already doing this, any existing formats/mechanisms for bulk import/export of Piwik events, and/or what I would need to do for the endpoint reimplementation?
Microsoft stack: Piwik should work perfectly on Microsoft IIS stack.
Thanks matt; the ‘Microsoft stack’ part I’m stuck on is SQL Server 2005.
I would like to setup something in production to archive just the event data, then import that into Piwik setup somewhere else to take advantage of all the reporting optoins.
Thanks Fabian, this seems like a good first step.
Ultimately I would prefer to have all the information available normally rather than as limited by that which can be extracted from the log files. I was hoping there was already some side channel available for transporting it to another system.
Great! I was confused because of this in the documentation:
Tracking cookies cannot be used resulting in a few missing data points[/url]. See also [url=http://piwik.org/faq/troubleshooting/#faq_50]this faq.
[li] Piwik will still be able to determine unique visitors based on IP address and other footprints, but this will be slightly less accurate.
[/li][li] Ecommerce and Goal tracking attribution
[/li][li] Reports such as “Days since last visit”, “Visits by visit count”, “Visits to Conversion”, “Days to Conversion” will count all visits without cookie similarly to new visitors.
There are two ways of using the log-import:
The second one is the one you want. You will want to use the --replay-tracking parameter (https://github.com/piwik/piwik/blob/master/misc/log-analytics/import_logs.py#L380)