SOLVED
Calculated Metrics: How to create at a device type level
I am looking to create a calculated metric that sets a different value for Device type = Mobile and another one for Device type = Desktop.
Example:
If homepage has page view & on mobile device, then set value for those hits to $2.
If homepage has page view & on desktop device, then set value for those hits to $1.
When I look at the report - at the mobile and desktop rows, the calculated metric is correct.
However when I look at the overall homepage total, it doesn't give the correct total value by adding both the rows. I do not want to be having each of these desktop / mobile rows on every report i run. I just want to see the total for a page.
See below how I am thinking of giving different value to the homepage depending on device
What I basically want is a list of sections or pages on our site - without having to use the breakdown of mobile / desktop.I just want an overall value.
When I look at the page itself with no device type, its taking the value of the homepage mobile views only as total. But the overall total is stranger, no idea how it got 120k.
Topics
Topics help categorize Community content and increase your ability to discover relevant content.
1 Accepted Solution
Correct answer by
Hi, I replicated using this:
The problem is the IF statement looks at the data in aggregate... since at the total level (row or column), there are pages from both desktop and mobile, the IF logic basically meets both criteria, so the first clause will always be true... if mobile is first, ALL the total will be doubled, if desktop is first then it won't be doubled...
You might want to try doing these as separate columns.. one for Desktop, one for Mobile, then a third column adding the two together:
Desktop:
Mobile:
Result:
(note the first column is just so you can see the original PVs, and that the new Total column is not it doubled)
This way you can have the breakdown as your pages, without needing the row breakdowns by Device Type. I know it might not be ideal to have the columns split out, but I think this is the only option based on how it works....
Correct answer by
Hi, I replicated using this:
The problem is the IF statement looks at the data in aggregate... since at the total level (row or column), there are pages from both desktop and mobile, the IF logic basically meets both criteria, so the first clause will always be true... if mobile is first, ALL the total will be doubled, if desktop is first then it won't be doubled...
You might want to try doing these as separate columns.. one for Desktop, one for Mobile, then a third column adding the two together:
Desktop:
Mobile:
Result:
(note the first column is just so you can see the original PVs, and that the new Total column is not it doubled)
This way you can have the breakdown as your pages, without needing the row breakdowns by Device Type. I know it might not be ideal to have the columns split out, but I think this is the only option based on how it works....
Thanks @Jennifer_Dungan
Step one complete, when we look at the homepage and add another page "checkout", you can see total is working at both row and column.
However...when I look overall at another dimension, let's just pick anything - say "Day" dimension. The total is adding mobile and desktop - but the overall number in the same row of "Day" just at the top doesnt make sense. Why is it showing 93,783 when below in the segments you can see only homepage and checkout are the only ones, and my formula is just looking at those two pages. And its using HIT level segments.
