PROMPT BRO
Marketing desk

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

By hand3 hrs
With AI30 min
Each time · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Export platform totals

Use campaign, spend, reach, leads and approved attribution definition. Same period and currency.

First time? Try it on fake data first:

Privacy Remove personal names, phone numbers, email IDs, photos and customer identifiers. Use approved business facts, anonymous codes or aggregate data.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
marketing-report.xlsx

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.

What you'll get back (example, from the practice files)
₹25,000spend
40known leads
₹500complete CPL
  • C2Zero leads. ₹5,000 spend; CPL not applicable.
  • C4Leads missing. ₹5,000 spend; hold CPL.
  • C1₹250 CPL. ₹5,000 / 20.
Before you trust it

Then send this: Recalculate spend, valid leads and CPL; missing leads not zero.

If it goes wrong
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?