Ask. by Levesque Ryan
Author:Levesque, Ryan
Language: eng
Format: epub
Published: 2015-04-20T16:00:00+00:00
COLUMN U: SMIQ (SINGLE MOST IMPORTANT QUESTION)
Between Column A and Column U, I’ve “hidden” all the data we won’t be using (e.g., Session ID, IP Address) to simplify what we’re looking at. Column U is where we list the answers to our open-ended Single Most Important Question (SMIQ).
COLUMNS V, W, X
This is where we list what categories each respondent falls into in each of our multiple-choice questions:
• Column V: Full-Time vs. Part-Time (FULLPART)
• Column W: Biz Owner, Consultant, Employee, etc. (TYPE)
• Column X: Revenue category (REVENUE)
COLUMNS AA, AC, AE
In these columns, we use a simple formula that spits out a 1 if the field in the previous column contains data and is not blank.
For example, if someone provides their PHONE in Column AD (which is hidden), Column AE spits out a 1. If they do NOT provide their PHONE in Column AD, Column AE spits out a 0.
This allows you to sort all the people who provided their name, email, and phone number—which, as you’ll see in a moment, we’ll be using in our analysis.
COLUMN AF: LEN
In this column, we use an MS Excel formula called “length” (LEN) to calculate the number of characters from our prospect’s response to our open-ended SMIQ. This tells us how long each prospect’s response is.
The reason why response length is vitally important is because it’s an indication of hyper-responsiveness, which is a leading indicator of how likely someone is to purchase a paid solution for the problem or challenge about which we’re asking.
In plain English, all things being equal, the longer a prospect’s open-ended response is, the more likely they are to be a buyer of whatever it is you’re selling.
For example, let’s say you’re selling a medical device that helps reduce back pain, and if you, as the business owner, ask, “What’s the single biggest challenge you’re having with back pain right now?”
Let’s pretend someone types in, “My back hurts.”
And the second person types in, “Five years ago I got into a car accident; it was a head-on collision; I had to go through physical therapy for six months; I went through three different back-pain medications; I was even on morphine for a period of time; I’ve been out of work for the last two-and-a-half years; I can’t hold down a stable job and it’s all because I can’t sit down in an office chair and I’ve been trying to find a solution for the last five years and I’m desperate to find anything that works.”
Which of those two respondents is more likely to purchase a product if you have a solution that solves their problem? The second one, of course. This is why we pay attention to response length, and why it’s so important.
COLUMN AG: MULT
The next column is MULT, which stands for multiplier. This column uses a simple MS Excel formula to check if the PHONE field is > 0 (i.e., if someone has provided us with their phone number). If they have, then the formula spits out a 1.5. If the person did not provide their phone number, it spits out a 1.
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Direct | Global |
Industrial | Multilevel |
Product Management | Research |
Telemarketing | Web Marketing |
Influence: The Psychology of Persuasion by Robert B. Cialdini(4162)
The Miracle Morning by Hal Elrod(3894)
The Hacking of the American Mind by Robert H. Lustig(3566)
Pre-Suasion: A Revolutionary Way to Influence and Persuade by Robert Cialdini(3394)
Unlabel: Selling You Without Selling Out by Marc Ecko(2967)
Hidden Persuasion: 33 psychological influence techniques in advertising by Marc Andrews & Matthijs van Leeuwen & Rick van Baaren(2753)
Who Can You Trust? by Rachel Botsman(2721)
Kick Ass in College: Highest Rated "How to Study in College" Book | 77 Ninja Study Skills Tips and Career Strategies | Motivational for College Students: A Guerrilla Guide to College Success by Fox Gunnar(2711)
Purple Cow by Seth Godin(2681)
Ogilvy on Advertising by David Ogilvy(2663)
I Live in the Future & Here's How It Works by Nick Bilton(2509)
This Is Marketing by Seth Godin(2463)
The Marketing Plan Handbook: Develop Big-Picture Marketing Plans for Pennies on the Dollar by Robert W. Bly(2400)
The Power of Broke by Daymond John(2366)
Building a StoryBrand by Donald Miller(2346)
The 46 Rules of Genius: An Innovator's Guide to Creativity (Voices That Matter) by Marty Neumeier(2297)
Draw to Win: A Crash Course on How to Lead, Sell, and Innovate With Your Visual Mind by Dan Roam(2268)
The Tipping Point by Malcolm Gladwell(2191)
Market Wizards by Jack D. Schwager(2148)