PROMPT BRO
Marketing desk

Lead sources and cost per lead

Lead source is 'WhatsApp'. Which campaign? That column is blank.

Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files

By hand1–2 hrs
With AI15 min
Per week · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Prepare channel working

Use lead ID, source and approved channel spend in same period. Do not include names or contacts.

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)
lead-source.xlsxchannel-spend.xlsx

Whenever I send the next brief, use this format. Period: [Period] Counting rule: [Counting rule] I'm attaching lead-source.xlsx and channel-spend.xlsx. A. Deduplicate for review: hold every duplicate occurrence, count valid unique leads by source and Unknown. B. Match supplied channel spend and calculate CPL per source where count positive; flag zero/missing. C. Facts and suggested tracking fixes, no invented attribution. 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.

Set it up once. Save the approved brand facts, tone and format, not customer details. Pick your tool at the top to see how.

After that, each time: send the new brief and current approved facts; check the result.

First time? Try it in a normal chat: paste and send.

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)
4valid leads
2duplicate rows
1unknown source
  • L2Duplicate. Both rows held.
  • Meta2 valid leads. ₹1,000 spend / 2 = ₹500 CPL.
  • L5Source unknown. Ask team; don't attribute.
Before you trust it

Then send this: Recount unique IDs, source totals and CPL; keep duplicates held.

If it goes wrong
Deletes duplicate

Reply: "Hold both; verify."

Guesses source

Reply: "Unknown."

Invents cost

Reply: "Only supplied spend."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?