On the eve of Twitter's much hyped initial public offering, Randi Zuckerberg, sister of Facebook founder Mark Zuckerberg, tells CNBC that video is the best way social media companies can engage users.