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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Analytics Coffee Break: On Monday, January 30 at 10am PT, the NOAM User Group led by Jennifer Dungan and Jeff Bloomer will be joining us to answer your Analytics related questions. To register and for more information, follow the link to the right.
SOLVED

Visit data doesnt match when added

Avatar

Level 4

I created a report in AA workspace where I added "Visits" as metric and Customer ID (tried evar & prop) as dimension. The workspace shows total visits as 56,000 but when I extracted that table as csv and added visits it shows 80,000 as total. 

 

When I tried the same report with dimension as Hours, the AA workspace showed total visits as 56,000 but When I extracted the table in csv and added the visits it shows 69,000 as total visit. 

Date range is just one day (Apr 1, 2022)

 

What's the logic here? Am I interpreting the calculation wrong?

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi @aagk123 This happens because the total you see below Visit metric is deduplicated count of a visit.

Here is an example that should give you some clarity:

 Visit #1  Visit #2
     
Page Visit Page Visit
A1 A1
B1 X1
C1   

 

AA Workspace: Since in reality there was only two visit where the visitor navigated through these pages, Workspace deduplicates the count of visits. So, summing visit for each page to determine total visit would not make any sense.

 

PageVisit
 2 (dedup)
A2
B1
C1
X1

View solution in original post

2 Replies

Avatar

Correct answer by
Employee

Hi @aagk123 This happens because the total you see below Visit metric is deduplicated count of a visit.

Here is an example that should give you some clarity:

 Visit #1  Visit #2
     
Page Visit Page Visit
A1 A1
B1 X1
C1   

 

AA Workspace: Since in reality there was only two visit where the visitor navigated through these pages, Workspace deduplicates the count of visits. So, summing visit for each page to determine total visit would not make any sense.

 

PageVisit
 2 (dedup)
A2
B1
C1
X1

Avatar

Level 1

Hi,

I am trying to understand the same concept in Analysis Workspace but my scenario is Dimension = Hour of Day and Metric = Unique Visitors and Visits. When I export the table and sum the visits by hour it is much higher than Total Unique visits or Total Visits. This explanation doesn't help me understand why. Can you elaborate any further please?

Thanks