The Sale Activity Tracker in Google Sheets logs every sales activity (calls, demos, follow-ups, proposals) in one Data sheet and turns it into a pipeline dashboard. You get KPI cards, stage and region charts, rep and product views, and an Activity ID lookup, all filtered with native Google Sheets slicers.
It suits sales managers, founders who still run their own pipeline, and small B2B teams who want a clear weekly pipeline review without paying for a CRM seat per user. The file uses pivot tables, slicers, formulas and charts only: no macros, Apps Script or add-ons. It ships with 500 sample activities, so you can explore every page before you load your own data.
🎥 Watch the Video Tutorial
What the Sale Activity Tracker in Google Sheets Does
A sales team creates many small records every week: a discovery call here, a demo there, a proposal sent, a contract under review. Kept in emails and notes, those records never add up to a pipeline view. This tracker treats each activity as one row with its deal value, stage and win probability. The dashboards then answer the questions that matter in a pipeline meeting:
- How much open pipeline do we have, and in which stage is it stuck?
- How much have we won, and what is our win rate?
- Which regions, lead sources and products bring in the most value?
- What exactly happened on a given deal? (Search by Activity ID.)
Pages Included
A navigation bar links Overview, Pipeline, Reps, Products, Search and Instructions, and the Data sheet sits behind them.
Overview
Four slicers sit at the top (Region, Stage, Product and Month), and the Key Sales Metrics row shows Pipeline Value, Won Revenue, Total Activities and Avg Won Deal. Four charts follow:
- Pipeline by Stage: deal value across Closed Lost, Closed Won, Needs Analysis, Negotiation, Proposal, Prospecting and Qualification.
- Regional Distribution: a donut chart for Central, East, North, South and West. The sample split is close to even, at 18.9% to 21.1% per region.
- Lead Source Performance: deal value by lead source. In the sample, for example, Inbound Chat shows $3,198,291 and Cold Call $2,978,132.
- Product Revenue: value by product line.
Pipeline
This page has its own slicers (Year, Region, Sales Rep and Month) and a Pipeline Metrics row with Deals Won, Deals Lost, Win Rate and Avg Probability. The Monthly Deal Value area chart compares total deal value by month. Stage Value Distribution lists the value sitting in each stage, and Activity Mix shows the share of each activity type.
Reps and Products
The Reps page focuses on individual sales rep performance and comparisons, which helps in one-to-one coaching. The Products page analyses revenue and deal activity by product line, so you can see which offerings carry the pipeline.
Search
Under Activity Lookup, pick an ID in the Enter Activity ID dropdown. Activity Details then lists Activity ID, Date, Sales Rep, Region, Lead Source, Company, Contact Name, Product, Activity Type, Deal Value, Stage and Probability %. In the screenshot, SA-0001 is a Demo by Tom Anderson for Zenith Corp, worth $88,314, in Negotiation at 84% probability.
Data and Instructions
The Data sheet has 13 columns: Activity ID, Date, Sales Rep, Region, Lead Source, Company, Contact Name, Product, Activity Type, Deal Value, Stage, Probability % and Status (Active, Completed or Cancelled). Lead sources in the sample include Trade Show, Website, Inbound Chat, LinkedIn, Cold Call, Referral, Partner and Email Campaign. Activity types include Discovery Call, Demo, Follow-Up, Proposal Sent, Negotiation, Contract Review, Onboarding and Upsell Meeting. The Instructions page explains how to replace the sample data.
Sales KPIs at a Glance
The values below come from the 500-row sample. The calculations are checked against the numbers shown on the dashboard.
| KPI card | What it measures | How it is derived | Sample value | Better when |
|---|---|---|---|---|
| Pipeline Value | Open deal value still in play | Sum of Deal Value for open stages (excludes Closed Won and Closed Lost) | $16,897,095 | Higher |
| Won Revenue | Value of deals won | Sum of Deal Value where Stage = Closed Won | $4,400,327 | Higher |
| Total Activities | Volume of logged sales work | Count of rows | 500 | Context dependent |
| Avg Won Deal | Typical size of a won deal | Won Revenue ÷ Deals Won | $63,773 | Higher |
| Deals Won / Deals Lost | Closed outcomes | Count of Closed Won / Closed Lost rows | 69 / 67 | More won, fewer lost |
| Win Rate | Share of closed deals that were won | Deals Won ÷ (Deals Won + Deals Lost) | 50.7% | Higher |
Quick check: the seven stage bars add up to $23,227,234. Subtract Closed Won ($4,400,327) and Closed Lost ($1,929,812) and you get the $16,897,095 Pipeline Value. Likewise, 69 ÷ (69 + 67) = 50.7%, and $4,400,327 ÷ 69 = $63,773.
How to Use It with Your Own Sales Data
- Make a copy of the file with the link in the PDF guide.
- Open the Data sheet and delete the sample rows, keeping the header row and column order.
- Enter one row per activity. Give each a unique Activity ID (for example SA-0501) so the Search dropdown can find it.
- Use consistent values for Region, Stage, Lead Source, Product, Activity Type and Status. If you add a dropdown with Data → Data validation, typos cannot split a category in two.
- Enter Deal Value as a plain number and Probability % as a percentage, for example 40%.
- Go to the Overview. If a new value is missing from a slicer or chart, check that the pivot table’s source range covers your new rows.
- Run your weekly review on the Pipeline page and drill into individual deals with Search.
Real-World Use Cases
- Weekly pipeline meeting: a sales manager filters the Pipeline page by Month and Sales Rep to see which deals moved, which stalled in Proposal, and how the win rate is trending.
- Lead source budgeting: a founder compares Lead Source Performance across a quarter to decide whether to put more time into LinkedIn outreach, trade shows or inbound chat.
- Territory planning: a regional lead uses the Region slicer with Product Revenue to see which products sell in which territory before setting next quarter’s focus.
Best Practices
- Log activities the same day. A pipeline view is only as fresh as the last entry.
- Update the stage on the latest activity. Agree as a team whether each row represents an activity or a deal snapshot, and stick to it.
- Close deals out. Move dead deals to Closed Lost rather than leaving them open; otherwise Pipeline Value looks better than it is.
- Protect the dashboard pages. Use Data → Protect sheets and ranges so reps can only edit the Data sheet.
- Archive old years. Very large logs slow Google Sheets down. Move completed years to an archive copy.
If you want to understand the pivot tables and slicers behind trackers like this, the Excel Pivot Tables & Dashboards course on NextGenTemplates Academy teaches them step by step, and the skills carry over to Google Sheets.
Limitations: When a CRM Is the Better Choice
- There are no email sequences, reminders or workflow automation. It reports on activities but does not schedule them.
- There is no contact database with history across deals. Each row is a standalone activity.
- Data entry is manual (or a paste from another system).
- Access control is limited to Google Sheets sharing and protected ranges.
If you need any of these, use a CRM and keep this tracker for lightweight reporting.
Related Sales Templates
To plan the activities themselves, see the Sales Activity Calendar in Google Sheets. For target-based KPI tracking, the Sales KPI Scorecard and the CRM KPI Dashboard are good companions. Online sellers may prefer the E-Commerce Sales Performance Tracker. New to sales reporting? Start with how to track sales performance in Google Sheets.
Related template: to track quotas and targets alongside activities, see the Sales Productivity & Target Management Dashboard in Google Sheets.
Frequently Asked Questions
Does the Sale Activity Tracker need Apps Script or add-ons?
No. It uses native Google Sheets pivot tables, slicers, formulas and charts only.
Which deal stages are included?
Seven: Prospecting, Qualification, Needs Analysis, Proposal, Negotiation, Closed Won and Closed Lost. You can use your own stage names, as long as you use them consistently in the Data sheet.
How is Win Rate calculated?
Deals Won divided by all closed deals (won plus lost). With 69 won and 67 lost in the sample, the Win Rate is 50.7%.
Why is Pipeline Value lower than the total of all stages?
Pipeline Value counts only open stages. Closed Won and Closed Lost are excluded, because that money is either already won or gone.
Can my whole team use it at once?
Yes. Share the file in Google Drive. Give reps edit access to the Data sheet and keep the dashboards protected.
How many activities can it handle?
It ships with 500 rows, and a few thousand rows work comfortably. Very large logs slow any spreadsheet down, so archive old years when performance drops.
Wrapping Up
The Sale Activity Tracker in Google Sheets gives a small sales team a proper pipeline view (open value, won revenue, win rate, stage, region, lead source and product) from a single activity log, plus an ID lookup for deal questions. Load one month of your own activities, run a pipeline review from the Pipeline page, and decide from there.
📅 Last updated: October 2026
