# Blog Post Roi Calculator

> ---

- Skill: `akhilkannur/blog-post-roi-calculator` (Agent Skill)
- Install (CLI): `npx skillmds@latest add akhilkannur/blog-post-roi-calculator`
- Raw SKILL.md: https://api.skillmd.com/api/skills/akhilkannur/blog-post-roi-calculator/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: akhilkannur (https://skillmd.com/u/akhilkannur)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/akhilkannur/blog-post-roi-calculator

---

--- 
name: blog-post-roi-calculator
description: "Takes two separate exports (Closed Deals from CRM and Traffic Logs from Analytics), stitches them together by Email, and calculates the exact revenue revenue per entry page."
version: 1.0.0
category: Marketing Ops
---

# Content Revenue Attributor


## Core Instructions
You are a highly specialized AI agent focusing on Marketing Ops. Your mission is:
Takes two separate exports (Closed Deals from CRM and Traffic Logs from Analytics), stitches them together by Email, and calculates the exact revenue revenue per entry page.

## Implementation Workflow
### Phase 1: Ingestion & Stitching
1.  **Load CRM Data:** Read `crm_deals.csv`.
2.  **Filter:** Keep ONLY rows where `Deal_Stage` is exactly "Closed Won".
3.  **Load Tracking Data:** Read `web_tracking.csv`.
4.  **Join:** Match the rows from the filtered CRM list to the Tracking list using `Email` as the key.
    *   *Note:* If a deal email is not found in tracking, label their Source as "Direct/Unknown".

### Phase 2: The Calculation
1.  **Group By:** `First_Page_Seen`.
2.  **Calculate:**
    *   **Total Revenue:** Sum of `Amount`.
    *   **Deal Count:** Count of unique emails.
    *   **Avg Deal Size:** Total Revenue / Deal Count.

### Phase 3: Reporting
1.  **Generate Report:** Create a file named `attribution_report.md` (Markdown table).
2.  **Structure:**
    *   Sort the table by **Total Revenue** (Descending).
    *   Include columns: Page, Total Revenue, Deal Count, Avg Deal Size.
3.  **Insight Summary:**
    *   Identify the "Unsung Hero": The page with low volume but high revenue.
    *   Identify the "Vanity Trap": The page with high volume but low/no revenue (if any).

---
*Run this recipe to see which blog posts are actually paying the bills.*

---
*Blueprint ID: blog-post-roi-calculator*
*Source: [Real AI Examples](https://realaiexamples.com)*