Overview

Daily analytics automation that calculates which lead sources generate actual revenue, not just leads. Provides ROI data, conversion rates, and budget allocation recommendations.

What It Does

• Runs nightly to analyze closed deals from last 30 days
• Matches deals to their original lead sources
• Calculates total revenue per source
• Computes ROI (revenue vs. cost per lead)
• Determines conversion rates by source
• Updates Lead Sources table with metrics
• Sends weekly reports to team

Business Impact

• Marketing ROI: Know exactly which channels generate revenue
• Budget optimization: Allocate spend to highest-ROI sources
• Data-driven decisions: Stop guessing, start knowing
• Cost reduction: Cut low-performing channels
• Revenue growth: Double down on what works

Technical Requirements

Required Accounts:

• n8n (self-hosted or cloud)
• Airtable (uses existing tables)