DEPRECATED use TSR instead
HootSuite is a great tool for managing and monitoring your Twitter accounts. However, it's rather difficult to export search data. That's why I wrote HootSuite Extractor (HSE).
With HSE, you can export your search streams as shareable HTML reports.
Here's how it works:
Download & install the HSE Chrome Extension. I haven't uploaded this to the Chrome webstore yet, so you'll have to install it as an "unpacked extension," but don't worry, it's only scoped to HootSuite's domain.
Create your search streams in HootSuite and click the extension icon. The extension grabs the HTML source for the entire page and feeds it to a Flask webapp.
Input your original search terms as a comma separated list (e.g. #brunch, hackathon) and click
Run Report. It can take 2-3 minutes to process the data. Hang in there.
Voila! HSE will render a report with tweets separated by search term. It's automatically uploaded on S3, so you can share it with colleagues, clients, etc.
There are some bugs & issues here and there - but it works. If you've got ideas for improvement, let me know!