Skip to content
Sales Activity Tracker cover: a sample sheet with activities logged, calls made and meetings booked and a column chart, beside the Dashboard and Activity tabs

Sales Activity Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

Sales managers and reps use this tracker to measure effort as well as results. On the Activity tab, each call, email, meeting and demo is logged with its date, rep, account, result and minutes spent. The Goals tab sets a call target and a meeting target for each rep and counts what has been done against them. The Dashboard totals activities, meetings booked and hours spent, with charts for activity by rep and by type.

Log each activity on the day it happens, while the result is clear. Pick the result from the list so meetings booked are counted correctly. Review the Goals tab weekly rather than daily. If calls are high but meetings booked are low, filter the Result column for No answer and Callback to see whether the account list needs work before you change how the team calls.

Useful for

  • Setting weekly call and meeting targets for each rep
  • Seeing which activities lead to meetings booked
  • Showing a manager how the week's time was spent on accounts

What's included

  • 4 tabs: Dashboard, Activity, Goals, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Activity: a table
  • Goals: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Activity tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What counts as a meeting booked?

Only the Meeting booked result counts toward the meetings figures. Choose it when the prospect agrees to a meeting with a date and time, even if that meeting is moved later. Use Callback or Proposal sent for the other outcomes so the figures stay honest.

Can the tracker be limited to a single week?

Yes. Copy the file each week and keep only that week's rows on the Activity tab. The dashboard and the Goals tab count every row they can see, so the counts and targets match the same period when you change the targets to weekly figures.

Why do the minutes not match my calendar?

The minutes column records the time spent on each activity, including notes and follow-up, so it will not match a calendar entry exactly. Time a call from dialing to hang-up and estimate an email. Using the same method for everyone matters more than precision when you compare reps.

  • #sales-tracker
  • #sales-activity-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More sales tracker templates

See all 8

Also in Sales

All sales templates
Get this template

Preparing your template…