Multi-Touch Attribution (Contact-Level)
Petavue, please analyze all contacts tied to Closed-Won deals in the past year:
1. Deduplicate Touchpoints: Merge any records for the same channel and campaign within 24 hours.
2. Apply Attribution: Use a U-shaped model (40% first touch, 40% last touch, 20% shared across middle touches) or custom weights supplied via model_weights.
3. Allocate Revenue: Spread each deal’s revenue across its touchpoints, then summarize by:
- Channel
- Campaign
- Contact Role (Decision Maker vs. Influencer)
4. Deliverables:
- Channel Attribution Table
- Campaign Attribution Table
- Contact Role Attribution Table
5. Edge-Case Review: Flag any customer journeys with fewer than 3 touches or more than 25 touches for validation.
- List the top five channels by total revenue credit under the current multi‑touch model.
- Compare revenue allocation for each campaign when using the U‑shaped model versus a flat equal‑weight model.
- Show all contacts flagged in the edge‑case check with fewer than three or more than 25 touches.
What This Prompt Does
This prompt merges and deduplicates each contact’s touchpoints (same channel and campaign within 24 hours) for Closed‑Won deals over the past year, applies a U‑shaped (40‑20‑40) or custom position‑based weighting to split revenue across those touches, then rolls up credits into Channel, Campaign and Contact‑Role tables. It also flags journeys with fewer than three or more than 25 touches to validate the attribution logic.
Strategic Impact
Delivering precise, contact‑level revenue attribution empowers teams to optimize investment, refine campaign strategies, and recognize key influencers.
Business outcomes:
→ Increases marketing efficiency by allocating budget to channels and campaigns with proven impact
→ Aligns sales and marketing around the roles that drive the most revenue influence
→ Enhances attribution policy flexibility with customizable weighting parameters