To view orphaned contacts, you can query the MobileLineOrphanContactView data view in Automation Studio. In Contact Builder, create a data extension with the fields in the data view and add a column of NowDate with type Date. In Automation Studio, create an automation and add a SQL query.
Full Answer
What are orphaned contacts in the Pardot Salesforce connector?
The Pardot Salesforce Connector settings can be changed to create Contacts instead of Leads; while this may fit a specific Salesforce use case, it creates an additional challenge: ‘Orphaned’ Contacts, also known as ‘Private’ Contacts. What are Orphaned Contacts? What Happens when Pardot Reverse Syncing is Enabled?
What is the “contacts&accounts” report in Salesforce?
Out of the box, Salesforce gives you a variety of reports for working with Contact records. The most commonly used one is probably “Contacts & Accounts”, I’ll confidently guess it’s your standard go-to report for anything related to the Contact record! So what’s the problem with this report?
What is the go-to contact report in Salesforce?
What’s even scarier, is that the go-to Contact report in Salesforce is the standard ‘Contacts and Accounts’. I’m going to call upon my friend, Stacy, who explained the ‘Contacts and Accounts’ report type limitations so well:
Is there a report for just the contacts object?
There is no report for just the Contacts object, only Contacts & Accounts, or Contacts & something else! Oh, the horror!” As seen in: 5 Salesforce Lead & Contact Hacks Every Admin Should Know
What is a private contact?
Contacts without an Account are called “Private Contacts”. Bonus tip: Account name should be required on the Contact page layout, but don’t forget about your Global Quick Actions, Quick Create, Email Integrations, or any applications that might allow a user to import a Contact Record.
What is text area field?
A Text Area field on Leads (and Contacts, Opportunities, and Accounts), mapped upon Lead Conversion, gives you the exact source of this single Lead, the name of the tradeshow and the date, the name of the webform, or the partner name and company name that referred the Lead. This field is extremely granular, so you may not be doing a lot of reporting on this data, but it will be useful when you want to compare exactly which events are the most successful, or particular events year-over-year.
Can you report contacts?
Oh wait – you can’t! There is no report for just the Contacts object, only Contacts & Accounts, or Contacts & something else! Oh, the horror! Not to worry, there is a simple solution. Just create a custom Report Type for the Contact object, that’s it!
Can you see which contacts came from Lead Conversion?
This information is available in the History reports, but those can be cumbersome to work with. If you want to use a regular Contacts and Accounts report, and see which Contacts came from Lead Conversion, you are out of luck. There’s no out of the box solution to see which records came from Lead Convert, and which did not.
