Andy Simon

GTM Systems & Revenue Technology

Architecture · PREDICTif Solutions for Wilsonart

Marketing Analytics Lakehouse on AWS

End-to-end multi-channel campaign tracking: ad platforms, website, CRM, and marketing tools unified into reporting-ready models. Later brought in-house.

Source
Ad platforms
Source
Website
GA4 / GTM
Source
CRM
Source
Marketing tools
Ingestion & transform
Lambda + Glue
Event-driven pipelines into the lakehouse
Governed storage
S3 + Lake Formation
Customer data foundation for Marketing
Warehouse
Redshift
Reporting-ready models for attribution, funnel analysis, and planning
Use
Attribution
Use
Funnel analysis
Use
Planning
Use
Tableau / KPIs

The infrastructure layers are bought commodity; the joins and the lifecycle model are the build — the composable pattern from Buy vs. Build for the GTM Stack.

Result

~90% of marketing spend attributable across the customer lifecycle — cost per lead, opportunity, and closed-won pipeline by channel and campaign.

Related writing: GA4 Data API at Build Time · Buy vs. Build for the GTM Stack