Workflow · Search and ads · Opening soon
Search Console clicks by page
Compare page performance from your Search Console exports. See clicks, impressions, CTR, and position for this month and last month by page.
Someone typed
“show clicks, impressions, CTR and position by page this month compared to last month”
The agent read it as
Show clicks, impressions, CTR and position by page for Google Search Console pages export - this month compared to Google Search Console pages export - last month.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
File
Google Search Console pages export - this month
CSV export · 12 rows
File
Google Search Console pages export - last month
CSV export · 12 rows
Step
Make page match key (This month pages)
Step 1
Step
Make page match key (Last month pages)
Step 2
Join
Bring in last month
12 of 12 paired
Step
Show page comparison
Step 4
Result
Page Search Comparison
12 rows
Schedule
Runs when you say
Proposed
- FileGoogle Search Console pages export - this monthCSV export · 12 rows
- FileGoogle Search Console pages export - last monthCSV export · 12 rows
- StepMake page match key (This month pages)Step 1
- StepMake page match key (Last month pages)Step 2
- JoinBring in last month12 of 12 paired
- StepShow page comparisonStep 4
- ResultPage Search Comparison12 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 12 rows came out, and the join paired 12 of 12 rows.
- Download Google Search Console pages export - this month sample (12 rows)Google Search Console: Performance > Search results > Pages > Export
- Download Google Search Console pages export - last month sample (12 rows)Google Search Console: Performance > Search results > Pages > Export
What you get back
The result of that run, the rows to look at first.
Page Search ComparisonSample data12 rows
| Page | Clicks this month | Clicks last month | Impressions this month | Impressions last month | CTR this month | CTR last month | Position this month | Position last month |
|---|---|---|---|---|---|---|---|---|
| https://www.northstarfabrics.com/ | 184 | 171 | 4,860 | 4,580 | 0.04 | 0.04 | 8.70 | 8.90 |
| https://www.northstarfabrics.com/collections/organic-cotton | 161 | 148 | 3,420 | 3,250 | 0.05 | 0.05 | 6.20 | 6.40 |
| https://www.northstarfabrics.com/blog/how-to-choose-bedding | 143 | 139 | 3,185 | 3,060 | 0.05 | 0.05 | 7.10 | 7.30 |
| https://www.northstarfabrics.com/products/linen-sheet-set | 129 | 122 | 2,740 | 2,675 | 0.05 | 0.05 | 5.90 | 6.10 |
| https://www.northstarfabrics.com/collections/bath | 116 | 109 | 2,515 | 2,400 | 0.05 | 0.05 | 8.10 | 8.30 |
| https://www.northstarfabrics.com/pages/about | 88 | 91 | 1,970 | 1,895 | 0.05 | 0.05 | 10.80 | 10.50 |
| https://www.northstarfabrics.com/products/weighted-throw-blanket | 82 | 77 | 1,640 | 1,580 | 0.05 | 0.05 | 6.80 | 7 |
| https://www.northstarfabrics.com/blog/sleep-hygiene-guide | 74 | 69 | 1,895 | 1,810 | 0.04 | 0.04 | 9.40 | 9.80 |
| https://www.northstarfabrics.com/collections/kids | 63 | 58 | 1,410 | 1,325 | 0.05 | 0.04 | 11.20 | 11.40 |
| https://www.northstarfabrics.com/pages/contact | 41 | 44 | 920 | 890 | 0.05 | 0.05 | 12.70 | 12.30 |
| https://www.northstarfabrics.com/products/blackout-curtains | 38 | 33 | 1,105 | 1,035 | 0.03 | 0.03 | 14.30 | 14.80 |
| https://www.northstarfabrics.com/blog/winter-layering-tips | 27 | 29 | 860 | 845 | 0.03 | 0.03 | 15.60 | 15.10 |
How do you show clicks, impressions, CTR and position by page this month compared to last month?
Export the pages report from Google Search Console for this month and for last month. Then match pages between the two files and compare the metrics side by side. You get one view of page performance for both months.
How it works
How to use the Page Search Comparison workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Page Search Comparison: questions
What export should you use?
Use the pages export from Google Search Console for each month you want to compare. One export should cover this month, and one should cover last month.
What happens if a row does not match?
Rows that do not match the other file are left out of the comparison result for that step. They do not get paired with a page unless the key matches.
How do you change the rules?
Change the rules by editing the steps in words, for example by choosing a different match key or comparing a different time period. You can also add, remove, or reorder steps to change what the workflow does.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Decide which pages to keep, update or prune, and find the search terms that spend without converting.
- ROAS by campaignCalculate ROAS by campaign from Google Ads and Shopify exports, matched by week and utm campaign.See the workflow Built by the agent
- Content auditEvery page's clicks now and before, and a keep, update or prune callSee the workflow Template
- Google Ads wasted spendFind search terms with spend and no conversions in the last 30 days, ranked by spend, from a Google Ads export.See the workflow Built by the agent
- Keyword rankings changeCompare this month's average position with last month from Search Console and see which keywords moved up or down in a keyword ranking report.See the workflow Built by the agent
- Negative keyword finderEvery search term that spent money and never converted, with its share of spendSee the workflow Template
- Marketing ROI by campaignCalculate marketing ROI for each campaign from HubSpot exports, using won deal revenue and campaign spend.See the workflow Built by the agent