A Campaign Member’s First Associated Date records the date a Lead/Contact became a member of a Salesforce Campaign, and it’s a great metric to use in your reporting. First Associated Date can be used to show how many Leads/Contacts a Campaign touched in a given time period, how long the Lead/Contact was in the campaign before they moved to a “Responded” status, or how long the Lead/Contact was in the campaign before an associated Opportunity was opened. However, sometimes the Campaign Member’s first associated date gets skewed. 

Common causes of this are:

Lead/Contact should have been added to the campaign on September 15th, but was stuck in the Account Engagement sync queue until October 1st

New Leads from an event we’re not uploaded into Salesforce until a few weeks after the event

Campaign Members were brought over from another Salesforce org during a migration

Sales didn’t enter a new Lead they were working with until after the Opportunity was created

If you are relying on Campaign Member First Associated Date for your reporting, any of the above causes can really throw off your data and make a Campaign, or a time period, look less successful than it actually was. Luckily, you can backdate this field with a few system permissions and the help of Data Loader!

You can insert, but not update!

Before we get into the nitty-gritty of how to do this, it’s important to note that you can’t update the Campaign Member First Associated Date of existing Campaign members. You can only insert new Campaign Members with a backdated first associated date. However, you can use Data Loader to export Campaign Members, their Campaign Status, their dates, etc. from a Campaign, delete the Campaign Members, then re-add them to the Campaign with new dates. 

Permissions needed

The first step to updating First Associated Date is enabling “Set Audit Fields Upon Record Creation”.

Navigate to Setup > User Interface 

Ensure the “Enable “Set Audit Fields upon Record Creation” and “Update Records with Inactive Owners” User Permissions” option is selected

Select Save

Next, create a Permission Set for “Set Audit Fields Upon Record Creation” and assign this Permission Set to the user(s) who will handle the Data Loader imports. 

Navigate to Setup > Permission Sets

Select New

Name your Permission Set “Set Audit Fields Upon Creation”

Select Save

Within your new permission set, type “Set Audit” into the “Find Settings” box

Select Set Audit Fields Upon Creation

Select Edit on the resulting page and select the Set Audit Fields Upon Creation checkbox 

Select Save

Select Manage Assignments 

Select Add Assignments

Select any users who will be handling the Data Loader imports of Campaign Members, then select Next and Assign

Import your data

Finally, get your Data ready for import! At a minimum, you’ll want to make sure your file includes:

Campaign ID

Lead ID and/or Contact ID

If you are importing both Leads and Contacts into the Campaign, I recommend splitting the import into 2 files. 

Campaign Member Status (if different from the Campaign’s default Status)

Campaign Member first associated date

Ensure the column is formatted using one of the options below, otherwise you will get an error.

MM/DD/YYYY (example: 04/23/2012)

DD/MM/YYYY (example: 23/04/2012)

YYYY-MM-DD (example: 2012-03-25)

To import the data

Open Data Loader and login

Note: Updating Campaign Member First Associated Date is not possible with the Data Import Wizard, only Data Loader.

Select Insert

Note: The ability to map to Campaign Member First Associated Date will not be available if you select Update or Upsert.

Check the Show all Salesforce Objects checkbox and search for CampaignMember

Select your CSV file and click Next

Select Create or Edit a Map and map your fields

CreatedDate is the field you’ll need to map to the Member First Associated Date column

Select OK > Next > Finish

And Voila, beautiful, accurate Campaign Member data!

Original article: Fix Your Reports! How to Backdate Campaign “Member First Associated Date”

©2023 The Spot. All Rights Reserved.

The post Fix Your Reports! How to Backdate Campaign “Member First Associated Date” appeared first on The Spot.