Updating Bonus Tracker
Table of Contents
Overview of SOP- This SOP will demonstrate how to locate updated sales numbers for sales reps in order to update The Bonus Tracker spreadsheet.
Cypress Sales & Bonus Tracker
Maghub
Username: membership@crittendenresearch.com
Password: Crittenden123$
Quick Guide:
1.)Run Consolidated Sales Report
2.) Fill in fields with necessary information
3.) Run for Each Rep
4.)Use Cash total
5.) Update in Bonus Tracker under “Goals being currently worked”
Detailed Guide
Open bonus tracker google sheet. Named “Cypress Sales and Bonus Tracker”. Make sure it has been shared with you and that you have edit access. If you do not have edit access, email Blake.
Open up AdOrbit and log in. On the menu options on the left hand side, select
Reports→Al Reports→Sales→Consolidated Sales Report
Double click to open the report. Then Fill in required fields. Choose the publication, Issue, and Sales rep.Change probability to 90% Click “Get Report”.
For each rep on each issue, you will run the report. To get their current sales number, you'll use the”cash” column as highlighted in the screen grab above.
You will then input the current number for each rep. It will look like this:
Update this every week before the Sales Meeting so the reps can see where they are at.
Once an issue has closed, you can remove the issue from the “current goals being worked” and place them in the old goals tab. This is simply cutting from current, and pasting into “Old Goals” section.