This section describes the metadata and sample reports for the Twitter Adapter.
The following table lists and describes the available metadata for the Twitter Adapter.
Metadata |
Description |
---|---|
account_settings |
Used to retrieve the account settings for a Twitter user. |
followers_list |
Used to retrieve a list users following a specific user. |
search_tweets |
Used to search for tweets based on a query string. |
statuses_retweets |
Used to retrieve the first 100 retweets of a specific tweet. |
statuses_user_timeline |
Used to retrieve the most recent tweets for a Twitter Screen Name. |
twtsampl/tw_tweet_sentiment |
Describes a SQL Server table loaded by the tw_datamigrator_sentiment_load DataMigrator flow. The table contains Sentiment Scores for Twitter tweets. Used when the WAND Sentiment Analysis Adapter is configured. |
twtsampl/tw_tweets |
Describes a SQL Server table loaded by the tw_datamigrator_load DataMigrator flow. The table contains Twitter tweets. |
twtsampl/tw_tweets_to_sentiment |
Cluster Join from tw_tweets to wandscore; wandscore metadata is created from the WAND Sentiment Analysis Adapter. Used by the tw_datamigrator_sentiment_load DataMigrator flow. |
twtsampl/tw_user_info |
Describes a SQL Server table loaded by the tw_datamigrator_load DataMigrator flow. The table contains user information. |
The following table lists and describes the sample reports for the Twitter Adapter.
Sample Report |
Description |
---|---|
twtsampl/account_settings |
Retrieves the account settings for a Twitter user. Uses: account_settings |
twtsampl/followers_list |
Displays a list of users who a follow a specific Twitter user. Uses: followers_list |
twtsampl/search_tweets |
Search for all public posts containing a specified query string. Query operators: word1 word2 Containing both words. This is the default operator. "word1 word2" Containing the exact phrase. word1 OR word2 Containing either word1 or word2. word1 -word2 Containing word1 but not word2. #word1 Containing hashtag word1. from:ScreenName Tweets sent from a specific Screen Name. to:ScreenName Tweets sent to a specific Screen Name. @ScreenName Referencing a specific Screen Name. word1 since:YYYY-MM-DD Containing word1 and sent starting at a specific date. word1 until:YYYY-MM-DDContaining word1 and sent before a specific date. Uses search_tweets. |
twtsampl/statuses_retweets |
Reports on the first 100 retweets of a specific tweet. Uses: statuses_retweets |
twtsampl/statuses_user_timeline |
Reports on the tweets for a specific Screen Name. Uses: statuses_user_timeline |
twtsampl/tw_create_datamodel |
Creates the SQL Server tables used for the Twitter Data Model loaded by the tw_datamigrator_load and tw_datamigrator_sentiment_load DataMigrator flows. As a prerequisite, a SQL Server connection called socialmedia must be configured as well as the creation of a SQL Server database called Twitter. |
twtsampl/tw_delete_datamodel |
Deletes the SQL Server tables used for the Data Model. |
twtsampl/tw_tagcloud_tweets |
Tag cloud graph for tweets. The Words Analysis adapter must be configured. Uses: twtsampl/tw_join_datamodel_excluding_sentiment wan_document (Words Analysis metadata) |
twtsampl/tw_tweet_report |
Reports on Twitter tweets and user information. Uses: twtsampl/tw_tweets twtsampl/tw_user_info |
twtsampl/tw_tweet_scored_report |
Reports on Twitter tweets and user information including sentiment. Uses: twtsampl/tw_tweets twtsampl/tw_user_info twtsampl/tw_tweet_sentiment |
The following table lists and describes the DataMigrator flows for the Twitter Adapter. The Twitter Data Model must first be created by running twtsampl/tw_create_datamodel.
Flow |
Description |
---|---|
twtsampl/tw_datamigrator_load |
Data flow to load Twitter tweets and user information. |
twtsampl/tw_datamigrator_sentiment_load |
Data Flow to load Sentiment Scores for Twitter tweets. |
Information Builders |