AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
2.7K members online now
2.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Different Filters on Different Parts of Caluclated Metrics

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

Currently, I'm trying to create a calculated metric that uses different filters for the numerator and denominator of the calculation.


Has anyone found a way to do this? My current work around is to do the calculation inside of google sheets and import the number.

 

Example:

[Unique clicks to event action = abc where landing page = xyz] / [Sessions landing on page xyz]


Thanks!!

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Peter G
May 2016

Re: Different Filters on Different Parts of Caluclated Metrics

Top Contributor
# 2
Top Contributor
Hi Peter,

this is unfortunately not possible - limitations / options are listed here https://support.google.com/analytics/answer/6121409?hl=en#creating-calculated-metrics. In order to achieve what you listed in your question use a combination of Segments / Custom Report or similar.

Kind regards,
Zorin
Web analyst @ escapestudio.net

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Peter G
May 2016

Re: Different Filters on Different Parts of Caluclated Metrics

Top Contributor
# 2
Top Contributor
Hi Peter,

this is unfortunately not possible - limitations / options are listed here https://support.google.com/analytics/answer/6121409?hl=en#creating-calculated-metrics. In order to achieve what you listed in your question use a combination of Segments / Custom Report or similar.

Kind regards,
Zorin
Web analyst @ escapestudio.net