Reply To: Calculating cpl when there’s no conversions (for a pivot table)

Just put cost per lead as 1 billion dollars.

Kidding aside, I don’t think there’s any real answer. Even when Google has a cost per conversion that’s undefined, it says “0,” so that when you aggregate all of the campaigns, your total cost per conversion is still accurate. Can you use “null” in place of 0?