Systems and methods for arranging participant interview clips for conducting ethnographic research. Video clips and photographs of interviews of participants in a market research study are stored in a database. Each item stored in the database is tagged with an interpretive tag indicative of an observed behavioral, attitudinal, or emotive characteristic of the participant. A user searches the database for tags or search terms of interest, and selects clips from the search results for inclusion in a perspective, which is a collection of selected clips and their associated tags and comments from multiple users who collaborate to determine which clips to include in the perspective. The process of creating a perspective is iterative and collaborative, in which the database can be mined and re-mined using different search strategies by multiple users, who provide their comments on selected clips to form a perspective that can be used for product innovation.