Monarch - How to find Accounts that do not have Contacts?

To find out what Accounts do not have Contacts associated with them, please follow the below steps:

1. Download the template of AccountsWithNoContacts.xlsx located at the bottom of the page into your local computer.

2. Get the Account list. To do this, please follow below:

  • Navigate to Accounts under LISTS. 

  • Click Export button on the top right. This will export all the account into an Excel file named AccountsList.csv.  
  • Copy only the first column (NAME) from the AccountsList.csv and paste into the first page (AccountList) on the AccountsWithNoContacts.xlsx template that you just downloaded from step#1.

3. Get the Contact list. To do this, please follow below: 

  • Navigate to Contacts under LISTS.

  • On the top right of the page, click Account and then CSV.  This will export all the account contacts into an Excel file named ContactList.csv

  • Copy all the data from the ContactList.csv and paste into the second page (ContactList) on the AccountsWithNoContacts.xlsx template that you just downloaded from step#1

4. On the AccountsWithNoContacts.xlsx template, click the third page(Missing). On the third page(Missing), all account names are listed on the first column. If the account is missing a contact, "Missing" word will show on the second column otherwise the row number of the contact from the second page(ContactList) will show.

For example, per below screen shots:

"AccountAA" and "AccountBB" have no contacts because they show "Missing" on the Missing? column

"50 Floor, Inc." has a contact and their contact is on the line#17 of second page(Contact List).

"Advance Community Health" has a contact and their contact is on the line#34 of the second page(Contact List).

Did you find it helpful? Yes No