---
title: Salesforce Field History Reports For Tracking Stage Or Field Changes In Spinify
description: Learn how to use Salesforce Field History Tracking to report on stage and field changes, prevent duplicate counts, and use the data in Spinify.
---

[Skip to content](https://knowledge.spinify.com/help/salesforce-field-history-reports#main-content)

English

Show submenu for translations

[Create Ticket](https://knowledge.spinify.com/help/kb-tickets/new?hsLang=en) [Customer Portal](https://knowledge.spinify.com/tickets?hsLang=en)

- [Home](https://knowledge.spinify.com/)
- [Customer Portal](https://knowledge.spinify.com/tickets?offset=0)
- [Academy](https://academy.spinify.com/trainings)
- [YouTube](https://www.youtube.com/channel/UCr89cR8jfrU7LbTBFSu2iPQ)
- [Success Stories](https://spinify.com/customer-stories/)
- [Blog](https://spinify.com/blog/)

Open main navigation

Close main navigation

- [Home](https://knowledge.spinify.com/)
- [Customer Portal](https://knowledge.spinify.com/tickets?offset=0)
- [Academy](https://academy.spinify.com/trainings)
- [YouTube](https://www.youtube.com/channel/UCr89cR8jfrU7LbTBFSu2iPQ)
- [Success Stories](https://spinify.com/customer-stories/)
- [Blog](https://spinify.com/blog/)
- English
  
  Show submenu for translations
- [Create Ticket](https://knowledge.spinify.com/help/kb-tickets/new)
- [Customer Portal](https://knowledge.spinify.com/tickets)
- [Spinify Academy](https://academy.spinify.com/trainings)

[Spinify Academy](https://academy.spinify.com/trainings)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Spinify Knowledge](https://knowledge.spinify.com/help?hsLang=en)
2. [Integrations](https://knowledge.spinify.com/help/integrations?hsLang=en)
3. [Salesforce](https://knowledge.spinify.com/help/integrations?hsLang=en#salesforce)

# Salesforce Field History Reports For Tracking Stage Or Field Changes In Spinify

### Overview

Salesforce doesn't store the date that an opportunity entered a specific stage by default. This makes it difficult to answer questions like:

- How many opportunities moved to **Demo Completed** this month?
- How many deals reached **Advocate** this month?
- How many opportunities became **Active Trials** this month?

Fortunately, Salesforce's **Field History Tracking** can be used to report on field changes over a specific time period. By combining this with a **Unique Count** in your report, Spinify can accurately measure how many records changed to a particular value without double-counting.

This approach removes the need to create additional date fields purely for reporting purposes.

### Before You Begin

Field History Tracking must be enabled for any field you want to report on.

If history tracking is not enabled before changes occur, Salesforce will not record those historical changes.

### Step 1: Enable Field History Tracking

1. In Salesforce, go to **Setup**.
2. Open **Object Manager**.
3. Select the object you want to track (for example, **Opportunity**).
4. Select **Fields & Relationships**.
5. Click **Set History Tracking**.
6. Enable **History Tracking** for the object (if not already enabled).
7. Select the fields you want Salesforce to track.

#### Examples include:

- Stage
- Demo Completed
- Proposal Sent
- Contract Signed
- Any custom checkbox or picklist field

> **Note:** Formula fields cannot be tracked. If the value is generated by a formula, you'll need to track the underlying field instead.

### Step 2: Create an Opportunity Field History Report

Create a new report using the **Opportunity Field History** report type.

Apply the following filters:

| Filter | Value |
| --- | --- |
| Edit Date | This Month (or your desired timeframe) |
| Opportunities | All Opportunities (or as required) |
| Field | The field being tracked (for example, Stage) |
| Field / Event | The field you want to track |

### Step 3: Filter for the New Value

Add a filter for the **New Value**.

For example:

- Advocate
- Differentiate
- Demo Completed
- Any other value you want to track

This will return every instance where the selected field changed to that value during the reporting period.

Example:

| Opportunity | Previous Value | New Value |
| --- | --- | --- |
| Deal A | Win Back | Differentiate |
| Deal A | Differentiate | Advocate |
| Deal B | Win Back | Advocate |

### Step 4: Add Opportunity ID

To prevent the same opportunity being counted multiple times:

1. Add the **Opportunity ID** field to the report.
2. Open the Opportunity ID column menu.
3. Select **Show Unique Count**.

This creates a unique count of opportunities instead of counting every individual field change.

#### Why this matters

Without a Unique Count:

- Win Back → Differentiate
- Differentiate → Advocate

would count as **2** changes.

With a Unique Count:

That opportunity is counted only **once**.

### Step 4: Add Opportunity ID

To prevent the same opportunity being counted multiple times:

1. Add the **Opportunity ID** field to the report.
2. Open the Opportunity ID column menu.
3. Select **Show Unique Count**.

This creates a unique count of opportunities instead of counting every individual field change.

#### Why this matters

Without a Unique Count:

- Win Back → Differentiate
- Differentiate → Advocate

would count as **2** changes.

With a Unique Count:

That opportunity is counted only **once**.

### Step 6: Connect the Report to Spinify

When importing the Salesforce report into Spinify:

1. Select the report you've created.
2. Choose the appropriate score column.

You'll typically have two options:

- **Record Count**
- **Unique Count (Opportunity ID)**

Choose **Unique Count** if you want to measure the number of opportunities that reached the target stage or value.

Choose **Record Count** if you want to count every individual field change.

#### Example

Imagine one opportunity progresses like this during the month:

- Win Back → Differentiate
- Differentiate → Advocate
- Advocate → Closed Won

The report would show:

| Metric | Result |
| --- | --- |
| Record Count | 3 |
| Unique Opportunity Count | 1 |

For most Spinify competitions, **Unique Count** is the recommended metric because it measures how many opportunities achieved the milestone, rather than how many times they changed.

Also see: [How to Use Salesforce Reports in Competitions](https://knowledge.spinify.com/help/how-to-use-salesforce-reports-in-competitions?hsLang=en) 

### Common Use Cases

This method can be used for much more than opportunity stages.

Examples include:

- Opportunities moved to Demo Completed
- Active Trials started
- Proposal Sent
- Contract Signed
- Discovery Completed
- Qualification Completed
- Any tracked checkbox
- Any tracked picklist value

Essentially, any tracked field can become a leaderboard metric in Spinify.

### Benefits

Using Field History Tracking allows you to:

- Track when fields change without creating additional date fields.
- Report on changes within any timeframe.
- Avoid duplicate counting by using Unique Count.
- Build more accurate Spinify competitions and leaderboards.
- Measure milestones that were previously difficult to report on in Salesforce.

This provides a flexible way to track meaningful sales activities while keeping your Salesforce configuration simpler and your reporting more accurate.

- [Discover Spinify](https://knowledge.spinify.com/help/discover-spinify?hsLang=en)
- [Quick Set Up](https://knowledge.spinify.com/help/quick-set-up?hsLang=en#main-content)

    - [Competitions & Leaderboards](https://knowledge.spinify.com/help/quick-set-up?hsLang=en#competitions-leaderboards)
    - [Users](https://knowledge.spinify.com/help/quick-set-up?hsLang=en#users)
    - [Achievements](https://knowledge.spinify.com/help/quick-set-up?hsLang=en#achievements)
    - [TV & Displays](https://knowledge.spinify.com/help/quick-set-up?hsLang=en#tv-displays)
    - [Onboarding](https://knowledge.spinify.com/help/quick-set-up?hsLang=en#onboarding)
    - [Single Sign On](https://knowledge.spinify.com/help/quick-set-up?hsLang=en#single-sign-on)
- [Integrations](https://knowledge.spinify.com/help/integrations?hsLang=en#main-content)

    - [Agentbox](https://knowledge.spinify.com/help/integrations?hsLang=en#agentbox)
    - [MRI Box and Dice](https://knowledge.spinify.com/help/integrations?hsLang=en#mri-box-and-dice)
    - [Bullhorn](https://knowledge.spinify.com/help/integrations?hsLang=en#bullhorn)
    - [Zendesk](https://knowledge.spinify.com/help/integrations?hsLang=en#zendesk)
    - [PowerBI](https://knowledge.spinify.com/help/integrations?hsLang=en#powerbi)
    - [CSV Upload](https://knowledge.spinify.com/help/integrations?hsLang=en#csv-upload)
    - [HubSpot](https://knowledge.spinify.com/help/integrations?hsLang=en#hubspot)
    - [Google Sheets](https://knowledge.spinify.com/help/integrations?hsLang=en#google-sheets)
    - [Google Slides or Google Calendar](https://knowledge.spinify.com/help/integrations?hsLang=en#google-slides-or-google-calendar)
    - [Spinify API](https://knowledge.spinify.com/help/integrations?hsLang=en#spinify-api)
    - [Salesforce Reports](https://knowledge.spinify.com/help/integrations?hsLang=en#salesforce-reports)
    - [Microsoft Excel](https://knowledge.spinify.com/help/integrations?hsLang=en#microsoft-excel)
    - [Pipedrive](https://knowledge.spinify.com/help/integrations?hsLang=en#pipedrive)
    - [Salesforce Trailhead](https://knowledge.spinify.com/help/integrations?hsLang=en#salesforce-trailhead)
    - [Tableau](https://knowledge.spinify.com/help/integrations?hsLang=en#tableau)
    - [LockedOn](https://knowledge.spinify.com/help/integrations?hsLang=en#lockedon)
    - [Microsoft Teams](https://knowledge.spinify.com/help/integrations?hsLang=en#microsoft-teams)
    - [SQL](https://knowledge.spinify.com/help/integrations?hsLang=en#sql)
    - [Slack](https://knowledge.spinify.com/help/integrations?hsLang=en#slack)
    - [Microsoft Dynamics](https://knowledge.spinify.com/help/integrations?hsLang=en#microsoft-dynamics)
    - [Outreach](https://knowledge.spinify.com/help/integrations?hsLang=en#outreach)
    - [Rex Software](https://knowledge.spinify.com/help/integrations?hsLang=en#rex-software)
    - [JobAdder](https://knowledge.spinify.com/help/integrations?hsLang=en#jobadder)
    - [Salesforce](https://knowledge.spinify.com/help/integrations?hsLang=en#salesforce)
    - [Follow Up Boss](https://knowledge.spinify.com/help/integrations?hsLang=en#follow-up-boss)
    - [Zapier](https://knowledge.spinify.com/help/integrations?hsLang=en#zapier)
    - [CloudCall](https://knowledge.spinify.com/help/integrations?hsLang=en#cloudcall)
    - [Freshdesk](https://knowledge.spinify.com/help/integrations?hsLang=en#freshdesk)
    - [MRI Vault CRM](https://knowledge.spinify.com/help/integrations?hsLang=en#mri-vault-crm)
    - [Webhooks](https://knowledge.spinify.com/help/integrations?hsLang=en#webhooks)
    - [FTP](https://knowledge.spinify.com/help/integrations?hsLang=en#ftp)
    - [GetAccept](https://knowledge.spinify.com/help/integrations?hsLang=en#getaccept)
    - [Close CRM](https://knowledge.spinify.com/help/integrations?hsLang=en#close-crm)
    - [HighLevel](https://knowledge.spinify.com/help/integrations?hsLang=en#highlevel)
    - [Aircall](https://knowledge.spinify.com/help/integrations?hsLang=en#aircall)
    - [Kixie](https://knowledge.spinify.com/help/integrations?hsLang=en#kixie)
    - [LeadDesk](https://knowledge.spinify.com/help/integrations?hsLang=en#leaddesk)
    - [Zoho](https://knowledge.spinify.com/help/integrations?hsLang=en#zoho)
- [Incentives](https://knowledge.spinify.com/help/incentives?hsLang=en#main-content)

    - [Reward Store](https://knowledge.spinify.com/help/incentives?hsLang=en#reward-store)
    - [Points, Badges & Tiers](https://knowledge.spinify.com/help/incentives?hsLang=en#points-badges-tiers)
    - [Prize Wheels](https://knowledge.spinify.com/help/incentives?hsLang=en#prize-wheels)
- [FAQs](https://knowledge.spinify.com/help/faqs?hsLang=en#main-content)

    - [Competitions](https://knowledge.spinify.com/help/faqs?hsLang=en#competitions)
    - [Account](https://knowledge.spinify.com/help/faqs?hsLang=en#account)
    - [TV & Channels](https://knowledge.spinify.com/help/faqs?hsLang=en#tv-channels)
    - [Spinify](https://knowledge.spinify.com/help/faqs?hsLang=en#spinify)
    - [Troubleshooting](https://knowledge.spinify.com/help/faqs?hsLang=en#troubleshooting)
    - [Sidekick](https://knowledge.spinify.com/help/faqs?hsLang=en#sidekick)
    - [Achievement](https://knowledge.spinify.com/help/faqs?hsLang=en#achievement)
- [Manager Toolkit](https://knowledge.spinify.com/help/manager-toolkit?hsLang=en#main-content)

    - [AI Coaching Agent](https://knowledge.spinify.com/help/manager-toolkit?hsLang=en#ai-coaching-agent)
    - [Analytics](https://knowledge.spinify.com/help/manager-toolkit?hsLang=en#analytics)
    - [Messages & Announcements](https://knowledge.spinify.com/help/manager-toolkit?hsLang=en#messages-announcements)
    - [Coaching Tools](https://knowledge.spinify.com/help/manager-toolkit?hsLang=en#coaching-tools)
- [Administration & Accounts](https://knowledge.spinify.com/help/administration-accounts?hsLang=en#main-content)

    - [Billing](https://knowledge.spinify.com/help/administration-accounts?hsLang=en#billing)
    - [Privacy & Terms](https://knowledge.spinify.com/help/administration-accounts?hsLang=en#privacy-terms)
- [Players Zone](https://knowledge.spinify.com/help/players-zone?hsLang=en)
- [Apps & Extensions](https://knowledge.spinify.com/help/apps-extensions?hsLang=en#main-content)

    - [Chrome Extension](https://knowledge.spinify.com/help/apps-extensions?hsLang=en#chrome-extension)
    - [Mobile App](https://knowledge.spinify.com/help/apps-extensions?hsLang=en#mobile-app)
    - [Spinify MCP](https://knowledge.spinify.com/help/apps-extensions?hsLang=en#spinify-mcp)

[![download (2)](https://knowledge.spinify.com/hs-fs/hubfs/download%20(2).png?width=150&height=150&name=download%20(2).png "download (2)")](https://Spinify.com)

#1 Ranked Sales Gamification Software

<https://www.facebook.com/> <https://www.twitter.com/> <https://www.instagram.com/> <https://podcasts.apple.com/> [mailto:email@email.com](mailto:email@email.com)

Copyright © 2024, Spinify