Personality discovery template
This personality discovery template is a worksheet to explore your personality useful for determining your interests, passions and talents. Download it here
Spreadsheet enhancements to Personal Consumption Expenditures
Personal Consumption Expenditures (PCE) data is easily accessible and published monthly. But it is not very useful in its downloadable form, so I improved it with additional sheets for calculations and charts built on the fly. It is useful to take a look at top level consumer product categories to see their performance over [...]
What factors should I consider in deciding which product size to first launch?
This is a Quora question I was asked to answer. You are going to generally size based on the competing products already available to consumers. The reason is because that is what consumers expect and in many cases, supply chain, warehousing, e-commerce operations and store shelves are already optimized for the sizing sold. If you [...]
Format for consumer product feedback surveys and how it can correct for problems with getting accurate and reliable data
Here is a format for consumer product feedback surveys that I use. I take consumer product feedback surveys with a big grain of salt, for reasons listed here. But they have been useful for me when I follow the format below. Interview Format Could be a voice call, in-person/video or over email. Interview Process Describe [...]
How is e-commerce viable for low value products?
This is a Quora question I was asked. My answer as follows. That depends. You really need to maximize your average order value (AOV), ideally above $75 in order to make the e-commerce operation pay for itself and earn a profit. If you can do that, then yes. Subscription orders and repeat customers will help [...]
How can I get better margins for my products in my e-commerce business?
This is a Quora question I was asked to answer. By margins I am going to assume net margin, which is net income. Think of the flow of money in a consumer goods business as a way to help you improve margins. I have a spreadsheet model accompanying this graphic here. In the [...]
Simple model to determine success of product sampling in e-commerce
Here is a simple model to determine success of product sampling in e-commerce. I was presented with some quick performance metrics on an e-commerce product sampling campaign for a supplement startup, which included the cost of the sample plus shipping ($.70), the average order value ($39) and the response rate at 20%. That got my [...]