Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Total is different from the sum API

Avatar

Level 2

I am having troubles understanding how Adobe Analytics calculates the totals. I used the API debugger to copy the request. When I sum the response values I get a different (higher) sum from the one in total . I am looking at the metric visits and dimensions daterange .... Any ideas ? 

1 Accepted Solution

Avatar

Correct answer by
Employee

@user04080,

As I can see the dimension being used is "Page" and applied metric filters like "Day" and "referrer type".

There could be a possibility that a single visit has more than 1 page and all the pages had the same referrer type as it is based on visit container. In report all the pages would be available as separate line item and would be having 1 visit against all the page and referrer type but in total it is actually one visit.

 For 1 visitor 1 visit, report would be like:
Page         |       Visit(Day and referrer type)
-------------------------------------------------------------
Page A     |           1 (Feb. 1st, Search Engine)
Page B      |          1 (Feb. 1st, Search Engine)
--------------------------------------------------------------
Total        |             1

 

View solution in original post

4 Replies

Avatar

Employee

@user04080 ,

This is happening because of deduplication.

Suppose a visitor started the journey on the site at 11:55pm (Feb. 1st) made 5 hits and ended the visit at 12:05am(Feb. 2nd) next day. 
The data in API/workbook would look like:
Day        |          Visit
------------------------------
Feb. 1    |              1
Feb. 2    |              1
-----------------------------
Total        |             1
If you do the sum of individual line items it will be 2 but due to de-duplication total here would be 1 as the visit made by the user was only 1.
Hope this helps.

Avatar

Level 2

Thanks for your answer. I am actually requesting the data for the same date. Here is my request 

{
	"rsid": "xxxxx",
	"globalFilters": [
		{
			"type": "dateRange",
			"dateRange": "2022-02-01T00:00:00.000/2022-02-02T00:00:00.000"
		}
	],
	"metricContainer": {
		"metrics": [
			{
				"columnId": "0",
				"id": "metrics/visits",
				"filters": [
					"0",
					"1"
				]
			}
		],
		"metricFilters": [
			{
				"id": "0",
				"type": "breakdown",
				"dimension": "variables/daterangeday",
				"itemId": "1220101"
			},
			{
				"id": "1",
				"type": "breakdown",
				"dimension": "variables/referrertype",
				"itemId": "3"
			}
		]
	},
	"dimension": "variables/page",
	"settings": {
		"countRepeatInstances": true,
		"limit": 50000,
		"page": 0,
		"nonesBehavior": "return-nones"
	}
}

Not sure why I would have de-duplication if it's for the same date.

Avatar

Correct answer by
Employee

@user04080,

As I can see the dimension being used is "Page" and applied metric filters like "Day" and "referrer type".

There could be a possibility that a single visit has more than 1 page and all the pages had the same referrer type as it is based on visit container. In report all the pages would be available as separate line item and would be having 1 visit against all the page and referrer type but in total it is actually one visit.

 For 1 visitor 1 visit, report would be like:
Page         |       Visit(Day and referrer type)
-------------------------------------------------------------
Page A     |           1 (Feb. 1st, Search Engine)
Page B      |          1 (Feb. 1st, Search Engine)
--------------------------------------------------------------
Total        |             1