Question about breakdowns and metrics

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)

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)