Rep Activity-to-Revenue Ratio Report

Why This Hack Is Needed

Most sales dashboards track:

• Number of calls

• Number of emails

• Meetings booked

• Revenue closed

But they rarely connect:

Activity volume → directly to revenue output

This creates major blind spots:

1. Activity Inflation

Reps can log high activity counts but produce low revenue.

2. Wrong Behavior Reinforcement

Leadership rewards volume instead of effectiveness.

3. No Efficiency Benchmark

You don’t know:

• How many activities it actually takes to close a deal

• Which activity types correlate to revenue

• Which reps are most efficient

This hack solves that by creating:

Revenue per activity metrics at the rep level.

Works best in Sales Hub Pro or Enterprise.

---

What This Build Will Deliver

You will create:

1. Revenue per Rep

2. Activities per Rep

3. Revenue per Activity Ratio

4. Activity-Type Effectiveness View

5. Executive Efficiency Dashboard

---

Step 1: Confirm Activity Tracking Is Clean

Before building reporting, verify:

Go to:
Settings → Objects → Activities

Confirm logging is consistent:

• Calls logged

• Sales emails tracked

• Meetings logged

• Tasks completed (optional inclusion)

Important:
Decide whether to include:

• Only completed activities

• Or all logged activities

For clean reporting, filter by:

• Activity date is known

• Activity outcome is completed (recommended)

---

Step 2: Build Revenue by Rep Report

Navigate:

Reports → Create report → Custom report builder

Primary object:

Deals

Fields:

• Deal owner

• Deal amount

• Deal stage

• Close date

Visualization:

Column chart

X-axis:

• Deal owner

Y-axis:

• Sum of Deal amount

Filters:

• Deal stage = Closed Won

• Close date = This quarter (or chosen period)

Save as:

---

Step 3: Build Activity Volume by Rep Report

Create new custom report

Data Sources:

Deals + Activities

Ensure:
Deals is primary object

---

Fields:

• Deal owner

• Activity type

• Activity date

Visualization:

Column chart

X-axis:

• Deal owner

Y-axis:

• Count of activities

Filters:

• Activity date = This quarter

• Deal stage = Closed Won

• Activity outcome = Completed (if applicable)

Save as:

This ensures you're measuring activity tied to revenue — not random prospecting.

---

Step 4: Create Revenue per Activity Metric

In the Custom Report Builder:

Edit the Activities on Closed Won Deals report.

Add field:

• Deal amount

Change visualization to:

• Table

Group by:

• Deal owner

Add metrics:

• Sum of Deal amount

• Count of Activities

Then add a calculated field:

Click “Add field” → Calculated field

Create:

Format:

• Currency

Save as:

---

Step 5: Create Activity-Type Effectiveness Report

This identifies which activities correlate most with revenue.

Create new custom report:

Primary object:
Deals

Associated:
Activities

---

Fields:

• Activity type

• Deal amount

• Deal stage

Visualization:

Column chart

X-axis:

• Activity type

Y-axis:

• Sum of Deal amount

Filters:

• Deal stage = Closed Won

• Close date = This quarter

Save as:

This shows whether:

• Meetings drive most revenue

• Calls are high volume but low impact

• Emails convert efficiently

---

Step 6: Build the Sales Efficiency Dashboard

Go to:
Reports → Dashboards → Create dashboard

Name:

Add:

1. Closed Won Revenue by Rep

2. Activities on Closed Won Deals – By Rep

3. Revenue per Activity – By Rep

4. Revenue Influenced by Activity Type

Optional additions:

• Avg Sales Cycle by Rep

• Win rate by Rep

• Time in Stage by Rep

---

How to Interpret This Dashboard

High Revenue + Low Activity Count

→ Highly efficient rep
→ Strong qualification
→ High-value conversations

High Activity + Low Revenue

→ Process inefficiency
→ Poor targeting
→ Weak deal advancement

Activity Type Revenue Insights

If:

• Meetings correlate with revenue
  → Double down on meeting creation

• Calls correlate weakly
  → Improve call scripting or targeting

---

Advanced Upgrade (Optional)

Add “Activities per Closed Won Deal” Metric

In report:

Add:

• Count of Closed Won deals

Create calculated field:

This reveals:

• How much effort it takes to close one deal

• Rep efficiency differences

• Process complexity

---

What This Hack Delivers

You now have:

• Revenue per activity efficiency tracking

• Rep-level productivity benchmarking

• Activity-type ROI clarity

• Data-backed coaching insights

• Operational improvement levers

This transforms activity reporting from volume metrics into performance intelligence.