function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
JBallJBall 

Quick solution for sub-campaigns/list sources that is report friendly

I just thought I'd share a quick solution we came up with for tracking which sub-campaign (or list source & promotion code, e.g. Google/WP2007) a lead was generated from.  We simply use the Campaign Member status field, listing all possible list sources as a picklist value.  The 50 lines limitation is more than enough for our purposes, and multiple list sources per lead is only about a .01% occurrence.  We keep the default "Sent", and set all the list sources as a "Responded" status.
 
The biggest advantages to this solution are that we needn't attempt any relationship management of custom objects, no work is necessary to maintain the list source when a lead is converted, as Campaign membership is automatically transferred, and reporting is easily done using this field.
 
The drawbacks are that you have to create a new list for each campaign, you're limited to 20 characters per entry, and can only have one per lead, but we feel the benefits more than justify this implementation.

Hopefully this will all be moot come Winter '08.

Message Edited by JBall on 09-12-2007 01:35 PM