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
JoannaAtMaritzJoannaAtMaritz 

Importing Lead Data with Attached Campaign

On the Lead object in SFC, there is a standard lookup field called Campaign.  We are trying to import Leads from a flat file, specifying the Campaign Id.  However, the Campaign field does not seem to be available via the Apex Data Loader or via Informatica.  Can anyone tell me how I can specify the campaign on a Lead for import?  Thanks!
jkucerajkucera

Short answer - this field isn't avaible in the API, only in the UI and in Web to Lead.  You can reproduce the behavior w/ a lead trigger or use the API to mass create campaign members if you have a list of the lead id's.

 

The campaign field isn't really a field at all, more like a conduit to auto-create a campaign member for this lead in the specified campaign.  It was created long ago to enable quick creation of members from web to lead or the lead detail.

 

Tangent - as of Winter 10, campaign member workflow, triggers, & validation rules will now fire from the members created from this field on lead, but you must activate the feature under Critical Updates in setup.