Print this page

How to create a report for Activities that are on Leads and Contacts related to Campaigns?

Knowledge Article Number 000220214
Description When adding Activities to Contacts/Leads, these Activities are not directly link with the source Campaign. So, reporting on Activities from Campaign Members is currently not possible in Salesforce yet. There is an idea posted related to this: https://success.salesforce.com/ideaview?id=08730000000BqB3AAK
Resolution As a work around, create 2 custom report types. 
  • 1st report type is for Campaigns with Contacts with Activities
  • 2nd report type Campaigns with Leads with Activities

Then create 2 separate reports using these report types. 

--------------------------------------------------------------------------------
To create a custom report type (Campaigns with Contacts with Activities)
 
1. From Setup | Create | Report Types. 
2. Click on New Report Type. 
3. Select Campaigns as the primary object. 
4. Name the report type "Campaigns with Contacts with Activities". 
5. Select the folder where you want it to save (Ex. Other Reports or Campaigns). Click Next. 
6. Add a child object Contacts then Activities and specify it like this: 

Campaigns (A) 
with at least one related record from Contacts (B) 
with at least one related record from Activities (C) 

7. Click Save. 

To create a custom report type (Campaigns with Leads with Activities)
 
Repeat Steps 1-3, name the 2nd report type as Campaigns with Leads with Activities. Then specify it like this:

Campaigns (A) 
with at least one related record from Leads (B) 
with at least one related record from Activities (C) 

 
--------------------------------------------------------------------------------
To create a report:

1. From the Reports tab, click on New Report. 
2. Select the report type Campaigns with Contacts with Activities, click Create.
3. Select a Specific Campaign or select All Campaigns
4. Click the Add button to add a filter.
5. Customize the report. Remove or Add columns that you want to show on the report.
6. Run the report and Save.

--------------------------------------------------------------------------------




promote demote