We had a customer recently who had a need to track when records were updated or inserted by any of his PeopleImport scenarios. This can be easily accomplished using field mapping options in Stage 1.
First, users would have to create fields in Salesforce to house this data. In this case, I am using date fields named Date Inserted by PeopleImport(to track inserts) and Date Updated by PeopleImport(to track updates) that I have added to the Lead, Contact, and Account objects.
Now on all of my imports I will need to add two columns to my input file containing that day's date and map the date from my file to each of these fields. I will control when these fields are inserted into or updated by my field mapping options in Stage 1 of PeopleImport.
Tracking Date Inserted by PeopleImport
When setting up mapping for my Date Inserted by PeopleImportfields I want to make sure to check the Insert option and select the Do Not Update option in my field mapping box. This will insure that this field is only populated when a record is inserted, thus tracking my insert date.
Tracking Date Updated by PeopleImport
When setting up mapping for my Date Updated by PeopleImportfields, I will make sure to uncheck the insert option on my field mappings and set the update option to 'Update.' This will ensure that this field will only be updated on existing records and not inserted on new records, thus tracking any updates by PeopleImport to my records.
Here is a screen shot of what these mappings would look like on the lead object:
While this example is very granular tracking specific dates records are inserted or updated by PeopleImport, you could also simply just track touch points to records using a simple Salesforce checkbox field.
Need PeopleImport training? View a previously recorded session.