How effective is social media marketing?

I'm just in the start up stage of my company and want to establish it a bit more. Have read a few bits and bobs on it, but want some first hand advice. How effective do you think it is in terms of marketing your products and services? And are there any companies that will do it for you? I'm not that good technology wise ha!

Thank you, Joanne x