This content has been marked as final. Show 3 replies
Cécile, you are not alone in your desire for an aggregate behavioral analysis capability. Neither RCA/RCE or Salesforce have anything like that.
You would need to export the list and calculate via excel. You can ensure that you do not miss a day and always have the historical score value at the desired points in time after an event by creating score fields to hold the desired scores and smart campaigns to update their values.
You can see which leads have been touched by campaigns using the technique described by Adam Waterson in the Deciding Program Atrtibution Percentages help article where he concatenates campaign names into a text area field.
I agree with Elliott: CRM systems in general do not offer such report.
I would add the detail: you can take advantage of Talend Open Studio instead of spreadsheets (free publicity of your product is pure coincidence).
Exporting to analytical tools such as Jasper Reports Community Edition (free at http://community.jaspersoft.com/) would offer vast possibilities. Eclipse plugins available.
I have given some thoughts about it and I have created smart campaigns (filter for history and trigger for incoming) that sort all my set of April leads into static lists :
- April Leads w/ score < 10 Day 1
- April Leads w/ score 11-49 Day 1
- April Leads w/ score 50-99 Day 1
- April Leads w/ score 100 Day 1
If I then create a trigger campaign for +30 days that says
- Lead has been added to list April Leads w/ score < 10 Day 1
- Activity has taken place 30 days ago
- Lead Score is less than 11
> Add to April Leads w/ score < 10 Day 30 (run once)
Would that work?
If yes, how can I set add to list + wait 30 days + check score?
I can only see add activity constrainst, last 30 days but that would take into account leads that have been created 2 days ago.
Cécile @ Talend