This is a really common RevOps problem and you’re right to avoid relying purely on the analytics page. What’s worked best for me is treating sequences as a data model problem, not a reporting one:
Create a canonical “Sequence ID / Original Sequence” property and force cloned sequences to reference it (manual tagging is totally fine short-term).
Stamp Sequence Name + ID + Enrolled by (SDR) at enrollment time via workflow where possible.
Tie leads to campaign first, then campaign → sequence via that shared ID (otherwise attribution gets messy fast).
Once that’s in place, the dashboards become straightforward:
Weekly enrollments per SDR
% of assigned leads that ever got a sequence stamp
Adoption by campaign based on stamped enrollments, not native sequence reports
HubSpot can handle this, but only if the properties and conventions are clean from the start.
