Free: 96 PPC tools + my AI Playbook book
Skip to the guide

Inside the pack

The Search Opportunity Workbook

A 10-tab spreadsheet that turns Search Console exports into a working decision board: what to keep, fix, build, test, or ignore, and when to check the result.

10 tabs 91 day tracker 5 decision types

Built by Stewart DunlopPPC.io founder and hands-on PPC consultant

Excel · 10 tabs · works with any Search Console export
  1. 1 Paste your export
  2. 2 Sort the ten decisions
  3. 3 Track the result
Jump to a section

Want to keep a copy? Download the same guide as a Markdown file and use it with your workbook or AI.

Download the workbook

The workbook is a 10-tab Excel file. It turns the pack's method into a working spreadsheet, so you are not doing the sorting in your head.

Export your Search Console queries, paste them in, and work through the tabs in order. Here is what each one does.

Tab 01

Start Here

Reference

Tab 02

Raw Search Console

You paste in

Tab 03

Offers

You paste in

Tab 04

Intent Ledger

You work out

Tab 05

Opportunity Board

You decide

Tab 06

SEO Queue

It hands you

Tab 07

PPC Test Queue

It hands you

Tab 08

91-Day Tracker

It hands you

Tab 09

Glossary + Example

Reference

Tab 10

_Lists

Reference

Start Here

Tab 1 of 10 · Reference

Orientation. It explains how the other nine tabs fit together and what order to use them in.

Raw Search Console

Tab 2 of 10 · You paste in

Paste your exported queries here. This is the only tab where you're expected to paste in new data.

Offers

Tab 3 of 10 · You paste in

The profitable products or services you're prioritizing around. Every decision later in the workbook checks back against this list.

Intent Ledger

Tab 4 of 10 · You work out

Who's behind each search and what they actually want. You work this out before you decide what to do about it.

Opportunity Board

Tab 5 of 10 · You decide

The decision tab. For each query, you pick one: KEEP, FIX, BUILD, TEST PPC, or IGNORE.

SEO Queue

Tab 6 of 10 · It hands you

The FIX and BUILD work, laid out so you can hand it straight to whoever does your SEO.

PPC Test Queue

Tab 7 of 10 · It hands you

The TEST PPC candidates, with the CPC ceiling math done for you, so you know the most you can pay for a click before you start.

91-Day Tracker

Tab 8 of 10 · It hands you

What you expect to happen, and the date you've committed to check it. This is what turns a guess into a test.

Glossary + Example

Tab 9 of 10 · Reference

Terms explained in plain English, plus one fully worked row so you can see the whole process end to end.

_Lists

Tab 10 of 10 · Reference

Dropdown data that powers the other tabs. You don't need to touch this one.


Download it, open the Start Here tab, and paste your first export into Raw Search Console.

The complete pack

Everything in the pack. Three ways to use it.

Read it

Work it

  • Search Opportunity Workbook About the tabs Excel

    Ten tabs that turn your export into a decision board.

  • 10-Minute Quick Start Markdown

    Your first pass, from export to one written-down action.

  • 91-Day Search Test Tracker CSV

    What you expect, when you check, what proves you wrong.

Hand it to your AI

  • Complete Pack for AI Markdown

    Everything in one file. Attach it in Claude, ChatGPT, or Claude Code and talk it through.

  • Claude Code Skill + AI Agent Skill file

    Save it as .claude/skills/search-console-opportunity/SKILL.md and Claude runs the method on your export. Works as plain agent instructions in any other AI.

  • Method JSON JSON

    The rules as structured data, for people building their own agent.

Get everything in one ZIP

Every file above is free to grab directly. The one-email unlock adds the full ZIP and emails you the links for later.

Do this next

Get the whole pack

The workbook comes with the Blueprint, the Worked Example, and seven other files, all free.