A | B | C | |
---|---|---|---|
1 | #REF! | TAGS v6.0 | |
2 | 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 | tags.hawksey.info OR hawksey.info/tagsexplorer/ | <- 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 | default | |
15 | Follower count filter | 0 | <- 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 | 2,468 | |
20 | Unique tweets | 2,234 | |
21 | First Tweet | 15/09/2014 07:51:45 | |
22 | Last Tweet | 14/10/2015 19:26:10 | |
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 to use these views | ||
26 | TAGSExplorer | <- conversation explorer | |
27 | |||
28 | TAGS Archive | <- searchable archive | |
29 | |||
30 | News | ||
31 | TAGS v6.0 is here! Includes streamlined twitter connection experience and new support site | ||
32 | http://tags.hawksey.info/ | ||
33 | #REF! | ||
34 |