How can I show Deposits and Registrations instead of Total Conversions in Looker?

Looker Q&A Looker Studio
1

In my Looker report I currently only see Total Conversions, but I need to display Deposits and Registrations separately.
How can I configure this properly — via Floodlight (or the correct conversion event setup) so that deposits and registrations appear as separate metrics?

2

To display these metrics separately, you don’t need to change anything in Floodlight (as long as the Deposit and Sign-up tags are already distinct activities there). You just need to filter the data within Looker using Calculated Fields.

This transforms “Deposits” and “Registrations” into their own standalone metrics, allowing you to calculate specific conversion rates or place them side-by-side in a table.

In your report, click on your data source or directly on “Add a field”.

Create a field for Sign-ups (Registrations) using the following formula:

CASE
WHEN Conversion Name = ‘Exact Sign-up Tag Name’ THEN Conversions
ELSE 0
END

CASE
WHEN Conversion Name = ‘Exact Deposit Tag Name’ THEN Conversions
ELSE 0
END

3

CASE
WHEN Conversion Name = ‘Exact Sign-up Tag Name’ THEN Conversions
ELSE 0
END

When I enter this formula, it says “invalid formula”.

Also, could you please explain how this formula understands from the total conversions which one is a registration and which one is a deposit? Because these metrics don’t exist separately in general.