Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Visits not matching Downloaded CSV Report

Avatar

Avatar
Validate 1
Level 1
rene_to
Level 1

Likes

2 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
rene_to
Level 1

Likes

2 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
rene_to
Level 1

15-10-2015

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.

View Entire Topic

Avatar

Avatar
Validate 1
Level 1
stella_anton
Level 1

Likes

2 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
stella_anton
Level 1

Likes

2 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
stella_anton
Level 1

02-01-2017

Hello,

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: 

                                                             
 DateVisits 
1.Dec 18, 2016318.159 
2.Dec 19, 2016296.037 
3.Dec 20, 2016284.166 
4.Dec 21, 2016261.077 
5.Dec 22, 2016213.449 
6.Dec 23, 2016193.797 
7.Dec 24, 2016127.186 
 Total1.684.490SUM: 1.693.871

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....

Please, could someone help me understand this?

Thank you.

Stella