)
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.”
Salesforce’s native reporting forces you to select date ranges for LastLoginDate filters, which automatically excludes users who have never logged in since they have null login dates.
Here’s how to bypass this limitation and identify active users with no login history using direct data access.
Access user data without date picker constraints using Coefficient
CoefficientSalesforceeliminates the mandatory date picker problem by connecting directly to yourdata through API calls rather than the constrained reporting interface. This gives you complete access to User object data, including records with null login dates that standard reports can’t capture.
How to make it work
Step 1. Import User object data directly.
SalesforceIn, select “From Objects & Fields” and choose the User object. Include fields like Id, Username, IsActive, LastLoginDate, CreatedDate, and Profile.Name. No date picker will appear since you’re accessing raw object data.
Step 2. Apply null login date filters.
Use Coefficient’s advanced filtering with “LastLoginDate is blank” condition combined with “IsActive = TRUE” to identify active users who have never logged in. This filtering happens in your spreadsheet environment, which naturally handles empty cells.
Step 3. Use custom SOQL for complex queries.
For more control, write a custom query:. This bypasses all UI limitations entirely.
Step 4. Set up automated monitoring.
Schedule daily refreshes to track unused active accounts for security compliance. You can also create formulas liketo categorize users automatically.
Start tracking unused accounts today
Get startedThis approach gives you complete visibility into active users with null login dates while eliminating the date picker constraints that block native Salesforce reporting.with Coefficient to access your full user data without limitations.
