TAGS - v3.2 #dev8d
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABC
1
TAGS v3.2Beta
2
Created by mhawksey. Read more about this at:
3
http://mashe.hawksey.info/twitteralyticsv2/
4
With this spreadsheet you can:
5
- automatically pull results from a Twitter Search into a Google Spreadsheet
6
Instructions:
7
Setup video http://www.youtube.com/watch?v=vpckqM0acaQ - this is for version 2

1. Enter settings for search term etc below

2. To test the collection from the menu above select Twitter -> Test Collection (you might need to hit the setup button twice. The first time prompts for script authorisation, before you can run the setup properly)

3. You can control the type of data returned by changing the column heading in the TMP sheet.

4. To automatically collect results set a script trigger by Tools -> Script Editor then Triggers -> Current script's triggers... -> 'No trigger set up. Click here to add one now'. Then select collectTweets for Run and Time-driven for Events and choose Day timer for dailly updates or Week timer for weekly.

5. If you aren't getting any results back it usually indicates that you are being rate limited. To improve the number of results you can get run the Twitter > API Authentication

*Note* If using 'continuous' search results it can only go back 100 tweets so set the scheduling of the trigger accordingly.

If you want to do date manipulations on the created_at results then you can use the function =VALUE(MID({date_cell};5;21)) where {date_cell} is the created_at cell reference
8
Settings:
9
Who are youhttp://hawksey.info<- twitter like to know who you are site/blog url. Without this Twitter might stop giving results to you
10
Search term#dev8d<- can be as complex as you like and include search operators
11
Perioddefault<- either default or yesterday (if NOT using default switch to 'paged' below)
12
No. results1500<- how greedy you want the search to be (max 1500 per search)
13
Continuous/pagedcontinuous<- continuous will add results to a single sheet, paged adds results to a new sheet
15
Make interactive
16
Turn your archive into an interactive online resource using TAGSExplorer - see http://bit.ly/TAGSsetup
Loading...
 
 
 
Readme/Settings
Archive
Summary
Dashboard
Edges
Vertices
SNA Metrics
TMP