Creating Salesforce mention tracking reports when standard report types are unavailable

using Coefficient excel Add-in (500k+ users)

Build custom Salesforce mention tracking reports when standard types aren't available. Access Chatter data directly and automate mention monitoring with advanced filtering.

salesforce to google sheets connector

“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.”

5 star rating coeff g2 badge

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.

500,000+ happy users
Get Started Now
Connect any system to Google Sheets in just seconds.
Get Started

Trusted By Over 50,000 Companies