# Marketing workflow worksheet
Prepared by Jon Goodey. Updated 25 October 2026.
https://jongoodey.com/ai-consultancy

## Find
- Workflow and named owner:
- Intended user and outcome:
- Current steps, tools and handovers:
- Baseline time per run, frequency and review effort:
- Errors or repeated work (exclude costs already counted):

## Frame
- Approved sources, source dates and access limits:
- Input example:
- Required output and format:
- Claims that must not be made:
- Facts still missing:
- Human reviewer and approval point:

## Test
- Representative case:
- Missing/contradictory data case:
- Expected result and source:
- Acceptance checks:
- Correction count and review time:
- Does the full process improve on the baseline?

## Embed
- Owner and operating instructions:
- Exception and escalation route:
- Review date and maintenance responsibility:
- Stop conditions:

## Optional content brief
- Audience and need:
- Intended action and verified destination:
- Approved message and supporting source:
- Structure and format:
- Brand and accessibility requirements:
- Unknowns to resolve before publication:

## ROI assumptions
Annual time value = weekly hours x people x hourly cost x 52.
Potential time value recovered = annual time value x automation coverage x time saving.
Add separately measured rework benefits and tool-cost changes. Subtract setup cost for first-year net benefit.
Recovered staff time is capacity, not necessarily a cash saving. Validate every assumption in a pilot.


## Three-year business case
Use one currency throughout. Keep cash savings and recovered capacity separate.

| Assumption | Base case | Cautious case | Evidence or owner |
| --- | --- | --- | --- |
| Weekly hours per person | | | |
| People involved | | | |
| Hourly cost | | | |
| Automation coverage (%) | | | |
| Time saved within covered work (%) | | | |
| Monthly rework cost, excluding hours above | | | |
| Rework reduction (%) | | | |
| Current monthly tools | | | |
| Future monthly tools, APIs, review and maintenance | | | |
| Setup, testing, training and handover | | | |

Annual net benefit = recovered time value + annual rework reduction + 12 x (current monthly tools - future monthly costs).
First-year net benefit = annual net benefit - setup cost.
First-year ROI = first-year net benefit / setup cost x 100. Not applicable if setup cost is zero.
Payback months = setup cost / (annual net benefit / 12). Not reached if annual benefit is zero or negative.
Three-year net benefit = 3 x annual net benefit - setup cost.
Three-year proposed cost = setup cost + 3 x future annual process cost.

This simple model assumes immediate adoption and constant annual costs and benefits. It excludes discounting, inflation and changing workload. Use a phased finance model where those assumptions are material.

## Pilot decision and review
- Cash spend that will actually fall, with evidence:
- Capacity recovered and how it will be used:
- Quality standard and acceptable review effort:
- Pilot start, review date and named decision owner:
- Actual time per completed task, rework, adoption and spend:
- Stop conditions and decision on wider rollout:
