i've never had a successful attack with a ballista (by this, i mean they never do enough damage to be deemed successful but more a waste of time)
i odn't use them because i dont use them effectively and i would "invest in another unit of archers" or more appropriately CHARIOT ARCHERS