Content decay: pages losing clicks
“compare clicks per page this quarter vs last quarter and list the pages that lost the most so we can refresh them”
Compare clicks per page this quarter vs last quarter and list the pages that lost the most so we can refresh them in Google Search Console pages clicks.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileGoogle Search Console pages clicksCSV export · 18 rows
- StepRank pages by click lossStep 1
- ResultPage Click Losses5 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 5 rows came out.
- Download Google Search Console pages clicks sample (18 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 | Clicks lost | Clicks this quarter | Clicks last quarter |
|---|---|---|---|
| https://www.brightharbor.com/pricing | 780 | 480 | 1,260 |
| https://www.brightharbor.com/blog/keyword-research | 640 | 340 | 980 |
| https://www.brightharbor.com/ | 520 | 1,320 | 1,840 |
| https://www.brightharbor.com/integrations/slack | 500 | 210 | 710 |
| https://www.brightharbor.com/case-studies/meridian-retail | 30 | 470 | 500 |
How do you compare clicks per page this quarter vs last quarter and list the pages that lost the most?
Export your pages and clicks data from Google Search Console for this quarter and last quarter. Mammoth compares clicks by page, ranks the biggest losses, and gives you a list of pages with click drops. Use that list to choose which pages to refresh first.
How it works
How to use the Page Click Losses 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 Click Losses: questions
What export should you use?
What happens to rows that do not match?
How do you change the rules?
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