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! 😀