Twitter Analysis

Owned by Charles Bishop (Deactivated)
Jan 30, 2018
2 min read

This application analyzes the sentiment of tweets and identifies top hashtags and active users for your brand.  

Infographic

The Twitter Analysis application searches keywords for your brand to learn about your customers through social media. The data is analyzed and presented in the following charts and graphs:

  • The Overall Sentiment chart shows the distribution of your brand sentiment and if the words included in tweets about your brand are positive, neutral, or negative.
  • The Most Active Users graph identifies users who tweets the most about your brand. 
  • The Top 10 Hashtags widget lists popular hashtags that are associated with your brand. 
  • The Top Mentions widget shows connections between users and entities that mention your brand.
  • The Top 10 Hashtag Count table shows the number of popular hashtags associated with your brand.

Import and Connection

The TwitterRest connection uses the Twitter API to import data about your brand in the TwitterImportJob, (e.g Datameer). The S3 connection brings in sentiment dictionary data and uploads it using the SentimentDictionary import job.

Workbooks

The TwitterAnalysis workbook contains all of the necessary data and analysis to create the infographic. Tweets are tokenized and broken down into individual words which are joined with the words in the SentimentDictionary to find positive and negative sentiment. The most active users are determined by the frequency of tweets from each user. The Top10Hashtags worksheet is created by applying regular expression to identify hashtags and limit the count of those hashtags by top 10. Regular expression is also used to identify the connections between mentioned users and mentioning users, by sorting in descending order their conversation count, which feeds into the circular network widget.