Snowflake Marketing Analytics Navigator

关于

This skill serves as a specialized domain expert for RDC's Snowflake data ecosystem, enabling users to efficiently analyze marketing performance and consumer behavior. It provides deep context on table schemas, complex attribution rules such as EFR and IEFR calculations, and specific business logic for clickstream and spend data. By automating the application of historical tracking nuances and incrementality multipliers, it helps analysts and developers generate accurate, production-ready SQL queries for reporting on everything from SEM campaign efficiency to cross-platform user journeys.

主要功能

• Embedded logic for EFR and IEFR incrementality calculations across channels
• Standardized mapping for product verticals and lead attribution sources
• Automated SQL generation for clickstream, revenue, and marketing spend tables
• Contextual awareness of historical data gaps and SKAN privacy constraints
• 0 GitHub stars
• Pre-defined query patterns for common KPIs like CPL, ROAS, and IROAS

使用场景

• Calculating incrementality-adjusted revenue and spend efficiency for SEM and Paid Social
• Analyzing multi-touch user journeys from initial clickstream event to lead conversion
• Consolidating cross-channel marketing spend for unified budget and performance tracking