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 |
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 |