Skip to content

Weekly ad account health score with three fixes

Every Monday it pulls the last seven days of your ad account against the week before, runs a set of health checks and scores the account out of 100. You get the three fixes that matter most, each with the number behind it.

MarketingWorks with Claude Code · Claude Desktop with MCP+1Community example
Build your promptSee requirements

What it does

  • Connects to the ad platform's own connector, no exports
  • Detects whether the account optimizes for sales or leads and grades on that KPI
  • Compares this week with last week so every number carries a trend
  • Runs checks for efficiency, creative fatigue, wasted spend, winners and delivery
  • Ranks three fixes by severity

Your approval boundaries

Creates drafts

These actions always wait for your yes:

  • Pausing or changing any ad
  • Moving any budget

You decide what happens next.

More about this workflow

This setup is for marketers and solo creators who need steady output without losing their voice. It takes a repeat chore off your plate and hands back something you can check quickly.

First, it connects to the ad platform's own connector, no exports. Next, it detects whether the account optimizes for sales or leads and grades on that KPI. Then it compares this week with last week so every number carries a trend. After that, it runs checks for efficiency, creative fatigue, wasted spend, winners and delivery. Finally, it ranks three fixes by severity. It works with your ads manager and spreadsheets, each on its own login with limited access.

You get the prep work done and waiting for you. The agent stops and asks for your yes before pausing or changing any ad and moving any budget, and says plainly if a step cannot be undone.

“pulls this week against last week”
Mike Futia @mikefutia · Aug 19, 2026
Before you startAds manager · Spreadsheets accessScoped permissionsClaude Code or Claude Desktop with MCP
Explore required tools and model recommendations

Tools and access

  • Ads manager

    Handles the ads manager part of this job. Grant read-only reporting access.

    API required: Yes. Ad platforms need a developer app and approved access to read reports.

    No sign-up needed

  • Google Sheets

    Handles the spreadsheets part of this job. Grant access to the single sheet it needs.

    API required: Yes. Needs a Google Cloud OAuth app or a service account with the Sheets API turned on.

    Sign up: Google Workspace

Official links only. Not sponsored, no affiliate links.

Model recommendations

Best pick

GPT-6.1 Sol

Strong general writer at a mid price.

$2 per million input tokens, $10 per million output tokens, for prompts up to 272K tokens. Longer prompts cost $4 in and $15 out.

OpenAI docs as of October 11, 2026

Cheaper backup

GPT-6 Luna

Very low cost for first drafts and digests.

$0.10 per million input tokens, $0.50 per million output tokens, for prompts up to 272K tokens.

OpenAI docs as of October 11, 2026

Our own picks. Not sponsored, no affiliate links.

Build your prompt

Add your details, then copy the prompt into your tool.

1Your details

Fill these in and the prompt updates as you type.

sales or leads

cost per result

2Your prompt

4 of 4 still empty
Fill these in before you run it: [AD ACCOUNT ID] [GOAL: sales or leads] [WASTED SPEND CUTOFF: cost per result] [REPORT DAY] You are the Weekly ad account health score with three fixes agent. Every Monday it pulls the last seven days of your ad account against the week before, runs a set of health checks and scores the account out of 100. You get the three fixes that matter most, each with the number behind it. Use only the details filled in above. If any [BRACKETED] item is still blank or unclear, stop and ask for it first. Do not guess. What you do on your own: - Connects to the ad platform's own connector, no exports - Detects whether the account optimizes for sales or leads and grades on that KPI - Compares this week with last week so every number carries a trend - Runs checks for efficiency, creative fatigue, wasted spend, winners and delivery - Ranks three fixes by severity What you must never do without a yes from a person: - Pausing or changing any ad - Moving any budget Rules: - Before any step on the list above, stop and ask. Say in plain words what you want to do, who it affects, and whether it can be undone. - If something cannot be undone, say so first, in one short line. - Write drafts, not final actions. A person sends, pays, posts, or deletes. - Keep a short log of every action you took and every source you read. - If you are unsure, ask instead of guessing.
View run instructionsPaste into: Claude Code, Claude Desktop with MCP, Cursor

Your answers stay in this browser only.

Run your workflow

Connect your tools with only the access this setup needs, then follow these steps.

Steps

Do these in order. Test on old data before it touches live work.

  1. 1Set up Ads manager. Keep it to read-only reporting access.
  2. 2Connect Google Sheets with its own login, not yours. Grant access to the single sheet it needs.
  3. 3Paste the prompt where your harness takes instructions. See the note under the Copy button.
  4. 4Do a dry run on old or test data first. Check every draft and every stop point by hand before you let it near live work.
  5. 5Read its log after the first real run. Only widen access once a week of runs looks clean.

Safeguards and trust score

The score describes this example setup’s access, approval boundaries, ability to undo changes, and scope.

Access24 / 30

Writes drafts and notes inside your tools, nothing leaves on its own.

Human approval30 / 30

Waits for a yes on: pausing or changing any ad, moving any budget.

Undo and logs14 / 20

Proposes changes to live records, so the setup needs a change log and a way back.

Scope18 / 20

Runs on its own login across 2 tools. Fewer connections means a smaller blast radius.

How to raise it

  • Undo and logs: Stop it from editing live records. Have it write the change as a proposal you apply, and keep a log of every change with a way to roll it back +3
  • Scope: Run it on one tool only, with its own login that can see just what this job needs +2

Do all of these to reach 91, up from 86.

Want help getting there? Get an AI Trust Audit from Pixeldesigns

Reviewed by Trustcase (example setup). How scoring works

Embed badge

Show this trust score on your site or README. It links back here.

Trustcase trust score badge
Markdown
[![Trustcase trust score for Weekly ad account health score with three fixes](https://trustcase.dev/badge/weekly-ad-account-health-score-with-three-fixes.svg)](https://trustcase.dev/use-cases/weekly-ad-account-health-score-with-three-fixes)
HTML
<a href="https://trustcase.dev/use-cases/weekly-ad-account-health-score-with-three-fixes"><img src="https://trustcase.dev/badge/weekly-ad-account-health-score-with-three-fixes.svg" alt="Trustcase trust score for Weekly ad account health score with three fixes" height="20"></a>

More marketing workflows

Other workflows that use the same tools