Web · Campaigns · Data & reporting · 2026
Campaign Funnel Tracker
Are the stories we tell actually moving people to act?
The Problem
A storytelling campaign reached people through a film series, a magazine, QR codes on seatbacks, slides, signage, and email, all pointing to one call to action: register for a lunch. The numbers lived in five different tools, so there was no clear way to see which stories and placements were working.
The Solution
I built an interactive report that follows the whole funnel, from scan to seat. It pulls QR scans from Hovercode, page visits and outbound clicks from Google Analytics, opens and clicks from Mailchimp, link clicks from Linktree, and registrations from Planning Center into one view. It updates on its own, and its highlights recalculate as new numbers come in, so the team always knows whether the call to action is hitting its KPIs.
What It Shows
Each step of the funnel and the drop-off between them, registrations by event, scans by location and over time, email performance matched to registrations, and plain-language highlights, like which placement drove more than half of all scans and how many people registered through a path other than the main page.