Developer forum

Forum » Rapido » DW statistics vs Google Analytics statistics

DW statistics vs Google Analytics statistics

E-mail notifications
E Muller
Reply
Posted on 04/10/2019 16:10:38

Hi,

A few days ago we had a big campagne for a customer of ours (Holland-Controls). Now we want to analyse the statistics for this mailing (6000+ emails).
In the marketing module of the customer (DW statistics) show values much bigger than the values provided by Google Analytics.
The numbers are so different that we are not sure what is causing it (I added 2 screendumps of Google Analytics + the same statistics in DW).
Additional we have see odd numbers when it comes to open rates in e-mail clients 3.539 opens in Outlook when the total open rate is below that 1.632. Could you tell us what is causing differences in numbers?

Best regards,
Eric

 

 

2019-10-04_16_00_34-Microsoft_Edge.png 2019-10-04_16_04_29-Dynamicweb_Admin.png Screenshot_traffic_GA.PNG

Replies

 
Nicolai Pedersen
Posted on 23/10/2019 17:09:26
Reply

Hi Eric

There seem to be a bug in the data collection that causes the some of the too large numbers under email client. We are working on a fix for that and is also checking if the other numbers are ok.

The problem is that there are a lot of duplicate rows in one table. You can fix it by running this query on the database using SQL Server Management Studio:

WITH duplicateNonBrowserSessions AS (
    SELECT 
        SessionId, 
        SessionSessionId, 
        ROW_NUMBER() OVER (
            PARTITION BY 
                SessionSessionId
            ORDER BY 
                SessionSessionId
        ) row_num
     FROM 
        NonBrowserSession
)
DELETE FROM duplicateNonBrowserSessions where row_num>1;

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Posted on 24/10/2019 01:53:26
Reply

Hi all,

The issue is now bugged by TFS 71264 has been created. The fix will be provided in upcoming DW hotfix/release. Thanks.

BR, Oleg QA 

 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Posted on 27/11/2019 13:02:49
Reply

Hi Eric

The problem regarding #71264 "Statistic gathered wrongly in email management" has now been resolved in Dynamicweb version 9.7.4
To upgrade please choose this version from backend or download from here:
http://doc.dynamicweb.com/releases-and-downloads/releases
Let me know if you need any more help regarding this
 
Kind Regards
Dynamicweb Support
Kristian Kirkholt

 

You must be logged in to post in the forum