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

SOLVED

Data Warehouse - Adobe Analytics Discrepancy

dannye52454320
Level 1
Level 1

Howdy,

Noticing huge discrepancies in numbers from Data Warehouse vs. Workspace/AdHoc Analysis.
Both Pageviews and Total Seconds Spent are very in line with each other, but Visitors and Unique Visitors are significantly over-represented in Warehouse.

I'm breaking out by Date > New Repeat (sprop) > First Touch Channel > Mobile Device Type > PageName (sprop) : METRICS

Is the issue a result of the dimensions I'm breaking out by?

Help!

1 Accepted Solution
PratheepArunRaj
Correct answer by
Moderator
Moderator

Dear Danny,

Data warehouse will not de-duplicate the Visits and Visitors if you are about to calculate it.

Consider the below example:

A visitor (new) come to our site via Search and accessed 3 pages A, B and C.

Same visitor visited our site next day (So, now it is repeat) via Direct and accessed B (Twice) and C.

Below the table in Data Warehouse will look like:

1554249_pastedImage_0.png

As per Workspace/AdHoc Analysis, For New there are 3 page views, 1 Visit and 1 Unique Visitor for New. But if we add the visits in Data Warehouse it will give you 3 page views, 3 Visits and 3 Unique Visitors.

I.e. Metrics which involves persistence or expiration will be de-duplicated in Data Warehouse but not in Workspace/AdHoc Analysis and thus the difference.

Thank You

Arun

View solution in original post

2 Replies
PratheepArunRaj
Correct answer by
Moderator
Moderator

Dear Danny,

Data warehouse will not de-duplicate the Visits and Visitors if you are about to calculate it.

Consider the below example:

A visitor (new) come to our site via Search and accessed 3 pages A, B and C.

Same visitor visited our site next day (So, now it is repeat) via Direct and accessed B (Twice) and C.

Below the table in Data Warehouse will look like:

1554249_pastedImage_0.png

As per Workspace/AdHoc Analysis, For New there are 3 page views, 1 Visit and 1 Unique Visitor for New. But if we add the visits in Data Warehouse it will give you 3 page views, 3 Visits and 3 Unique Visitors.

I.e. Metrics which involves persistence or expiration will be de-duplicated in Data Warehouse but not in Workspace/AdHoc Analysis and thus the difference.

Thank You

Arun

View solution in original post

Lucia0
Level 1
Level 1
Pratheep, is there anything you can do so that the figures in data warehouse match workspace?