I need a report in BC to show all the contacts in the CRM with name, contact information, company name and a list of their activity (opened email, clicked on link, etc). There is a list of the Activity in the Activity tab under each contact but I am unable to run a report with the information. I realize that there is no set Custom form with Activity (they forgot to ask sales and marketing what they really need on these report).
The only alternative I know is to download the entire database which should include the Activity -- but I don't see a way to do that.
WHY would they not include this report as standard? It is much more valuable to a sales and marketing team than some of the other goofy reports. We want our sales staff to reach out to be able to rate and score each contact based on their level of activity and then have sales follow-up. For example if someone opened an email campaign 10 times in two days and click the same link 4 times, they would make an excellent prospect to follow-up with a phone call. But it's pretty hard to make this happen without a report.
Any ideas?
