Project 1
Restaurant Reviews Content Analysis
due Wednesday, 30 SEP, midnight (11:59 PM)

Visit local.yahoo.com and do a content analysis of customer comments about a restaurants in Terrell, TX, 75160.  Enter the search term "dining", enter the location "Terrell, TX 75160", and sort by "Top Results".  Click HERE to directly reach a page that uses this search and this sorting. 

Your analysis must not be anecdotal, but must be based on an analysis that is substantiated with the spreadsheet method that was discussed in Week 3 (marketing research).  The objective of this research is to determine what factors cause people in Terrell, TX to like or dislike local restaurants.  Your report should end with recommendations regarding features that should be emphasized when someone in Terrell, TX opens a new restaurant. 

Do an analysis of the first 100 usable evaluations that are posted using the following guide: 

  1. Be sure that the list of reviews is sorted by "Top Results". 

  2. Don't use reviews of large national or regional chain restaurants.  E.g., skip Whattaburger and Sonic (large regional chains) as well as McDonald's and KFC (large national/international chains.  If you know a restaurant to be a chain (two or more locations), but suspect that few people outside of a hundred mile radius of Terrell would know about it, then include it in your analysis. 

  3. Don't use any review that appears to have a bias (e.g., states that the manager is a relative) or that is focused on issues that are not an assessment of the restaurant food or service (e.g., is a commentary on the behaviors of another customer). 

  4. For each restaurant on the list, use only the first review that directly shows next to the listed restaurant.  Click on the "more" tag if the review is longer than what shows in the space provided on the list, but do not click on any links that lead to more reviews than that first one that appears on the list.  When you click on the "more" (if it appears below the review), you will get a little pop-up box that shows the complete review from that person.  You can get rid of that pop-up when you are done reading or copying the text by pretending that there is an "X" in the upper right hand corner of the box; click on the upper right corner tomake the box go away.

  5. Some listed restaurants don't have reviews; skip those.  Some of the listings are clearly not restaurants; skip those. 

  6. Some listed restaurants aren't in Terrell.  Use them anyhow if they are in this list.

Your report must indicate how many reviews were skipped and why they were skipped (discussed in the methodology section). 

Your report must include the following format, not necessarily with any sort of headings:

  1. objectives of the research

  2. source of the data

  3. discussion of the methodology

  4. discussion of the findings

  5. discussion of the conclusions
    (implications / recommendations)

The report should not include or refer to the spreadsheet itself; the spreadsheet is merely a working document that is a tool to assist in your analysis.  That is, the report should be understandable without your spreadsheet and your report should not refer the reader to your spreadsheet. 

However, your spreadsheet must be readily available if a research client wants to see it and absolutely must be submitted to me as your immediate supervisor.  That is, for the sake of grading your report for this class, you must submit your spreadsheet as a separate (independent) document.  If you have compiled your spreadsheet electronically, attach it to your electronic submission. 

If you have compiled your spreadsheet with paper, pencil, and lots of tape, that's OK and might be easier for you - the spreadsheet is a work document and only the report must be spotlessly neat.  However, this will require that you physically submit your report and attached spreadsheet either to me or to the College of Business staff support folks by the deadline or ensure that is postmarked five days before the due date if mailed. 

Regularly check the discussion board for additional information, advice, or constraints.