How to create a single conversion metric using Data Studio's calculated metrics

Note: This is a tip submitted by a Joinr user for manipulating Joinr data using Data Studio's calculated metrics. It's a nice solution, but should be considered a "workaround" or a "hack" that's not technically supported by Joinr. Your results may vary.

Joinr doesn't offer native functionality isolate a specific conversion as its own metric, but we have had users achieve this using Data Studio's calculated metrics. 

(And if you think we should add this feature, let us know!)

If you haven't used Data Studio's calculated fields before, browse this link:

Add, edit, and troubleshoot calculated fields

One you're comfortable with calculated fields, you can use the following formula to create a new metric for a specific conversion:

CASE WHEN Conversion Name = "Insert Name Here" THEN Conversions
ELSE 0 END

Swap out "Insert Name Here" for the desired conversion name (e.g. Purchases, Landing Page views) and you should be all set! (Note: The formula is case sensitive)

This solution also works for isolating revenue — just swap out "Conversions" for "Revenue" in the formula above.

Did this workaround help make your report better? Do you have a better option? Have additional questions? Let us know by emailing support@joinr.com.