Twitter Search

You can query and extract Twitter's tweet data.

Note that due to the Twitter Search API’s restriction, the data is supposed to be only for the last 7 days, though it usually returns 6 to 9 days of the data in most cases.

Number of tweets returned will often be less than what was specified by the user. This can happen because (a) the search query did not return many results (the search pool is already thinned out from the population of tweets to begin with), (b) because user hitting rate limit for a given token, or (c) of recent activity (either more tweets, which affect pagination in returned results or deletion of tweets).

1. Select Twitter Search Data Menu

Click '+' button next to 'Data Frames' and select 'Import Cloud Apps Data'.

Click 'Twitter Search'

2. OAuth Setting

Create a connection following this instruction.

3. Input parameters

  • Max # of tweets - Set max number of the tweets to return.

  • Language - Set a language code if you want to limit the tweets to certain languages. The code is ISO 639-1 alpha-2.

  • Last N Days - Set number of the past days for the search data.

  • Search Text - Type text to search.

Here's a list of the examples of how you can query tweets.

Operator

Finds Tweets...

watching now

containing both “watching” and “now”. This is the default operator.

“happy hour”

containing the exact phrase “happy hour”.

love OR hate

containing either “love” or “hate” (or both).

beer -root

containing “beer” but not “root”.

#haiku

containing the hashtag “haiku”.

from:interior

sent from Twitter account “interior”.

list:NASA/astronauts-in-space-now

sent from a Twitter account in the NASA list astronauts-in-space-now

to:NASA

a Tweet authored in reply to Twitter account “NASA”.

@NASA

mentioning Twitter account “NASA”.

politics filter:safe

containing “politics” with Tweets marked as potentially sensitive removed.

puppy filter:media

containing “puppy” and an image or video.

puppy -filter:retweets

containing “puppy”, filtering out retweets

puppy filter:native_video

containing “puppy” and an uploaded video, Amplify video, Periscope, or Vine.

puppy filter:periscope

containing “puppy” and a Periscope video URL.

puppy filter:vine

containing “puppy” and a Vine.

puppy filter:images

containing “puppy” and links identified as photos, including third parties such as Instagram.

puppy filter:twimg

containing “puppy” and a pic.twitter.com link representing one or more photos.

hilarious filter:links

containing “hilarious” and linking to URL.

puppy url:amazon

containing “puppy” and a URL with the word “amazon” anywhere within it.

superhero since:2015-12-21

containing “superhero” and sent since date “2015-12-21” (year-month-day).

puppy until:2015-12-21

containing “puppy” and sent before the date “2015-12-21”.

movie -scary :)

containing “movie”, but not “scary”, and with a positive attitude.

flight :(

containing “flight” and with a negative attitude.

traffic ?

containing “traffic” and asking a question.

For more details, please visit Twitter's Tweets Search page.

4. Preview and Import

Click Preview button to see the data back from Twitter. If it looks ok, then you can click 'Import' to import the data into Exploratory.