Filter Data Sets By Activities

With a combination of cross-object filters and smart dates, you can filter data sets by upcoming events or activity history, painting a picture of the customer journey and helping you to plan events, tasks, and routes accordingly. This can be especially useful for sales reps or customer success managers who want to get insight about which records need more attention.

In this document, we'll show you an example of a data set of Accounts with a scheduled Events in the upcoming week. Since Events are a child object of Accounts, we will use a cross-object filter. You can follow these steps for any object and its related child records, such as case history, check-ins, contact history, etc.

Accounts with an Event Scheduled This Week

Follow these steps:

1. Create a data set for Accounts or whatever object you want to visualize.

2. In the Filters tab of the Data Set Editing module, click Add Cross Object Filter

3. Select a child record to filter by from the cross-object drop-down list. In this example, we chose Events.

4. Click Add Events Filter and select a field. For our example, we selected Due Date Only because want to show events that are scheduled in the next week. 

5. Select an operator and value. Since we chose a date field, we can choose a smart date value by clicking the Smart Date button. For this example, we selected equals as the operator and THIS_WEEK as a Smart Date value. Save your data set. 

6. Load your data set and instantly visualize your meetings for the week. From here, you can plan your course of action and build your upcoming route.

More Use Cases

Accounts With No Check-Ins in the Last Month

This filter logic can help you see which accounts need more attention:
Accounts with Geopointe Check-ins
Created Date less than LAST_MONTH 

Accounts with a High-Priority Task Due This Month

This filter logic can help you see which tasks should be at the top of your to-do list:
Accounts with Tasks
Due Date equals THIS_MONTH
High Priority equals true

Accounts with No Activity

With the following filter logic, you can see accounts with no Last Activity Date:
Last Activity Date equals NULL

  • Salesforce uses specific criteria to determine Last Activity Date.
  • If you use a blank value instead of NULL for this filter, you may see the following error message: expecting a colon, found ')'

Add To An Existing Route

If you already have a route planned, you can maximize your day by adding stops from your targeted search. You can even use a shape search to find records along your existing route.

Get more info about routing and data sets from the helpful links below.


Learn More

Data Sets
Tutorial: Geopointe Routing
Scheduled Routes
Routing for the Salesforce Mobile App