Developer forum

Forum » Ecommerce - Standard features » eCommerce Statistics query - Where the data come from for Traffic sources to Sales

eCommerce Statistics query - Where the data come from for Traffic sources to Sales

E-mail notifications
Tan Pang Lin Dynamicweb Employee
Tan Pang Lin
Reply
Posted on 29/02/2024 04:01:08

Hi Sir

Our customers is asking why there is no data for orders statistics – traffic sources to sales.   May I know where this data come from?   Or at least direct should have some records,  but currently is 0.   We do enabled both statistic and tracking options upon LIVE.   Appreciate your advise.

Thanks

Pang Lin


Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 29/02/2024 16:54:33
Reply
This post has been marked as an answer

Hi Pang Lin

It comes from the table Statv2Session in the field Statv2SessionRefererDomain column and is linked to orders using the Statv2Object table in the column Statv2ObjectElement where the orderid should be. So you should have data there (and orders) that matches using the orderID and Statv2SessionSessionID that should be both on orders and in Statv2 table.

To get data "Enable statistics" should be set.

Votes for this answer: 1
 
Tan Pang Lin Dynamicweb Employee
Tan Pang Lin
Posted on 04/03/2024 04:51:26
Reply

Dear Nicolai

I had checked the table and follow the design and did an excel export and use vlookup to get all the necessary field.   and I observed that even though there is data, refer to image below.   But there is still no data in DW statistic.  Please advise where could go wrong. 

Here are my queries.

  1.  Why most of the order was registered under NULL and not shakesshack.ph?
  2. There are orders come from Facebook, google, direct.  But the graph still show 0, how to make it showed?

Thanks

Pang Lin

 

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 04/03/2024 10:29:28
Reply
This post has been marked as an answer

Many browsers and services do not send referers anymore - i.e. Google specifically removes the Referer header and many sites these days issue a referer policy (https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Referrer-Policy) that disables adding the information. So basically this is a useless statistics and we cannot fix it. 

This has happened due to security issues, tracking issues and sorts. And Google wants to force people into using analytics.

 

Votes for this answer: 1

 

You must be logged in to post in the forum