Hootsuite CEO tells CNBC why companies need to develop a deep, cultural understanding of social media.