Identifying micro- and macro- characteristic lengths governing sound wave properties in cellular foams