Salesforce Marketing Blog

Salesforce Marketing Blog

Powerful Analytics with Campaign Summaries

John Kucera Oct 26, 2009

Have you ever wanted to see how many people registered for your webinar or attended your tradeshow without running a report?  In Winter 10 it's a breeze with Campaign Summaries!  

Campaign Summaries pic 1


Now you can quickly create detailed campaign metrics catered to your campaigns.  In this example, we'll create a new Attended count and corresponding % attended field to track webinar success.

Setting up new Campaign Summaies is simple:
1) Create a new campaign rollup summary custom field
2) Select the criteria of what it should measure
3) Add it to the page layout



First create a new campaign custom field by clicking: Setup-->Customize-->Campaigns-->Fields-->New

Campaign Summaries pic 2


Then, select Roll-Up Summary as the Data Type & click Next

Campaign Summaries pic 3


Give the field a name: # Attended

Campaign Summaries pic 4


For Summarized Object, select Campaign Members.  For Roll-Up Type select Count.  

Campaign Summaries pic 5


Now here's where the rubber hits the road - the filter criteria.  Select "Only records meeting certain criteria" and you'll see the filter section shown below.  For ours, we want a count of campaign members where the custom field, Attended, is true.  Alternately you could base it on status, but the sky's the limit here!

Campaign Summaries pic 6


Now add it to your page layout and that's it!  Every campaign will now have a count of the # Attended without creating any reports or analytics!  If you want to take it a step further, you can create other metrics such as the % Attended by creating a percent formula fields with criteria like NumAttended__c / NumberSent.

Campaign Summaries pic 7


What Summary fields do you plan to create?  Respond in the comments below to share best practices with us.

 

0 Comments

Post a comment

If you have a TypeKey or TypePad account, please Sign In.