Web traffic analytics with Piwik through Lokad

Web traffic analytics with Piwik


Home » Integrations » Here

Lokad delivers quantitative supply chain optimizations that leverages many data sources. Among those data sources, the behavior of your web visitors is of prime interest. Thus, Lokad supports importing historical web traffic data from Piwik.

What does Lokad do with Piwik?

Lokad specializes in quantitative supply chain. We leverage all your historical data in order to model your business and generate inventory decisions that maximize the economic returns for your company. As such, Lokad is a programmatic platform dedicated to predictive supply chain optimization. The integration with Piwik takes care of retrieving all the relevant data from your Piwik account and making this data available in flat file format, ready for further data processing within your Lokad account.

Getting started

In order to connect Piwik to Lokad, you will be expect to provide the following credentials to Lokad webapp:

  • Piwik base URL: HTTP URL of the piwik instance that hosts the API
  • Authentication token: a secret token used to gain access to the Piwik data
  • Piwik site ID: also known as idSite, expected to be a number

Data retrieved from Piwik

The approach adopted by Lokad consists of an extensive retrieval of all the historical visits. This represents the most fine-grained data available in Piwik. The data is collected in a series of tabular files that can be further processed with Envision, Lokad's scripting language dedicated to supply chain modelling and optimization.

Piwik_Visits.tsv

The file contains the columns:
  • Date: the date of associated with action of the website visitor
  • Type: the type of action tracked from the visitor
  • IdSite: the identifier of the website (intended for multi-websites scenarios)
  • IdVisit: the identifier of the visit for the visitor (not unique across distinct visitors)
  • Url: the full URL visited
  • UserId : the identifier of a logged-in visitor (depends on how Piwik is setup)
  • VisitorId : the identifier of the visitor (anonymous, just a hash)