Data connector details

  • Category: Social Media
  • Connector type: Standard

Description

Use the Twitter connector to search and analyze tweets posted on Twitter.

Data limitations

Stratifyd does not impose the same limitations that Twitter imposes on a standard search, but for very large amounts of data you may want to limit it yourself using the Comment Limit option or by narrowing the date range.

If you have issues with no data, try widening your date range on the second page of the wizard.

Input fields

When setting up the connector, provide the query to return the Tweets that you want to analyze. 

  • Query: Enter your search terms using the Query syntax in the table below.
  • Comment Limit: To avoid returning too much data, it is a good practice to set a limit on the number of comments returned.

You can change your date range on the second page of the wizard, or optionally Schedule data crawls to update your data stream periodically.

Data dictionary

This connector returns the following fields that you can use in analysis.

Content

  • Description: Free-form text of the Tweet.

crawler_time_stamp

  • Description: Date and time when the record was crawled in numeric format.

DataSource

  • Description: Data source of the Tweet.

Date

  • Description: Date and time of the Tweet in numeric format.

DisplayName

  • Description: Display name of the person who posted the Tweet.

ExpandedUrl

  • Description: Full URL of any link within the Tweet.

FavoriteCount

  • Description: Number of people who liked the Tweet.

ResponseCount

  • Description: Number of people who responded to the Tweet.

RetweetCount

  • Description: Number of people who shared the Tweet.

TweetUrl

  • Description: URL of the Tweet.

UserID

  • Description: ID number of the person who posted the Tweet.

UserName

  • Description: Username of the person who posted the Tweet (the unique name that is included in the profile URL).

Data

  • Description: Adds all output fields to a list visualization.

Query syntax

Stratifyd uses Twitter's standard search endpoint. We support all of the operators listed in the Twitter Using standard search document except the one that lists NASA's astronauts in space.

  • 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.

Did this answer your question?