There are a number of different things that a social media consultant can do for you. They may help you to develop an overall strategy for using social media to effectively promote your site. They may help you to determine what types of content you could use to target social media users that would be relevant to your site. They may actually write the content for you. And, they may also help with promoting the content and getting votes for you.