Question about breakdowns and metrics

Avatar

Avatar

crsilvap

Avatar

crsilvap

crsilvap

01-08-2018

Suppose I have the following breakdown imported from Data Warehouse

Dimension 1
Dimension 2Recipe Id (Target)Page ViewseVar Instances
ADBXXXXXXXX
AEBYYYYYYYY
AFGZZZZZZZZ

then I decide to remove Dimension 2 because It's not relevant for what I want to calculate, so I remove the column and aggregate the rows (using a tool like Excel or Python), leaving me with the following table

Before aggregation:

Dimension 1
Recipe Id (Target)Page ViewseVar Instances
ABXXXXXXXX
ABYYYYYYYY
AGZZZZZZZZ

After aggregation:

Dimension 1
Recipe Id (Target)Page ViewseVar Instances
ABXXXX + YYYYXXXX + YYYY
AGZZZZZZZZ

is this a valid operation? My intuition tells me that for Page Views and Instances this is valid since the rows are exclusive. On the other hand, if I had a Visits metric it may be invalid since XXXX and YYYY may share a same visit.

How about Recipe Id (Target) or any other Target dimensions? A hit may belong to many Target Activities (AB tests for example), but Target breakdowns are individual, so if I want all Dimension 1 Page Views for element A, it may be wrong to sum XXXX + YYYY + ZZZZ because there is a chance that all Page Views of A belong to both B and G, resulting in inflated numbers of Page Views.

Thanks for any help, I'm still learning about these concepts

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Gigazelle

Employee

Avatar

Gigazelle

Employee

Gigazelle
Employee

07-11-2018

It depends on what metrics you're using. If you're using anything that is not hit-based, like visits or unique visitors, they would not add up. If you're using hit-based metrics like custom events, they'll likely end up pretty close.

Answers (0)