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