Query Topic Cluster Analysis

Modified on Tue, 4 Mar at 9:23 AM

The Query Topic Cluster Analysis tool categorizes your website’s search performance data into meaningful topic clusters, offering insights for better SEO and content strategy decisions.

This tool is available to all Schema App users.

How to use the Query Topic Cluster Analysis tool

Step 1: Download file from Google Search Console

Log into your Google Search Console account
Navigate to your domain's Search results
Make sure the date range and any desired filters have been applied
Click Export > Download Excel

Step 2: Run Query Topic Cluster Analysis

Log into Schema App and navigate to Resources > Topic Clustering
Click Browse and upload the .xlsx file from Google Search Console
Select the number of topic clusters you want to generate (we recommend 4-10)
Click Submit

Step 3: Analyze Results

The tool will return performance data on queries clustered into broader topics. Each topic starts with a number which identifies the cluster. Performance data is organized into 4 separate bar graphs:

Total Clicks by Topic Cluster
Total Impressions by Topic Cluster
Average Click-through-rate (CTR) by Topic Cluster
Average Position by Topic Cluster

Here's an example using sample data from Schema App:

Use this data to answer questions like:

Are the top performing clusters expected or unexpected?
Where are the largest discrepancies between performance metrics for a given cluster?
- E.g. Cluster 1 (knowledge, schema, google) shows the highest average position, but lowest LOW POSITION IS GOOD
High impressions but low clicks -- indicates clsuter that could be improved on -- ranking well for some stuff, but want to improve ranking/position
- E.g. Cluster 3 -- may indicate an opporunity to build additional content in this area/related to these topics/keywords