AdTweets
Retrieve all of the advertising-enabled Tweets the authenticating user has access to.
View Specific Information
Select
The AccountId field is filterable server-side.
SELECT * FROM AdTweets WHERE AccountId = '1234'
SELECT * FROM AdTweets WHERE AccountId IN (SELECT Id FROM AdAccounts)
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. |
| Name | String | The name of the Tweet, also known as the Ad name in the Twitter Ads UI. This field might be returned as null if no input name is provided when creating tweets using the Tweet composer. The name that is displayed in the UI for these cases is the Card name. |
| AccountId | String | The Id of the advertising account this AdTweet is associated with. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| TimelineType | String | Whether to return nullcasted (a.k.a. 'Promoted-only') Tweets, organic Tweets, or both. Possible values: ALL, NULLCAST, ORGANIC |
| TweetType | String | The Tweet type of the tweets. Possible values: DRAFT, PUBLISHED, SCHEDULED |