what is the difference between campaign member "Member First Associated Date" and campaign member "Created date"?

Object: Campaign Member


The Member First Associated Date is when the user was first added to a particular campaign. The Created Date is a Date/Time field that just notes when the campaign member record was created.

  • When a member is added to a campaign isn't it associated with a campaign ? So what how is the associated date different ? May 29 '15 at 14:35
  • Agreed. CreatedDate is a standard database field, so it'll appear on every object regardless of how redundant it may seem. Also, if you are migrating data from a legacy system (audit fields enabled), you can enter a historical value for CreatedDate, thereby causing CreatedDate to not exactly equal MemberFirstAssociatedDate.
    – James
    May 29 '15 at 14:35
  • @SalesDriver they are really the same. Just different names and different descriptions but other than that there isn't a difference. May 29 '15 at 14:39
  • @BlairKristin But the dates are different why is that so ? May 29 '15 at 14:49
  • @SalesDriver what are the dates for each one as an example? May 29 '15 at 15:01

We use a Process Builder and custom fields to mimic the behavior of the report column. It runs on creates and edits of Campaign Members. If the CM has a Lead ID, (it may not, the member could be a Contact or who knows what), and if that Lead's Camp_Name__c doesn't match the campaign member's Campaign's Name field, it stores:

  • the campaign's Name field to the Lead's Camp Name field,
  • the campaign's Type field to the Lead's Camp Type field, and
  • the formula Now() to the Lead's Camp Date field.

So we always have the date on which the Lead most recently began its association with a campaign, and the name and type of that campaign. Previous associations are forgotten.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.