Skip to content

How to report Task activity by event type

When to use this guide: Use this when you log activity as Tasks and want counts per event type (sent, open, click, reply, bounce).

This recipe mirrors the “activity volume” view many teams expect from a HubSpot dashboard: count OutboundSync Tasks whose Subject contains a specific event token.

  1. In Salesforce Lightning, open ReportsNew Report.
  2. Choose a Tasks and Events (or Activities) report type that includes Tasks, then continue.
  3. Set the report to show Tasks (not Events) if the type offers both.
  4. Add columns such as Subject, Due Date / Created Date, Name (related Lead or Contact), and Created By.

Add filters so you only count the event you care about:

GoalSubject filter (contains)
Emails sentEMAIL_SENT
OpensEMAIL_OPEN
Link clicksEMAIL_LINK_CLICK
RepliesEMAIL_REPLY
BouncesEMAIL_BOUNCE

Optional: also require Subject contains [OS] if you use the default prefix, or filter Created By equals your OutboundSync connecting user.

Report filters match substrings, so a shorter token can catch a longer one (for example EMAIL_SENT also matches EMAIL_SENT_TO_LEAD_WITH_LABEL). If you see over-counts, filter on the bracketed token from the default template instead — for example - EMAIL_SENT].

Add a date filter (for example Created Date = This Month) so the chart shows pace, not all-time history.

Clone the report once per event type (one filter each for EMAIL_SENT, EMAIL_REPLY, and so on). Do not group by the full Subject field for an event-type breakdown — the default template includes {{ subject }} , so each email gets a unique Subject and grouping would show one row per message, not per event type. If you need a single multi-type chart, add a Salesforce formula or bucket field that extracts the event token from Subject.

  1. Summarize by Row Count (count of Tasks).
  2. Group by Created Date (day or week) for a volume trend.
  3. Save each cloned report, then add the ones you need to a Salesforce dashboard component (bar or gauge).

Long date ranges undercount. Salesforce archives completed Tasks and Events older than a year, and archived activities are excluded from reports. OutboundSync logs completed Tasks, so all-time Task counts drop older activity. For durable historical totals, use the person-level counters (OSNumberOfEmailOpens__c, OSNumberOfEmailLinkClicks__c) and last-touch fields in contacts reached and engagement — those are not activity-archived.

There is no OSEventType__c custom field — event type comes from Subject only.