Blog post roi calculator
Skill akhilkannur/marketing-agent-blueprints/skills/blog-post-roi-calculator
A curated collection of 100+ actionable system prompts and automation blueprints for simple marketing operations. Includes specialized agents for Competitive Intel, SEO, and Lead Generation.
npx -y skills add akhilkannur/marketing-agent-blueprints --skill blog-post-roi-calculatorAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
2 things to look at
- no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
- 3 stars3 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
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.
SKILL.md
1.8 KB, as published. Nobody here has run it
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
- Load CRM Data: Read
crm_deals.csv. - Filter: Keep ONLY rows where
Deal_Stageis exactly "Closed Won". - Load Tracking Data: Read
web_tracking.csv. - Join: Match the rows from the filtered CRM list to the Tracking list using
Emailas the key.- Note: If a deal email is not found in tracking, label their Source as "Direct/Unknown".
Phase 2: The Calculation
- Group By:
First_Page_Seen. - Calculate:
- Total Revenue: Sum of
Amount. - Deal Count: Count of unique emails.
- Avg Deal Size: Total Revenue / Deal Count.
- Total Revenue: Sum of
Phase 3: Reporting
- Generate Report: Create a file named
attribution_report.md(Markdown table). - Structure:
- Sort the table by Total Revenue (Descending).
- Include columns: Page, Total Revenue, Deal Count, Avg Deal Size.
- 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