It’s easy to see in Salesforce when you need to know what Lead/Contact/Person Account’s first form completion was in Account Engagement (Pardot), and the date of that completion.
Unfortunately that same data about the LAST form completed is not as readily available. Here’s a way to solve that problem.
Step 1: Create a custom field on the Lead/Contact/Person Account object called “Last Form Completed”
Step 2: Create a custom date field on the Lead/Contact/Person Account object called “Date of Last Form Completed.”
Step 3: Create custom Prospect fields and call it “Last Form Completed” and “Date of Last Form Completed.” Make sure to select the field type of “Date.” For both custom fields in Pardot, select the sync criteria to defer to Account Engagement Values on sync, not Salesforce or Most Recently Updated.
Step 4: Move the fields on the Lead/Contact/Person Account page layout to a place where it makes sense. You could put it with the currently available fields for first form completion/conversion.
Step 5: Go to a form or form handler and in the Completion Actions, select “Change prospect custom field value,” then select the two custom fields you created. For the Date of Last Form Completed,” select “Submission Date” for the value.
Step 6: Test it! I included some screen grabs to demonstrate what it should look like. The fields will overwrite themselves with each new value, so the value in the field is the most recent form completed. You can do the same for Landing Pages, however that will require an Automation Rule to support the use case.
Pardot Geeks Blog Article
This Pardot article written by: Ben LaMothe
Original Pardot Article: https://pardotgeeks.com/2024/05/pardot-form-completion-reporting/
Find more great Pardot articles at https://pardotgeeks.com/author/blamothe/
Pardot Experts Blog
We have categorized all the different Pardot articles by topics.
Pardot Topic Categories
- Account Based Marketing (ABM) (7)
- Business Units (14)
- ChatGPT / AI (3)
- Completion Actions (5)
- Connectors (10)
- Custom Redirects (4)
- Data Cloud (2)
- Demand Generation (8)
- Dynamic Content (6)
- Einstein Features (12)
- Email Delivery (17)
- Email Open Rates (3)
- Pardot A/B Testing (2)
- Email Mailability (16)
- Do Not Email (1)
- Double Opt-in (2)
- Opt Out / Unsubscribe (14)
- Email Preferences Page (6)
- Engagement Studio (16)
- Industries (1)
- Non Profit (1)
- Landing Pages (9)
- Lead Generation (1)
- Lead Management (13)
- Lead Routing (3)
- Lead Scoring (16)
- Leads (3)
- Marketing Analytics – B2BMA (9)
- Marketing Automation (1)
- Marketing Cloud (3)
- Marketing Cloud Account Engagement (4)
- Marketing Cloud Growth (2)
- New Pardot Features (6)
- Opportunities (2)
- Optimization (2)
- Pardot Admin (64)
- Duplicates (1)
- Marketing Ops (1)
- Pardot Alerts (1)
- Pardot API (2)
- Pardot Automations (3)
- Pardot Careers (12)
- Pardot Certifications (4)
- Pardot Consulting (1)
- Pardot Cookies (3)
- Pardot Custom Objects (3)
- Pardot Email Builder (8)
- Pardot Email Templates (9)
- HML (6)
- Pardot Events (16)
- Pardot External Actions (1)
- Pardot External Activities (4)
- Pardot Forms (29)
- Form Handlers (8)
- Pardot Integrations (20)
- Data Cloud (1)
- Slack (1)
- Pardot Lead Grading (5)
- Pardot Lead Source (2)
- Pardot Lightning (1)
- Pardot Migration (1)
- Pardot Nurture / Drip Campaigns (1)
- Pardot Personalization (3)
- Pardot Profiles (1)
- Pardot Releases (18)
- Pardot Sandboxes (2)
- Pardot Segmentation (5)
- Pardot Strategy (7)
- Pardot Sync (2)
- Pardot Sync Errors (1)
- Pardot Tracker Domains (5)
- Pardot Training (3)
- Pardot Vs Other MAPs (4)
- Pardot Website Tracking (2)
- Reporting (22)
- Salesforce and Pardot (31)
- Marketing Data Sharing (2)
- Pardot Users (3)
- Salesforce Automation (5)
- Salesforce Flows (2)
- Salesforce Campaigns (20)
- Salesforce CRM (3)
- Record Types (1)
- Salesforce Engage (3)
- Salesforce Queues (2)
- Security and Privacy (1)
- Tags (3)
- The Authors (504)
- Cheshire Impact (9)
- Greenkey Digital (51)
- Invado Solutions (37)
- Jenna Molby (9)
- Marcloud Consulting (6)
- Nebula Consulting (60)
- Pardot Geeks (44)
- Salesforce Ben | The Drip (235)
- SalesLabX (3)
- Slalom (4)
- Unfettered Marketing (46)
- Uncategorized (1)
- Website Tracking (2)
- Website Search (1)