Examples

This section describes the metadata and sample reports for the Twitter Adapter.


Top of page

x
Reference: Twitter Adapter Metadata

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.



x
Reference: Twitter Adapter Sample Reports

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-DD
Containing 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



x
Reference: Twitter Adapter DataMigrator Flows

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