A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | TAGS v6.0 | |||||
2 | NS - New Sheets Created by mhawksey. Read more about this at: | |||||
3 | http://tags.hawksey.info | |||||
4 | With this spreadsheet you can: | |||||
5 | - automatically pull results from a Twitter Search into a Google Spreadsheet | |||||
6 | Instructions: | |||||
7 | 1. If there is no TAGS menu click this button --> 2. If you've never run TAGS > Setup Twitter Access do so now (this should only need be done once for all your TAGS sheets) | |||||
8 | ||||||
9 | 3. Enter term | #musedmot | <- you can use serach operators like AND OR as well as from: and to: eg '#JobsNow AND from:BarackObama' (without quotes) | |||
10 | ||||||
11 | 4. Make a one off collection with TAGS > Run now! or set a trigger to collect every hour TAGS > Update archive every hour. To change the frequency open Tools -> Script Editor then Triggers -> Current script's triggers... and adjust | |||||
12 | Advanced Settings: | |||||
13 | Period | -6 days | ||||
15 | Follower count filter | 1 | <- if search term is being spammed you can set the minimum followers a person must have to be included in archive | |||
16 | Number of tweets | 3000 | <- maximum varies based on the type of archive you are collecting | |||
17 | Type | search/tweets | <- use a search term in step 3 above to get results from last 7 days | |||
18 | Stats | |||||
19 | Number of Tweets | 1,637 | ||||
20 | Unique tweets | |||||
21 | First Tweet | 23/05/2012 01:26:41 | ||||
22 | Last Tweet | 07/06/2013 20:26:52 | ||||
23 | Make interactive | |||||
24 | Turn your archive into an interactive online resource using TAGSExplorer - see http://bit.ly/TAGSsetup | |||||
25 | Note: File > Publish to the web and Share > Anyone with link to use these views | |||||
26 | TAGSExplorer | <- conversation explorer | ||||
27 | ||||||
28 | TAGS Archive | <- searchable archive | ||||
29 | ||||||
30 | News | |||||
31 | ||||||
32 | http://tags.hawksey.info/ | |||||
33 | #NAME? | |||||
34 |