Zero vs Null for analytics data

Hi everyone,

I am building an analytics tool and curious on the best practices in storing data when it comes to zero vs null

For example, if there was zero add to carts today

Do we store that as zero or null in the database?

The issue with using zero is when checking average add to carts for example, it skews the data

Thank you