| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Instructions for using the messages in Hootsuite | |||||
2 | 1 | In column A, set your Date and time for hootsuite either (DD/MM/YYYY 24Hr time) or (MM/DD/YYYY 24hr time) | ||||
3 | 2 | In column B set your message | ||||
4 | 3 | In column C, set a temporary column to calculate the character count. You will delete this column before upload. Use the formula =LEN(B1) to count | ||||
5 | 4 | In column D, add your hyperlinks, if any. Use a URL shortener like bit.ly or other to shorten the links. | ||||
6 | 5 | Before upload ensure the tag(s) you will be using and make sure they are properly referenced in each of your messages. | ||||
7 | 6 | If also posting to Facebook, copy and paste everything, deleting column C, to another worksheet. On this worksheet do a find replace to remove all of the hashtag references. If you've shortened anything that doesn't make sense without a hashtag, go ahead and expand the description here. | ||||
8 | 7 | To upload to Hootsuite, make sure you've removed column C and your weblink column is the new column C. Make sure the page you want to upload is the first tab - hootsuite will only upload the first tab. I start with twitter, then switch to Facebook. Save your file as a CSV (comma separated value) | ||||
9 | 8 | Select your accounts and upload each worksheet. Save the worksheet with a new name as a record of what you've uploaded. | ||||
10 | 9 | Do not assume all messages apply to your organization or timing during an incident. Review twice, send once. | ||||
11 | Read each message to make sure it appropriately suits your agency. Ensure that you change web addresses as appropriate and include the relevant hashtags without exceeding 140 characters. | |||||
12 | 10 | Sample graphics on Canva are here: https://www.canva.com/sacramentooes | ||||
13 | ||||||
14 | Send suggestions for other categories and messaging to @maryjofly or email mjflynn001@gmail.com | |||||
15 | ||||||
16 | ||||||
17 | ||||||
18 | ||||||
19 | ||||||
20 | ||||||
21 | ||||||
22 | ||||||
23 | ||||||