Data Dictionary for Twitter CSV/Excel ExportsΒΆ
Social Feed Manager captures entire tweets, with all their data. To download selected, processed fields for each tweet in a user timeline, use the csv export option, available on each user page.
This data dictionary currently only describes SFM’s Twitter exports. Tumblr, Flickr, and Weibo exports contain fewer columns that are generally self-explanatory and/or are similar to the columns described here in the Twitter export.
For more info about source tweet data, see the Twitter API documentation, including Tweets and Entities.
Field | Description | Example |
---|---|---|
created_at | Date and time the tweet was created, in Excel-friendly format. | 12/1/2016 1:22:35 AM |
twitter_id | Twitter identifier for the tweet. | 114749583439036416 |
screen_name | The screen name of the account that authored the tweet, at the time the tweet was posted. Note that an account’s screen name may change over time. | NASA |
followers_count | Number of followers this account had at the time the tweet was harvested. | 235 |
friends_count | Number of users this account was following at the time the tweet was harvested. | 114 |
favorite_count/ like_count | Number of times this tweet had been favorited/liked by other users at the time the tweet was harvested. | 12 |
retweet_count | Number of times this tweet had been retweeted at the time the tweet was harvested. | 25 |
hashtags | Hashtags from the tweet text, as a comma-separated list. | Mars, askNASA |
mentions | Other Twitter accounts mentioned in the text of the tweet, separated by comma and space. | NASA_Airborne, NASA_Ice |
in_reply_to_screen_name | If the tweet is a reply, the screen name of the original tweet’s author. | wiredscience |
twitter_url | URL of the tweet. If the tweet is a retweet made using the Twitter retweet feature, the URL will redirect to the original tweet. | http://twitter.com/NASA/status/394883921303056384 retweet redirecting to original tweet: http://twitter.com/NASA/status/394875351894994944 |
text | The text of the tweet. Newline characters are stripped out. | Observing Hurricane Raymond Lashing Western Mexico: Low pressure System 96E developed quickly over the... http://t.co/YpffdKVrgm |
is_retweet | Yes if tweet is a retweet of another tweet, according to the tweet’s metadata; otherwise No. | Yes |
is_quote | Yes if tweet is a quote of another tweet, according to the tweet’s metadata; otherwise No. | No |
coordinates | The geographic coordinates of the tweet. This is only enabled if geotagging is enabled on the account. The value, if present, is of the form [longitude, latitude] | [-0.22012208, 51.59248806] |
url1 | First URL in text of tweet, as shortened by Twitter. | http://t.co/WGJ9VmoKME |
url1_expanded | Expanded version of url1; URL entered by user and displayed in Twitter. Note that the user-entered URL may itself be a shortened URL, e.g. from bit.ly. | http://instagram.com/p/gA_zQ5IaCz/ |
url2 | Second URL in text of tweet, as shortened Twitter. | |
url2_expanded | Expanded version of url2; URL entered by user and displayed in Twitter. Note that the user-entered URL may itself be a shortened URL, e.g. from bit.ly. | http://instagram.com/p/gA_zQ5IaCz/ |
media_url | URL of the media embedded in the tweet. If the media embedded in the tweet is a video, this is the URL of the video’s thumbnail image | http://pbs.twimg.com/media/Cyir15CVIAAfAWd.jpg |