We often have users ask for tips on using spreadsheets to analyzeÂ social media data. In this video, we give a quick tutorial on how to use a google spreadsheet formula to search and filter for keywords within tweets (this process will work also in Microsoft Excel). We’ve found this kind of analysis highly useful for understanding what is driving the conversation around a specific brand or topic. Breaking down the tweets by keywords helps dig a level deeper. In this example we analyze tweets about RowFeeder for mentions of “twitter,” “data,” and “facebook.”Â In the past, we used the search function to look for mentions of “goal” and “ref” during Sounders games.
Try one of our 14 free reports to analyze your Twitter, Facebook, Google+, YouTube, or Instagram presence
Or, get access to the full suite of Simply Measured social media analytics report - over 48 and counting!