How do I balance the customer's needs against my company's?
You can advocate well; the bind you feel is not a skill gap, it is the honest tension of standing between two real interests. Anyone who takes both sides seriously feels it. The ones who don't have simply stopped caring about one side. The way through is to stop seeing it as a tug of war with you in the middle. The best outcomes are usually the ones where the customer's real need and the company's real interest overlap, and part of your job is finding that overlap instead of just splitting the difference. A happy customer who stays is good for the company too. Argue from there. And when they truly cannot be reconciled, be honest about it rather than pretending. Tell the customer what you can and cannot do, plainly and kindly. People can handle a clear no far better than a vague maybe. Clarity, not endless balancing, is what keeps your footing steady.