Template · Search and ads · Opening soon
Content audit template that reads your Search Console
List every page with its clicks, the change over the last 12 weeks and a keep, update or prune call, straight from Search Console. It refreshes as Google does.
You bring
Search Console pages720 rows
PageDateClicksImpressions
Mammoth does the work
You get
One table30 rows
Every page's clicks now and before, and a keep, update or prune call.
PageClicksClicks beforeChange %ImpressionsPositionAction
- Not a spreadsheet to fill inIt is a ready-made workflow in Mammoth. You bring the files, and it does the work.
- Your files, as they areUpload a file or connect a source. Your column names do not have to match.
- Runs again by itselfWhen new data arrives, every step runs again and the result updates.
What you get back
The real result of this template, run on sample data.
Content audit: the resultSample data30 rows
| Page | Clicks | Clicks before | Change % | Impressions | Position | Action |
|---|---|---|---|---|---|---|
| https://example.com/pricing | 5,599 | 4,419 | 26.7 | 162,669 | 2.20 | Keep |
| https://example.com/blog/bank-reconciliation | 2,710 | 2,651 | 2.2 | 74,143 | 6.40 | Keep |
| https://example.com/blog/what-is-dso | 1,352 | 2,627 | -48.5 | 39,304 | 3.50 | Update |
| https://example.com/blog/cohort-analysis | 1,335 | 1,369 | -2.5 | 35,728 | 11.90 | Update |
| https://example.com/blog/remove-duplicates | 1,024 | 856 | 19.6 | 29,983 | 8.90 | Update |
| https://example.com/blog/merge-excel-files | 967 | 1,452 | -33.4 | 29,315 | 1.70 | Update |
| https://example.com/blog/ar-aging | 897 | 762 | 17.7 | 25,172 | 4 | Keep |
| https://example.com/features/pipelines | 760 | 733 | 3.7 | 23,070 | 2.20 | Keep |
What is a content audit?
A content audit lists every page on a site with how it performs, so each can be kept, updated or pruned. Pages losing clicks or ranking just off page one are the cheapest wins; pages nobody finds are candidates to merge or remove.
How it works
How to use the content audit template
- 1Bring your dataConnect a source, or upload a file.
- 2Check the columnsMammoth matches each column the template needs and asks only when it is unsure.
- 3Choose where it goesA table, a sheet, or a dashboard. It rebuilds on every refresh.
See the exact columns and steps ›
What it needs
Search Console data by page and date: clicks and impressions (and position)
Search Console pages
- Page
- Date
- Clicks
- Impressions
- Position(optional)
The steps it runs
- 1Match columns
- 2Clicks now and before, and a call
Every step is an ordinary Mammoth step you can open and change.
Content audit: questions
How does it decide keep, update or prune?
Prune or merge: fewer than 10 clicks in both periods. Update: clicks down more than 20%, or an average position between 8 and 20, close enough to the top for a refresh to move it. Keep: the rest. The weeks and the click floor are settings.
Does the Search Console pages export work?
It needs a date on each row, which the Search Console connection gives. The pages export from the Search Console screen has no dates, so it cannot show a change.
Does it update by itself?
Yes. The template becomes an ordinary workflow in Mammoth. When your data refreshes, from a connector, a scheduled pull or a new file, every step runs again and the result table updates.
Can I change the steps?
Every step is an ordinary Mammoth step you can open and edit. Mammoth remembers which steps came from the template, so an update never overwrites your changes.
Do my column names have to match?
No. You point the template at your columns once. Mammoth suggests a match for each one and asks only when it is unsure.
Get early access to this template
Bring your data, check the columns, and the result rebuilds on every refresh.
More search and ads templates
Decide which pages to keep, update or prune, and find the search terms that spend without converting.