Search Community
- Force.com Discussion Boards
- :
- Salesforce User Discussions
- :
- Best Practices Discussion
- :
- Report on Number of Campaigns per Lead or Contact
turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Report on Number of Campaigns per Lead or Contact
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
08-14-2008 12:18 PM
I want to run a report to see how many of our leads and contacts have responded to more than one campaign. Specifically, I want to see how many leads/contacts have responded to 4 or more of our webinar type campaigns.
I've tried running a Campaign with Contacts report and then grouping by Contact ID. Then I can see how many records (campaigns) each Contact has responded to. However, I can't filter or sort by number of campaigns. And when I try exporting the data into Excel, the file is too large to do any manipulation.
Ideas?
Thanks!
I've tried running a Campaign with Contacts report and then grouping by Contact ID. Then I can see how many records (campaigns) each Contact has responded to. However, I can't filter or sort by number of campaigns. And when I try exporting the data into Excel, the file is too large to do any manipulation.
Ideas?
Thanks!
Re: Report on Number of Campaigns per Lead or Contact
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
12-03-2008 01:36 PM
I've exported data into a quick access database and grouped them by the lead (or contact) id. It is a quick way to get the total number of campaigns for each lead (or contact).
I wish there was an easy way to calculate the total number into a field. We use campaigns as touch points and score based on the total number of touch points. I believe there is an advanced way to run a script to calculate this but for now I am doing it by hand.

