Cleaning your list with Microsoft Excel

Posted on July 25, 2011 in Tools & Techniques

MailChimp provideds an excellent guide to cleaning email lists (removing duplicates and bounces) with Microsoft Excel when utilizing email marketing lists in marketing research.

MailChimp was originally built for companies that already have a list management system, but needed help with delivery. Since we clean your bounces for you in the list area, only those who clean an internal database manually would need to use these instructions.

Instructions for removing duplicates from your list:

  1. Open up Microsoft Excel.
  2. Paste your entire list into Column A.
  3. Sort the entire column alphabetically (A > Z). This is very important.
  4. Click on and highlight Column B.
  5. With Column B highlighted (press the gray B button above the column to highlight the entire column), enter the following into the “formula” box in Excel: =IF(TRIM(A1)=TRIM(A2),”",TRIM(A1))

Cleaning your list with Microsoft Excel

View the entire Cleaning your list with Microsoft Excel procedure.

 

InterVu 2.0 Webcam Focus Groups

Posted on July 18, 2011 in Industry News

MarketView Research is proud to support InterVu 2.0 Webcam Focus Groups.

An online qualitative research solution for respondents at different remote locations with full two-way audio and video capabilities. Now enhanced with a new project management portal and marking tool, FocusVision InterVu™ 2.0 harnesses the power of web conferencing and teleconferencing technology, so you can recruit hard-to-reach respondents anywhere in the world, at any time.

Continue Reading →

WEBCAM Focus Groups 101

Posted on July 18, 2011 in Industry News

The QRCA Views, Spring 2011 issue features an insightful article on the live qualitative focus group industry. The article enitled “WEBCAM Focus Groups 101″, contains several tips, techniques and key figures about this growing segment of the industry.

The last two years have witnessed significant growth in the number of “webcam focus groups” taking place. According to Inside Research’s 2010 “Online Qualitative Research Index,” the number of live qualitative “events” conducted online jumped 65% in 2009, with an estimated 32% growth in 2010.

Continue Reading →

CASRO: Evolving Mobile Research

Posted on July 18, 2011 in Opinion & Editorial

2011 CASRO Tech. Decipher’s Kristin Luck (winner of the 2010 Marketing Research Emerging Leader award) shares her thoughts on emerging mobile applications for market research.  Decipher’s President Kristin Luck won the 2010 Marketing Research Emerging Leader Award given by the American Marketing Association.

FRESNO, Calif. – May 11, 2010 – Decipher announces today that President Kristin Luck has been named a recipient of the 2010 Marketing Research Emerging Leader Award, honored by the American Marketing Association. A highly selective accolade, with four individuals chosen annually, the award honors those professionals who have made significant contributions to the field while demonstrating leadership and continued service.

“The AMA Marketing Research Council found Kristin Luck to be a clear and easy choice for the Marketing Research Emerging Leader Award,” says Matt Valle, chair for the 2010 Marketing Research Emerging Leader Award committee. “Kristin has been a true visionary in applying new technology to address marketing research challenges, and she has been very active in the industry push toward enhanced online research quality. In addition to her entrepreneurial successes, she has given back to the industry through frequent speaking engagements and by helping educate the next generation of insights professionals as an adjunct instructor at UCLA and SUNY Albany.”