Data Sources

To build an analytics solution, the most important component is the data that goes into it. Sana Commerce Insights (SCI) combines three key data sources. 

ERP Data

The ERP system is the beating heart of your company and contains everything you would like to know about the commercial performance of the company. It does not just contain data about all of the orders that go through your webstore, it includes every order that your company has processed.

Because Sana Commerce Cloud integrates with the ERP systems, we have a unique opportunity to extract the order data through our existing connection to give you a full picture of your commercial performance including orders placed by sales agents, EDI, or any other channel, not just your webstore performance.  

Further ensuring, as ERP is a single source of truth of your company, that the important commercial data we are reporting on is accurate. 

Piwik Pro Web Analytics Data

To effectively optimize your webstore, it is crucial to know what your visitors are doing on the webstore. For instance, you want to know which pages they visit, which products they add to their baskets, and how they ended up on the webstore - directly typing in the address, through an ad, or for instance an e-mail campaign.

This is web analytics or clickstream data. The name clickstream comes from the fact that every click on the website leads to a data point, which could potentially be a whole stream of data points if a website has many visitors. 

With Piwik Pro, we have access to each and every data point that we capture through your webstore, without being aggregated. This gives us complete flexibility in how we use the data. 

Lastly, Piwik Pro allows us to track the unique identification number of each shop account (the registered account that webstore visitors use to access and place orders in the webstore) for every data point that comes in. This allows us to track the behavior of individual customers of the webstore. 

This is of course only possible if the webstore visitors are logged in to the webstore with their accounts. 

Sana Webstore Data

The last key data source we use in Sana Commerce Insights is the Sana database. It contains information about all webstore settings configured in Sana Admin. 

For Sana Commerce Insights, the Sana database acts as a link between the clickstream data and the ERP data. Through the shop accounts table, we can match the unique identifier that we store in each Piwik Pro data point to the ERP customer. 

Next to this, it contains product reviews that are posted in your webstore as well as information about the customers and products connected to the store.