How was the weekend?

Engagement can be simple and fun. Sometimes we make it too complicated.

This Tribal Tool-Kit ActionMap survey “How was the weekend?” asked:

1. On Friday, we look towards the next two days with certain expectations. How important were these aspects for you on Friday?
2. Now the weekend is over, how satisfied are you with the level of achievement with these aspects?

Below are the aspects and the numbers form the ActionMap key:

1. Socialising
2. Exercise
3. Catch up on home to-do list
4. Christmas preparation
5. Catch up on work to-do list
6. Relaxing

How was your weekend ActionMap

Interpreting the ActionMap

Who would have guessed that relaxing (6) would be the most important with the second highest level of satisfaction! It was just out-done by socialising (1), which wasn’t as important. Not a hugely healthy bunch of participants with exercising (2) having both low importance and satisfaction.  While both Christmas preparation (4) and Catch up on work to-do list (5) were not very important, participants were reasonably satisfied with their progress. There needs to be some improvement on catching up on the home to-do list (3)!

I wonder how it will look in six months time?

The ActionMap shows relative rating of importance and satisfaction. To translate this, the scale is stretched so that the minimum and maximum averages (+/-0.02) are the end points of the scale, not 1 and 7.

Now for the important information

The survey was open for less than 24 hours and had 36 participants who were invited through Twitter, Facebook and LinkedIn. The participants rated the statements on a 7 point scale (see below). No other information was collected. We don’t know who completed the survey and hadn’t invited only a targeted audience. Therefore, the survey results could be greatly biased, but we don’t know in which way (except we know they use online networking / social media as that was the only form of invitation).

For a business it would be better to invite people to participate through email so you know who the potential participants are, but can still guarantee their anonymity as the ActionMap survey doesn’t collect personal or provide you with raw data.

How the survey appears

You can do your own ActionMap, just head over to Tribal Tool-Kit.

Hyperlinked word clouds

CloudMaker feature explained: How to create a hyperlinked word cloud to place on a webpage, so that when the words are clicked they take you to a specific website page. An explanation of word clouds is on the CloudMaker webpage.

Case study background: Tony Cosentino started a guest book of people attending North Side Coffee Mornings (NSCM or #NCSM) that he has been posting to the North Side Coffee Mornings Posterous site. He wanted to create a word cloud of the people who have come along so the more often they have been to NSCM the larger their name is.

Before he got started we had a bit of a chat, the napkin shows our discussion about it.

Firstly, he set up a spreadsheet with the following format:

• A : Twitter name (eg: @katetribe).
• B : Formula of the sum of columns D, E, F, G etc.
• C : Website address for the twitter name (eg: http://www.twitter.com/katetribe).
• D : Date 1, then column E is date 2, etc. If a person attended an NSCM then they had a 1 put in cell for the dates they attended.

Secondly, the formula column B needs to be copied then paste special with only the values pasted (remember to not save the spreadsheet file as you will then loose the formulas). Then delete the date columns.

Thirdly, save the file with the 3 columns and no column headings as a csv.

Then it is time to play with CloudMaker in Tribal Tool-Kit.

• Click on Upload to CloudMaker.
• The title in this example is: NSCM Guestbook the last 6 weeks…
• The description in this example is: All guestbook data between 29 October 2009 and 3 December 2009.
• Select the file and then click upload.
• As the spreadsheet in this case is already edited there is no need to use the CloudMaker editing features.
• Click on Create word cloud from dataset.
• In the display options section change, Show HTML source to ‘yes’.
• Click ‘re-draw word cloud’ at the bottom of the screen.

Finally, copy the HTML code and paste it into the webpage you would like it to appear.

The outcome: The CloudMaker word cloud below is also on the Posterous site. They look slightly different due to website styling on each site.

Easy isn’t it!  Now other coffee mornings (as well as other events) can start a guest book from the start so that they can progressively create their own word clouds.

Mocks Facebook fan views of the weekend

The Mocks fan page is very active, so I thought it would be interesting to create a word cloud of the comments from: What kind of weekend did you and your Mock have – in one word?

They weren’t all one word, some had a little story, and we still included these. For example:

This is what we did to get the word cloud below:

• Copy and pasted the text into a spreadsheet
• Deleted the profile pic, time and ‘comment’. This left the comments.
• Did a few find & replaces.
  • Took out all the symbols by finding . , ) [ ! etc and replacing with nothing
  • To find spaces and replace with comma and space. This allows CloudMaker to make a series of words into separate words for the word cloud.
• Saved as a CSV file.
• Uploaded the CSV to Tribal Tool-Kit.
• Clicked on the ‘Amalgamate similar terms’ link (this will merge the same words so your words are easier to edit).
• Added a list of words to the stopword list. These were: i; my; to; and; the; a; are; comment; dont; for; im; in; it; of; they; still; is; come; with. This means that these words were still in the list of data, but won’t appear in the word cloud.
• Deleted from the list: don’t
• Merged some words that were similar so that they had a higher frequency and therefore appeared bigger:
  • Supercalifragilisticexpialidocious and supercalifragolisticexpialidociousi
  • BORING and boringi
  • disappointing and disappoint
  • Mockariffic and Mockorific
  • Mocktastic and mocktasstic
• Clicked on ‘Create word cloud from dataset’.
• Changed the font to: Comic Sans MS (Bold Regular).
• Changed ‘Convert case’ to ‘all lower case’
• Made the maximum frequency colour black (#000000)
• Made the minimum frequency colour pink (#CC3399)
• Changed the ‘Save options and formatting’ to ‘new template’
• Clicked on ‘re-draw Word Cloud’
• Gave the template the name ‘Mocks’ and clicked ‘Save’. There is an option to make the settings the default template so future word clouds have this format as soon as you click on the ‘Create word cloud from dataset’.
• Then clicked on ‘Save as image options’. You can save the word cloud as an SVG, PNG, or JPEG image format. JPEG is the lowest quality but opens in the most applications. The word cloud to the right is a JPEG format.

Simple. And interesting. Lipgloss is so big because we kept the 3 times it was said in the one comment shown above. Great to see the number of ways that fans put ‘mock’ into a word and that ’supercalifragilisticexpialidocious’ was used more than once!