I would like to add values across multiple columns when using various Data Studio Connectors, like Facebook ads, Adwords, and Analytics, but the custom metrics do not calculate properly if any of the columns contain null values.
For instance, suppose I want to add multiple actions within the Facebook Ads Connector, such as Leads (form) + website leads, the results will look like this:
|Campaign||Leads (form)||Website Leads||Total Form Fills (Custom Metric)|
Is there a way to convert null values to 0 or some other way to get columns to add up properly?
Unfortunately this is something that we cannot influence. Many people have been discussing about the same Data Studio issue at https://www.en.advertisercommunity.com/t5/Data-Studio/Replacing-No-Data-with-0/td-p/999599#