OptimizeQuality

Refresh Opportunity List

Finds pages with strong backlinks and falling traffic, and proposes an owner and a date for each refresh.

Part of Content Refresh and Decay Detection

Tools

Ahrefs, Google Analytics 4, Notion

Outcomes

Backlinks put to work • Owner and date proposed • Fewer wasted rewrites

Documentation

Instruction-ready detail below

Once a month, match the <in:spreadsheets>pages holding the strongest backlinks</in:spreadsheets> against falling traffic, then <email>email</email> a short refresh list with a suggested owner for each.

Instruction file

Once a month, match the <in:spreadsheets>pages holding the strongest backlinks</in:spreadsheets> against falling traffic, then <email>email</email> a short refresh list with a suggested owner for each.

Setup requirements

Tools

Ahrefs, Google Analytics 4, Notion

Trigger

On the first working day of each month

Setup time

15 minutes

Other automations in this workflow

Content Decay Digest

Lists the pages losing clicks or position and orders the refresh work by the traffic each page is losing.

Related workflows

SEO Brief to Publish Pipeline

Moves a target keyword from search data to a written brief, a draft, a review, and a published page with tracking attached.

Content tagging

Applies one tag set to every published page, email, and asset, so the library can be searched and a campaign's results can be counted by what it actually shipped.

Campaign reporting

Builds the weekly campaign report from one agreed set of channel numbers, so the meeting starts from the same figures instead of five screenshots.

Download

Start with one instruction file.

Download the app and begin with drafts and checklists before you write anything back.

  • •Plain-language instructions
  • •Runs on your machine
  • •Works with your existing setup
  • •Reviewable activity history
Download