HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!)

HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) - YouMoz

seomoz.org 08 Mar '12, 5pm

HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!)

Track updates from any niche conference or event (through the official hashtag). In this particular case, archiving is very essential because your archive will let you find testimonials for your next event or quotes for your event coverage, etc. Monitor most recent link building opportunities . I for one use Twitter search to instantly react to niche guest posting invites; Monitor your own brand mentions (both linked and unlinked). Here's one post I did previously on awesome Twitter search operators that let you filter out all the clutter and track only very essential brand mentions (for example, filter out Twitter updates that contain links and only listen to "real" conversations); Keep an eye on your competitors and how they are doing on Twitter (for example, find negative mentions and be there to offer a better alternative) Identify active users and influencers within y...

Full article: http://www.seomoz.org/ugc/how-to-archive-twitter-search-r...

Tweets

@venkatvp » 05 Apr '12, 8am
HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) - YouMoz | SEOmoz [link] via @SEOmoz [like]
@chamada » 30 Mar '12, 3am
@Melodee681 Instructions here: [link]
@limaihuey » 27 Mar '12, 7am
RT @citiconnects: RT @seomoz: HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) - [link] - New YouMoz from...
@SamairaThakur » 17 Mar '12, 6pm
HOW TO: Archive #Twitter Search Results in a #GoogleSpreadsheet [link]
@seosmarty » 14 Mar '12, 6pm
Tool alert! Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link] via @SEOmoz
@hughmacken » 12 Mar '12, 4pm
HOW TO FREEBIE: Archive Twitter Search Results in a Google Spreadsheet and Analyze Them! / from @seosmarty [link]
@451Heat » 12 Mar '12, 2pm
How 2 Archive Twitter Search Results in a Google Spreadsheet (& Analyze Them!) via @SEOmoz [link] Do you use Twitter results?
@AnikoLecoultre » 12 Mar '12, 12pm
RT @DailySEO: HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link] via @SEOmoz
@MatthewForzan » 12 Mar '12, 11am
Great for tracking opportunities, competitors and more! HOW TO: Archive Twitter Search Results and Analyze Them! [link] #seo
@BlaesComm » 12 Mar '12, 2am
RT @aprilrendonvera: HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link] via @seomoz
@badassmarketing » 11 Mar '12, 5pm
Great stuff from @seosmarty via @SEOmoz - One great free tool to archive Twitter search results and analyze them! [link]
@seosmarty » 11 Mar '12, 12pm
One great free tool to archive Twitter search results and analyze them! [link] via @SEOmoz
@seotweetz » 10 Mar '12, 7pm
RT @Dick_Foster: HOW TO: Archive Twitter #Search Results in a Google Spreadsheet & Analyze Them [link] via @seomoz #seo
@lessheppard » 10 Mar '12, 4pm
HOW TO: Archive Twitter search results in a Google Docs spreadsheet [link] #twitter
@seosmarty » 10 Mar '12, 10am
@brian_mcdowell @glenngabe Thanks for your kind words on my Youmoz post! [link]
@JaspalX » 10 Mar '12, 9am
MT @seosmarty: Read my Youmoz post yet? -> Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link]
@JazzTyrrilSmart » 10 Mar '12, 6am
RT @ericlukazewski: HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link] via @seomoz #eventprofs
@1step2theleft » 09 Mar '12, 10pm
RT @seosmarty: Have you read my Youmoz post? Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link]
@ericlukazewski » 09 Mar '12, 10pm
HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link] via @seomoz #eventprofs
@jkvirtualoffice » 09 Mar '12, 9pm
OMG the geek in me loves this! HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link]
@brian_mcdowell » 09 Mar '12, 9pm
.@SEOSmarty always has good info - Archive Twitter Search Results in Google Spreadsheet (and Analyze Them!) [link]
@content_muse » 09 Mar '12, 8pm
@seosmarty Shows how to pour tasty Twitter data into G spreadsheets for analytic goodness [link]
@ExeCarrizo » 09 Mar '12, 7pm
RT @Xyborg: HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link]
@topfreelancer » 09 Mar '12, 7pm
HOW TO: Archive #Twitter Search Results in a #Google Spreadsheet (and Analyze Them!) [link] via @SEOmoz #sm
@mintblogger » 09 Mar '12, 5pm
HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link] #SEO #socialmedia
@HelenOster » 09 Mar '12, 5pm
12:00 #TwitterTip - How to archive Twitter Search Results in a Google Spreadsheet (& analyze Them) [link]
@redcrew » 09 Mar '12, 4pm
Woohoo, shoutout to @mhawksey for his Twitter Archive Google Spreadsheet app highlighted in @seomoz: [link]
@seosmarty » 09 Mar '12, 4pm
Thank YOU -> RT @mhawksey: thanks to @seosmarty for [link] & [link] and @JaspalX for [link] #ff
@mhawksey » 09 Mar '12, 4pm
also big thanks to @seosmarty for [link] & [link] and @JaspalX for [link] #ff
@nurubenzq » 09 Mar '12, 2pm
RT @SEOAware: HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) - SEOmoz [link]
@DazMSmith » 09 Mar '12, 1pm
RT @fortheloveofseo: HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link] (RT @SEOmoz)
@ruetsch » 09 Mar '12, 12pm
RT @Inboundorg: HOW TO: Archive Twitter Search Results in a Google Spreadsheet - [link] - Discussion - [link]
@Inboundorg » 09 Mar '12, 9am
HOW TO: Archive Twitter Search Results in a Google Spreadsheet - [link] - Discussion - [link]
@hsiao_yun » 09 Mar '12, 6am
RT @ashley: How To Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link]
@analyticsdennis » 09 Mar '12, 4am
Reading: HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) - YouMoz | SEOmoz: [link]
@ShatterboxVox » 09 Mar '12, 1am
Serious analytics | How to Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link] via SEOmoz
@i_abel » 08 Mar '12, 10pm
RT @aleyda: HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) - YouMoz | SEOmoz [link] ví ...
@gfiorelli1 » 08 Mar '12, 10pm
RT @aleyda: HOW TO: Archive Twitter Search Results in a Google Spreadsheet (& Analyze Them!) on @SEOmoz [link] vía @SEOmoz
@JaspalX » 08 Mar '12, 9pm
If you haven't seen it already @mhawksey you're on youmoz [link]
@seosmarty » 08 Mar '12, 8pm
Featuring awesome tool by @mhawksey in my today's Youmoz article! [link]
@seosmarty » 08 Mar '12, 8pm
@mitchmonsen @UTstartup @scottcowley Thanks for your support on my Youmoz article! [link]
@edSocialMedia » 08 Mar '12, 7pm
Results-driven tip! RT @SEOmoz: HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link]
@UTstartup » 08 Mar '12, 7pm
RT @mitchmonsen: Exceptional tool highlighted here: [link] Archiving Twitter Search Results by @seosmarty #UTstartup
@mitchmonsen » 08 Mar '12, 7pm
Exceptional tool highlighted here: [link] Archiving Twitter Search Results by @seosmarty
@MyKickAssIdeas » 08 Mar '12, 7pm
HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!): The author's views below are... [link]
@nick_eubanks » 08 Mar '12, 7pm
Use this. [link] @adjote @grrrando
@christen_george » 08 Mar '12, 6pm
How to archive & analyze Twitter search results in Excel. [link]
@acornseo » 08 Mar '12, 5pm
#News Blog: HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link] #seo
@fuzz1media » 08 Mar '12, 5pm
HOW TO: Archive Twitter Search Results in a Google Spreadsheet (and Analyze Them!) [link] #seo #fb
@MikeOverthrow » 08 Mar '12, 5pm
Gotta love a good scaper tool!>> "@SEOmoz: HOW TO: Archive Twitter Search Results in a Google Spreadsheet [link]"