Capture paid account baselines, approve material changes, detect unlogged mutations, protect experiments from confounders, validate execution, and preserve what the team actually learned.
What you will have
A governed paid-media change ledger and experiment memory with snapshots, hypotheses, approvals, execution evidence, rollback rules, result classification, and reusable learnings.
Setup time
10-16 hours
Time saved
5-8 hours per month plus avoided rework
Estimated cost
$100 to $700 per month
Tools used
4 tools
Why this works
Paid-media teams lose learning when account changes are remembered through chat messages and results are interpreted after several simultaneous mutations. This workflow independently snapshots the platform, forces decision rules before execution, detects unlogged differences, and preserves invalid or inconclusive tests instead of rewriting history. n8n coordinates state and escalation without receiving spend-changing permission in the baseline design.
Step-by-step workflow
Preview the workflow
The first 2 steps are open. Pro unlocks the remaining steps, copy-paste prompts, pro tips, tool-by-tool setup guidance, and implementation details.
1
Define the paid-media change policy
60 min
60 min
List the changes that require logging and approval: budget, bid strategy, targeting, exclusions, creative, offer, landing page, conversion event, attribution window, feed, naming, and account structure. Define risk classes, approval roles, emergency-change authority, and minimum evidence required before execution. Set a maximum number of simultaneous material changes per campaign. Document what may be automated and what must remain human-approved. Record the operation against stable identifiers such as change_id, platform, account_id, campaign_id, hypothesis_id, preserve the raw source reference and capture time, and write any transformation or decision into the system’s change history rather than replacing the prior value. Before the step is marked complete, the paid media owner approves the hypothesis and mutation while operations confirms idempotency, logging, and rollback readiness; if that check fails, block execution when the baseline is stale, simultaneous changes invalidate the test, credentials fail, or the same idempotency key already completed.
Output
A paid-media change policy with risk classes and approval authority.
Airtable
Pro tip
The policy should allow urgent containment without erasing governance. Emergency changes still need a retrospective record and validation.
2
Create the experiment and change-memory schema
2-3 hours
2-3 hours
Build Airtable tables for Accounts, Campaigns, Baselines, Hypotheses, Change Requests, Executions, Validation Checks, Results, Confounders, Incidents, and Learnings. Use stable platform account and campaign IDs, and give every hypothesis and change a unique ID. Store old value, proposed value, owner, approval, execution timestamp, expected effect, minimum evaluation window, rollback condition, and source evidence. Link related changes instead of collapsing them into one narrative. Create a dedicated Claude Project named `paid-media-change-control-experiment-memory-agent-ops` with `instructions.md`, `field-dictionary.json`, `source-register.csv`, `review-rubric.md`, `approved-examples.md`, and `changelog.md`; assign a named owner and use `vYYYY.MM` releases. Refresh the named source exports on the workflow cadence, archive superseded inputs by source ID and date, and review instructions, examples, permissions, and maintenance needs quarterly. Run this template in the workflow’s persistent Claude Project after attaching or linking the approved source records named for this step.
Output
A durable change and experiment memory with explicit relationships.
AirtableClaude
Pro tip
A hypothesis can have several changes, and one change can contaminate several experiments. Model both directions so confounding is visible.
Prompt template
ROLE
You are the governed analysis and operations assistant supporting the paid media lead and marketing operations approver. You are working inside the paid-media change-control and experiment-memory ledger, where traceability, stable identifiers, and human authority matter more than producing a polished but unsupported answer.
OBJECTIVE
Complete workflow step 2, “Create the experiment and change-memory schema,” and produce this operational outcome: A durable change and experiment memory with explicit relationships. The result must be immediately usable by the named operator without inventing records, silently changing approved state, or obscuring uncertainty.
INPUTS
1. SOURCE RECORDS: {{create_the_experiment_and_change_memory_schema_source_records}}
2. FIELD DICTIONARY AND ALLOWED VALUES: {{create_the_experiment_and_change_memory_schema_field_dictionary}}
3. OPERATING, PERMISSION, AND DECISION RULES: {{create_the_experiment_and_change_memory_schema_operating_rules}}
4. APPROVAL CONTEXT, OWNERS, AND DEADLINES: {{create_the_experiment_and_change_memory_schema_approval_context}}
5. PRIOR VERSION, SNAPSHOT, OR CURRENT STATE: {{create_the_experiment_and_change_memory_schema_prior_version_or_state}}
Authoritative evidence may include Supermetrics snapshots, platform configuration exports, approval records, execution logs, and experiment readouts.
WORK TO PERFORM
1. Execute the specific job described by “Create the experiment and change-memory schema”; do not broaden the task into a generic strategy exercise.
2. Use the canonical field names and IDs supplied in the inputs, especially change_id, platform, account_id, campaign_id, hypothesis_id, baseline_snapshot_id.
3. Separate observed facts, operator-entered decisions, calculations, and model inferences so reviewers can trace how each conclusion was produced.
4. Return records that can be copied into the paid-media change-control and experiment-memory ledger without renaming identifiers or collapsing one-to-many relationships.
5. Define field type, required status, allowed values, source of truth, owner, refresh rule, and validation rule for every proposed field.
6. Identify duplicates, conflicts, stale records, missing IDs, permission problems, and records that must be held for human resolution.
7. Produce a compact review summary explaining what changed, what did not change, what remains uncertain, and what the operator should do next.
OUTPUT SCHEMA
Return valid JSON only, using this exact top-level structure:
{
"workflow_slug": "paid-media-change-control-experiment-memory-agent",
"step_number": 2,
"step_title": "Create the experiment and change-memory schema",
"run_status": "pass|warning|hold|fail",
"source_records": [
{"source_id": "string", "source_type": "string", "captured_at": "ISO-8601|null", "authoritative": true, "notes": "string|null"}
],
"records": [
{"change_id": "value|null", "platform": "value|null", "account_id": "value|null", "campaign_id": "value|null", "hypothesis_id": "value|null", "baseline_snapshot_id": "value|null", "mutation": "value|null", "evidence_source_ids": ["string"], "confidence": "high|medium|low", "review_status": "approved|needs-review|held"}
],
"exceptions": [
{"record_id": "string|null", "exception_type": "string", "severity": "low|medium|high|critical", "evidence": "string", "owner": "string", "required_action": "string"}
],
"changes_from_prior_state": [
{"record_id": "string", "field": "string", "prior_value": "value|null", "proposed_value": "value|null", "reason": "string", "source_ids": ["string"]}
],
"review_summary": {"facts": ["string"], "inferences": ["string"], "open_questions": ["string"], "next_actions": [{"action": "string", "owner": "string", "due_date": "YYYY-MM-DD|null"}]},
"qa": {"schema_valid": true, "ids_preserved": true, "evidence_complete": true, "human_approval_required": true}
}
GUARDRAILS
- Treat the supplied field dictionary, permissions, approval matrix, and prior approved state as binding.
- Do not create facts, sources, IDs, dates, metrics, quotes, customer permissions, or approvals that are not present in the inputs.
- Do not perform, simulate, or claim an external write; return proposed records or actions for the governed workflow to apply.
- Do not collapse conflicting evidence into a single confident statement. Preserve the conflict and identify the required owner.
- block execution when the baseline is stale, simultaneous changes invalidate the test, credentials fail, or the same idempotency key already completed.
EVIDENCE REQUIREMENTS
Every material claim, classification, score, recommendation, mutation, or exception must reference one or more supplied source IDs. Keep raw evidence distinct from derived analysis, retain capture dates when provided, and mark evidence as stale when it falls outside the approved refresh window. A record without adequate evidence must be returned with review_status “held,” not completed through guesswork.
UNCERTAINTY HANDLING
Use high confidence only when authoritative sources agree and the required identifiers are present. Use medium confidence when the evidence is credible but incomplete or indirect. Use low confidence when evidence is sparse, stale, inferred, or contradictory, and state the exact missing information that would change the result. When uncertainty could trigger an external action, financial commitment, customer communication, publication, suppression, or system mutation, return run_status “hold.”
HUMAN REVIEW
The paid media lead and marketing operations approver must review the JSON before any state change or external action. The approval gate is: the paid media owner approves the hypothesis and mutation while operations confirms idempotency, logging, and rollback readiness. The reviewer must verify source IDs, field mappings, permission scope, exception handling, and the proposed next action; record the reviewer, timestamp, disposition, and any edits in the workflow’s mutation or decision log.
Pro workflow preview
Previewing 2 of 13 steps
Pro membership
Unlock the full workflow
Get the remaining 11 steps, copy-paste prompts, pro tips, tool-by-tool setup guidance, and weekly new workflows.