20% Discrepancy in Raw Data vs Adobe Reports | Community
Skip to main content
toddc59244792
toddc59244792
June 22, 2018

20% Discrepancy in Raw Data vs Adobe Reports

  • June 22, 2018
  • 1 reply
  • 4691 views

Hi, on average Im seeing a 20-27% difference when re-running year over year reports. For example, when I ran a report in May of 2017 Adobe said I had 100,000 visitors, however when I RE-RAN the month of May 2017 in May of 2018, it said I had 80,000 visitors in May 2017. This discrepancy is across all major metrics, for EVERY month.

Additionally, I've noticed that when using Ad Hoc Analysis (which I know is raw numbers) its showing a discrepancy of about 20% between its numbers and the numbers shown in Reports.

20% seems like a huge difference, can anyone explain this? What goes into Adobe's "Continual Processing" and how could it be off by so much in each different view? Where do the other numbers go? This is extremely problematic to the numbers our company is reporting.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Pablo_Childe
Community Advisor
Pablo_ChildeCommunity Advisor
Community Advisor
June 22, 2018

Seems odd to me, that data from one month like PVs UVs Visits changes month to month over a year. (I assume you pull exact same timeframes.) I would expcet PVs UVS visits once month is complete to be the same.

Things I have seen that could be making a change in numbers:

1 Are you using any year based KPIs(Yearly Unique Visitors) as an example, if time frame is changes when they are reported on it may change results.

2 Is the visit metric on the report in question restricted to a segment that may have changes over time?(Like new pages added or deleted in a segment)

3 Any custom data uploaded between dates of report pulls?

4 Do you have any special processing rules against any metrics that could be causing a change over time?

5 Any changes made to report suite itself(like a service issue)?

Any screen grabs would help as I honestly haven't seen this type of issue before.

suneeshkachroo
suneeshkachroo
June 22, 2018

If the discrepancy is consistent it means you have something wrong in logic.

Would recommend sticking to basics of each variable/metric and not to forget the exclusion if you have any setup.

toddc59244792
toddc59244792Author
June 22, 2018

By saying "its consistent" I mean that its the same difference regardless of whether there is a segment applied or not. Without any segments, AND using out-of-box basic KPIs there is still a discrepancy of 20+% in YOY numbers. It makes absolutely no sense.

    Terms & ConditionsAccessibility statement

    Loading footer...