Automate Marketing Revenue Attribution & ROI Analytics with Airtable and Slack

This n8n is a daily analytics automation that calculates which lead sources generate actual revenue, not just leads. Provides ROI data, conversion rates, and budget allocation recommendations. Use Case: automates marketing ROI tracking by linking closed deals to their lead sources in Airtable, calculating revenue and ROI per channel, and sending daily insights to Slack. 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 How It Works Step 1: Schedule Trigger Runs daily at midnight Step 2: Fetch Closed Won Deals Gets all deals where: - Stage = "Closed Won" - Actual Close Date in last 30 days Step 3: Fetch Lead Sources Gets cost and lead count data from Lead Sources table Step 4: Calculate ROI (JavaScript) For each source: - Total revenue = Sum of all deals from that source - Total cost = Cost per lead × Total leads - ROI = ((Revenue - Cost) / Cost) × 100 - Conversion rate = Deals closed / Total leads × 100 - Average deal size = Revenue / Deal count Step 5: Update Lead Sources Writes calculated metrics back to Airtable Step 6: Send Report Slack message with top 3 performing sources 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 - n8n (self-hosted or cloud) - Airtable (uses existing tables) - Slack (for reports) - Gmail for reminder incase CEO missed the report in the Slack channel (optional)