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

Show percentage (field 1 is 100%, field 2 is x% of field 1)

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭



i set up a report with AdWords as datasource. On the report are 2 fields:


Field 1: AdWords cost for all keywords (100%)

Field 2: AdWords cost for keyword "example" (filtered field)


Now i want to show how much field 2 is of field 1 in percent (field 2 / field 1). Is there a possibility do to this directly or do i have to setup a custom metric? When a custom metric is necessary how will i do that? I cannot add the keyword filter to a custom metric or can i?



Please help :-)