Marketing report with spend and lead checks
Marketing report says reach increased. Boss asks how many leads came.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Export platform totals
Use campaign, spend, reach, leads and approved attribution definition. Same period and currency.
Privacy Remove personal names, phone numbers, email IDs, photos and customer identifiers. Use approved business facts, anonymous codes or aggregate data.
Period: [Period] Basis: [Basis] I'm attaching marketing-report.xlsx. A. Sum spend and known leads; compute CPL per row when valid; flag zero or missing leads. B. List campaign performance and complete-row overall CPL; do not sum reach as unique people. C. Five-line report separating facts and suggested tests. Use only supplied facts. No invented statistics, awards, testimonials, customer names, No. 1, guaranteed, health, finance or legal claims. Do not copy competitor copy or use real people's names or photos. Write regional-language versions only if I request them in a box. A person checks before publishing or deciding.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
Keep actual company records in your own workbook; ask AI for the local method using headings and rules only.
Excel A:D campaign, spend, reach, leads. Basis [Basis]. Give formulas for CPL only when leads positive, zero or missing leads separately; sum known spend/leads and complete-row spend/leads for aggregate CPL (include complete zero-lead spend). Do not sum reach as unique people. Tell me exactly where to paste formulas or set up the local steps. Use fictional examples only; do not ask for actual company records.
Run locally, verify the figures and flags against your source records and ask the responsible person to approve before acting.
- C2Zero leads. ₹5,000 spend; CPL not applicable.
- C4Leads missing. ₹5,000 spend; hold CPL.
- C1₹250 CPL. ₹5,000 / 20.
Then send this: Recalculate spend, valid leads and CPL; missing leads not zero.
Divides zero
Reply: "CPL not applicable."
Missing leads zero
Reply: "Unknown; exclude incomplete."
Claims unique reach
Reply: "Reach is not deduplicated."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
If your whole team does this, we'll set it up for all of them in one session.