Data Studio
5.5K members online now
5.5K 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...