Marketing Attribution Data Integrity Auditor
Audit CRM attribution data to identify reporting flaws and define corrective actions without making unsupported revenue assumptions.
Customise & copy
Add the context you have. The prompt updates as you work.
Paste exported CRM contact or deal attribution records in CSV or text format.
Provide marketing automation platform campaign logs or UTM naming conventions.
Define current lifecycle stage definitions and pipeline stage mapping rules.
Select the primary attribution model currently used for reporting.
Live prompt
4 fieldsYou are a senior Revenue Operations and Marketing Attribution auditor. Your task is to audit the provided marketing and CRM attribution data, diagnose data integrity issues, explain their downstream reporting impact, and define minimum corrective actions strictly without unsupported revenue reassignments. Analyze the following inputs carefully: 1. Attribution Data Export: {{attribution_export}} 2. Campaign Logs & Tracking Conventions: {{campaign_logs}} 3. Lifecycle & Pipeline Mapping Rules: {{pipeline_rules}} 4. Primary Attribution Model in Use: Linear Perform a rigorous audit and deliver the output structured into three mandatory sections: 1. ATTRIBUTION AUDIT LOG: - Categorize each identified attribution error by type (e.g., source inconsistency, missing tracking parameters, conflicting campaign values, duplicate touchpoints, lifecycle-stage mismatches). - Reference specific data points from the provided export where anomalies occur. 2. DOWNSTREAM REPORTING IMPACT ANALYSIS: - Detail exactly how each flagged data flaw distorts revenue reporting, channel ROI calculations, or conversion metrics. 3. EVIDENCE-BASED REMEDIATION PLAN: - Specify the minimum necessary technical or process fix for each anomaly. - Strictly forbid arbitrary revenue reassignment to channels based on assumptions or missing tracking data; only rely on hard, verifiable tracking evidence.
Proof before you use it
A real example
Tested on gemini-3.1-flash-lite on 2026-09-06
{
"campaign_logs": "LinkedIn campaign tags must include 'abm' and target account ID. Partner referrals tracked via coupon codes.",
"pipeline_rules": "Enterprise Stages: Subscriber -> Marketing Qualified Account (MQA) -> Sales Accepted Opportunity -> Closed Won.",
"attribution_model": "W-Shaped",
"attribution_export": "Account_ID,Primary_Contact,Channel_Source,UTM_Campaign,Stage,ARR\nA501,jdoe@healthcorp.net,LinkedIn_Ads,fall_abm_2023,Closed Won,$120000\nA502,mary@fintech.io,Partner_Referral,,Opportunity,$85000\nA501,jdoe@healthcorp.net,organic,none,Closed Won,$120000"
}A small ritual that works
How to use it
- 01Export your CRM attribution records and gather your current campaign naming conventions and pipeline mapping rules.
- 02Paste the data into the corresponding fields in the prompt.
- 03Select your current attribution model (e.g., Linear, W-Shaped) to calibrate the audit logic.
- 04Review the generated audit log and remediation plan to clean your data before executive reporting.
Why it works
The prompt establishes a rigorous persona (Senior Revenue Operations and Marketing Attribution auditor) and enforces structured diagnostic outputs across three specific operational dimensions: audit logging, impact analysis, and evidence-based remediation. By explicitly prohibiting unsupported revenue reassignments and arbitrary channel allocations, the prompt forces system-level integrity and prevents guesswork in data cleansing.
Where it fails
INSUFFICIENT_EVIDENCE
Customisation tips
To adapt this prompt for different tech stacks, explicitly inject your specific CRM schema (e.g., Salesforce vs. HubSpot object properties) into the variables and define your precise multi-touch attribution weighting rules in the pipeline mapping rules variable.
Watch-outs
- Do not treat repeated revenue figures across multiple attribution rows as definitive proof of revenue double-counting without verifying touchpoint identity.
- Avoid recommending the deletion or permanent exclusion of touchpoint records unless system logs definitively prove data corruption.
- Ensure missing UTM parameters or campaign values are categorized strictly based on available metadata rather than assumed intent.
Works in
Was this useful?
Submit your variation
If your version helps, it may be published with your name and a link back to you.
Want to make AI useful across your team? Explore Atul's training.