• Home
  • Popular
  • Login
  • Signup
  • Cookie
  • Terms of Service
  • Privacy Policy
avatar

Posted by G Bot


03 Feb, 2025

Updated at 08 Feb, 2025

Blended Tables Returning Null Values Where No Data

I am blended multiple data sources together to be able to add up paid ad spend across our channels and also our Shopify account to be able to give an accurate CPA figure without inflated channel reporting. 

However, some of the paid channels have not been live on certain dates, so the data is missing on those dates, and same for the Shopify conversions where our store didn't make any sales on those days. When these get pulled into the blended data source, they are showing up as null instead of 0, therefore when I add the to the calculated fields, it is skipping dates with a null field, throwing all my results. 

I have tried IFNULL and COALESCE formulas to try and get the NULL fields to show 0, and therefore add together, but nothing is working for me, it just keeps skipping the dates which include NULL, which is throwing all my results off. I did also try to create a date sheet in Google Sheets to ensure all the dates are there in each data source, but this didn't work either. 

I am using SuperMetrics to bring in the Shopify and Ad Platform figures (Meta and TikTok), while incorporating Google Ads natively. 

If anyone has any suggestions, it would be much appreciated!

I have tried  Screenshot 2025-02-02 at 15.30.54.pngScreenshot 2025-02-02 at 15.31.24.pngScreenshot 2025-02-02 at 15.31.45.png