In Pardot we have a Prospect Activity tab as follows: enter image description here

I want to have a custom field in Salesforce as Form Handler Last Activity and Visit Last Activity which will be equal to the latest Date/Time for these Activities. Ex. Here for this Prospect , In Salesforce

Form Handler Last Activity = Sep 8, 2020 11:21 AM ; Visit Last Activity = Sep 9, 2020 8:08 AM

Can please someone suggest a way how this can be achieved as I am not able to find a solution for this?

1 Answer 1


You would need to use the Pardot API to accomplish this. In a regular interval, query Visitor activity (use form_handler_only=true for your Form Handler activity, type=20 for visits). Calculate/determine the latest respective visitor activity entry for each prospect then use the API to update each prospect (using either batch update or bulk update depending on your approach and volume)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .