Google Search Console Position Movement Matrix

Generate a query movement matrix from previous to current position bands using Google Search Console date comparison CSV. Instantly see how queries shift across ranking tiers.

Before

Top_queries	Last_28_days_Clicks	Previous_28_days_Clicks	Last_28_days_Position	Previous_28_days_Position
csv analysis tool	120	85	2.1	5.3
data pivot online	45	38	8.7	12.4
free csv editor	200	0	15.2
parquet converter	30	25	1.0	1.2
spreadsheet compare	18	22	42.5	28.1
csv to json	95	110	3.5	3.1

After

previous_position_label	01: 1	02: 2-3	04: 7-10	05: 11-20	06: 21-100
01: 1	1	0	0	0	0
02: 2-3	0	1	0	0	0
03: 4-6	0	1	0	0	0
05: 11-20	0	0	1	0	0
06: 21-100	0	0	0	0	1
07: 101+	0	0	0	1	0

Drag & drop CSV files here, or browse files

.csv format (up to 10 files, 500 MB each)

Required Columns

Top queriesLast 28 days ClicksPrevious 28 days ClicksLast 28 days ImpressionsPrevious 28 days ImpressionsLast 28 days CTRPrevious 28 days CTRLast 28 days PositionPrevious 28 days Position

Your data stays in your browser. By using this tool, you agree to our Terms and Privacy Policy.

How to Use This Template

Select Your File

Drag & drop a CSV file containing the required columns

Automatic Processing

Data is transformed and aggregated based on the template

View Results

Explore the aggregated results interactively on the Analyze page

Processing Details of This Template

1Add conditional column "previous_position_label"
2Add conditional column "current_position_label"
3Pivot by previous_position_label × column axis: current_position_label
4Metrics: Count(Top queries)