Hi, I just came across this problem when I downloaded a daily CSV report and noticed that the Total Sum of "Visits" and "Unique Visitors" did not match. E.g I downloaded a CSV report with 50000 rows and summed up every column, everything else matches except Visits and Unique Visitors. I want to know what is causing the differences.
I am posting my question here becasue I think is almost the same. However, I´ve read a lot about de-duplicated total metrics, the different types of reports and how when you try to breakdown by a certain dimension (Page, Product Name, etc) the number of Total Visits doedn´t match with the SUM of all of the components. And I get it. It makes sense. However, I don´t seem to find a logical explanation for the following case:
Dec 18, 2016
Dec 19, 2016
Dec 20, 2016
Dec 21, 2016
Dec 22, 2016
Dec 23, 2016
Dec 24, 2016
This is a standard Key Metrics report - I´ve selected "Visits" and set the date range for 1 week,
Why is there a difference between the total that Adobe is displaying at the bottom of the table and the SUM of these numbers (in Excel).
I mean...I´m not breaking down by a dimension, I´m not filtering, it´s just a simple trend of 1 single metrics....