CSV Export Data DictionaryΒΆ

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.

For more info about source tweet data, see the Twitter API documentation, including Tweets and Entities.

Field Description Example
sfm_id SFM internal identifier for tweet 6114
created_at UTC time when the tweet was created 2013-10-28T17:52:53Z
created_at_date date in Excel-friendly format, MM/DD/YYYY 10/28/2013
twitter_id Twitter identifier for the tweet 114749583439036416
screen_name The screen name, handle, or alias that this user identifies themselves with. Screen_names are unique but subject to change. NASA
followers_count Number of followers this account had at the time the tweet was harvested 235
friends_count Number of users this account is following at the time the tweet was harvested 114
retweet_count Number of times the tweet has been retweeted at the time the tweet was harvested. If the tweet is a retweet AND the retweet was done using the Twitter retweet feature (i.e. is_reweet_strict = TRUE) the retweet_count reflects the retweet count for the original tweet. If the retweet was done by typing RT at the beginning (is_retweet_strict = FALSE) the retweet_count reflects retweets of the retweet. 25
hashtags Hashtags which have been parsed out of the tweet text, separated by a comma and space Mars, askNASA
in_reply_to_screen_name If the tweet is a reply, the screen name of the original tweet's author wiredscience
mentions Other Twitter users mentioned in the text of the tweet, separated by comma and space. @NASA_Airborne, @NASA_Ice
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
is_retweet_strict Tweet is a retweet of another tweet, using Twitter's retweet function FALSE
is_retweet SFM's best guess at whether tweet is a retweet of another tweet; includes retweets accomplished using old-style method of placing RT in front of tweet TRUE
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]
text The UTF-8 text of the tweet Observing Hurricane Raymond Lashing Western Mexico: Low pressure System 96E developed quickly over the... http://t.co/YpffdKVrgm
url1 First URL in text of tweet, as shortened by Twitter http://t.co/WGJ9VmoKME
url1_expanded Expanded version of URL; URL entered by user and displayed in Twitter. May itself be a user-shortened URL, e.g. from bit.ly. Further expansion available in sfm web interface, not in csv export. http://instagram.com/p/gA_zQ5IaCz/
url2 Second URL in text of tweet, as shortened by Twitter  
url2_expanded Expanded version of URL; URL entered by user and displayed in Twitter. May itself be a user-shortened URL, e.g. from bit.ly. Further expansion available in SFM web interface, not in csv export