The goals of a social media consultant include helping businesses increase their brand awareness, engage with their target audience, drive website traffic, generate leads, and ultimately achieve their marketing objectives through strategic and effective use of social media platforms.