Google Ads custom columns in Looker studio custom fields

[Samuelz]

Hi all,

I'm trying to create a custom field in Looker Studio that resembles a custom column I've created in Google Ads. I'm trying to create metrics with specific conversion actions and calculated fields of ratios between them. I tried using filters in combination with All conv. but then I can only see one conv. per table at a time. So for example: if I want to have in one table sums of the following conv. actions:

• Step 1
• Step 2
• Step 3

and the conv. rates between them, it is not possible to have them in the same table with a filter.

I tried also creating a custom filed with this formula:

CASE WHEN `Segment Conversion Type Name` = "Step 1" THEN `All conv.` ELSE 0 END

But it's a binary formula that returns 1 or 0 so I can't sum the no. of conv. for this particular event.

There must be some way to create a custom field that sums one conv. event right?

Bless be upon you for sharing the solution! 😀

[murilomedeiros]

+1

[leticiath]

Did you find out? I have the same problem.

[Samuelz]

Unfortunately no...

[阿泰]

Hi, here is my solution. I hope this will help you. For example, if I have three conversion events: "purchase," "add to cart," and "checkout," then Looker Studio will count them as 1; otherwise, it will count as 0.

CASE
WHEN `Segment Conversion Type Name` IN ("purchase", "add to cart", "checkout") THEN 1
ELSE 0
END