| A | B | C | |
|---|---|---|---|
1 | Export TwapperKeeper Archive | ||
2 | Created by mhawksey. Read more about this at: | ||
3 | http://mashe.hawksey.info/2011/12/free-the-tweet/ | ||
4 | With this spreadsheet you can: | ||
5 | UKSG twitter archive pre-2012 See the Archive worksheet (tab below) for archive of tweets. This archive of tweets was imported from the now defunct (and merged in to hootsuite) TwapperKeeper. The Import functionality was developed and documented by Martin Hawksey (see links above). The UKSG twitter archive based on Martin's template was set up by Chris Keene. For tweets after 2012 see https://docs.google.com/spreadsheet/ccc?key=0AhQrW07ARKGcdFItVjNEZ1l2Y081RXJQclhZaERXR1E&usp=sharing | ||
6 | Instructions: | ||
7 | 1. If you haven't already click File > Make a copy 2. Enter settings for archive name, type and size below | ||
8 | Settings: | ||
9 | Name | uksg | <- archive name (without '#' or '@') |
10 | Type | hashtag | <- can be hashtag, person or keyword |
11 | No. results | 15000 | <- 15000 works best |
12 | |||
13 | Test archive settings | http://twapperkeeper.com/rss.php?type=hashtag&name=uksg&l=15000 | |
14 | 3. Click the button (twice, once to authorise the script and second to run it ) -> [Tip: when you click the 'Get the Archive' button make sure the setting cells are still not active] Find out how to keep archiving your tweets in Google Spreadsheets at http://mashe.hawksey.info/twitteralyticsv2/ For more things you can do with Google Spreadsheets and Twitter visit http://bit.ly/SpreadsheetsAndTwitter | ||
15 | |||