Keyword rankings change
“compare each query's average position this month to last month from search console and show which keywords moved up or down”
Compare each query's average position this month to last month from Google Search Console Queries and show which keywords moved up or down.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileGoogle Search Console QueriesCSV export · 16 rows
- StepCompare monthly average positionsStep 1
- ResultKeyword Position Moves8 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 8 rows came out.
- Download Google Search Console Queries sample (16 rows)Google Search Console: Performance > Search results > Queries > Export
What you get back
The result of that run, the rows to look at first.
| Query | This month average position | Last month average position | Movement |
|---|---|---|---|
| api integration | 10.70 | 9.60 | Moved down |
| return policy | 7.60 | 6.80 | Moved down |
| shipping rates | 12.80 | 10.90 | Moved down |
| bulk upload products | 12 | 15.20 | Moved up |
| crm pricing | 10.10 | 12.40 | Moved up |
| inventory forecast | 16.20 | 18.70 | Moved up |
| loyalty program | 20.40 | 24.30 | Moved up |
| webinar schedule | 18.10 | 21.40 | Moved up |
How do you compare keyword rankings month to month?
Export your Google Search Console queries, then upload the file. Mammoth compares each query's average position this month with last month and shows the changes in a keyword ranking report.
How it works
How to use the Keyword Position Moves 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.
Keyword Position Moves: questions
What export should you use?
What happens if a row does not match?
How do you change the comparison 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
- 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
- Multi-touch attributionSplit closed HubSpot deal credit across touchpoints, by touch and by channel, from exported deal, contact, engagement, and channel mapping files.See the workflow Built by the agent