PROMPT BRO
Marketing desk

Ad results and the next test questions

Ad dashboard has twelve metrics. The owner asks one question: what did we get?

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

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

Export ad results

Use ad code, spend, clicks, leads and same date range. Keep missing metrics blank.

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)
ad-results.xlsx

Whenever I send the next brief, use this format. Period: [Period] Review rule: [Review rule] I'm attaching ad-results.xlsx. A. Calculate CPC and CPL if denominator positive; sum spend and known leads. B. List above-threshold, zero-lead and missing rows; compare complete-row CPL only. C. Three suggested tests, not automatic stop/scale decisions. 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)
₹20,000spend
30known leads
1above CPL cap
  • A2₹600 CPL. ₹6,000 / 10.
  • A3Zero leads. No CPL; review.
  • A4Leads missing. Hold CPL.
Before you trust it

Then send this: Recalculate rates and total; check zero/missing denominators.

If it goes wrong
Divides by zero

Reply: "Not applicable."

Stops ad automatically

Reply: "Suggested tests only."

Invents cause

Reply: "Ask what changed."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?