Reply
Contributor
Ms.TMB
Posts: 4

Report on Number of Campaigns per Lead or Contact

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!


Contributor
sepple
Posts: 5

Re: Report on Number of Campaigns per Lead or Contact

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.