Reports don't add up

Forum|Forum|9 years ago
May 31, 2016
1 reply
4656 views

I want to run a total count of page views for my site. but I want two specific pages excluded. So I checked the following by running the pages report and doing a data extract:

1. run the report will all pages included

2. run report with just the 2 pages included

3. run the report with the 2 pages excluded.

#1 - #2 should equal #3. But it doesn't. why would that be. Nothing else is modified when running these reports

Analytics

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

TanmayMathur

Adobe Employee

Hi Mike,

The calculation you are doing seems right from the point of view of logic but would lead to an incorrect answer because of the way analytics reports data. The totals in the reports are de-duplicated. For example, you visit a site and go through 5 pages. When you run a site wide report you will contribute 1 visit to the site, but when you run a report having visits for those 5 pages, your visit would be counted as once for every page which makes it 5 in total. So when you compare or process the data from these two reports together it would lead to a unexpected result.

This article also explains the same situation. Though its about comparing sum of line items, the same holds true in case of difference as well - https://marketing.adobe.com/resources/help/kb/en_US/analytics/kb/sum-line-items-different-from-total.html

Let me know if this information was helpful. Thanks!

Tanmay

A

Anonymous

My report has a total that is greater than the sum of the line items. The reasons for this in the article you referenced are not applicable to my report. It does not make sense to me why the total number of unique visitors would be greater since they should be falling into the bookmarked/typed category as a catch all. I have uploaded the report here. Can you please take a look and let me know what you think may be the issue.

Total-Does-Not-Equal-Sum---Referrers-Report.pdf

S

shalup

Can you assist with understanding why the unique visitors don't add up to the total but instances do?

The unique visitors metric does not add up to individual line items when line items are dates(trended). Each line item (such as day, week, or month) receives credit for every period the visit/visitor touched, but the total is deduplicated.

Pls refer foll article.

https://helpx.adobe.com/analytics/kb/sum-line-items-different-from-total.html

https://marketing.adobe.com/resources/help/en_US/reference/reports_unique_visitors_v15_dsc.html

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded