PromptSharp › Prompt Library › Marketing › Attribution reconciliation: platform claims vs source of truth
Attribution reconciliation: platform claims vs source of truth
The ad platform says 400 conversions, analytics says 220, the CRM says 180. Build the reconciliation before finance builds it for you.
The prompt — copy and run it
You are a marketing analytics lead reconciling conversion counts across systems. I will paste the numbers and each system's counting rules as I understand them. Produce: A) A RECONCILIATION TABLE: source, count, counting method (click vs view-through, attribution window, deduplication, conversion definition), and the known reasons the counts diverge — each divergence labeled DEFINITIONAL (explainable by counting rules) or UNEXPLAINED (investigate). B) A DECISION RULE: which number is used for which decision — in-platform optimization, cross-channel budget allocation, and board or client reporting — with one line of rationale each. C) THREE INVESTIGATIONS for the unexplained gaps, ordered cheapest first, each with what a resolved answer looks like. My numbers: [PASTE: conversions claimed by each ad platform, analytics, and CRM/backend for the same period, plus each system's window/dedup settings as far as you know them] Rules: Do not invent, estimate, or fabricate any statistic, benchmark, or performance figure — if a number is not in the material I give you, write "not provided" and flag it. Mark every claim I should verify in my analytics or source systems before it is published or presented. Never include customer personally identifiable information or client-confidential terms.
Why this prompt works
Every marketing team eventually loses a credibility fight over three conversion numbers that disagree. Running the reconciliation on your own timeline — with definitional and unexplained gaps separated — converts an ambush into a methodology footnote you control.
Want the daily version?
The PromptSharp Marketing Brief delivers prompts like this every day. Honest status: sample stage — 50 waitlist signups start the free daily, and waitlist members see every issue first.
Frequently asked
When should I use this prompt?
The ad platform says 400 conversions, analytics says 220, the CRM says 180. Build the reconciliation before finance builds it for you.
Why does this prompt work?
Every marketing team eventually loses a credibility fight over three conversion numbers that disagree. Running the reconciliation on your own timeline — with definitional and unexplained gaps separated — converts an ambush into a methodology footnote you control.
Related Marketing prompts
Scale, kill, or keep testing: the audience portfolio call
Performance by audience is in and the meeting wants decisions. Make the scale/kill/test calls on stated criteria — with an honest …
Pre-launch media QA: the twenty-minute disaster check
The campaign goes live tomorrow. Run the QA that catches the tracking gap, the budget typo, and the missing exclusion before spend…
Weekly performance read: verdict first, story second
Monday morning, accounts are live, and someone will ask 'how's it going?' by 10am. Turn the exports into a verdict-first read that…
Lifecycle leak-finder: where the funnel actually loses people
You own 'retention' in the broadest sense. Map the lifecycle against your real numbers and find the one leak worth a quarter of wo…
All Marketing free prompts
The PromptSharp Marketing Brief page — five full free prompts plus the ladder status.
PromptSharp Daily — free
The cross-vertical sampler: one sharp, copy-paste prompt each day, rotating across the roster. See what each vertical is like before you commit to one.
Double-opt-in. Unsubscribe anytime. No spam, ever.
Home · Prompt Library · Pricing · Archive · Privacy · Terms · Refunds
Finance · CPG · Marketing · Sales · Consulting & Strategy · Product Management · Dev & Engineering · C-suite · Law · Personal Finance · Career & Job Search · Focus & Productivity · Learning · Health & Fitness · Parenting