ABC
1
Twitteralytics v2.3.1
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://www.google.com<- twitter like to know who you are site/blog url. Without this Twitter might stop giving results to you
10
Search term#ili2011<- can be as complex as you like and include search operators
11
Periodweekly<- either weekly or daily
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