COMPUTER-IMPLEMENTED METHODS AND SYSTEMS FOR CLUSTERING USER REVIEWS AND RANKING CLUSTERS
Computer-implemented methods and systems are disclosed for organizing user reviews, especially computer app reviews, into clusters and ranking the clusters so that the reviews may be more meaningfully analyzed.
Latest Applause App Quality, Inc. Patents:
- SYSTEMS AND METHODS FOR AUTOMATING TEST AND VALIDITY
- Systems and methods for automating test and validity
- Computer-implemented methods and systems for clustering user reviews and ranking clusters
- METHODS AND SYSTEMS FOR QUANTIFYING AND TRACKING SOFTWARE APPLICATION QUALITY
- Methods and systems for quantifying and tracking software application quality
This Application is a Continuation of U.S. application Ser. No. 14/539,623, filed Nov. 12, 2014, entitled “COMPUTER-IMPLEMENTED METHODS AND SYSTEMS FOR CLUSTERING USER REVIEWS AND RANKING CLUSTERS,” incorporated herein by reference in its entirety.
BACKGROUNDThe present application relates generally to analysis of user reviews and, more particularly, to computer-implemented methods and systems for organizing such reviews into clusters and ranking the clusters so that the reviews may be more meaningfully analyzed.
An app is a computer program designed to run on a computer device or system, including, without limitation, mobile devices (such as smartphones and tablet computers), desktop computers, wearable computers, connected devices, etc. App stores, from which apps can be downloaded, allow app users to create and publicly share their reviews of apps. This allows users to praise app developers for effective new features, but it also allows users to post complaints on a public stage and to expose undesirable elements of apps.
Given the steady influx of review data flowing into app stores, app developers need to constantly monitor the incoming stream of user feedback. However, many apps get hundreds and even thousands of reviews a day, and it can be difficult for app developers to keep up with the issues raised by app users.
BRIEF SUMMARY OF THE DISCLOSUREIn accordance with one or more embodiments, a method is provided for organizing user reviews for data analysis. The method, which is implemented in a computer system, includes the steps of (a) sampling a plurality of reviews to be analyzed from one or more sources; (b) identifying unique terms in each of the plurality of reviews; (c) determining frequency values indicating the number of times each of the unique terms appears in each of the plurality of reviews; (d) adjusting the frequency values for each unique term to account for the rarity of that unique term across the plurality of reviews; (e) calculating the similarities between the reviews based on the frequency values as adjusted in step (d); and (f) grouping the reviews into clusters based on the similarities of the reviews determined in step (e).
In accordance with one or more further embodiments, a computer system is provided, including at least one processor, memory associated with the at least one processor, and a program supported in the memory for organizing user reviews for data analysis. The program contains a plurality of instructions which, when executed by the at least one processor, cause the at least one processor to: (a) sample a plurality of reviews to be analyzed from one or more sources; (b) identify unique terms in each of the plurality of reviews; (c) determine frequency values indicating the number of times each of the unique terms appears in each of the plurality of reviews; (d) adjust the frequency values for each unique term to account for the rarity of that unique term across the plurality of reviews; (e) calculate the similarities between the reviews based on the frequency values as adjusted in (d); and (f) group the reviews into clusters based on the similarities of the reviews determined in (e).
Various embodiments disclosed herein are directed to computer-implemented methods and systems for organizing app reviews into clusters and ordering the clusters so that user review data can be more effectively analyzed by app developers to improve their apps.
The methods and systems for clustering reviews may be used for organizing generally any feedback related corpus that includes text feedback and a scaled rating such as, e.g., a star or numerical rating.
While the exemplary embodiments disclosed herein refer to user reviews for apps, it should be understood that the clustering techniques described herein can be used for analyzing user reviews involving generally any subject matter.
At step 100, a set of reviews collected for an app are sampled, as desired. For instance, a user of the clustering system may choose to sample only the last N reviews or only reviews posted in the last M days.
At step 102, the text comments in the sampled reviews are tokenized. Tokenization refers to the process of breaking a stream of text into a set of words.
Each of the words is then reduced to a stem, i.e., to its root meaning. For instance, the words “crashed” and “crashing” would be stemmed to “crash.” The stemmed words (and words already in root form) in reviews are referred to herein as “terms.”
At step 104, all unique terms in a review are extracted and placed in a term/review matrix. In an exemplary matrix, each row identifies a review and each column identifies a unique term, and the matrix specifies the frequency of terms within each review.
At step 106, “tf/idf” (term frequency/inverse document frequency) data is calculated for each review in order to determine how important each term is to a review within the set of reviews to control for the fact that some terms are more commonly used than others.
tf=the raw frequency of a term within a review.
idf=log(total number of reviews/total number of reviews containing the term).
The calculated tf/idf values are placed in respective row/column cells in the term/review matrix. The matrix is then normalized.
The user of the clustering system selects a similarity threshold, which can be based, e.g., on the total number of reviews posted for the app, the total number posted in the last M days, and the total number selected for the sample. In one example, similarity thresholds range between 0.20-0.35.
The reviews are divided up into k number of chunks of equal number of reviews. In one or more embodiments, the reviews are separated into chunks based on when each review was posted.
At step 108, the similarity of each review is calculated against every other review in the chunk, cos _sim(ri, rj), using standard cosine similarity between each pair of reviews.
For each pair of reviews, if cos _sim(ri, rj)>sim_threshold, the reviews are clustered at step 110.
The transitive property is used for an initial pass through reviews for clustering reviews. For example: If ri˜rj, and rj˜rk, then ri, rj, rk form a cluster.
A merge list is then created in order to merge clusters with sufficiently similar reviews. For instance, if cluster1=[ri, rj, rk] and cluster2=[rl, rm, rn], and ri˜rn, then the clusters are added to merge list.
Next, the system passes through the merge list. Clusters 1 and 2 are merged only if sim_score(ri, rn)>avg(sim_score for cluster1) and>avg(sim_score for cluster2); otherwise the clusters are left unmerged. Thus, even though there is a link between cluster 1 and cluster 2, it may not be strong enough to group the clusters together.
Clusters can also be merged based on cluster centroids within each chunk. A cluster similarity threshold, C, is first selected based on samplings of apps across markets and categories. The centroid of each cluster is calculated using a standard calculation that takes each review within the cluster and uses the row that represents the review as a point in n-dimensional space. Centroid calculation generally finds the geometric center of all the points.
The cosine similarity between clusters based on their centroids is calculated. Clusters with a cluster similarity threshold>C are merged.
At step 112, a post merge process is performed to collapse clusters across k chunks. Clusters again are merged based on cluster centroids. A cluster similarity threshold, C, is selected based on sampling of apps across markets and categories, C. The centroid of each cluster is calculated. The cosine similarity between clusters based on their centroids is calculated. Clusters with a cluster similarity threshold>C are merged.
At step 114, a final cluster list is prepared of all reviews within X number of arbitrary clusters for an app, based on similarity of text and number of reviews per app.
In accordance with one or more further embodiments, methods and system are provided for ranking clusters, which are formed as described above.
At step 200, a time bucket is assigned to each cluster. The time buckets are broken down into N chunks, from the most recent to the least recent review in the sample. For example, if the cluster contains a review within the last 24 hours, assign time_bucket=1, and if the cluster contains a review within the last 72 hours, assign time_bucket =3. In each case, the most recent review in cluster a determines the time bucket for that cluster.
At step 202, the average rating of each cluster is extracted. The star rating of all reviews within the cluster are averaged. For example, if ri=1 star, rj=1 star, rk=5 star, rl=5 star, the average star rating for cluster=3 star.
At step 204, the number of reviews in each cluster is extracted.
At step 206, the average similarity score for each cluster is extracted. The similarity rating
of all reviews within the cluster is averaged, given every pairwise review within the cluster was clustered based on similarity. For example:
cos _sim(ri, rj)=0.50, cos _sim(ri, rk)=0.60, average_similarity score for cluster=0.55.
At step 208, a weight is assigned to each cluster for each of the features identified above with descending priority. Recent time buckets are assigned higher weights than older time buckets. Negative star ratings are assigned higher weights than positive ratings. Higher number of reviews in a cluster are assigned higher weights than a lower number of reviews. Higher similarity scores are assigned higher weights than lower similarity scores.
At step 210, the clusters are ordered based on the weighted scores, built by linear function:
Weighted_score=m1 * x1+m2 * x2+m3 * x3+m4 * x4, where mi=weight of feature xi, and xi=value for that cluster for an app.
The result of the process is an ordered list of clustered reviews for one specific app.
By way of example,
A user of the system can zoom in on the cluster 300 in
The processes of clustering reviews and ranking clusters described above may be implemented in software, hardware, firmware, or any combination thereof. The processes are preferably implemented in one or more computer programs executing on a programmable computer including a processor, a storage medium readable by the processor (including, e.g., volatile and non-volatile memory and/or storage elements), and input and output devices. Each computer program can be a set of instructions (program code) in a code module resident in the random access memory of the computer. Until required by the computer, the set of instructions may be stored in another computer memory (e.g., in a hard disk drive, or in a removable memory such as an optical disk, external hard drive, memory card, or flash drive) or stored on another computer system and downloaded via the Internet or other network. Program code may be applied to input entered using the input device to perform the functions described and to generate output. The output may be provided to one or more output devices.
Having thus described several illustrative embodiments, it is to be appreciated that various alterations, modifications, and improvements will readily occur to those skilled in the art. Such alterations, modifications, and improvements are intended to form a part of this disclosure, and are intended to be within the spirit and scope of this disclosure. While some examples presented herein involve specific combinations of functions or structural elements, it should be understood that those functions and elements may be combined in other ways according to the present disclosure to accomplish the same or different objectives. In particular, acts, elements, and features discussed in connection with one embodiment are not intended to be excluded from similar or other roles in other embodiments.
Additionally, elements and components described herein may be further divided into additional components or joined together to form fewer components for performing the same functions. For example, the computer system may comprise one or more physical machines, or virtual machines running on one or more physical machines. In addition, the computer server system may comprise a cluster of computers or numerous distributed computers that are
Accordingly, the foregoing description and attached drawings are by way of example only, and are not intended to be limiting.
Claims
1. A method of organizing user reviews for data analysis, comprising the steps, each implemented in a computer system, of:
- identifying unique terms in a plurality of reviews from a sample set of reviews;
- determining frequency values indicating a number of times the unique terms appears in the plurality of reviews, wherein determining the frequency values includes generating a term/review matrix identifying a respective review and a respective unique term, and wherein the matrix specifies the frequency values for the respective unique terms;
- adjusting the frequency values for respective unique terms to account for the rarity of that unique term across the plurality of reviews, wherein adjusting the frequency values includes normalizing the values in the matrix based on values associated with the rarity of the unique term;
- calculating similarities between the reviews based at least in part on the frequency values once adjusted; and
- grouping the reviews into clusters based at least in part on the similarities of the reviews.
2. The method of claim 1, wherein identifying includes tokenizing text in the plurality of reviews into a set of words and stemming for words not already in root form to generate a set of terms for each review, from which said unique terms are identified.
3. The method of claim 1, wherein adjusting includes calculating tf/idf values for each review, wherein tf=the raw frequency of a term within a review, and idf=log (total number of reviews/total number of reviews containing the term), and wherein the tf/idf values comprise the frequency values adjusted.
4. The method of claim 3, further comprising normalizing the term/review matrix.
5. The method of claim 1, wherein calculating and grouping includes dividing the reviews into a given number of chunks, calculating the similarity of each review against every other review in each chunk, and for each pair of reviews whose similarity exceeds a given threshold, clustering said reviews.
6. The method of claim 5, further comprising using the transitive property for clustering reviews.
7. The method of claim 5, further comprising merging clusters with similarly sufficient reviews.
8. The method of claim 7, wherein the clusters are merged based on cluster centroids within each chunk.
9. The method of claim 5, further comprising performing a post merge process to collapse clusters across chunks.
10. The method of claim 1, further comprising ranking the clusters.
11. The method of claim 10, wherein the clusters are ranked based on a plurality of factors.
12. A computer system, comprising:
- at least one processor;
- memory associated with the at least one processor; and
- a program supported in the memory for organizing user reviews for data analysis, the program containing a plurality of instructions which, when executed by the at least one processor, cause the at least one processor to:
- identify unique terms in a plurality of reviews from a sample set of reviews;
- determine frequency values indicating a number of times the unique terms appears in the plurality of reviews, wherein determining the frequency values includes generating a term/review matrix identifying a respective review and a respective unique term, and wherein the matrix specifies the frequency values for the respective unique terms;
- adjust the frequency values for respective unique terms to account for the rarity of that unique term across the plurality of reviews, wherein adjusting the frequency values includes normalizing the values in the matrix based on values associated with the rarity of the unique term;
- calculate similarities between the reviews based at least in part on the frequency values once adjusted; and
- group the reviews into clusters based at least in part on the similarities of the reviews.
13. The computer system of claim 12, wherein identifying includes tokenizing text in the plurality of reviews into a set of words and stemming each word not already in root form to generate a set of terms for each review, from which said unique terms are identified.
14. The computer system of claim 12, wherein adjusting includes calculating tf/idf values for each review, wherein tf =the raw frequency of a term within a review, and idf=log (total number of reviews/total number of reviews containing the term), and wherein the tf/idf values comprise the frequency values adjusted in (d).
15. The computer system of claim 14, wherein the program further comprises instructions for normalizing the term/review matrix.
16. The computer system of claim 12, calculating and grouping includes dividing the reviews into a given number of chunks, calculating the similarity of each review against every other review in each chunk, and for each pair of reviews whose similarity exceeds a given threshold, clustering said reviews.
17. The computer system of claim 16, wherein the program further comprises instructions for using the transitive property for clustering reviews.
18. The computer system of claim 16, wherein the program further comprises instructions for merging clusters with similarly sufficient reviews.
19. The computer system of claim 18, wherein the clusters are merged based on cluster centroids within each chunk.
20. The computer system of claim 19, wherein the program further comprises instructions for performing a post merge process to collapse clusters across chunks.
Type: Application
Filed: Mar 26, 2018
Publication Date: Aug 2, 2018
Applicant: Applause App Quality, Inc. (Framingham, MA)
Inventors: Heidi A. Young (Woodinville, WA), Jason M. Stredwick (Woodinville, WA), Yashas Mavianakere (Bellevue, WA)
Application Number: 15/936,273