Showing posts with label small business. Show all posts
Showing posts with label small business. Show all posts

Wednesday, February 4, 2009

Small Business Web Tip: Collect data quickly using a web form

At the Small Business Technology Summit this week, I was asked "what's the one action these small businesses can do today to have an impact on their business" (I put that in quotes - but I'm sure I've tweaked the question a bit to match my answer ;).
I answered, "Create a form - a survey - for free, which you can email to your customers to immediately find out what they think of your product or service". A bunch of people asked me for more information - so I figured it would be useful to post a quick "Web Tip" here... If you don't feel like reading, there are also plenty of public videos on this topic done by others.

If you want to first get a sense of what one of these Forms would look like, you can answer my example survey about blogging. If you do, try to really answer it, and maybe we'll get some useful results I can share.
The below might seem like a bunch of steps, but this can literally take 10 minutes - it's the thinking about which questions to ask and what multiple choice questions to offer, which is the hard and important part.

How to collect data for free using Google Docs Forms:

Step 1:
Go to Google Docs - http://docs.google.com
Sign-in or get an account. You need a google account, but that doesn't mean a Gmail account necessarily (see my old video on that topic).

You should see your list of Docs - if you've used the service before - or an empty list (which, actually then, isn't a list at all if there's nothing in it... it's just a frame)


Step 2:
Click the "New" dropdown button on the upper left - and choose "Form".

You'll be taken to a new window which is the "Form Editor". It starts you off with an automatic first question called "Name" - just to remind you that you may want to ask (optionally) for the respondants name - and leaves you in edit mode on question #2.
When editing the form - you edit one question at a time (click the pencil button on the right) and click "done" as you finish setting up each question.

At this point you can go back and edit the first question (example - add some help text to tell people that "Name is optional, but helps me know who you are").

The default field type is "Text" - but you *should* use multiple choice or scale questions where possible - as those give great quantitative summaries - and if you want people to type a more descriptive answer, change the question type to "paragraph text".

Step 3:
Finish entering all your questions and click the "Save" button at the top. Keep the form rather short if possible - nobody likes to answer a long survey - and you won't want your second survey to be ignored if you decide to do another one in a few weeks/months.

Step 4:
Make your own confirmation message. After someone responds to your form, they get a generic "Thanks!" message - but you can edit that to create your own message. You can include valid URLs to have a link on that page. At the top of the form editor, there is a "More Actions" button. Click that and select the option "Edit Confirmation".

Step 5:
Send the form! You have a few ways to get the form into the hands of your potential respondents:
1 - Send the form using email... If you select the "email this form" option, you can enter the email addresses of respondents and they will get the form EMBEDDED in their email message if they use Gmail or Yahoo mail (those are the only popular mail systems which allow that) - or - they will get a link to a separate web page which contains your form.
2 - Embed the form on your blog or website. The other option in the "more actions" button is "embed" - that gives you the HTML code you can embed in your blog post, blog template or website so people can answer the form directly from there.
3 - Get the URL of the form and IM/mail it directly to your potential respondents. The URL can be copied from the bottom of the form editor screen, where it says "You can view the published form here:".

Step 6:
Go see your form. Click on that link at the bottom of the Form Editor to make sure your form looks as you intended. That's how others will see it. [NOTE: You can test the form, but there is currently an issue where the form response count will not be reset, even if you remove your test response]

Step 7:
See your responses! The form you created actually created a spreadsheet in the background. After saving your form - close that form editor window and go back to your Google Docs list. Find your form/spreadsheet on the docs list and click it to open it. You'll see a spreadsheet with the questions you asked as the column headers (with one additional column as the first, which is the timestamp of each reply). If you already sent the form out, the spreadsheet may already contain responses which have been received. If you hang out there for a while, you may even see responses appear in real time (that's fun).


Step 8:

See your reponse summary. From the spreadsheet, click on the "Form" menu at the top and click on "Show Summary". That takes you to a page which summarizes, in chart format where feasible, the responses to each question.

Step 9:
Set up notifications so that you know when people respond to your form.
Click the "Share" button (on the upper right of the spreadsheet window) and select "Set notification rules". In that dialog, select the options "[when] A user submits a form", and choose either "Email - dialy digest" or "Email - right away", depending on how many responses you expect to get and how much you want to spam yourself.

Some Tips:

> *Do not* try to re-arrange the questions on the spreadsheet itself. There are issues where the form and the spreadsheet get out of sync if you do that. Re-arranging should be done from the form editor only - where questions can be dragged and dropped into the order you want them.

> There is not yet a way to restrict people to filling out the form only once.

> *Do not* "PUBLISH" the resulting spreadsheet or set it to "Anyone can view" unless that's really what you need. Those settings are NOT necessary to make the form broadly available, and it might let people see the results of the survey which you may not have intended.

> If you are HTML-ready, you can take the Form page and tweak the HTML to give it style or additional logic - just *never* change the POST URL or the NAME ATTRIBUTES on the HTML form object in that page. You'll also need your own place to host the updated HTML page. This isn't something you'll be able to get much support on from the Google Docs help center - so only do this if you are feeling lucky ;)

Have fun!

Tuesday, February 3, 2009

Small Business Summit in NYC


I attended the Small Business Summit in NY yesterday. Met many great people and had an opportunity to be on a Panel with Michael Shultz (Microsoft) and Harry Brooks (Network Solutions) moderated by Brent Leary (CRM Essentials and Business Technology Radio). I Had a chance to express some of my thoughts about how web-based social media and collaboration tools create opportunities for people to "keep and nurture loyal customers" (that was the official title - though we covered a wider set of concepts). Also got some great reminders about what small business focus on every day - and in particular, the importance of the search and ads side of the web. That stuff is highest on the small businesses "need to know, need to improve" list in most cases. More coverage of the conference can be found here.

There were a couple of points made during and after our panel which probably warrant more instruction and link or two for those of you who couldn't understand my babbling and happen to find me here... Here's two I can think of - but ping me here if there were others.

Create a Form on Google Docs
I suggested that you "Poll your customers and get their opinions directly and immediately [into a spreadsheet]"... Here's a link to the Google Docs Help Center on that topic. I'm also going to post a quick how-to here on my blog soon, since so many people have asked me for detailed instructions and a sample. (look for that soon)
[Update Feb 5: Here's that "Creating Forms" web tip post]

Use YouTube to collect videos about your product or service
I mentioned how you can create a channel on YouTube to collect videos about a specific topic, which could be useful for prospective customers, particularly when current customers have created those videos. We did that on the Google Docs team - we created the Google Docs Community channel. It's good for customers, for discovery and for the video creators who want more views/exposure.

Thursday, June 14, 2007

Learn Decision making skills from the (US) government

At first I was quite surprised with the "wealth" of information available on the Small Business Administration site.... at least at a high level - ya'know, squinting. They have 4 nicely organized sections to "Plan your business", "Start your business", "Manage your business" and "Getting out"... So I'm looking through the basic headlines of each subsection thinking "hey, this is pretty good..." seeing things like "Choose a structure" and "Lease Equipment" and "Get Insurance" - a total of 30 sub-categories, including the one which caught my eye enough to go deeper, labelled "Make Decisions".

Following that link gave me three subsequent links - including the winner of my next click, called "Are You A Good Decision Maker?".

Here lies the key secrets to government beauracracy (which they apparently think should now be applied to small businesses).
The first section, called "Ten Steps to Wise Decision-Making" should actually be called 'Ten ways to put off making a decision for as long as possible'... Each step requires deeper and deeper analysis of the potential alternatives - with no limits - starting with defining the decision to be made and the insightful lesson to ask yourself "Do you really need to make a decision? (if you do not have at least two options, there is no decision to be made)". Then to "Brainstorm as many different alternatives as you can imagine - let your imagination run free..." - including the wise suggestion to "just be sure to write everything down" (clearly there was an auditor on the editorial staff). The next 6 steps require further discovery and then deeper dives into all the potential alternatives of your pending decision which may exist in this universe and elsewhere (at this point, I fully expected them to suggest that I go search my grandmother's attic - or attend 4 more years of college to uncover even more potential alternatives).... afterall, "Additional information generally leads to more alternatives"... so I should "check out", then "Sort through", then "visualize the outcomes", then "do a reality check" (you think they did one?), then, finally, pick the "wise decision" and "Get started!". So here in step 9 is where the true decision-making spirit glistens... "Second-guessing yourself will only cause grief" so "you always have the option of changing your mind in the future" - which sounds like a euphamism for 'go to step 3 and randomly choose another of your deeply analyzed 417 potential alternatives'. Oh my.. step 10 actually does suggest this - "If the decision did not come out the way you planned, go through the complete decision-making process again"....

So, I'm guessing this process wouldn't work well for decisions like "Should I check my parachute?" - cause if I am unhappy with decision alternative #17 in that case, I'm probably not able to "go through the complete decision-making process again". I know, an extreme example - but just needed to make the point... 'cause even a decision like "should we spend our full year's marketing budget on this TV ad" is not exactly reversible...and it feels as important as the parachute example to the small business owner...

The best part (yes, better than the other best part) was in the next section labelled "Common-decision making mistakes" where they list "Not listening to your feelings or gut reactions" as a mistake... Huh?! The process never mentioned anything about intuition or gut reaction before now!! Where was that advice when I needed it! I could have saved 4 months and 62 yellow pads if I just listend to my gut from the beginning!! Why'd ya tell me to keep looking for alternatives!!

Yeah... I'm sure they just mis-titled this whole thing...