How to Find the Total Number of Records in an Account, Contact or Lead view

Standard

If you are here, you are probably aware that the most rows you can achieve in a CRM view is 250. Moreover, the views in CRM do not tell you the total number of records. Therefore if, for example, you want to know exactly how many contact records do not have the ‘gender’ attribute filled in (or whether it is male or female) it becomes a tedious process of getting the total number of pages, taking away 1,multiplying by 250 and adding the total number of records on the last page.

Here is a workaround.

Step 1: Create a Marketing List

image

Step 2: Add Marketing List Members using an Advanced Find Query that mimics the rules of the view in question

image

Step 3: Click the Find button and Add All Members Returned to the Marketing List

image

Step 4: Take a Good Look at the Marketing List Members Section of the Marketing List Record

image

There it is, above the action toolbar, the total number of members in the marketing list; in this case 1785.

Advertisements

One thought on “How to Find the Total Number of Records in an Account, Contact or Lead view

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s