Workflow · Search and ads · Opening soon
Search Console keyword report
Find search console keywords on page 2 with the most impressions. Group the results by page so you can review them one page at a time.
Someone typed
“from search console queries show keywords on page 2 (position 11 to 20) with the most impressions, by page”
The agent read it as
From Google Search Console query export show keywords on page 2 (position 11 to 20) with the most impressions, by page.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
Google Search Console query export
CSV export · 21 rows
Step
Show page two keywords by impressions
Step 1
Result
Page Two Keywords
16 rows
Schedule
Runs when you say
Proposed
- FileGoogle Search Console query exportCSV export · 21 rows
- StepShow page two keywords by impressionsStep 1
- ResultPage Two Keywords16 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 16 rows came out.
- Download Google Search Console query export sample (21 rows)Google Search Console: Performance > Search results > Queries > Export
What you get back
The result of that run, the rows to look at first.
Page Two KeywordsSample data16 rows
| Page | Query | Impressions | Position |
|---|---|---|---|
| https://www.orbitly.io/blog/backlink-audit | backlink audit | 980 | 19.80 |
| https://www.orbitly.io/blog/canonical-tags | canonical tags | 1,064 | 16.80 |
| https://www.orbitly.io/blog/content-calendar | best content calendar | 760 | 11.90 |
| https://www.orbitly.io/blog/featured-snippets | featured snippets | 1,022 | 14.90 |
| https://www.orbitly.io/blog/internal-linking-strategy | internal linking strategy | 1,284 | 14.50 |
| https://www.orbitly.io/blog/keyword-opportunities | keyword opportunities | 430 | 11.20 |
| https://www.orbitly.io/blog/keyword-research-tool | keyword research tool | 1,840 | 11.40 |
| https://www.orbitly.io/blog/on-page-seo | on page seo | 1,094 | 12.80 |
| https://www.orbitly.io/blog/robots-txt-seo | robots txt seo | 942 | 18.30 |
| https://www.orbitly.io/blog/search-console-keywords | search console keywords | 1,456 | 15.70 |
| https://www.orbitly.io/blog/seo-audit-checklist | seo audit checklist | 1,512 | 12.10 |
| https://www.orbitly.io/blog/xml-sitemap | xml sitemap | 888 | 19.10 |
How do you show Search Console keywords on page 2 by impressions, by page?
Export your query data from Google Search Console, then upload it to Mammoth. Set the rules to keep rows with average position from 11 to 20, sort by impressions, and group by page.
How it works
How to use the Page Two Keywords 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 Two Keywords: questions
Which export should you use?
Use the query export from Google Search Console. It needs the query, page, impressions, and average position fields.
What happens to rows that do not match the position rule?
Rows outside positions 11 to 20 are left out of the result. Only rows that match the rule are shown.
How do you change the rules later?
Edit the step words in the workflow, then run it again. You can change the position range, the sort field, or the grouping field.
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