- Share a more organized summary by compiling questions and answers into a document.
- Make it easy to review insights that were shared.
- Possibly identify contributors and influencers for future conversations.
- Support bloggers who want to post a recap.
This is a manual process involving rapidly categorizing tweets after the event and then sorting them into summaries. For real-time curation, see Storify.
SETUP: Install Tweet Archivist.
SAMPLE OUTPUT: https://t.co/Us88hlO5
- In Tweet Archivist, search for the tweetchat hashtag.
- Click on Export to Excel.Save the text file to your computer.
- In Microsoft Excel or another spreadsheet program, open the text file. (Tab-delimited.)
- Sort the tweets by date and delete any tweets before the start date.
- Move the username column to the left of the tweet text.
- Sort the tweets by title.
- Above the first category of question (ex: A1), insert a row and merge those cells. Do that for each category.
- Copy the questions (ex: Q1) into the merged cells.
- Copy the Q1, A1, … tweets into Microsoft Word.
- Click on Table Design and unchec Header Row. Choose the light blue striped table.
- Select each question (Q1, etc) and give them the Heading 1 style.
- Add a header and footer (see sample).
- Upload to Scribd and tweet the link.