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.
How to use this prompt
- Copy the full prompt above with the Copy button.
- Add your context. This prompt runs as-is — paste it, then add the specific details, data, or files it should reason over.
- Paste into ChatGPT, Claude, or Gemini and run. Read the reality guardrail below before you act on the output.
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.
Get a prompt like this every day
The PromptSharp Marketing Brief ships one desk-ready prompt every weekday — free on the web today. Free forever. Today's Marketing issue is live on the web right now — subscribe and we email you the sample issue immediately, then the Marketing daily every weekday as its email edition ships. Unsubscribe anytime.
Subscribe free → Read a sample issueFrequently 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
Objective to KPI tree: make it measurable before it launches
The objective slide says 'drive awareness and sales.' Before the plan locks, force objectives that can actually be measured — and …
Post-campaign wash-up that tells the truth
Campaign is done, the readout is due. Write the retro that says what the numbers support — not the one that launders the result in…
Message hierarchy: from feature list to claim ladder
Product marketing handed you nine features. Build the benefit ladder and find out which claims have proof — before legal or realit…
Budget reallocation: the marginal-dollar argument
There is pressure to move budget into the 'winning' channel. Build the reallocation case that respects diminishing returns and att…
Creative test post-mortem: did the winner really win?
The test 'has a winner' and everyone wants to scale it. Interrogate the result before it becomes the new control.…
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…
Segment hypotheses from the data you already have
Everyone wants personas; you have a CRM export and campaign history. Build evidence-based segment hypotheses before anyone invents…
All Marketing free prompts
The PromptSharp Marketing Brief page — five full free prompts plus today's issue.
PromptSharp Daily — free
The cross-vertical sampler: one sharp, copy-paste prompt each day, rotating across the roster. Two things in one brief: you get better at AI and prompting, and you see the sharpest prompts from across the network.
Double-opt-in. Unsubscribe anytime. No spam, ever.
Even a sharp prompt starts from zero unless your AI knows you. Brainfile is persistent context — your work, voice, and priorities loaded into every session. Brainfile is the memory; PromptSharp is the playbook. Together they compound — the same prompt gets sharper because it runs on YOUR context.
Set up your brainfile →Want both? The All-Access + Brainfile annual bundle covers the pair.
Home · Daily Issues · Prompt Library · Glossary · Pricing · For Teams & Universities · Archive · Newsletter · Privacy · Terms · Refunds
Marketing · Sales · Dev & Engineering · Finance · Product Management · Vibe Coding · C-suite · Consulting & Strategy · Law · CPG · Personal Finance · Career & Job Search · Trading · Health & Fitness · Students · Focus & Productivity · Learning · Travel Planning