Daily Tracker Formulas
Weekly Numbers
Frick & FastLane/ HubSpot
Daily Tracker General
100

What is the formula for the present days date to autofill?

=TODAY()

100

Who do we send the Weekly Numbers to?

Carey

100
What tab do we pull the territory checks Support Team completes from?

Territory Checks - Support

100

What do you need to do before you edit anything on the Daily Tracker?

Pause Protection

200

Why would this show?

#DIV/0!

The sales goal is 0 and you cannot divide any number by zero

200

If we have Thursday and Friday off at holiday days, what day will we send the weekly numbers on?

Wednesday

200

Where can we view the previous sales/post success deals?

Admin > Sales Data

200

Who at FastLane do we ask if we have questions regarding the Sales Goal for the quarter?

Matt or Donn

300

If my team has 57 sold units and the goal was 115 units. What percent of units have we sold rounded up to the nearest whole number?

50%

300

What is the correct formula we use to track Territory Checks, Leads, Active Pipeline, C-Day Commitment + Prep, Candidates in Closing and Logged Sales Calls?

COUNTIF

300

What do you need to do for "Yesterdays Logged Sales Calls" before you export the data from Hubspot?

Change the filter to the previous business day

300

If a deal closes on Friday after the daily tracker is sent out, what do you need to do when you send out the daily tracker on Monday?

Include it in your post success deals on Monday when you send out the daily tracker.

400

If my team has hit 40% of our sales goal for the quarter and we have sold 18 units. What is our sales goal for the quarter?

45 Units

400

Which calls are we tracking for the "Logged Calls" column?

Director Logged Calls - any call they have with a candidate

400

Who enters the Post Success Deals?

Debbie / Hannah

400

What months does Quarter four consist of?

October, November, December

500

If my team hit 79% of their goal and Franchise FastLane team hit 94% of their goal, what would my bonus be?

450

500

Name at least four of the deal stages NOT included in "Active Pipeline"

Qualification

Scheduling

On Hold

Director Follow Up

Registration Pending

Dead Lead

500

What does is mean when it says the deal type for a post success deal is "Additional Units"?

A current franchisee we previously closed purchased more territories

500

What is the most you could get for your bonus each quarter?

$1,200

We can earn up to 120% of each half of our bonus