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
star_border
Reply

Sum conversions and clicks by name and type

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

Hi! everyone!

I want to SUM all the conversions in Adwords with the name "Booking call" and all clicks with the type "Phone Call"

 

There's any way to do it??

 

I tried to create a metric called "Conversions - Phone call" with this formula: SUM(CASE WHEN Segment Conversion Type Name = "Booking calls" THEN 1 ELSE 0 END)

 

Then, create another metric called "Clicks - Phone calls" with this formula: SUM(CASE WHEN Click type = "Phone calls" THEN 1 ELSE 0 END)

 

Finally, create another metric called: "Total phone calls" with this formula: "Clicks - Phone calls + Conversions - Phone call"

 

But is not working. Any suggestions? 

Sum conversions and clicks by name and type

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hi, did you figure this one out? I have the same issue...