Adobe Analytics

mike_vargas · 5/31/16

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

TanmayMathur · 6/1/16

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

Let me know if this information was helpful. Thanks!

Tanmay

mike_vargas · 6/1/16

In your reply, it sounds like you are suggesting I'm comparing a "visitors" report to a "pages" report. I'm comparing the "pages" report for all pages, and all but 2 pages. Your answer doesn't make sense to me.

esthert38368486 · 6/29/16

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.

Gigazelle · 6/29/16

What's the exact dimension and exact metric you're using? Does the date range include today? Do they line up if you instead use the 'instances' metric?

esthert38368486 · 6/29/16

I am using a date range of 6/14-6/29 (today). They do line up if I use the 'instances' metric but I am, and want to be, using the 'unique visitors' metric. Do you know why they do not add up with unique visitors?

esthert38368486 · 7/1/16

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

shalup · 6/6/18

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