Social Media Spreadsheet Tips: Search Keywords within TweetsAdam SchoenfeldBlogger ExtraordinaireSimply Measured
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.
Links and Resources Mentioned in this Tutorial:
The functions needed are: SEARCH, ISERROR, and IF.
The combined function looks like: =if(iserror(search(I$2,$C3)), “”, 1)
We made the spreadsheet in the video public, check it out here.
Adam is the Co-Founder and VP of Strategy at Simply Measured. In 2010 (aka the dark ages of social marketing), Adam joined Damon Cortesi and Aviel Ginzburg to found "Untitled Startup, Inc" with the goal of helping marketers and analysts use social data to do their best work. The company quickly evolved to become Simply Measured and the trusted leader in social analytics. Outside of Simply Measured, Adam is a golfer, breakfast enthusiast, and long-time data geek.
8 Awesome New RowFeeder Features [Unicorns on Hold]Adam SchoenfeldBlogger ExtraordinaireSimply Measured
It has been a crazy month here at RowFeeder! We had a great response to our last big release, including some nice mentions and articles in theÂ blogosphere. We’ve had an ongoing stream of amazing feedback as we’ve welcomed a ton of new folks to the RowFeeder family. We just added a handful of heavily requested… Continue Reading
#TCDisrupt: Twitter Tackles the TechCrunch ConferenceKevin ShivelyBlogger ExtraordinaireSimply Measured
This year, TechCrunch Disrupt went back to San Francisco, but it didn’t leave it’s fans in New York. Fans took to Twitter stronger than ever, using the hashtag #TCDisrupt over 39,000 times during the five day technology summit. TechCrunch brought in some awesome presenters this year, including a great array of start up founders and CEOs… Continue Reading
Which Magazines are Winning With Social Media?Kevin ShivelyBlogger ExtraordinaireSimply Measured
This week, Ad Age Magazine released it’s annual “Magazine A-List” which highlighted 10 Magazines that have made waves in the print media space this year. Winners were chosen based on what appears to be a variety of categories, from circulation, ad revenue, and strategic moves in the publishing industry. Being the data junkies we are here… Continue Reading
Introducing the New Simply Measured Facebook Fan Page ReportKevin ShivelyBlogger ExtraordinaireSimply Measured
Social Media isn’t static. The top networks are constantly evolving to become more useful, engaging and aesthetically bold. That’s why you continue using them. Simply Measured is no different. Our team of analysts and developers work tirelessly to make sure your reports are the most complete, easy to understand, and beautiful analytics tools available. In… Continue Reading