Meta Full Funnel Tracker
Meta Full Funnel Tracker
Meta Funnel Tracker
End-to-end lead + revenue attribution system that connects paid traffic to form submissions, bookings, and payments in one clean reporting spreadsheet.
Category
Funnel Automation
Client
bencraughwell.com
Start Date
December 17, 2025
Developer
Tanvir
Key Features
Email_Key Matching
Standardized email key (lowercase + trimmed) ensures Typeform, Calendly, and Stripe data merges into the same row.
Clean Master Sheet
One Master_Leads table for operations + reporting (no duplicate records, no manual copy/paste).
UTM Preservation
UTM parameters are retained through the redirect to Typeform so performance stays measurable by campaign/ad set/ad.
Scalable Automation
Works for high volume. Easily extendable with extra status fields, revenue logic, and dashboard charts.
(Typeform → Calendly → Stripe) Google Sheets Reporting
What I Implemented
- Zap-1:Typeform → Master_Leads(Create Row) for every new Submission.
- Zap-2:Calendly → Master_Leads (Find Raw By Email_key → Update Raw) to merge booking details into the same Lead record.
- Zap-3: Strioe → Master_Leads (Find Raw by Email_key → Update Row) to attach payment status + revenue to the correct Lead.
- Attribution reliabiliy: UTM + click IDs pass Correctly from the main website into the Typeform Url,keeping attrubution intact.
Workflow Summary
- Meta Ad Click → Website Landing Page (UTM captured)
- CTA Click → Typeform (UTM carried into Typeform URL)
- Typeform Submit → Master_Leads (Create Row)
- Calendly Booking → Master_Leads (Find by Email_Key → Update Row)
- Stripe Payment → Master_Leads (Find by Email_Key → Update Row)
Deliverables
- Master_Leads sheet structure for full-funnel visibility
- Zapier automation (Typeform + Calendly + Stripe-ready mapping)
- Attribution-safe URL parameter flow into Typeform
- Documentation-ready setup flow for the owner/team