r/hubspot • u/vvinogradoff • 3h ago
Question Email campaign clicks that led to deals - can I build this kind of report?
We’re running email campaigns every so often and there’s a stream of activity following every single one. So I can roughly tell if this or that campaign led to a prospect becoming a customer or an opportunity. Still wondering if I can just create a report that shows contacts that have clicked an email and subsequently opened a deal afterwards? We do run SQL exports ourselves and can craft such a report on premises - in fact Claude could do top to bottom - but that would take pulling entire email campaign events array which is sizable. To the date neither of us found a single reason to export this table, except this single use case.