)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Standard Salesforce query tools and report builders struggle with null login date conditions when date filters are required, creating a logical barrier to finding unused accounts.
Here’s how to execute direct SOQL queries that bypass these limitations and return exactly the user data you need.
Execute direct SOQL queries using Coefficient
CoefficientSalesforceSalesforce‘s custom SOQL capability directly addresses this limitation by executing queries without mandatory date selection. Unlike native reporting tools that force date parameters even for null value queries, Coefficient executes SOQL directly against thedatabase throughintegration.
How to make it work
Step 1. Use the custom SOQL query import feature.
Paste this query directly into Coefficient’s custom query interface:
Step 2. Execute without date filter requirements.
Coefficient executes the query without mandatory date selection, giving you direct access to the database results. This bypasses Salesforce’s UI requirement for date filters entirely when dealing with null values.
Step 3. Handle empty login timestamp results effectively.
The query returns exactly what you need – active users where last login date is empty. You can then sort by CreatedDate to prioritize oldest unused accounts or add additional analysis in your spreadsheet.
Step 4. Set up automated refresh scheduling.
Configure daily imports to maintain current lists of unused active accounts. This provides ongoing monitoring of security compliance without repeatedly running manual queries or dealing with UI constraints.
Execute your queries without limits
Start queryingThis approach provides precise results for active users with blank login history by executing SOQL directly against the database without UI constraints.your Salesforce data with complete flexibility today.
