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 webstore database. It contains detailed records of online activity, including transactions placed through the webstore, login events, and all registered shop accounts.

For Sana Commerce Insights, this database acts as the crucial link between clickstream data and ERP data. Using the shop accounts table, we can match each Piwik PRO data point to the corresponding ERP customer, enabling customer-level insights across both online and offline channels.

In addition, the database provides essential context about customers and products connected to your webstore, allowing for richer, more actionable reporting.