'Mystery' solved in expensive council campaign