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
4.4K members online now
4.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

calculated metric (CTR) based on same dimension metrics

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

hello

i have this doubt (i think its not possible to solve it, but if would be nice to have this): im trying to calculate CTR of a Category Event (in GA): 

basically, I have 2 event categories, which are: 

 

popup_views

popup_clicks

 

how can i create a calculated metric if the dimension is the same "Event Category"?

Is there a way to filter, within the formula, to take only Event Category = popup_click / Event Category = popup_views * 100 

or something like that? 

 

thanks a lot for help

eugenio