Gravity
Search…
⌃K

AdTweets

Columns

Name
Type
Description
ID [KEY]
String
The Id of the status update or tweet. Set this value when inserting to retweet an existing tweet.
IDLong
String
The long type Id of the status update or tweet.
SearchTerms
String
The SearchTerms to search against. This cannot be used with the Screen_Name or User_Id inputs. For more information on using the advanced query operators, see the Twitter API documentation here: https://dev.twitter.com/docs/using-search. Roughly 1500 results can be returned using the SearchTerms.
Created_At
Datetime
When the tweet was made.
Text
String
The text of the tweet.
Lang
String
Language code the tweet was made in.
Source
String
Source of the tweet.
Favorited
Boolean
Boolean indicating if this tweet has been favorited.
Favorite_Count
Integer
The approximate number of times this tweet has been favorited.
Retweeted
Boolean
Boolean indicating if this tweet has been retweeted.
Retweet_Count
Integer
The number of times the tweet has been retweeted.
Retweeted_Status_Id
String
Id of the tweet which was retweeted by this one. Empty if the current tweet is not a retweet.
Truncated
Boolean
Boolean indicating if this tweet has been truncated.
Filter_Level
String
Indicates the maximum value of the Filter_Level parameter that can be used and still stream this tweet.
Possibly_Sensitive
String
This field is available only when a tweet contains a link. The meaning of the field does not pertain to the tweet content itself, but instead it is an indicator that the URL contained in the tweet may contain content or media identified as sensitive content.
Withheld_Copyright
Boolean
When present and set to true, indicates that this piece of content has been withheld due to a DMCA complaint.
Withheld_Scope
String
When present, indicates whether the content being withheld is the status or a user.
Withheld_In_Countries
String
A list of uppercase, two-letter country codes this content is withheld from.
Contributors
String
An XML collection of user objects (usually only one) indicating users who contributed to the authorship of the tweet, on behalf of the official tweet author.
Coordinates_Coordinates
String
The geographic coordinates of this tweet (longitude first, then latitude).
Coordinates_Type
String
The type of coordinate, if applicable.
Place_Full_Name
String
The full name of the location of this tweet (city and state).
Place_Country
String
The country of origin of this tweet.
Current_User_Retweet_Id
String
Details the tweet Id of the authenticated user's own retweet (if it exists) of this tweet.
Scopes
String
A set of key-value pairs indicating the intended contextual delivery of the containing tweet. Currently used by Twitter's promoted products.
In_Reply_To_Status_Id
String
Represents the Id of the original status if this tweet is in reply to another.
From_User_Id
String
Id of the user who made the tweet. Use this in the WHERE clause to get tweets for the specified user.
From_User_Screen_Name
String
Screen name of the user who made the tweet. Use this in the WHERE clause to get tweets for the specified user.
From_User_Name
String
Name of the user who made the tweet.
From_User_Location
String
Location of the user who made the tweet.
From_User_Profile_URL
String
URL to the user who made the tweet. This is not returned when a SearchTerms is specified.
From_User_Profile_Image_Url
String
URL to the profile image for the from user.
To_User_Id
String
Id of the user who made the tweet. Use this in the WHERE clause to get tweets for the specified user.
To_User_Screen_Name
String
Screen name of the user who made the tweet.
User_Mentions
String
Mentions of other users in the tweet, returned as an XML aggregate.
URLs
String
URLs in the tweet, returned as an XML aggregate.
Hashtags
String
Hashtags in the tweet, returned as an XML aggregate.
Media
String
Media in the tweet, returned as an XML aggregate.