We use a very specifically formatted google spreadsheet to work on writing tweets.

The Strategy: Planning a drip campaign

This is usually done for repeating events 1x per month and takes about 2 hours to add everything to the spreadsheet.

• Check the MeetUp Calendar for upcoming classes
• Add 3 rows per event assuming you have at least 3 or more weeks before the events
• Fill out columns A-G and J
  • A: n for not schedules
  • B: Tweet = x for yes
  • C: Facebook = x for yes
  • D: Instagram = x for yes
  • E: Type, choose from the dropdown
  • F: Topic (simple description)
  • G: Date of Class/event
  • J: Link to Meet up, Facebook or another relevant item
• Calculate postdates by going into the cell and creating a formula that subtracts 21, 7 and 3 days, or however many days you judge to be a good amount of mentions to attract folks to the event. Try to avoid too many tweets/posts in one day.

Adding Copy

• Use the sort function of the spreadsheet to show you upcoming classes by date and topic that have not been scheduled
• Choose one class and write copy for 1-3 posts
• Look at the link to the event to learn more about the event or chime in on slack

Scheduling posts in Hootsuite