Hi folks - question around attribution. I'm looking to build a simple dashboard for marketing to see how many MQLs / SQLs are being driven per channel by month, using last touch attribution. Would like to also reflect, but not double-count, any activity that can be attributed to a given channel that isn't last-touch (e.g., an SQL is flagged as coming from a webinar but they got to the webinar via PPC). How would you typically indicate that in a dashboard?
What CRM are we working wirh?
Hubspot
The dashboard for last touch should be rather simple so long as you’re accurately capturing last conversion and stamping relevant data at MQL/SQL conversion. The multi-touch you’re after is hard no matter what.
Thanks, I assumed that might not be easy. 🙂 But provided I can tell whether a given MQL / SQL was 'touched' by another channel prior to the last touch, would the best practice be to just have a separate column let's say for 'indirect' that does have duplicates in it? A drill-down would be nice but a bit more complicated.
Are you seeing multiple conversions between original source (PPC) and MQL?
Not that I'm aware of but will need to dig into the data to be able to tell that for certain.
Matt H. Ibrahim Nalwala can help you out with this.
Appreciate it, thanks all.
