To create a pivot grid to show leads by hour, navigate to any of the 3 screens: Search Leads, Lead Maximizer, or Client Distribution. This example will show how to add this report from the Search Leads screen. 

Here is the lead search screen

Click on Pivot to open the pivot grid screen.

Navigating to Pivot Grid screen

Next:

  1. Set the field to Date Added, and add the field as a column.

  2. Select the interval to be done by hour.

Setting the Field and Interval

Then:

  1. Set the field to UID.

  2. Add field and select Data Item

  3. Set the calculation to Count.

  4. Your pivot grid will now show you (in military time) the amount of leads you received per hour.

Leads received per hour

Set the field back to Date Added and add one more column field set to Day. This splits up the report on a per day per hour basis.

Leads received per hour

Did this answer your question?