How to track first occurrence of accounts in Salesforce reports while grouping by week

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

Learn how to track first occurrence of accounts in Salesforce weekly reports using advanced formulas and real-time data integration with spreadsheets.

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

Salesforce’s native reporting can’t track first occurrence of accounts when you group by time periods because the grouping functionality resets unique value calculations for each time bucket.

You’ll learn how to overcome this limitation by combining real-time Salesforce data with advanced spreadsheet formulas to track true first occurrences across weekly groupings.

Track first occurrence data using Coefficient

CoefficientSalesforceSalesforcesolves this problem by importing yourdata into spreadsheets where you can use advanced formulas alongsidedata. This approach lets you calculate first occurrences across the entire dataset rather than being limited by grouped time periods.

How to make it work

Step 1. Import your training task data from Salesforce.

Use Coefficient to import Task records with fields like Account ID, Account Name, Activity Date, and Subject. Filter for training activities using a custom SOQL query:. This gives you all training activities for the current year.

Step 2. Calculate first occurrence dates for each account.

Add a helper column with the MINIFS formula:where column C contains Activity Dates and column B contains Account IDs. This formula identifies the earliest training date for each account across your entire dataset, not just within individual weeks.

Step 3. Create weekly groupings that preserve first occurrence data.

Add another helper column using the WEEKNUM formula:to group activities by week. Then use UNIQUE and FILTER functions to show only first occurrences per account while maintaining the weekly structure.

Step 4. Build your summary dashboard with running totals.

Create a pivot table showing accounts by week of first training. Include a cumulative count of unique accounts trained year-to-date using formulas that reference your first occurrence calculations. Set up automatic refresh schedules to keep your data current without manual updates.

Get accurate first occurrence tracking

Start trackingThis approach gives you true first occurrence tracking with weekly granularity that Salesforce reports simply can’t provide.your first occurrences accurately 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