)
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.”
When standard Salesforce report types for mention tracking are unavailable, native reporting options become severely limited since Chatter data access through standard reports is restricted and complex.
Here’s how to build comprehensive mention tracking that bypasses report type limitations entirely while providing detailed insights into team communication patterns and user engagement.
Build advanced mention tracking using direct Chatter object access with Coefficient
CoefficientSalesforceSalesforceprovides superior mention tracking by accessing FeedItem and FeedComment objects directly fromusing custom SOQL functionality. This approach identifies mentions through text pattern matching for “@username” patterns while joining Chatter data with User and business objects for comprehensive context that standardreport types cannot provide.
How to make it work
Step 1. Write custom SOQL queries for mention detection.
Use Coefficient’s custom SOQL functionality to query FeedItem and FeedComment objects, searching Body fields for mention patterns. Write queries like `SELECT Id, Body, CreatedDate, CreatedById FROM FeedItem WHERE Body LIKE ‘%@%’` to capture all potential mentions.
Step 2. Apply advanced text filtering for mention identification.
Use Coefficient’s filtering capabilities to search Chatter post content for specific mention patterns, user-specific mentions, or mention frequency across different time periods. Filter for posts containing “@” followed by specific usernames or roles.
Step 3. Join mention data with business context.
Create multi-object queries that combine FeedItem data with User, Account, and Opportunity objects. This shows which users are most active in mentions, which accounts generate the most mention activity, and how mentions correlate with business outcomes.
Step 4. Set up automated mention monitoring.
Schedule hourly or daily refreshes to capture new mentions as they occur. Configure email and Slack alerts when specific users are mentioned or when mention volumes exceed defined thresholds for immediate notification of important communications.
Step 5. Build historical mention analysis.
Use Coefficient’s append new data functionality to maintain a comprehensive historical database of mentions. This enables trend analysis, communication pattern identification, and user engagement tracking over time without losing historical context.
Monitor team communication with comprehensive mention intelligence
Start buildingThis approach provides detailed mention tracking and analysis that far exceeds standard Salesforce reporting while enabling real-time monitoring and historical trend analysis.your advanced mention tracking system today.
