Social Media Data Analysis Overview:
Social Media Data Analysis Overview: Explore the Twitter & Facebook data for your company and others like you
Jennell McIntire - Last Updated 2/22/2012
Contents
Purpose ......................................................................................................................................................... 3 Data ............................................................................................................................................................... 3 Analysis ......................................................................................................................................................... 4 Conclusion ..................................................................................................................................................... 7
Social Media Data Analysis
Purpose The purpose of the Social Media Data Analysis demo is to illustrate how Twitter and Facebook data can be combined in one QlikView document to compare and analyze Twitter and Facebook activity and sentiment for six companies. This demo allows a company, My Company, to compare their Twitter and Facebook statistics to five other companies in their industry.
Data The data used in this demo was collected by Industrial Codebox using QVSource. The Twitter Connector and the Facebook Pages Connector were used to extract the data. This demo is not supported by QlikTech and documentation on how to use the Twitter and Facebook Pages connectors can be found at www.qvsource.com. The demo includes Twitter data from September 12, 2011 to October 15, 2011. The following types of tweets were collected for all six companies: • • • •
Tweets containing the company name Tweets containing the hashtag “Company Name” Tweets sent from “Company Name” Tweets sent to “Company Name”
Facebook data included in this demo is from January 2, 2011 to October 14, 2011. Data was collected from the individual Facebook pages for the six companies. Sentiment data was also collected for this demo. Sentiment analysis is the processing of words to determine the attitude of the writer regarding some topic. Sentiment analysis data for tweets, posts and comments were collected using 2 different sentiment analyzers for each social media site. The sentiment scores were determined based on the first 140 characters. The tweet, post or comment was sent to the analyzer via URL which then returned a score. Since the range differed for the various analyzers, a new field was created in the data model assigning the sentiment score to either -1 (negative), 0 (neutral) or 1 (positive).
Social Media Data Analysis
Analysis Below is some of the analysis that can be performed in the Social Media Data Analysis demo by sheet: Intro – The bar chart on the Intro sheet compares the number of negative tweets/posts/comments to the number of positive tweets/posts/comments by company. It also shows the ratio for the positive number of tweets/posts/comments to negative number of tweets/posts/comments.
Social Media Data Analysis
Dashboard – The Dashboard sheet compares Twitter and Facebook data such as the number of tweets/posts/comments over time and sentiment.
Social Media Data Analysis
Twitter Analysis – The Twitter Analysis sheet focuses on just Twitter data and compares the companies with regards to the number of followers they have, klout score and overall average sentiment. Klout is a service that measures a user’s influence across a social network. It measures the size of someone’s network, the content created and how other people interact with that content. Other various statistics such as reach (number of unique Twitter users reached by a tweet) and Share of Voice (percentage of tweets for one company versus competitors) can also be found on this sheet. Below is a glimpse at the top portion of the sheet.
Social Media Data Analysis
Facebook Analysis – The Facebook Analysis sheet focuses on just Facebook data and compared the companies with regards to “likes” and sentiment. This sheet also takes a look at Share of Voice and analyzes the number of external posts versus internal posts the companies have. Below is a glimpse at the top portion of the sheet.
Conclusion The Social Media Data Analysis demo demonstrates how social media data can be used by a company to determine how they compare to their competitors. Keeping in mind that sentiment is subjective, this demo provides insight into what people are talking about (tweeting/posting/commenting) and how often they are doing it.
Social Media Data Analysis
Jennell McIntire - Last Updated 2/22/2012
Contents
Purpose ......................................................................................................................................................... 3 Data ............................................................................................................................................................... 3 Analysis ......................................................................................................................................................... 4 Conclusion ..................................................................................................................................................... 7
Social Media Data Analysis
Purpose The purpose of the Social Media Data Analysis demo is to illustrate how Twitter and Facebook data can be combined in one QlikView document to compare and analyze Twitter and Facebook activity and sentiment for six companies. This demo allows a company, My Company, to compare their Twitter and Facebook statistics to five other companies in their industry.
Data The data used in this demo was collected by Industrial Codebox using QVSource. The Twitter Connector and the Facebook Pages Connector were used to extract the data. This demo is not supported by QlikTech and documentation on how to use the Twitter and Facebook Pages connectors can be found at www.qvsource.com. The demo includes Twitter data from September 12, 2011 to October 15, 2011. The following types of tweets were collected for all six companies: • • • •
Tweets containing the company name Tweets containing the hashtag “Company Name” Tweets sent from “Company Name” Tweets sent to “Company Name”
Facebook data included in this demo is from January 2, 2011 to October 14, 2011. Data was collected from the individual Facebook pages for the six companies. Sentiment data was also collected for this demo. Sentiment analysis is the processing of words to determine the attitude of the writer regarding some topic. Sentiment analysis data for tweets, posts and comments were collected using 2 different sentiment analyzers for each social media site. The sentiment scores were determined based on the first 140 characters. The tweet, post or comment was sent to the analyzer via URL which then returned a score. Since the range differed for the various analyzers, a new field was created in the data model assigning the sentiment score to either -1 (negative), 0 (neutral) or 1 (positive).
Social Media Data Analysis
Analysis Below is some of the analysis that can be performed in the Social Media Data Analysis demo by sheet: Intro – The bar chart on the Intro sheet compares the number of negative tweets/posts/comments to the number of positive tweets/posts/comments by company. It also shows the ratio for the positive number of tweets/posts/comments to negative number of tweets/posts/comments.
Social Media Data Analysis
Dashboard – The Dashboard sheet compares Twitter and Facebook data such as the number of tweets/posts/comments over time and sentiment.
Social Media Data Analysis
Twitter Analysis – The Twitter Analysis sheet focuses on just Twitter data and compares the companies with regards to the number of followers they have, klout score and overall average sentiment. Klout is a service that measures a user’s influence across a social network. It measures the size of someone’s network, the content created and how other people interact with that content. Other various statistics such as reach (number of unique Twitter users reached by a tweet) and Share of Voice (percentage of tweets for one company versus competitors) can also be found on this sheet. Below is a glimpse at the top portion of the sheet.
Social Media Data Analysis
Facebook Analysis – The Facebook Analysis sheet focuses on just Facebook data and compared the companies with regards to “likes” and sentiment. This sheet also takes a look at Share of Voice and analyzes the number of external posts versus internal posts the companies have. Below is a glimpse at the top portion of the sheet.
Conclusion The Social Media Data Analysis demo demonstrates how social media data can be used by a company to determine how they compare to their competitors. Keeping in mind that sentiment is subjective, this demo provides insight into what people are talking about (tweeting/posting/commenting) and how often they are doing it.
Social Media Data Analysis
