The time taken by social media optimization campaigns to reflect on your business performance will depend on the result that you expect from the campaign.
If you are expecting an active social media presence, it can be done within a couple of weeks or a month. However, for the SMO services to generate website traffic and leads, it might take 3-6 months at the very least.