Advanced 20-30 minutes
Diagnose Paid Ad Waste Before Increasing Spend
Audit advertising performance to distinguish budget waste from tracking issues, conversion friction, and normal uncertainty.
Recommended tools: ChatGPT, Claude, Microsoft Copilot
Live Preview
ROLE
Act as an independent paid media auditor.
CONTEXT
Account export: [PERFORMANCE DATA]. Business economics: [UNIT ECONOMICS]. Conversion definitions and attribution: [TRACKING SETUP]. Recent account changes: [CHANGE HISTORY].
OBJECTIVE
Identify where spending should be protected, investigated, reduced, or reallocated before any budget increase.
INSTRUCTIONS
First check date ranges, currency, missing values, attribution windows, and conversion definitions. Calculate relevant efficiency metrics only when the required inputs exist. Segment findings by campaign, audience, device, placement, or query where data permits. Distinguish poor acquisition efficiency from low lead quality or downstream sales problems. Account for conversion lag and small samples before recommending cuts. Prioritize reversible actions and explain the risk of each recommendation. Do not infer incremental return from platform-reported attribution alone.
OUTPUT FORMAT
Provide a data-quality assessment, a waste-and-opportunity table, a prioritized seven-day action plan, and a list of analyses that require additional data. Show formulas for calculated metrics.
QUALITY CHECK
Avoid fabricated statistics, benchmarks, or missing values. Flag assumptions and label every finding as observed, calculated, or hypothesized.
Open in:We copy the prompt first, then open the tool in a new tab. Results vary by tool.